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

21 rows where analysis = "blastn", bioproject = "PRJEB29441" and tax_kingdom = "Thermotogati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
988302	988302	PRJEB29441_P_NODE_32261_length_184_cov_1.851852_g31820_i0	PRJEB29441	32261	184	1.851852	3.40740768	Deinococcus	1298	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g31820	i0	100	172.423913043478	184	0	100	0	1	184	214	31	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	31726	340	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
8641367	8641367	PRJEB29441_P_NODE_19187_length_244_cov_1.876923_g18746_i0	PRJEB29441	19187	244	1.876923	4.57969212	root	1	Root_unresolved	Root_unresolved	446	8.639999999999999e-121	NTclustered	gi\|1092183759\|dbj\|AB862156.1\|	274	g18746	i0	99.59	112	244	1	100	0	1	244	327	84	Thermus thermophilus gene for 16S ribosomal RNA, partial sequence, strain: TR2	blastn	27328	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
8641480	8641480	PRJEB29441_P_NODE_31747_length_186_cov_1.116788_g31306_i0	PRJEB29441	31747	186	1.116788	2.07722568	Bacteria	2	Bacteria	Bacteria	333	5.069999999999999e-87	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g31306	i0	98.925	143.204301075269	186	2	100	0	1	186	1759	1574	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	26636	333	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
9916338	9916338	PRJEB29441_P_NODE_13288_length_302_cov_11.181818_g12847_i0	PRJEB29441	13288	302	11.181818	33.76909036	Deinococcus	1298	Bacteria	Bacteria	521	1.7799999999999999e-143	NTclustered	gi\|1488149667\|gb\|MK036535.1\|	47478	g12847	i0	98	101.324503311258	300	6	99	0	1	300	713	414	Deinococcus sp. strain 16081601 16S ribosomal RNA gene, partial sequence	blastn	30600	521	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
10229561	10229561	PRJEB29441_P_NODE_429_length_1791_cov_4.565442_g351_i0	PRJEB29441	429	1791	4.565442	81.76706622	Trueperaceae bacterium	2026798	Bacteria	Bacteria	1814	0	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g351	i0	86.524	199.908989391401	1677	193	92	29	83	1738	2560877	2559213	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	358037	1814	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
11504397	11504397	PRJEB29441_P_NODE_16810_length_263_cov_3.121495_g16369_i0	PRJEB29441	16810	263	3.121495	8.20953185	Trueperaceae bacterium	2026798	Bacteria	Bacteria	335	2.129999999999999e-87	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g16369	i0	89.695	448.923954372624	262	27	99	0	2	263	3599969	3599708	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	118067	335	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
12467249	12467249	PRJEB29441_P_NODE_11970_length_322_cov_1.827839_g11529_i0	PRJEB29441	11970	322	1.827839	5.88564158	Thermus	270	Bacteria	Bacteria	595	1.1099999999999995e-165	NTclustered	gi\|1162503842\|gb\|KY784655.1\|	275	g11529	i0	100	118.996894409938	322	0	100	0	1	322	788	467	Thermus sp. strain C419 16S ribosomal RNA gene, partial sequence	blastn	38317	595	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
13741688	13741688	PRJEB29441_P_NODE_22631_length_222_cov_1.913295_g22190_i0	PRJEB29441	22631	222	1.913295	4.2475149	Thermus	270	Bacteria	Bacteria	392	1.0199999999999999e-104	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g22190	i0	98.649	146.09009009009	222	2	100	1	1	222	1103	1323	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	32432	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
15328953	15328953	PRJEB29441_P_NODE_5573_length_502_cov_269.688742_g5140_i0	PRJEB29441	5573	502	269.688742	1353.83748484	Deinococcus radiophilus	32062	Bacteria	Bacteria	872	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g5140	i0	98.016	101.378486055777	504	6	100	4	1	502	1907242	1906741	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	50892	872	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
16290969	16290969	PRJEB29441_P_NODE_30933_length_188_cov_1.618705_g30492_i0	PRJEB29441	30933	188	1.618705	3.0431654	Deinococcus	1298	Bacteria	Bacteria	324	3.09e-84	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g30492	i0	97.861	161.675531914894	187	4	99	0	2	188	1792153	1792339	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	30395	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
17566275	17566275	PRJEB29441_P_NODE_6074_length_480_cov_9.095128_g5640_i0	PRJEB29441	6074	480	9.095128	43.6566144	Deinococcus	1298	Bacteria	Bacteria	726	0	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g5640	i0	93.983	273.910416666667	482	25	99	3	1	478	21	502	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	131477	726	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
17566301	17566301	PRJEB29441_P_NODE_9354_length_372_cov_3.009288_g8913_i0	PRJEB29441	9354	372	3.009288	11.19455136	Thermanaerovibrio	81461	Bacteria	Bacteria	145	5.67e-30	NTclustered	gi\|470485441\|ref\|NR_076701.1\|	81462	g8913	i0	75	3.86827956989247	360	67	93	22	3	348	1742	1392	Thermanaerovibrio acidaminovorans strain Su883 23S ribosomal RNA gene, complete sequence	blastn	1439	145	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
17877955	17877955	PRJEB29441_P_NODE_16895_length_262_cov_5.568075_g16454_i0	PRJEB29441	16895	262	5.568075	14.5883565	Deinococcus radiophilus	32062	Bacteria	Bacteria	460	3.3499999999999996e-125	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g16454	i0	98.473	198.404580152672	262	3	100	1	1	262	1814817	1815077	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	51982	460	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
17878539	17878539	PRJEB29441_P_NODE_9455_length_370_cov_2.439252_g9014_i0	PRJEB29441	9455	370	2.439252	9.0252324	Deinococcus metallilatus	1211322	Bacteria	Bacteria	499	1.04e-136	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g9014	i0	93.713	217.045945945946	334	20	90	1	1	334	329552	329220	Deinococcus metallilatus strain MA1002 chromosome	blastn	80307	499	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
19152339	19152339	PRJEB29441_P_NODE_4756_length_551_cov_18.844622_g4337_i0	PRJEB29441	4756	551	18.844622	103.83386722	Deinococcus radiophilus	32062	Bacteria	Bacteria	780	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g4337	i0	92.405	273.119782214156	553	33	100	7	1	551	1813948	1813403	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	150489	780	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
20114678	20114678	PRJEB29441_P_NODE_17836_length_254_cov_5.195122_g17395_i0	PRJEB29441	17836	254	5.195122	13.19560988	Truepera	332248	Bacteria	Bacteria	444	3.26e-120	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g17395	i0	98.795	192.169291338583	249	3	98	0	1	249	1932	2180	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	48811	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
20114746	20114746	PRJEB29441_P_NODE_28156_length_197_cov_5.547297_g27715_i0	PRJEB29441	28156	197	5.547297	10.92817509	Deinococcus	1298	Bacteria	Bacteria	331	1.96e-86	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g27715	i0	96.97	213.279187817259	198	5	100	1	1	197	2624	2821	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	42016	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
22978187	22978187	PRJEB29441_P_NODE_10359_length_350_cov_14.787375_g9918_i0	PRJEB29441	10359	350	14.787375	51.7558125	Deinococcus radiopugnans	57497	Bacteria	Bacteria	588	2.0399999999999998e-163	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g9918	i0	97.126	246.68	348	10	99	0	3	350	69372	69025	Deinococcus swuensis strain DY59, complete genome	blastn	86338	588	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
23940499	23940499	PRJEB29441_P_NODE_11939_length_322_cov_4.655678_g11498_i0	PRJEB29441	11939	322	4.655678	14.99128316	Deinococcus	1298	Bacteria	Bacteria	584	2.41e-162	NTclustered	gi\|2678098150\|gb\|PP359631.1\|	47478	g11498	i0	99.379	105.152173913043	322	2	100	0	1	322	19	340	Deinococcus sp. strain BFCQ1 16S ribosomal RNA gene, partial sequence	blastn	33859	584	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
23940681	23940681	PRJEB29441_P_NODE_36239_length_173_cov_1.645161_g35798_i0	PRJEB29441	36239	173	1.645161	2.84612853	Truepera	332248	Bacteria	Bacteria	276	7.92e-70	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g35798	i0	95.376	110.225433526012	173	8	100	0	1	173	15	187	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	19069	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
25214520	25214520	PRJEB29441_P_NODE_7240_length_433_cov_314.794271_g6801_i0	PRJEB29441	7240	433	314.794271	1363.05919343	Deinococcus	1298	Bacteria	Bacteria	773	0	NTclustered	gi\|2095695476\|gb\|OK149243.1\|	47478	g6801	i0	98.848	100.145496535797	434	4	100	1	1	433	476	43	Deinococcus sp. strain ATSAR 16S ribosomal RNA gene, partial sequence	blastn	43363	778	0.993573264781491	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.

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);;