metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA908278" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA908278" 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
27245626	27245626	PRJNA908278_P_NODE_34143_length_242_cov_1.366864_g34040_i0	PRJNA908278	34143	242	1.366864	3.30781088	Thermus sp.	275	Bacteria	Bacteria	63.2	2.3e-9	NR	WP_347241856.1	275	g34040	i0	43.8	8.64049586776859	64	36	79.3	0	51	242	179	242	WP_347241856.1 hypothetical protein [Thermus sp.]	diamond	2091	63.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
27443002	27443002	PRJNA908278_P_NODE_17603_length_304_cov_1.333333_g17500_i0	PRJNA908278	17603	304	1.333333	4.05333232	Bacteria	2	Bacteria	Bacteria	134	7.21e-37	NR	MDX2007147.1	1955249	g17500	i0	64	7.84539473684211	100	36	98.7	0	302	3	87	186	MDX2007147.1 ZIP family metal transporter [Meiothermus sp.]	diamond	2385	135	0.992592592592593	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp.
29171957	29171957	PRJNA908278_P_NODE_28589_length_249_cov_0.875000_g28486_i0	PRJNA908278	28589	249	0.875	2.17875	Deinococcus kurensis	2662757	Bacteria	Bacteria	129	2.8e-36	NR	WP_155298389.1	2662757	g28486	i0	82.1	0.939759036144578	78	14	94	0	247	14	57	134	WP_155298389.1 type II secretion system protein [Deinococcus kurensis]	diamond	234	129	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus kurensis
29298114	29298114	PRJNA908278_P_NODE_12709_length_347_cov_2.489051_g12606_i0	PRJNA908278	12709	347	2.489051	8.63700697	Deinococcus rubellus	1889240	Bacteria	Bacteria	72.4	1.13e-12	NR	WP_260561237.1	1889240	g12606	i0	36.4	0.92507204610951	107	60	88.2	3	346	41	5	108	WP_260561237.1 DUF4397 domain-containing protein [Deinococcus rubellus]	diamond	321	72.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
30285039	30285039	PRJNA908278_P_NODE_3552_length_604_cov_1.644068_g3449_i0	PRJNA908278	3552	604	1.644068	9.93017072	Bacteria	2	Bacteria	Bacteria	213	4.1e-62	NR	WP_015234697.1	432329	g3449	i0	53.7	5.90562913907285	205	87	99.8	3	1	603	374	574	WP_015234697.1 NAD-dependent malic enzyme [Deinococcus peraridilitoris]	diamond	3567	214	0.995327102803738	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
31232313	31232313	PRJNA908278_P_NODE_33655_length_243_cov_0.905882_g33552_i0	PRJNA908278	33655	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	67	7.91e-11	NR	WP_012896261.1	93929	g33552	i0	47.6	4.88888888888889	82	31	98.8	3	240	1	207	278	WP_012896261.1 potassium channel beta subunit family protein [Thermotoga petrophila]	diamond	1188	67.4	0.99406528189911	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga petrophila

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