metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1227535" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1227535" and tax_clade = "PVC group"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2886040	2886040	PRJNA1227535_P_NODE_11263_length_288_cov_1.451163_g11140_i0	PRJNA1227535	11263	288	1.451163	4.17934944	Luteolibacter luteus	2728835	Bacteria	Bacteria	200	8.99e-47	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g11140	i0	81.557	10.7777777777778	244	43	84	2	1	243	4046240	4046482	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	3104	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
4162203	4162203	PRJNA1227535_P_NODE_16024_length_271_cov_3.267677_g15901_i0	PRJNA1227535	16024	271	3.267677	8.85540467	Alienimonas californiensis	2527989	Bacteria	Bacteria	217	8.329999999999999e-52	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g15901	i0	86.07	0.74169741697417	201	28	74	0	71	271	1593819	1593619	Alienimonas californiensis strain CA12 chromosome	blastn	201	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
6712919	6712919	PRJNA1227535_P_NODE_15966_length_272_cov_1.316583_g15843_i0	PRJNA1227535	15966	272	1.316583	3.58110576	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	206	1.8099999999999994e-48	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g15843	i0	85.938	1.41911764705882	192	27	71	0	2	193	201284	201093	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	386	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9263453	9263453	PRJNA1227535_P_NODE_28428_length_245_cov_0.906977_g28304_i0	PRJNA1227535	28428	245	0.906977	2.22209365	Akkermansia muciniphila	239935	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g28304	i0	100	99.1265306122449	245	0	100	0	1	245	2046344	2046588	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	24286	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
19461418	19461418	PRJNA1227535_P_NODE_29696_length_243_cov_1.452941_g29572_i0	PRJNA1227535	29696	243	1.452941	3.53064663	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	204	5.71e-48	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g29572	i0	84.466	95.0123456790123	206	32	85	0	2	207	1875545	1875750	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	23088	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;