metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA758087" and tax

10 rows where analysis = "blastn", 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
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)
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

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