metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA635874" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA635874" 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
607873	607873	PRJNA635874_P_NODE_54781_length_248_cov_0.880000_g54634_i0	PRJNA635874	54781	248	0.88	2.1824	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	217	7.52e-52	NTclustered	gi\|1819263924\|gb\|CP049359.1\|	1288484	g54634	i0	84.783	5.29435483870968	230	19	87	8	23	238	130034	129807	Deinococcus wulumuqiensis R12 plasmid unnamed2, complete sequence	blastn	1313	217	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
3158662	3158662	PRJNA635874_P_NODE_49663_length_250_cov_0.870056_g49516_i0	PRJNA635874	49663	250	0.870056	2.17514	Deinococcus aquaticus	328692	Bacteria	Bacteria	412	9.02e-111	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g49516	i0	96.761	72.06	247	8	99	0	4	250	1459094	1458848	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	18015	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
6986864	6986864	PRJNA635874_P_NODE_74246_length_236_cov_2.441718_g74099_i0	PRJNA635874	74246	236	2.441718	5.76245448	Deinococcus ficus	317577	Bacteria	Bacteria	361	3.1e-95	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g74099	i0	94.468	188.080508474576	235	11	99	2	1	234	2341783	2341550	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	44387	361	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
8261084	8261084	PRJNA635874_P_NODE_53987_length_248_cov_0.880000_g53840_i0	PRJNA635874	53987	248	0.88	2.1824	Deinococcus geothermalis	68909	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g53840	i0	99.597	4	248	1	100	0	1	248	21361	21114	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	992	453	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
9535904	9535904	PRJNA635874_P_NODE_35488_length_283_cov_1.309524_g35341_i0	PRJNA635874	35488	283	1.309524	3.70595292	Deinococcus sp. JJ521	1647448	Bacteria	Bacteria	490	4.67e-134	NTclustered	gi\|823104572\|gb\|KP128922.1\|	1647448	g35341	i0	97.88	99.9929328621908	283	6	100	0	1	283	416	134	Deinococcus sp. JJ521 16S ribosomal RNA gene, partial sequence	blastn	28298	490	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. JJ521
13908571	13908571	PRJNA635874_P_NODE_47831_length_251_cov_0.865169_g47684_i0	PRJNA635874	47831	251	0.865169	2.17157419	Deinococcus	1298	Bacteria	Bacteria	206	1.65e-48	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g47684	i0	92.908	16.0876494023904	141	10	63	0	53	193	1015620	1015760	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	4038	207	0.995169082125604	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
14636625	14636625	PRJNA635874_P_NODE_46572_length_251_cov_0.865169_g46425_i0	PRJNA635874	46572	251	0.865169	2.17157419	Deinococcus geothermalis	68909	Bacteria	Bacteria	420	5.41e-113	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g46425	i0	96.813	1	251	8	100	0	1	251	408662	408912	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	251	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
17185800	17185800	PRJNA635874_P_NODE_53094_length_249_cov_0.869318_g52947_i0	PRJNA635874	53094	249	0.869318	2.16460182	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	344	3.32e-90	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g52947	i0	91.566	13.0722891566265	249	21	100	0	1	249	689948	690196	Deinococcus sp. NW-56 chromosome, complete genome	blastn	3255	344	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
18460008	18460008	PRJNA635874_P_NODE_54555_length_248_cov_0.880000_g54408_i0	PRJNA635874	54555	248	0.88	2.1824	Deinococcus geothermalis	68909	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g54408	i0	100	1	248	0	100	0	1	248	2070104	2069857	Deinococcus geothermalis DSM 11300, complete genome	blastn	248	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
19734689	19734689	PRJNA635874_P_NODE_59076_length_246_cov_0.890173_g58929_i0	PRJNA635874	59076	246	0.890173	2.18982558	Deinococcus geothermalis	68909	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g58929	i0	91.463	3.96747967479675	246	21	100	0	1	246	418742	418497	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	976	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
23560346	23560346	PRJNA635874_P_NODE_48159_length_251_cov_0.865169_g48012_i0	PRJNA635874	48159	251	0.865169	2.17157419	Deinococcus aquaticus	328692	Bacteria	Bacteria	390	4.239999999999999e-104	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g48012	i0	94.821	44.7211155378486	251	12	100	1	1	251	1294609	1294360	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	11225	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus

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