metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA911178" 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
892372	892372	PRJNA911178_P_NODE_236781_length_252_cov_2.536313_g234307_i0	PRJNA911178	236781	252	2.536313	6.39150876	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	276	1.2499999999999998e-69	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g234307	i0	86.939	15.0714285714286	245	32	97	0	1	245	803444	803200	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	3798	276	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
3443628	3443628	PRJNA911178_P_NODE_281083_length_243_cov_1.194118_g278609_i0	PRJNA911178	281083	243	1.194118	2.90170674	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	381	2.4599999999999995e-101	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g278609	i0	95.062	46.1810699588477	243	10	99	2	2	243	3043041	3042800	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	11222	381	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
8544777	8544777	PRJNA911178_P_NODE_172467_length_287_cov_2.126168_g169994_i0	PRJNA911178	172467	287	2.126168	6.10210216	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	272	1.8699999999999993e-68	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g169994	i0	84.698	3.65156794425087	281	34	97	8	10	287	253065	253339	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	1048	272	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8545905	8545905	PRJNA911178_P_NODE_301147_length_232_cov_3.540881_g298673_i0	PRJNA911178	301147	232	3.540881	8.21484392	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	326	1.11e-84	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g298673	i0	92.857	90.8146551724138	224	16	97	0	1	224	1904523	1904746	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	21069	326	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11095674	11095674	PRJNA911178_P_NODE_204129_length_269_cov_2.188776_g201655_i0	PRJNA911178	204129	269	2.188776	5.88780744	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	329	1.02e-85	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g201655	i0	89.655	2.59851301115242	261	24	96	3	4	262	422278	422019	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	699	329	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11096172	11096172	PRJNA911178_P_NODE_265569_length_246_cov_0.890173_g263095_i0	PRJNA911178	265569	246	0.890173	2.18982558	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	322	1.53e-83	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g263095	i0	91.176	221.845528455285	238	19	96	2	3	239	802181	801945	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	54574	322	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13645468	13645468	PRJNA911178_P_NODE_170191_length_289_cov_1.101852_g167718_i0	PRJNA911178	170191	289	1.101852	3.18435228	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	267	8.77e-67	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g167718	i0	83.618	40.5190311418685	293	38	100	8	1	289	3042506	3042792	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	11710	267	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14919791	14919791	PRJNA911178_P_NODE_169332_length_289_cov_1.754630_g166859_i0	PRJNA911178	169332	289	1.75463	5.0708807	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	318	2.39e-82	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g166859	i0	89.015	127.826989619377	264	19	89	6	10	267	3485840	3486099	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	36942	318	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16194829	16194829	PRJNA911178_P_NODE_189313_length_278_cov_0.873171_g186840_i0	PRJNA911178	189313	278	0.873171	2.42741538	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	407	4.74e-109	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g186840	i0	94.052	169.787769784173	269	15	97	1	10	278	172004	172271	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	47201	407	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16196002	16196002	PRJNA911178_P_NODE_42413_length_528_cov_1.969231_g39999_i0	PRJNA911178	42413	528	1.969231	10.39753968	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	621	3.1499999999999995e-173	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g39999	i0	87.902	29.7253787878788	529	62	100	2	1	528	1553307	1553834	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	15695	621	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
16552456	16552456	PRJNA911178_P_NODE_210373_length_266_cov_1.528497_g207899_i0	PRJNA911178	210373	266	1.528497	4.06580202	Bacteria	2	Bacteria	Bacteria	259	1.34e-64	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g207899	i0	85.433	71.4924812030075	254	31	94	6	17	266	231560	231309	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	19017	261	0.992337164750958	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
19101777	19101777	PRJNA911178_P_NODE_279935_length_243_cov_1.764706_g277461_i0	PRJNA911178	279935	243	1.764706	4.28823558	Gemmatimonas	173479	Bacteria	Bacteria	283	7.14e-72	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g277461	i0	88.703	129.263374485597	239	17	96	6	11	243	231727	231961	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	31411	285	0.992982456140351	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
20018737	20018737	PRJNA911178_P_NODE_205596_length_268_cov_5.200000_g203122_i0	PRJNA911178	205596	268	5.2	13.936	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	401	2.1099999999999995e-107	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g203122	i0	94.318	48.8432835820896	264	11	97	4	5	264	801397	801134	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	13090	401	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21294354	21294354	PRJNA911178_P_NODE_237977_length_252_cov_1.368715_g235503_i0	PRJNA911178	237977	252	1.368715	3.4491618	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	252	2.1e-62	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g235503	i0	84.921	9.19047619047619	252	34	99	4	3	252	422086	422335	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	2316	252	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23843597	23843597	PRJNA911178_P_NODE_116199_length_339_cov_2.236842_g113727_i0	PRJNA911178	116199	339	2.236842	7.58289438	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	477	4.459999999999998e-130	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g113727	i0	94.788	112.410029498525	307	15	91	1	6	312	421690	421995	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	38107	477	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium

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