metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA716463" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA716463" and tax_phylum = "Verrucomicrobiota"

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
707179	707179	PRJNA716463_P_NODE_106841_length_245_cov_3.343023_g106423_i0	PRJNA716463	106841	245	3.343023	8.19040635	Chthoniobacter flavus	191863	Bacteria	Bacteria	320	5.49e-83	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g106423	i0	90.833	235.465306122449	240	20	97	1	1	238	504	743	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	57689	320	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
707336	707336	PRJNA716463_P_NODE_11721_length_348_cov_2.625455_g11306_i0	PRJNA716463	11721	348	2.625455	9.1365834	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	472	2.13e-128	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g11306	i0	91.594	205.25	345	24	98	5	8	348	1315272	1315615	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	71427	472	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5811403	5811403	PRJNA716463_P_NODE_32545_length_300_cov_9.303965_g32128_i0	PRJNA716463	32545	300	9.303965	27.911895	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g32128	i0	100	0.0966666666666667	29	0	10	0	1	29	106170	106198	Lacunisphaera limnophila strain IG16b, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
5811797	5811797	PRJNA716463_P_NODE_585_length_1278_cov_6.094606_g324_i0	PRJNA716463	585	1278	6.094606	77.88906468	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1605	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g324	i0	89.457	241.77386541471	1290	111	100	22	1	1278	1316252	1314976	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	308987	1605	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8361086	8361086	PRJNA716463_P_NODE_29447_length_310_cov_2.552743_g29030_i0	PRJNA716463	29447	310	2.552743	7.9135033	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	69.4	2.88e-7	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g29030	i0	87.097	2.62258064516129	62	7	25	1	216	276	4763234	4763173	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	813	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
10912063	10912063	PRJNA716463_P_NODE_46129_length_293_cov_3.672727_g45712_i0	PRJNA716463	46129	293	3.672727	10.76109011	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g45712	i0	90.244	0.26962457337884	41	4	14	0	50	90	1515702	1515742	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	79	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
14737246	14737246	PRJNA716463_P_NODE_62432_length_282_cov_1.473684_g62015_i0	PRJNA716463	62432	282	1.473684	4.15578888	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	311	3.89e-80	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g62015	i0	88.889	1.05673758865248	252	28	100	0	31	282	3183536	3183787	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	298	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
21111359	21111359	PRJNA716463_P_NODE_93877_length_257_cov_1.673913_g93460_i0	PRJNA716463	93877	257	1.673913	4.30195641	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	359	1.23e-94	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g93460	i0	91.86	68.3540856031128	258	19	100	2	1	257	3832286	3832542	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	17567	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22386100	22386100	PRJNA716463_P_NODE_87278_length_262_cov_4.058201_g86861_i0	PRJNA716463	87278	262	4.058201	10.63248662	Fontisphaera persica	2974023	Bacteria	Bacteria	388	1.6e-103	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g86861	i0	93.822	80.5801526717557	259	15	99	1	1	259	3863005	3863262	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	21112	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica

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);;