metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA751877" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA751877" 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
3277616	3277616	PRJNA751877_P_NODE_18143_length_277_cov_1.323529_g18021_i0	PRJNA751877	18143	277	1.323529	3.66617533	Deinococcus oregonensis	1805970	Bacteria	Bacteria	143	1.02e-40	NR	WP_380009940.1	1805970	g18021	i0	76.1	1.9927797833935	92	22	99.6	0	2	277	113	204	WP_380009940.1 hypothetical protein [Deinococcus oregonensis]	diamond	552	143	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus oregonensis
27305794	27305794	PRJNA751877_P_NODE_20603_length_261_cov_1.638298_g20481_i0	PRJNA751877	20603	261	1.638298	4.27595778	Truepera radiovictrix	332249	Bacteria	Bacteria	103	8.44e-26	NR	WP_013177066.1	332249	g20481	i0	64	0.988505747126437	86	30	98.9	1	260	3	62	146	WP_013177066.1 helix-hairpin-helix domain-containing protein [Truepera radiovictrix]	diamond	258	103	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
28316144	28316144	PRJNA751877_P_NODE_23626_length_250_cov_0.870056_g23504_i0	PRJNA751877	23626	250	0.870056	2.17514	Deinococcota bacterium	1913990	Bacteria	Bacteria	61.6	2.79e-10	NR	MEM7737149.1	1913990	g23504	i0	53.6	1.356	56	26	67.2	0	249	82	28	83	MEM7737149.1 type II toxin-antitoxin system prevent-host-death family antitoxin [Deinococcota bacterium]	diamond	339	61.6	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
32455827	32455827	PRJNA751877_P_NODE_25119_length_248_cov_0.880000_g24997_i0	PRJNA751877	25119	248	0.88	2.1824	Deinococcus antarcticus	1298767	Bacteria	Bacteria	99	4.159999999999999e-23	NR	WP_380075582.1	1298767	g24997	i0	97.9	0.568548387096774	47	1	56.9	0	107	247	1	47	WP_380075582.1 hypothetical protein [Deinococcus antarcticus]	diamond	141	99	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus

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