metadata: contig_metadata: 7 rows where bioproject = "PRJNA785164" and tax

7 rows where bioproject = "PRJNA785164" 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
7145252	7145252	PRJNA785164_P_NODE_63246_length_234_cov_2.310559_g62781_i0	PRJNA785164	63246	234	2.310559	5.40670806	Deinococcus radiopugnans	57497	Bacteria	Bacteria	427	2.9799999999999993e-115	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g62781	i0	99.573	169.128205128205	234	1	100	0	1	234	69339	69106	Deinococcus swuensis strain DY59, complete genome	blastn	39576	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
17344269	17344269	PRJNA785164_P_NODE_32854_length_317_cov_2.245902_g32389_i0	PRJNA785164	32854	317	2.245902	7.11950934	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	580	3.0599999999999993e-161	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g32389	i0	99.685	243.094637223975	317	1	100	0	1	317	201358	201674	Deinococcus sp. AJ005 chromosome, complete genome	blastn	77061	580	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
21615749	21615749	PRJNA785164_P_NODE_43957_length_272_cov_1.105528_g43492_i0	PRJNA785164	43957	272	1.105528	3.00703616	Deinococcus	1298	Bacteria	Bacteria	459	1.2599999999999999e-124	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g43492	i0	97.059	221.268382352941	272	8	100	0	1	272	73253	72982	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	60185	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
27053725	27053725	PRJNA785164_P_NODE_43522_length_273_cov_1.540000_g43057_i0	PRJNA785164	43522	273	1.54	4.2042	Deinococcus cellulosilyticus	401558	Bacteria	Bacteria	87	1.46e-17	NR	WP_222594715.1	401558	g43057	i0	47	0.912087912087912	83	44	91.2	0	25	273	539	621	WP_222594715.1 DNA primase family protein [Deinococcus cellulosilyticus]	diamond	249	87	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cellulosilyticus
29737552	29737552	PRJNA785164_P_NODE_57490_length_245_cov_0.895349_g57025_i0	PRJNA785164	57490	245	0.895349	2.19360505	Synergistes jonesii	2754	Bacteria	Bacteria	59.7	1.72e-8	NR	WP_281680806.1	2754	g57025	i0	41.7	1.82448979591837	84	36	86.9	3	1	213	12	95	WP_281680806.1 endonuclease domain-containing protein [Synergistes jonesii]	diamond	447	59.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Synergistes	Synergistes jonesii
30590715	30590715	PRJNA785164_P_NODE_60113_length_243_cov_0.905882_g59648_i0	PRJNA785164	60113	243	0.905882	2.20129326	Deinococcus arenicola	2994950	Bacteria	Bacteria	96.7	3.75e-21	NR	WP_317640314.1	2994950	g59648	i0	55.7	1.96296296296296	79	35	97.5	0	241	5	124	202	WP_317640314.1 glycoside hydrolase family 15 protein [Deinococcus arenicola]	diamond	477	96.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus arenicola
30970083	30970083	PRJNA785164_P_NODE_64194_length_226_cov_2.588235_g63729_i0	PRJNA785164	64194	226	2.588235	5.8494111	Trueperaceae bacterium	2026798	Bacteria	Bacteria	60.5	1.4e-8	NR	HET8984466.1	2026798	g63729	i0	49.1	2.82743362831858	57	26	71.7	1	65	226	210	266	HET8984466.1 DUF6384 family protein [Trueperaceae bacterium]	diamond	639	60.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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