metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA558770" 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
540509	540509	PRJNA558770_P_NODE_283921_length_234_cov_1.673367_g281916_i0	PRJNA558770	283921	234	1.673367	3.91567878	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	76.8	1.24e-9	NTclustered	gi\|2108172456\|gb\|CP070716.1\|	2026742	g281916	i0	86.765	0.290598290598291	68	9	29	0	5	72	2068512	2068579	MAG: Gemmatimonadetes bacterium isolate bin486 chromosome	blastn	68	76.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
3091203	3091203	PRJNA558770_P_NODE_265243_length_234_cov_1.994975_g263238_i0	PRJNA558770	265243	234	1.994975	4.6682415	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	89.8	1.6e-13	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g263238	i0	89.855	17.4358974358974	69	7	29	0	160	228	3084525	3084593	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	4080	89.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4367132	4367132	PRJNA558770_P_NODE_236544_length_234_cov_2.628141_g234539_i0	PRJNA558770	236544	234	2.628141	6.14984994	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	80.5	9.61e-11	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g234539	i0	91.379	0.247863247863248	58	5	25	0	3	60	3438833	3438890	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	58	80.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5643622	5643622	PRJNA558770_P_NODE_236905_length_234_cov_2.618090_g234900_i0	PRJNA558770	236905	234	2.61809	6.1263306	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	126	1.22e-24	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g234900	i0	97.297	0.551282051282051	74	2	55	0	2	75	1769317	1769390	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	129	126	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9468439	9468439	PRJNA558770_P_NODE_238088_length_234_cov_2.587940_g236083_i0	PRJNA558770	238088	234	2.58794	6.0557796	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	71.3	5.79e-8	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g236083	i0	88.525	6.51282051282051	61	4	28	3	161	218	178538	178598	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	1524	71.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10744188	10744188	PRJNA558770_P_NODE_244689_length_234_cov_2.427136_g242684_i0	PRJNA558770	244689	234	2.427136	5.67949824	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	97.1	9.55e-16	NTclustered	gi\|2893358411\|emb\|OZ220702.1\|	2910168	g242684	i0	92.537	7.16239316239316	67	5	29	0	168	234	1375129	1375063	MAG: Longimicrobiales bacterium isolate 5c038fdb-8e0b-4cbd-9550-43be1afc0bbf genome assembly, chromosome: 1	blastn	1676	97.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
15841642	15841642	PRJNA558770_P_NODE_182333_length_234_cov_4.532663_g180328_i0	PRJNA558770	182333	234	4.532663	10.60643142	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	102	2.05e-17	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g180328	i0	90.789	0.324786324786325	76	7	32	0	1	76	809790	809715	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	76	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
19666560	19666560	PRJNA558770_P_NODE_256176_length_234_cov_2.175879_g254171_i0	PRJNA558770	256176	234	2.175879	5.09155686	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	122	1.5699999999999994e-23	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g254171	i0	96	1.17948717948718	75	3	32	0	1	75	4387538	4387464	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	276	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19667980	19667980	PRJNA558770_P_NODE_382896_length_205_cov_4.300000_g380891_i0	PRJNA558770	382896	205	4.3	8.815	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	69.4	1.78e-7	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g380891	i0	91.837	0.239024390243902	49	4	24	0	11	59	8210608	8210656	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	49	69.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20941462	20941462	PRJNA558770_P_NODE_209437_length_234_cov_3.432161_g207432_i0	PRJNA558770	209437	234	3.432161	8.03125674	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	110	1.23e-19	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g207432	i0	94.366	6.66239316239316	71	4	30	0	3	73	3678467	3678537	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	1559	110	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20942781	20942781	PRJNA558770_P_NODE_290977_length_234_cov_1.547739_g288972_i0	PRJNA558770	290977	234	1.547739	3.62170926	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	119	2.04e-22	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g288972	i0	94.737	0.324786324786325	76	4	32	0	159	234	127709	127784	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	76	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20943409	20943409	PRJNA558770_P_NODE_347317_length_233_cov_1.883838_g345312_i0	PRJNA558770	347317	233	1.883838	4.38934254	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	124	4.36e-24	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g345312	i0	97.26	0.690987124463519	73	2	31	0	3	75	4190443	4190515	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	161	124	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22215950	22215950	PRJNA558770_P_NODE_181238_length_234_cov_4.587940_g179233_i0	PRJNA558770	181238	234	4.58794	10.7357796	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g179233	i0	100	0.11965811965812	28	0	12	0	16	43	2703496	2703469	Gemmatimonas phototrophica strain AP64, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
24080491	24080491	PRJNA558770_P_NODE_116539_length_234_cov_9.653266_g114534_i0	PRJNA558770	116539	234	9.653266	22.58864244	Pseudomonadati	3379134	Bacteria	Bacteria	104	5.7e-18	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g114534	i0	92	1.93162393162393	75	4	32	2	2	75	126396	126323	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	452	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24765595	24765595	PRJNA558770_P_NODE_209620_length_234_cov_3.427136_g207615_i0	PRJNA558770	209620	234	3.427136	8.01949824	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	62.1	3.48e-5	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g207615	i0	93.023	40.4957264957265	43	2	18	1	165	206	2733289	2733247	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	9476	62.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24766342	24766342	PRJNA558770_P_NODE_255120_length_234_cov_2.195980_g253115_i0	PRJNA558770	255120	234	2.19598	5.1385932	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	106	1.59e-18	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g253115	i0	92	0.320512820512821	75	6	32	0	1	75	1362315	1362241	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	75	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24766749	24766749	PRJNA558770_P_NODE_282320_length_234_cov_1.698492_g280315_i0	PRJNA558770	282320	234	1.698492	3.97447128	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	108	4.41e-19	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g280315	i0	93.243	0.782051282051282	74	3	31	2	1	73	4259030	4259102	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	183	108	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);;