metadata: contig_metadata: 15 rows where bioproject = "PRJNA758087" and tax

15 rows where bioproject = "PRJNA758087" 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
733530	733530	PRJNA758087_P_NODE_34841_length_339_cov_1.375940_g33521_i0	PRJNA758087	34841	339	1.37594	4.6644366	Deinococcus aquaticus	328692	Bacteria	Bacteria	516	9.44e-142	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g33521	i0	97.667	206.705014749263	300	7	88	0	1	300	715121	714822	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	70073	516	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
2009673	2009673	PRJNA758087_P_NODE_37082_length_308_cov_1.548936_g35762_i0	PRJNA758087	37082	308	1.548936	4.77072288	Deinococcus geothermalis	68909	Bacteria	Bacteria	490	5.14e-134	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g35762	i0	96.918	0.948051948051948	292	9	95	0	17	308	520180	520471	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	292	490	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
4562069	4562069	PRJNA758087_P_NODE_36004_length_322_cov_2.473896_g34684_i0	PRJNA758087	36004	322	2.473896	7.96594512	Thermus thermophilus	274	Bacteria	Bacteria	568	2.4299999999999993e-157	NTclustered	gi\|333967597\|gb\|CP002778.1\|	762633	g34684	i0	100	6.64285714285714	307	0	95	0	1	307	394446	394752	Thermus thermophilus SG0.5JP17-16 plasmid pTHTHE1601, complete sequence	blastn	2139	568	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
5836654	5836654	PRJNA758087_P_NODE_17285_length_690_cov_33.578606_g16013_i0	PRJNA758087	17285	690	33.578606	231.6923814	Deinococcus yunweiensis	367282	Bacteria	Bacteria	1171	0	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g16013	i0	98.496	1.81014492753623	665	8	96	2	25	688	221133	221796	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	1249	1171	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
9661757	9661757	PRJNA758087_P_NODE_24328_length_516_cov_4.009029_g23008_i0	PRJNA758087	24328	516	4.009029	20.68658964	Deinococcus cavernae	2320857	Bacteria	Bacteria	278	4.53e-92	NR	WP_119762050.1	2320857	g23008	i0	99.3	0.790697674418605	136	1	79.1	0	408	1	1	136	WP_119762050.1 nucleotidyltransferase domain-containing protein [Deinococcus cavernae]	diamond	408	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
13487440	13487440	PRJNA758087_P_NODE_35791_length_325_cov_2.440476_g34471_i0	PRJNA758087	35791	325	2.440476	7.931547	Thermus scotoductus	37636	Bacteria	Bacteria	532	8.949999999999998e-147	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g34471	i0	99.32	36.7815384615385	294	2	90	0	1	294	434372	434665	Thermus scotoductus SA-01, complete genome	blastn	11954	532	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
16035547	16035547	PRJNA758087_P_NODE_10213_length_1005_cov_4.410944_g9149_i0	PRJNA758087	10213	1005	4.410944	44.3299872	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	1506	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g9149	i0	95.45	41.3004975124378	945	41	94	1	17	959	2009340	2008396	Deinococcus sp. NW-56 chromosome, complete genome	blastn	41507	1506	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
17780522	17780522	PRJNA758087_P_NODE_37794_length_299_cov_1.721239_g36474_i0	PRJNA758087	37794	299	1.721239	5.14650461	Deinococcus	1298	Bacteria	Bacteria	446	1.09e-120	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g36474	i0	96	192.983277591973	275	9	92	2	1	275	881206	881478	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	57702	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
21136353	21136353	PRJNA758087_P_NODE_43677_length_241_cov_0.916667_g42357_i0	PRJNA758087	43677	241	0.916667	2.20916747	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	366	6.82e-97	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g42357	i0	98.095	31.746887966805	210	4	87	0	1	210	1061159	1061368	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	7651	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
22410649	22410649	PRJNA758087_P_NODE_23258_length_539_cov_2.478541_g21941_i0	PRJNA758087	23258	539	2.478541	13.35933599	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	632	1.4899999999999995e-176	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g21941	i0	90.947	169.760667903525	475	36	87	7	44	514	1638537	1639008	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	91501	632	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
22411097	22411097	PRJNA758087_P_NODE_39818_length_275_cov_1.287129_g38498_i0	PRJNA758087	39818	275	1.287129	3.53960475	Deinococcus	1298	Bacteria	Bacteria	109	4.4000000000000005e-27	NR	WP_129118210.1	1298	g38498	i0	83.6	7.98545454545455	61	10	66.5	0	37	219	1	61	WP_129118210.1 MULTISPECIES: PIG-L deacetylase family protein [Deinococcus]	diamond	2196	110	0.990909090909091	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
24959674	24959674	PRJNA758087_P_NODE_17020_length_698_cov_28.388800_g15754_i0	PRJNA758087	17020	698	28.3888	198.153824	Deinococcus gobiensis	502394	Bacteria	Bacteria	1160	0	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g15754	i0	99.53	71.6074498567335	638	2	91	1	32	668	1241386	1240749	Deinococcus gobiensis I-0, complete genome	blastn	49982	1160	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
24960100	24960100	PRJNA758087_P_NODE_32320_length_374_cov_4.033223_g31000_i0	PRJNA758087	32320	374	4.033223	15.08425402	Truepera radiovictrix	332249	Bacteria	Bacteria	88.2	1.36e-18	NR	WP_013179167.1	332249	g31000	i0	59.3	0.649732620320856	81	33	65	0	7	249	136	216	WP_013179167.1 metal-dependent transcriptional regulator [Truepera radiovictrix]	diamond	243	88.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
27147346	27147346	PRJNA758087_P_NODE_31002_length_395_cov_4.077640_g29682_i0	PRJNA758087	31002	395	4.07764	16.106678	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	48.5	9.34e-4	NR	WP_041232012.1	432329	g29682	i0	50	0.379746835443038	50	25	38	0	382	233	143	192	WP_041232012.1 SMI1/KNR4 family protein [Deinococcus peraridilitoris]	diamond	150	48.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
29105790	29105790	PRJNA758087_P_NODE_42688_length_246_cov_0.890173_g41368_i0	PRJNA758087	42688	246	0.890173	2.18982558	Deinococcus caeni	569127	Bacteria	Bacteria	153	1.3099999999999999e-42	NR	WP_380064848.1	569127	g41368	i0	93.8	1.97560975609756	81	5	98.8	0	3	245	165	245	WP_380064848.1 hypothetical protein [Deinococcus caeni]	diamond	486	153	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus caeni

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