metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Thermotogota"

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
29677649	29677649	PRJNA946307_P_NODE_163650_length_161_cov_3.973214_g162776_i0	PRJNA946307	163650	161	3.973214	6.39687454	Thermotogota bacterium	2053689	Bacteria	Bacteria	48.9	8.06e-5	NR	HPB87749.1	2053689	g162776	i0	48.9	0.838509316770186	45	22	83.9	1	139	5	180	223	HPB87749.1 phage portal protein [Thermotogota bacterium]	diamond	135	48.9	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
30246815	30246815	PRJNA946307_P_NODE_173212_length_153_cov_2.644231_g172338_i0	PRJNA946307	173212	153	2.644231	4.04567343	Petrotogaceae bacterium	2819251	Bacteria	Bacteria	75.9	2.19e-14	NR	HOT31121.1	2819251	g172338	i0	94.4	4.94117647058824	36	2	70.6	0	15	122	332	367	HOT31121.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Petrotogaceae bacterium]	diamond	756	75.9	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae		Petrotogaceae bacterium
31352661	31352661	PRJNA946307_P_NODE_140676_length_167_cov_1.364407_g139802_i0	PRJNA946307	140676	167	1.364407	2.27855969	Petrotogaceae bacterium	2819251	Bacteria	Bacteria	98.6	3.37e-23	NR	HQI79463.1	2819251	g139802	i0	96	0.898203592814371	50	2	89.8	0	16	165	13	62	HQI79463.1 HD-GYP domain-containing protein [Petrotogaceae bacterium]	diamond	150	98.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae		Petrotogaceae bacterium
31479332	31479332	PRJNA946307_P_NODE_153876_length_164_cov_0.886957_g153002_i0	PRJNA946307	153876	164	0.886957	1.45460948	Fervidobacterium sp.	1871331	Bacteria	Bacteria	80.5	6.05e-18	NR	HQG01813.1	1871331	g153002	i0	97.7	2.41463414634146	44	1	80.5	0	19	150	1	44	HQG01813.1 UDP-N-acetylglucosamine 1-carboxyvinyltransferase [Fervidobacterium sp.]	diamond	396	80.5	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
32459971	32459971	PRJNA946307_P_NODE_158479_length_163_cov_0.894737_g157605_i0	PRJNA946307	158479	163	0.894737	1.45842131	Petrotogaceae bacterium	2819251	Bacteria	Bacteria	48.1	1.59e-4	NR	HNV06322.1	2819251	g157605	i0	96.3	0.993865030674847	27	1	49.7	0	97	17	1	27	HNV06322.1 PQQ-binding-like beta-propeller repeat protein [Petrotogaceae bacterium]	diamond	162	48.1	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae		Petrotogaceae bacterium
32712209	32712209	PRJNA946307_P_NODE_139320_length_167_cov_2.415254_g138446_i0	PRJNA946307	139320	167	2.415254	4.03347418	Mesotoga sp.	2053577	Bacteria	Bacteria	62	2.04e-9	NR	HRV01180.1	2053577	g138446	i0	64	0.898203592814371	50	18	89.8	0	166	17	211	260	HRV01180.1 hypothetical protein [Mesotoga sp.]	diamond	150	62	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga sp.
32750441	32750441	PRJNA946307_P_NODE_84480_length_191_cov_2.549296_g83606_i0	PRJNA946307	84480	191	2.549296	4.86915536	FCB group	1783270	Bacteria	Bacteria	99.4	2.18e-22	NR	WP_333640880.1	1184387	g83606	i0	98.2	3.45549738219895	55	1	86.4	0	166	2	1017	1071	WP_333640880.1 PEGA domain-containing protein [Mesotoga prima]	diamond	660	99.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga prima

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