metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1197996" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1197996" 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
2874941	2874941	PRJNA1197996_S_NODE_2743_length_503_cov_1.865116_g2691_i0	PRJNA1197996	2743	503	1.865116	9.38153348	Deinococcus ficus	317577	Bacteria	Bacteria	822	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g2691	i0	96.223	213.268389662028	503	18	100	1	1	503	2341851	2341350	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	107274	822	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
8696675	8696675	PRJNA1197996_S_NODE_5047_length_413_cov_1.350000_g4993_i0	PRJNA1197996	5047	413	1.35	5.5755	Deinococcus	1298	Bacteria	Bacteria	715	0	NTclustered	gi\|442558064\|gb\|KC245148.1\|	1282409	g4993	i0	98.058	107.825665859564	412	7	99	1	1	411	68	479	Deinococcus sp. HME8654 16S ribosomal RNA gene, partial sequence	blastn	44532	715	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. HME8654
9251723	9251723	PRJNA1197996_S_NODE_11908_length_316_cov_2.967078_g11854_i0	PRJNA1197996	11908	316	2.967078	9.37596648	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	575	1.4199999999999995e-159	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g11854	i0	99.682	194.598101265823	314	1	99	0	3	316	73341	73654	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	61493	575	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
11802819	11802819	PRJNA1197996_S_NODE_6550_length_381_cov_2.444805_g6496_i0	PRJNA1197996	6550	381	2.444805	9.31470705	Deinococcus aquaticus	328692	Bacteria	Bacteria	608	1.719999999999999e-169	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g6496	i0	95.561	206.144356955381	383	12	100	5	1	381	714597	714976	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	78541	608	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
15626599	15626599	PRJNA1197996_S_NODE_11393_length_321_cov_1.500000_g11339_i0	PRJNA1197996	11393	321	1.5	4.815	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	488	1.9399999999999996e-133	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g11339	i0	94.099	211.084112149533	322	18	100	1	1	321	543942	543621	Deinococcus sp. NW-56 chromosome, complete genome	blastn	67758	488	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
17621482	17621482	PRJNA1197996_S_NODE_7654_length_363_cov_3.703448_g7600_i0	PRJNA1197996	7654	363	3.703448	13.44351624	Allomeiothermus	2935559	Bacteria	Bacteria	660	0	NTclustered	gi\|470486339\|ref\|NR_076751.1\|	52022	g7600	i0	99.449	47.6198347107438	363	2	100	0	1	363	434	72	Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence	blastn	17286	660	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
19449854	19449854	PRJNA1197996_S_NODE_12756_length_309_cov_2.347458_g12702_i0	PRJNA1197996	12756	309	2.347458	7.25364522	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	551	2.3299999999999993e-152	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g12702	i0	100	225.601941747573	298	0	96	0	12	309	57790	57493	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	69711	551	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
22000636	22000636	PRJNA1197996_S_NODE_15998_length_288_cov_1.074419_g15944_i0	PRJNA1197996	15998	288	1.074419	3.09432672	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	359	1.4e-94	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g15944	i0	91.829	167.184027777778	257	21	89	0	1	257	69281	69537	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	48149	359	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum

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