metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJEB39269" and tax

14 rows where analysis = "blastn", bioproject = "PRJEB39269" 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
57124	57124	PRJEB39269_P_NODE_71601_length_166_cov_1.921260_g71196_i0	PRJEB39269	71601	166	1.92126	3.1892916	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g71196	i0	100	206.385542168675	166	0	100	0	1	166	73533	73698	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	34260	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
2264555	2264555	PRJEB39269_P_NODE_68482_length_169_cov_5.330769_g68077_i0	PRJEB39269	68482	169	5.330769	9.00899961	Thermus	270	Bacteria	Bacteria	141	2.93e-29	NTclustered	gi\|1699893943\|dbj\|AP019794.1\|	274	g68077	i0	98.734	8.97633136094675	79	1	94	0	1	79	1901128	1901050	Thermus thermophilus AA2-29 DNA, complete genome	blastn	1517	141	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
2607006	2607006	PRJEB39269_P_NODE_743_length_1274_cov_3.834818_g644_i0	PRJEB39269	743	1274	3.834818	48.85558132	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	2278	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g644	i0	98.98	205.845368916797	1274	10	100	3	1	1274	75052	73782	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	262247	2278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
2607027	2607027	PRJEB39269_P_NODE_89803_length_151_cov_1.464286_g89398_i0	PRJEB39269	89803	151	1.464286	2.21107186	Deinococcus gobiensis	502394	Bacteria	Bacteria	263	5.23e-66	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g89398	i0	98.013	30.6622516556291	151	3	100	0	1	151	112527	112377	Deinococcus gobiensis I-0, complete genome	blastn	4630	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
6092343	6092343	PRJEB39269_P_NODE_58105_length_181_cov_1.154930_g57700_i0	PRJEB39269	58105	181	1.15493	2.0904233	Truepera	332248	Bacteria	Bacteria	200	5.19e-47	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g57700	i0	95.935	123.17679558011	123	5	68	0	1	123	1365	1243	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	22295	200	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
7709489	7709489	PRJEB39269_P_NODE_81607_length_157_cov_5.364407_g81202_i0	PRJEB39269	81607	157	5.364407	8.42211899	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	246	5.54e-61	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g81202	i0	94.512	5.22292993630573	164	2	100	1	1	157	1476438	1476275	Thermus sp. NEB1569 chromosome, complete genome	blastn	820	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
10259849	10259849	PRJEB39269_P_NODE_66229_length_170_cov_4.099237_g65824_i0	PRJEB39269	66229	170	4.099237	6.9687029	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	148	1.7599999999999998e-31	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g65824	i0	100	2.82352941176471	80	0	94	0	1	80	691680	691759	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	480	148	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
13742700	13742700	PRJEB39269_P_NODE_50191_length_194_cov_1.051613_g49786_i0	PRJEB39269	50191	194	1.051613	2.04012922	Truepera	332248	Bacteria	Bacteria	279	7.06e-71	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g49786	i0	93.158	155.396907216495	190	13	98	0	3	192	1789	1600	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	30147	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
16633939	16633939	PRJEB39269_P_NODE_78534_length_159_cov_4.608333_g78129_i0	PRJEB39269	78534	159	4.608333	7.32724947	Thermus antranikianii	88190	Bacteria	Bacteria	230	5.67e-56	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g78129	i0	91.908	106.654088050314	173	0	100	1	1	159	509619	509791	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	16958	230	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
20115754	20115754	PRJEB39269_P_NODE_43736_length_207_cov_3.214286_g43331_i0	PRJEB39269	43736	207	3.214286	6.65357202	Deinococcus	1298	Bacteria	Bacteria	361	2.65e-95	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g43331	i0	98.068	217.676328502415	207	4	100	0	1	207	709	503	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	45059	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
20115808	20115808	PRJEB39269_P_NODE_90876_length_150_cov_2.216216_g90471_i0	PRJEB39269	90876	150	2.216216	3.324324	root	1	Root_unresolved	Root_unresolved	278	1.85e-70	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g90471	i0	100	104	150	0	100	0	1	150	458	607	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	15600	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
21391333	21391333	PRJEB39269_P_NODE_66017_length_170_cov_5.809160_g65612_i0	PRJEB39269	66017	170	5.80916	9.875572	Thermus	270	Bacteria	Bacteria	148	1.7599999999999998e-31	NTclustered	gi\|2701833777\|dbj\|AP031329.1\|	274	g65612	i0	100	47.1941176470588	80	0	74	0	91	170	109303	109382	Thermus thermophilus TF24 plasmid pTF24b DNA, complete sequence	blastn	8023	148	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
23009139	23009139	PRJEB39269_P_NODE_78839_length_159_cov_3.341667_g78434_i0	PRJEB39269	78839	159	3.341667	5.31325053	Thermus sp. PS18	2849039	Bacteria	Bacteria	158	2.71e-34	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g78434	i0	84.409	4.69182389937107	186	2	100	11	1	159	1732931	1733116	Thermus sp. PS18 chromosome, complete genome	blastn	746	158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
23009152	23009152	PRJEB39269_P_NODE_82959_length_156_cov_3.675214_g82554_i0	PRJEB39269	82959	156	3.675214	5.73333384	Thermus scotoductus	37636	Bacteria	Bacteria	272	9.059999999999999e-69	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g82554	i0	98.077	78.9807692307692	156	3	100	0	1	156	757074	756919	Thermus scotoductus SA-01, complete genome	blastn	12321	272	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus

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