metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA473799" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA473799" 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
4272420	4272420	PRJNA473799_P_NODE_16224_length_286_cov_2.718310_g15950_i0	PRJNA473799	16224	286	2.71831	7.7743666	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	320	6.56e-83	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g15950	i0	87.77	215.741258741259	278	29	96	5	12	286	1904478	1904753	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	61702	320	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4272647	4272647	PRJNA473799_P_NODE_32444_length_254_cov_2.607735_g32170_i0	PRJNA473799	32444	254	2.607735	6.6236469	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	337	5.69e-88	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g32170	i0	90.588	360.377952755906	255	23	100	1	1	254	1903864	1904118	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	91536	337	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6823420	6823420	PRJNA473799_P_NODE_39026_length_249_cov_0.875000_g38752_i0	PRJNA473799	39026	249	0.875	2.17875	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	141	4.68e-29	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g38752	i0	83.66	7.3293172690763	153	21	65	4	99	249	2400004	2399854	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	1825	141	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8098482	8098482	PRJNA473799_P_NODE_14727_length_290_cov_1.119816_g14453_i0	PRJNA473799	14727	290	1.119816	3.2474664	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	250	8.87e-62	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g14453	i0	86.667	1.56896551724138	225	30	78	0	3	227	2462871	2463095	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	455	250	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8098697	8098697	PRJNA473799_P_NODE_30627_length_258_cov_1.091892_g30353_i0	PRJNA473799	30627	258	1.091892	2.81708136	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	250	7.76e-62	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g30353	i0	93.976	2.94186046511628	166	9	64	1	1	165	3126099	3125934	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	759	250	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9373416	9373416	PRJNA473799_P_NODE_32508_length_254_cov_2.127072_g32234_i0	PRJNA473799	32508	254	2.127072	5.40276288	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	283	7.51e-72	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g32234	i0	90.278	2.08267716535433	216	21	85	0	1	216	2793225	2793010	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	529	283	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10649151	10649151	PRJNA473799_P_NODE_13349_length_297_cov_3.602679_g13075_i0	PRJNA473799	13349	297	3.602679	10.69995663	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	176	1.57e-39	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g13075	i0	78.37	2.03030303030303	319	35	98	17	2	291	2494587	2494274	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	603	176	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10649338	10649338	PRJNA473799_P_NODE_28169_length_262_cov_1.629630_g27895_i0	PRJNA473799	28169	262	1.62963	4.2696306	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	357	4.52e-94	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g27895	i0	91.221	1	262	23	100	0	1	262	4870882	4871143	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	262	357	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10649448	10649448	PRJNA473799_P_NODE_36889_length_250_cov_0.870056_g36615_i0	PRJNA473799	36889	250	0.870056	2.17514	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	241	4.5e-59	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g36615	i0	84.4	55.04	250	33	99	6	1	247	4004764	4005010	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	13760	241	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14474162	14474162	PRJNA473799_P_NODE_26032_length_266_cov_1.663212_g25758_i0	PRJNA473799	26032	266	1.663212	4.42414392	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	366	7.65e-97	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g25758	i0	92.337	442.462406015038	261	14	97	6	9	266	1904745	1904488	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	117695	366	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15748474	15748474	PRJNA473799_P_NODE_4133_length_652_cov_4.169257_g3873_i0	PRJNA473799	4133	652	4.169257	27.18355564	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	826	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g3873	i0	89.818	57.6687116564417	658	48	100	17	1	652	3044058	3043414	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	37600	826	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18946987	18946987	PRJNA473799_P_NODE_11275_length_313_cov_5.333333_g11001_i0	PRJNA473799	11275	313	5.333333	16.69333229	Gemmatimonadaceae	219687	Bacteria	Bacteria	453	6.87e-123	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g11001	i0	93.98	227.779552715655	299	18	96	0	15	313	3042896	3043194	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	71295	453	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
20847501	20847501	PRJNA473799_P_NODE_4897_length_570_cov_2.702213_g4631_i0	PRJNA473799	4897	570	2.702213	15.4026141	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	640	9.429999999999998e-179	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g4631	i0	87.26	131.2	573	58	99	14	4	570	3042874	3042311	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	74784	640	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
22121965	22121965	PRJNA473799_P_NODE_19838_length_279_cov_1.019417_g19564_i0	PRJNA473799	19838	279	1.019417	2.84417343	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	364	2.909999999999999e-96	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g19564	i0	90.357	186.741935483871	280	23	100	4	1	279	8175871	8176147	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	52101	364	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22122016	22122016	PRJNA473799_P_NODE_23358_length_271_cov_2.257576_g23084_i0	PRJNA473799	23358	271	2.257576	6.11803096	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g23084	i0	100	0.11070110701107	30	0	11	0	3	32	3721894	3721865	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22122233	22122233	PRJNA473799_P_NODE_3838_length_686_cov_1.378467_g3579_i0	PRJNA473799	3838	686	1.378467	9.45628362	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	726	0	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g3579	i0	86.111	68.2638483965015	684	83	99	9	1	682	2075714	2076387	Gemmatimonas phototrophica strain AP64, complete genome	blastn	46829	726	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
22122290	22122290	PRJNA473799_P_NODE_42638_length_247_cov_0.885057_g42364_i0	PRJNA473799	42638	247	0.885057	2.18609079	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	200	7.529999999999999e-47	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g42364	i0	81.301	34.2793522267206	246	46	99	0	1	246	8348179	8348424	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	8467	200	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22122486	22122486	PRJNA473799_P_NODE_55598_length_236_cov_2.705521_g55324_i0	PRJNA473799	55598	236	2.705521	6.38502956	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	294	3.19e-75	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g55324	i0	90.868	1.04661016949153	219	20	93	0	18	236	6117641	6117423	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	247	294	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23397788	23397788	PRJNA473799_P_NODE_26579_length_265_cov_1.619792_g26305_i0	PRJNA473799	26579	265	1.619792	4.2924488	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	209	1.36e-49	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g26305	i0	81.203	12.5094339622642	266	44	99	6	1	263	2144036	2143774	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	3315	209	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);;