metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1092581" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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
196909	196909	PRJNA1092581_P_NODE_41101_length_426_cov_3.756374_g40568_i0	PRJNA1092581	41101	426	3.756374	16.00215324	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	440	7.499999999999998e-119	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g40568	i0	86.914	403.767605633803	405	37	94	14	22	420	1904761	1904367	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	172005	440	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
197201	197201	PRJNA1092581_P_NODE_52501_length_370_cov_1.885522_g51968_i0	PRJNA1092581	52501	370	1.885522	6.9764314	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	361	5.139999999999999e-95	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g51968	i0	85.345	1.88918918918919	348	51	94	0	21	368	4105741	4105394	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	699	361	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1017814	1017814	PRJNA1092581_P_NODE_1201_length_1689_cov_12.641089_g1087_i0	PRJNA1092581	1201	1689	12.641089	213.50799321	Gemmatimonas	173479	Bacteria	Bacteria	1903	0	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g1087	i0	87.455	230.891059798697	1682	173	99	34	4	1669	2076354	2074695	Gemmatimonas phototrophica strain AP64, complete genome	blastn	389975	1908	0.997379454926625	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
2746993	2746993	PRJNA1092581_P_NODE_1883_length_1512_cov_8.797776_g1087_i1	PRJNA1092581	1883	1512	8.797776	133.02237312	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	1748	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g1087	i1	88.102	154.747354497355	1496	147	98	26	19	1497	3042303	3043784	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	233978	1748	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4022489	4022489	PRJNA1092581_P_NODE_115524_length_231_cov_2.145570_g114991_i0	PRJNA1092581	115524	231	2.14557	4.9562667	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	311	3.08e-80	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g114991	i0	94.554	209.285714285714	202	10	87	1	30	231	3044647	3044447	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	48345	311	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
6575311	6575311	PRJNA1092581_P_NODE_62606_length_334_cov_3.731801_g62073_i0	PRJNA1092581	62606	334	3.731801	12.46421534	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	359	1.66e-94	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g62073	i0	87.037	327.044910179641	324	35	96	6	14	334	172211	172530	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	109233	359	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
7850001	7850001	PRJNA1092581_P_NODE_58367_length_348_cov_2.345455_g57834_i0	PRJNA1092581	58367	348	2.345455	8.1621834	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	350	1.04e-91	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g57834	i0	86.943	146.278735632184	314	38	90	3	17	328	234204	233892	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	50905	350	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
7850879	7850879	PRJNA1092581_P_NODE_93007_length_264_cov_2.816754_g92474_i0	PRJNA1092581	93007	264	2.816754	7.43623056	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	195	3.79e-45	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g92474	i0	80.303	1.31818181818182	264	46	99	5	4	264	4978306	4978046	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	348	195	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
7850896	7850896	PRJNA1092581_P_NODE_93807_length_263_cov_1.457895_g93274_i0	PRJNA1092581	93807	263	1.457895	3.83426385	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	331	2.75e-86	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g93274	i0	89.354	1.61596958174905	263	28	100	0	1	263	1275203	1275465	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	425	331	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10400316	10400316	PRJNA1092581_P_NODE_45289_length_402_cov_38.990881_g44756_i0	PRJNA1092581	45289	402	38.990881	156.74334162	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	233	1.2799999999999998e-56	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g44756	i0	89.674	1.9228855721393	184	17	46	2	22	204	1211832	1212014	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	773	233	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
12950760	12950760	PRJNA1092581_P_NODE_47811_length_390_cov_4.400631_g47278_i0	PRJNA1092581	47811	390	4.400631	17.1624609	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	385	3.24e-102	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g47278	i0	85.372	47.1384615384615	376	50	96	5	17	389	421225	420852	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	18384	385	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15500705	15500705	PRJNA1092581_P_NODE_86853_length_275_cov_3.054455_g86320_i0	PRJNA1092581	86853	275	3.054455	8.39975125	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	272	1.78e-68	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g86320	i0	85.824	78.0581818181818	261	32	94	4	4	261	423454	423712	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	21466	272	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15500737	15500737	PRJNA1092581_P_NODE_87913_length_273_cov_3.475000_g87380_i0	PRJNA1092581	87913	273	3.475	9.48675	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	285	2.2699999999999996e-72	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g87380	i0	85.978	0.992673992673993	271	33	98	4	6	272	4679799	4680068	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	271	285	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16773873	16773873	PRJNA1092581_P_NODE_37734_length_447_cov_2.056150_g37202_i0	PRJNA1092581	37734	447	2.05615	9.1909905	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	257	8.54e-64	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g37202	i0	78.118	94.013422818792	425	79	94	14	30	447	1390637	1391054	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	42024	257	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
16775270	16775270	PRJNA1092581_P_NODE_93414_length_263_cov_5.231579_g92881_i0	PRJNA1092581	93414	263	5.231579	13.75905277	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	339	1.65e-88	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g92881	i0	93.778	108.539923954373	225	14	86	0	14	238	802576	802352	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	28546	339	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20599197	20599197	PRJNA1092581_P_NODE_91077_length_267_cov_7.175258_g90544_i0	PRJNA1092581	91077	267	7.175258	19.15793886	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	311	3.65e-80	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g90544	i0	92.593	29.6928838951311	216	16	81	0	33	248	1903502	1903287	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	7928	311	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21873892	21873892	PRJNA1092581_P_NODE_4798_length_1132_cov_54.186969_g4525_i0	PRJNA1092581	4798	1132	54.186969	613.39648908	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	1003	0	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g4525	i0	86.739	525.222614840989	920	100	80	18	217	1123	1296459	1295549	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	594552	1003	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24421740	24421740	PRJNA1092581_P_NODE_117120_length_228_cov_4.238710_g116587_i0	PRJNA1092581	117120	228	4.23871	9.6642588	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	100	7.16e-17	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g116587	i0	79.333	0.657894736842105	150	25	63	3	32	175	2151332	2151481	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	150	100	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);;