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

13 rows where analysis = "blastn", bioproject = "PRJNA1262902" 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
363479	363479	PRJNA1262902_P_NODE_11301_length_243_cov_0.905882_g11259_i0	PRJNA1262902	11301	243	0.905882	2.20129326	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	119	2.13e-22	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g11259	i0	82.482	1.2798353909465	137	22	56	2	95	230	3591900	3591765	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	311	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2914273	2914273	PRJNA1262902_P_NODE_7703_length_251_cov_0.865169_g7661_i0	PRJNA1262902	7703	251	0.865169	2.17157419	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	263	9.65e-66	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g7661	i0	86.345	1.21513944223108	249	25	98	9	3	248	1712695	1712453	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	305	263	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
5466893	5466893	PRJNA1262902_P_NODE_8465_length_249_cov_0.875000_g8423_i0	PRJNA1262902	8465	249	0.875	2.17875	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	243	1.25e-59	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g8423	i0	85.776	0.931726907630522	232	29	92	4	8	237	313558	313787	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	232	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
6741275	6741275	PRJNA1262902_P_NODE_10926_length_244_cov_0.900585_g10884_i0	PRJNA1262902	10926	244	0.900585	2.1974274	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	324	4.22e-84	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g10884	i0	91.489	1.11065573770492	235	20	96	0	10	244	4597031	4597265	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	271	324	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
8016894	8016894	PRJNA1262902_P_NODE_12127_length_241_cov_0.916667_g12085_i0	PRJNA1262902	12127	241	0.916667	2.20916747	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	368	1.9e-97	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g12085	i0	94.191	94.9294605809129	241	14	100	0	1	241	4372589	4372349	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	22878	368	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
8016932	8016932	PRJNA1262902_P_NODE_5207_length_276_cov_1.152709_g5165_i0	PRJNA1262902	5207	276	1.152709	3.18147684	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	309	1.36e-79	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g5165	i0	87.004	4.89855072463768	277	32	99	4	1	275	3006274	3006548	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	1352	309	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
9291706	9291706	PRJNA1262902_P_NODE_7888_length_250_cov_0.870056_g7846_i0	PRJNA1262902	7888	250	0.870056	2.17514	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	204	5.909999999999999e-48	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g7846	i0	87.222	8.748	180	22	72	1	36	214	2345876	2345697	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	2187	204	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9291727	9291727	PRJNA1262902_P_NODE_9268_length_247_cov_0.885057_g9226_i0	PRJNA1262902	9268	247	0.885057	2.18609079	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	337	5.5e-88	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g9226	i0	91.429	1.417004048583	245	21	99	0	3	247	4208997	4208753	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	350	337	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10567666	10567666	PRJNA1262902_P_NODE_7609_length_251_cov_0.865169_g7567_i0	PRJNA1262902	7609	251	0.865169	2.17157419	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	348	2.5900000000000005e-91	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g7567	i0	93.913	0.916334661354582	230	14	92	0	16	245	2686370	2686599	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	230	348	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
11842160	11842160	PRJNA1262902_P_NODE_10910_length_244_cov_0.900585_g10868_i0	PRJNA1262902	10910	244	0.900585	2.1974274	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	134	7.640000000000001e-27	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g10868	i0	89.623	0.807377049180328	106	9	43	2	26	130	289108	289004	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	197	134	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
16940805	16940805	PRJNA1262902_P_NODE_7314_length_251_cov_1.556180_g7272_i0	PRJNA1262902	7314	251	1.55618	3.9060118	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	193	1.28e-44	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g7272	i0	87.952	4.51792828685259	166	17	65	3	1	163	2780364	2780529	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	1134	193	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
18215314	18215314	PRJNA1262902_P_NODE_8555_length_249_cov_0.875000_g8513_i0	PRJNA1262902	8555	249	0.875	2.17875	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	246	9.629999999999999e-61	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g8513	i0	84.8	56.1204819277108	250	33	99	5	1	247	1178063	1177816	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	13974	246	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18215317	18215317	PRJNA1262902_P_NODE_8755_length_248_cov_0.880000_g8713_i0	PRJNA1262902	8755	248	0.88	2.1824	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	180	9.859999999999999e-41	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g8713	i0	84.916	10.883064516129	179	25	72	2	1	178	4557345	4557168	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	2699	180	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);;