metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA630162" 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
3703329	3703329	PRJNA630162_P_NODE_91943_length_190_cov_3.212766_g90420_i0	PRJNA630162	91943	190	3.212766	6.1042554000000004	Bacteria	2	Bacteria	Bacteria	161	2.6e-35	NTclustered	gi\|2518551241\|emb\|OX638340.1\|	203437	g90420	i0	82.609	8.3421052631579	184	31	96	1	1	183	2533396	2533213	MAG: uncultured Gemmatimonadota bacterium isolate 6ed59a95-0d5b-4630-9937-108f2708d2fb genome assembly, chromosome: 1	blastn	1585	161	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadota bacterium
5705915	5705915	PRJNA630162_P_NODE_40785_length_278_cov_3.096070_g39262_i0	PRJNA630162	40785	278	3.09607	8.6070746	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	416	7.879999999999999e-112	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g39262	i0	94.203	48.3453237410072	276	10	98	6	1	273	1467830	1468102	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	13440	416	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
6254842	6254842	PRJNA630162_P_NODE_121465_length_173_cov_4.379032_g119942_i0	PRJNA630162	121465	173	4.379032	7.57572536	Gemmatimonas	173479	Bacteria	Bacteria	122	1.0899999999999999e-23	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g119942	i0	80.473	3.01156069364162	169	26	97	4	1	167	1396	1559	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	521	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
6980696	6980696	PRJNA630162_P_NODE_32006_length_318_cov_3.918216_g30484_i0	PRJNA630162	32006	318	3.918216	12.45992688	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	534	2.4299999999999998e-147	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g30484	i0	97.444	118.066037735849	313	8	98	0	5	317	1104102	1104414	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	37545	534	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
7529524	7529524	PRJNA630162_P_NODE_8946_length_642_cov_3.327150_g7583_i0	PRJNA630162	8946	642	3.32715	21.360303	Gemmatimonas	173479	Bacteria	Bacteria	800	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g7583	i0	89.425	338.404984423676	643	56	99	12	2	636	1877	1239	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	217256	800	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
11354852	11354852	PRJNA630162_P_NODE_43389_length_269_cov_1.995455_g41866_i0	PRJNA630162	43389	269	1.995455	5.36777395	Gemmatimonas	173479	Bacteria	Bacteria	348	2.81e-91	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g41866	i0	92.063	13.7323420074349	252	12	92	6	22	269	233	480	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	3694	348	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
13355933	13355933	PRJNA630162_P_NODE_14451_length_497_cov_6.000000_g12963_i0	PRJNA630162	14451	497	6	29.82	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	784	0	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g12963	i0	95.706	82.6800804828974	489	17	99	3	7	493	1102386	1102872	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	41092	784	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
13356653	13356653	PRJNA630162_P_NODE_57591_length_232_cov_2.972678_g56068_i0	PRJNA630162	57591	232	2.972678	6.89661296	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	176	1.18e-39	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g56068	i0	97.115	81.2672413793103	104	3	88	0	18	121	1102418	1102521	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	18854	176	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
14630885	14630885	PRJNA630162_P_NODE_169792_length_154_cov_3.895238_g168269_i0	PRJNA630162	169792	154	3.895238	5.99866652	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	196	5.52e-46	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g168269	i0	99.083	58.7207792207792	109	1	97	0	41	149	1104735	1104627	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	9043	196	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
14631779	14631779	PRJNA630162_P_NODE_93352_length_190_cov_0.879433_g91829_i0	PRJNA630162	93352	190	0.879433	1.6709227	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	265	1.93e-66	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g91829	i0	92.896	172.168421052632	183	12	96	1	3	184	803954	803772	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	32712	265	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15904581	15904581	PRJNA630162_P_NODE_139213_length_167_cov_1.084746_g137690_i0	PRJNA630162	139213	167	1.084746	1.81152582	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	165	1.72e-36	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g137690	i0	85.366	14.1197604790419	164	18	96	5	4	164	172722	172562	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	2358	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16454147	16454147	PRJNA630162_P_NODE_28473_length_340_cov_3.996564_g26951_i0	PRJNA630162	28473	340	3.996564	13.5883176	Gemmatimonas	173479	Bacteria	Bacteria	560	4.32e-155	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g26951	i0	96.471	118.061764705882	340	10	100	2	1	340	777	440	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	40141	560	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
17180067	17180067	PRJNA630162_P_NODE_24154_length_373_cov_1.833333_g22635_i0	PRJNA630162	24154	373	1.833333	6.83833209	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	497	3.79e-136	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g22635	i0	91.105	264.664879356568	371	27	99	6	1	368	1903863	1904230	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	98720	497	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18454334	18454334	PRJNA630162_P_NODE_43955_length_267_cov_2.188073_g42432_i0	PRJNA630162	43955	267	2.188073	5.84215491	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	416	7.519999999999998e-112	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g42432	i0	95.094	109.112359550562	265	12	99	1	1	264	802328	802064	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	29133	416	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18454392	18454392	PRJNA630162_P_NODE_48275_length_254_cov_1.321951_g46752_i0	PRJNA630162	48275	254	1.321951	3.35775554	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	252	2.12e-62	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g46752	i0	84.921	13.2716535433071	252	35	99	3	4	254	232430	232679	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	3371	252	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
18454750	18454750	PRJNA630162_P_NODE_82195_length_199_cov_1.453333_g80672_i0	PRJNA630162	82195	199	1.453333	2.89213267	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	285	1.56e-72	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g80672	i0	94.18	35.2412060301508	189	7	94	2	13	199	1101411	1101597	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	7013	285	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
21004094	21004094	PRJNA630162_P_NODE_137357_length_167_cov_3.237288_g135834_i0	PRJNA630162	137357	167	3.237288	5.40627096	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	145	2.25e-30	NTclustered	gi\|2518552101\|emb\|OX638356.1\|	2910168	g135834	i0	92.929	159.461077844311	99	7	59	0	23	121	1940882	1940980	MAG: Longimicrobiales bacterium isolate 11c1aa9f-90ef-4017-a54d-d6b2e11378d8 genome assembly, chromosome: 1	blastn	26630	145	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
21004789	21004789	PRJNA630162_P_NODE_49577_length_250_cov_4.422886_g48054_i0	PRJNA630162	49577	250	4.422886	11.057215	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	433	6.92e-117	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g48054	i0	98.765	198.22	243	3	97	0	4	246	2077630	2077388	Gemmatimonas phototrophica strain AP64, complete genome	blastn	49555	433	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
21005104	21005104	PRJNA630162_P_NODE_81557_length_199_cov_5.060000_g80034_i0	PRJNA630162	81557	199	5.06	10.0694	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	132	2.16e-26	NTclustered	gi\|2518552101\|emb\|OX638356.1\|	2910168	g80034	i0	85.827	135.914572864322	127	14	63	4	39	163	1940851	1940727	MAG: Longimicrobiales bacterium isolate 11c1aa9f-90ef-4017-a54d-d6b2e11378d8 genome assembly, chromosome: 1	blastn	27047	132	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
21553144	21553144	PRJNA630162_P_NODE_140717_length_167_cov_0.881356_g139194_i0	PRJNA630162	140717	167	0.881356	1.47186452	FCB group	1783270	Bacteria	Bacteria	121	3.789999999999999e-23	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g139194	i0	96	47.5568862275449	75	2	44	1	57	130	1044506	1044432	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	7942	122	0.991803278688525	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23553902	23553902	PRJNA630162_P_NODE_101479_length_185_cov_1.125000_g99956_i0	PRJNA630162	101479	185	1.125	2.08125	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	204	4.119999999999999e-48	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g99956	i0	94.074	156.778378378378	135	7	72	1	51	184	1904035	1903901	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	29004	204	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);;