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

11 rows where analysis = "blastn", bioproject = "PRJNA716463" 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
3259340	3259340	PRJNA716463_P_NODE_47663_length_292_cov_2.534247_g47246_i0	PRJNA716463	47663	292	2.534247	7.40000124	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	239	1.94e-58	NTclustered	gi\|2893358400\|emb\|OZ220691.1\|	2026742	g47246	i0	82.034	135.116438356164	295	40	100	8	1	292	2520154	2519870	MAG: Gemmatimonadota bacterium isolate 1766b9ea-3269-4cc1-97f5-695b05480569 genome assembly, chromosome: 1	blastn	39454	239	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
3259366	3259366	PRJNA716463_P_NODE_49383_length_291_cov_2.004587_g48966_i0	PRJNA716463	49383	291	2.004587	5.83334817	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	394	3.89e-105	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g48966	i0	91.156	217.103092783505	294	20	100	5	1	291	1592832	1592542	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	63177	394	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5810912	5810912	PRJNA716463_P_NODE_112985_length_240_cov_2.143713_g112567_i0	PRJNA716463	112985	240	2.143713	5.1449112	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	220	5.59e-53	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g112567	i0	84.348	168.5125	230	30	95	6	7	234	3042471	3042696	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	40443	220	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
7086453	7086453	PRJNA716463_P_NODE_29746_length_310_cov_2.485232_g29329_i0	PRJNA716463	29746	310	2.485232	7.7042192	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	195	4.5499999999999995e-45	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g29329	i0	92.143	53.4322580645161	140	7	45	3	1	138	803621	803484	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	16564	195	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
7086470	7086470	PRJNA716463_P_NODE_3046_length_552_cov_3.256785_g2653_i0	PRJNA716463	3046	552	3.256785	17.9774532	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	555	3.399999999999999e-153	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g2653	i0	87.103	118.896739130435	504	48	91	12	23	524	3043758	3043270	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	65631	555	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
8360886	8360886	PRJNA716463_P_NODE_16907_length_310_cov_5.523207_g16490_i0	PRJNA716463	16907	310	5.523207	17.1219417	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	230	1.2499999999999995e-55	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g16490	i0	94.079	33.3903225806452	152	7	97	2	161	310	801318	801167	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	10351	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8361400	8361400	PRJNA716463_P_NODE_4967_length_469_cov_4.156566_g4561_i0	PRJNA716463	4967	469	4.156566	19.49429454	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	361	6.669999999999999e-95	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g4561	i0	80.882	89.319829424307	476	76	100	14	1	469	1594472	1594939	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	41891	361	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12187892	12187892	PRJNA716463_P_NODE_83730_length_265_cov_3.645833_g83313_i0	PRJNA716463	83730	265	3.645833	9.66145745	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	250	8e-62	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g83313	i0	84.191	29.0679245283019	272	28	100	12	1	265	3042752	3042489	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	7703	250	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
16010369	16010369	PRJNA716463_P_NODE_30853_length_309_cov_2.627119_g30436_i0	PRJNA716463	30853	309	2.627119	8.11779771	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	187	7.58e-43	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g30436	i0	89.726	0.954692556634304	146	15	47	0	162	307	902974	903119	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	295	187	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17285626	17285626	PRJNA716463_P_NODE_15814_length_311_cov_3.508403_g15397_i0	PRJNA716463	15814	311	3.508403	10.91113333	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	318	2.6e-82	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g15397	i0	85.185	160.813504823151	297	38	95	5	18	311	802731	803024	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	50013	318	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23660577	23660577	PRJNA716463_P_NODE_13539_length_327_cov_4.102362_g13123_i0	PRJNA716463	13539	327	4.102362	13.41472374	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	497	3.29e-136	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g13123	i0	94.969	219.605504587156	318	14	97	2	10	327	801715	802030	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	71811	497	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);;