metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA951810" 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
2212944	2212944	PRJNA951810_P_NODE_60542_length_310_cov_3.485232_g60199_i0	PRJNA951810	60542	310	3.485232	10.8042192	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	135	2.8e-27	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g60199	i0	83.221	0.480645161290323	149	23	48	2	1	148	1797874	1797727	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	149	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
4765192	4765192	PRJNA951810_P_NODE_192104_length_211_cov_5.934783_g191759_i0	PRJNA951810	192104	211	5.934783	12.52239213	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	285	1.68e-72	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g191759	i0	91.08	653.388625592417	213	16	100	3	1	211	2076560	2076349	Gemmatimonas phototrophica strain AP64, complete genome	blastn	137865	285	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
7313945	7313945	PRJNA951810_P_NODE_135266_length_269_cov_3.668367_g134921_i0	PRJNA951810	135266	269	3.668367	9.86790723	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	224	4.929999999999999e-54	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g134921	i0	86.256	28.1412639405204	211	23	77	5	62	269	1897651	1897444	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	7570	224	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
7314493	7314493	PRJNA951810_P_NODE_169166_length_243_cov_2.052941_g168821_i0	PRJNA951810	169166	243	2.052941	4.98864663	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	115	2.7500000000000003e-21	NTclustered	gi\|575462059\|gb\|CP007130.1\|	861299	g168821	i0	84.746	2.52263374485597	118	14	48	4	25	140	66503	66618	Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence	blastn	613	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
7315446	7315446	PRJNA951810_P_NODE_43966_length_310_cov_7.907173_g43623_i0	PRJNA951810	43966	310	7.907173	24.5122363	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	135	2.8e-27	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g43623	i0	87.288	18.3258064516129	118	15	38	0	31	148	4200876	4200759	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	5681	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8589369	8589369	PRJNA951810_P_NODE_162787_length_248_cov_0.880000_g162442_i0	PRJNA951810	162787	248	0.88	2.1824	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	122	1.69e-23	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g162442	i0	84.553	0.495967741935484	123	19	50	0	33	155	4156115	4156237	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	123	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9863711	9863711	PRJNA951810_P_NODE_123248_length_278_cov_1.385366_g122903_i0	PRJNA951810	123248	278	1.385366	3.85131748	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	385	2.22e-102	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g122903	i0	91.786	81.6690647482014	280	17	100	6	1	278	3042928	3042653	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	22704	385	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9864396	9864396	PRJNA951810_P_NODE_163688_length_247_cov_3.241379_g163343_i0	PRJNA951810	163688	247	3.241379	8.00620613	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	383	6.97e-102	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g163343	i0	96.154	433.777327935223	234	9	95	0	3	236	3043199	3042966	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	107143	383	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
12415218	12415218	PRJNA951810_P_NODE_149130_length_258_cov_9.075676_g148785_i0	PRJNA951810	149130	258	9.075676	23.41524408	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	195	3.69e-45	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g148785	i0	84.236	12.7325581395349	203	28	78	4	58	258	323193	322993	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	3285	195	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
18787670	18787670	PRJNA951810_P_NODE_133475_length_270_cov_6.385787_g133130_i0	PRJNA951810	133475	270	6.385787	17.2416249	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	110	1.45e-19	NTclustered	gi\|2107901501\|gb\|CP070815.1\|	2026742	g133130	i0	90.588	29.6962962962963	85	4	30	4	8	88	1390522	1390438	MAG: Gemmatimonadetes bacterium isolate bin118 chromosome	blastn	8018	110	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
18789101	18789101	PRJNA951810_P_NODE_36435_length_326_cov_2.403162_g36092_i0	PRJNA951810	36435	326	2.403162	7.83430812	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	494	4.24e-135	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g36092	i0	94.136	49.739263803681	324	19	99	0	1	324	3043220	3043543	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	16215	494	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
21338409	21338409	PRJNA951810_P_NODE_159237_length_250_cov_6.446328_g158892_i0	PRJNA951810	159237	250	6.446328	16.11582	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	141	4.7e-29	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g158892	i0	79.71	2.148	207	32	81	9	12	213	428756	428957	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	537	141	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
25164015	25164015	PRJNA951810_P_NODE_70840_length_304_cov_1.285714_g70496_i0	PRJNA951810	70840	304	1.285714	3.90857056	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	440	5.169999999999997e-119	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g70496	i0	92.787	156.546052631579	305	21	100	1	1	304	423120	422816	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	47590	440	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);;