metadata: contig_metadata: 11 rows where bioproject = "PRJNA1245487" and tax

11 rows where bioproject = "PRJNA1245487" and tax_phylum = "Gemmatimonadota"

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
1625886	1625886	PRJNA1245487_P_NODE_4562_length_588_cov_2.132039_g4231_i0	PRJNA1245487	4562	588	2.132039	12.53638932	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	621	3.53e-173	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g4231	i0	85.93	83.3741496598639	597	66	100	17	1	588	422650	422063	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	49024	621	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4178419	4178419	PRJNA1245487_P_NODE_5764_length_520_cov_3.033557_g5428_i0	PRJNA1245487	5764	520	3.033557	15.7744964	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	455	3.32e-123	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g5428	i0	83.884	21.8923076923077	484	71	93	7	39	520	422518	422040	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	11384	455	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11829677	11829677	PRJNA1245487_P_NODE_15150_length_290_cov_2.755760_g14812_i0	PRJNA1245487	15150	290	2.75576	7.991704	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	279	1.13e-70	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g14812	i0	84.775	125.5	289	32	97	12	9	290	422321	422604	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	36395	279	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14380276	14380276	PRJNA1245487_P_NODE_21552_length_243_cov_4.664706_g21214_i0	PRJNA1245487	21552	243	4.664706	11.33523558	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	327	3.25e-85	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g21214	i0	90.984	146.460905349794	244	21	100	1	1	243	233887	234130	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	35590	327	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
16928257	16928257	PRJNA1245487_P_NODE_14374_length_300_cov_1.700441_g14036_i0	PRJNA1245487	14374	300	1.700441	5.101323	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	368	2.44e-97	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g14036	i0	89	152.77	300	30	99	2	1	299	3043426	3043723	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	45831	368	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18902883	18902883	PRJNA1245487_P_NODE_19995_length_249_cov_3.176136_g19657_i0	PRJNA1245487	19995	249	3.176136	7.90857864	Gemmatimonas	173479	Bacteria	Bacteria	222	1.62e-53	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g19657	i0	83.534	142.473895582329	249	30	98	9	6	249	421060	420818	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	35476	222	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19477271	19477271	PRJNA1245487_P_NODE_3096_length_708_cov_3.703937_g2779_i0	PRJNA1245487	3096	708	3.703937	26.22387396	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	821	0	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g2779	i0	87.692	118.043785310734	715	75	100	13	1	708	421491	420783	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	83575	821	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19477283	19477283	PRJNA1245487_P_NODE_476_length_1487_cov_13.144272_g119_i1	PRJNA1245487	476	1487	13.144272	195.45532464	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	2060	0	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g119	i1	92.057	159.454606590451	1473	103	99	12	1	1467	2074703	2076167	Gemmatimonas phototrophica strain AP64, complete genome	blastn	237109	2060	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
19477307	19477307	PRJNA1245487_P_NODE_736_length_1258_cov_15.220253_g119_i2	PRJNA1245487	736	1258	15.220253	191.47078274	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	1674	0	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g119	i2	91.673	310.301271860095	1225	77	97	17	39	1258	2075907	2074703	Gemmatimonas phototrophica strain AP64, complete genome	blastn	390359	1674	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
21453060	21453060	PRJNA1245487_P_NODE_13657_length_310_cov_2.932489_g13319_i0	PRJNA1245487	13657	310	2.932489	9.0907159	root	1	Root_unresolved	Root_unresolved	300	9.37e-77	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g13319	i0	84.395	67.5741935483871	314	40	100	8	1	310	331	23	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	20948	300	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
27453011	27453011	PRJNA1245487_P_NODE_15563_length_286_cov_1.276995_g15225_i0	PRJNA1245487	15563	286	1.276995	3.6522057	Longimicrobium sp.	2029185	Bacteria	Bacteria	44.7	0.0113	NR	HLL82190.1	2029185	g15225	i0	34.1	0.891608391608392	85	51	83.9	3	254	15	141	225	HLL82190.1 hypothetical protein [Longimicrobium sp.]	diamond	255	44.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.

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