metadata: contig_metadata: 5 rows where bioproject = "PRJNA594101", tax_kingdom = "Thermotogati" and tax

5 rows where bioproject = "PRJNA594101", tax_kingdom = "Thermotogati" and tax_superkingdom = "Bacteria"

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
27205935	27205935	PRJNA594101_S_NODE_57762_length_241_cov_0.869048_g57460_i0	PRJNA594101	57762	241	0.869048	2.09440568	Synergistaceae bacterium	2053624	Bacteria	Bacteria	40.4	0.0233	NR	MCL2010685.1	2053624	g57460	i0	41	0.485477178423237	39	23	48.5	0	75	191	9	47	MCL2010685.1 hypothetical protein [Synergistaceae bacterium]	diamond	117	40.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
28279689	28279689	PRJNA594101_S_NODE_25546_length_335_cov_1.381679_g25244_i0	PRJNA594101	25546	335	1.381679	4.62862465	Thermosipho sp. (in: thermotogales)	1968895	Bacteria	Bacteria	83.2	3.35e-16	NR	MDK2886678.1	1968895	g25244	i0	42.1	2.88358208955224	107	61	95.8	1	12	332	75	180	MDK2886678.1 threonine aldolase [Thermosipho sp. (in: thermotogales)]	diamond	966	83.2	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho sp. (in: thermotogales)
28753481	28753481	PRJNA594101_S_NODE_3327_length_870_cov_2.836888_g3086_i0	PRJNA594101	3327	870	2.836888	24.6809256	Deinococcus misasensis	392413	Bacteria	Bacteria	82.8	1.17e-13	NR	WP_034336163.1	392413	g3086	i0	28.9	0.655172413793103	190	122	62.1	5	121	660	281	467	WP_034336163.1 thiol-activated cytolysin family protein [Deinococcus misasensis]	diamond	570	82.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus misasensis
30030087	30030087	PRJNA594101_S_NODE_24031_length_344_cov_4.413284_g23729_i0	PRJNA594101	24031	344	4.413284	15.18169696	Bacteria	2	Bacteria	Bacteria	51.6	2.25e-5	NR	WP_189000849.1	392414	g23729	i0	51.9	2.32848837209302	52	25	45.3	0	188	343	56	107	WP_189000849.1 NADAR family protein [Deinococcus roseus]	diamond	801	51.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus roseus
30775031	30775031	PRJNA594101_S_NODE_46854_length_255_cov_2.115385_g46552_i0	PRJNA594101	46854	255	2.115385	5.39423175	Deinococcus radiophilus	32062	Bacteria	Bacteria	44.3	0.0112	NR	WP_126350846.1	32062	g46552	i0	40.8	0.576470588235294	49	29	57.6	0	253	107	93	141	WP_126350846.1 DMT family transporter [Deinococcus radiophilus]	diamond	147	44.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus

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