metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA812001" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA812001" and tax_phylum = "Aquificota"

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
9738509	9738509	PRJNA812001_P_NODE_18328_length_390_cov_3.047319_g18082_i0	PRJNA812001	18328	390	3.047319	11.8845441	Aquificaceae bacterium	2053503	Bacteria	Bacteria	155	1.67e-42	NR	MCY0867597.1	2053503	g18082	i0	95.4	0.838461538461538	109	5	83.8	0	371	45	26	134	MCY0867597.1 hypothetical protein [Aquificaceae bacterium]	diamond	327	155	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae		Aquificaceae bacterium
13564191	13564191	PRJNA812001_P_NODE_27971_length_342_cov_9.382900_g27725_i0	PRJNA812001	27971	342	9.3829	32.089518	Aquificaceae bacterium	2053503	Bacteria	Bacteria	200	7.98e-62	NR	MFN4319670.1	2053503	g27725	i0	86.9	4.69298245614035	107	14	93.9	0	22	342	122	228	MFN4319670.1 phosphogluconate dehydrogenase (NAD(+)-dependent, decarboxylating) [Aquificaceae bacterium]	diamond	1605	200	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae		Aquificaceae bacterium
27180456	27180456	PRJNA812001_P_NODE_45662_length_298_cov_0.960000_g45416_i0	PRJNA812001	45662	298	0.96	2.8608	Hydrogenobacter hydrogenophilus	35835	Bacteria	Bacteria	61.2	2e-8	NR	WP_096602810.1	35835	g45416	i0	37.7	0.694630872483222	69	43	69.5	0	233	27	1	69	WP_096602810.1 exodeoxyribonuclease VII large subunit [Hydrogenobacter hydrogenophilus]	diamond	207	61.2	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae	Hydrogenobacter	Hydrogenobacter hydrogenophilus
28191058	28191058	PRJNA812001_P_NODE_136066_length_235_cov_3.469136_g135820_i0	PRJNA812001	136066	235	3.469136	8.1524696	Sulfurihydrogenibium sp.	2053621	Bacteria	Bacteria	90.1	6.13e-19	NR	MBX0310512.1	2053621	g135820	i0	91.5	0.6	47	4	60	0	142	2	239	285	MBX0310512.1 hypothetical protein [Sulfurihydrogenibium sp.]	diamond	141	90.1	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Hydrogenothermaceae	Sulfurihydrogenibium	Sulfurihydrogenibium sp.
28791067	28791067	PRJNA812001_P_NODE_80147_length_251_cov_0.865169_g79901_i0	PRJNA812001	80147	251	0.865169	2.17157419	Aquificaceae bacterium	2053503	Bacteria	Bacteria	132	2.8799999999999993e-34	NR	MDM7266167.1	2053503	g79901	i0	92.6	0.812749003984064	68	5	81.3	0	22	225	399	466	MDM7266167.1 DUF1156 domain-containing protein [Aquificaceae bacterium]	diamond	204	132	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae		Aquificaceae bacterium
29043956	29043956	PRJNA812001_P_NODE_65728_length_267_cov_1.706186_g65482_i0	PRJNA812001	65728	267	1.706186	4.55551662	Sulfurihydrogenibium sp.	2053621	Bacteria	Bacteria	100	1.46e-22	NR	MBX0311688.1	2053621	g65482	i0	92	0.561797752808989	50	4	56.2	0	18	167	377	426	MBX0311688.1 hypothetical protein [Sulfurihydrogenibium sp.]	diamond	150	100	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Hydrogenothermaceae	Sulfurihydrogenibium	Sulfurihydrogenibium sp.
29327878	29327878	PRJNA812001_P_NODE_3949_length_774_cov_4.854494_g3725_i0	PRJNA812001	3949	774	4.854494	37.57378356	Sulfurihydrogenibium sp.	2053621	Bacteria	Bacteria	103	4.46e-21	NR	MBX0310511.1	2053621	g3725	i0	87.1	0.24031007751938	62	8	24	0	297	482	528	589	MBX0310511.1 hypothetical protein [Sulfurihydrogenibium sp.]	diamond	186	103	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Hydrogenothermaceae	Sulfurihydrogenibium	Sulfurihydrogenibium sp.
29368369	29368369	PRJNA812001_P_NODE_31909_length_330_cov_1.428016_g31663_i0	PRJNA812001	31909	330	1.428016	4.7124528	Pseudomonadati	3379134	Bacteria	Bacteria	71.2	4.89e-12	NR	WP_089322045.1	240169	g31663	i0	45.2	6.72727272727273	73	40	66.4	0	220	2	4	76	WP_089322045.1 bifunctional methylenetetrahydrofolate dehydrogenase/methenyltetrahydrofolate cyclohydrolase FolD [Desulfurobacterium atlanticum]	diamond	2220	71.2	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Desulfurobacteriales	Desulfurobacteriaceae	Desulfurobacterium	Desulfurobacterium atlanticum
30252843	30252843	PRJNA812001_P_NODE_125832_length_242_cov_0.911243_g125586_i0	PRJNA812001	125832	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	147	2.95e-40	NR	MBX0310205.1	2053621	g125586	i0	93.6	1.93388429752066	78	5	96.7	0	234	1	201	278	MBX0310205.1 hypothetical protein [Sulfurihydrogenibium sp.]	diamond	468	147	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Hydrogenothermaceae	Sulfurihydrogenibium	Sulfurihydrogenibium sp.
30505470	30505470	PRJNA812001_P_NODE_39233_length_311_cov_2.537815_g38987_i0	PRJNA812001	39233	311	2.537815	7.89260465	Hydrogenobacter	939	Bacteria	Bacteria	110	1.08e-26	NR	WP_304092352.1	940	g38987	i0	50	1.86173633440514	94	45	90.7	2	15	296	64	155	WP_304092352.1 hypothetical protein [Hydrogenobacter thermophilus]	diamond	579	110	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae	Hydrogenobacter	Hydrogenobacter thermophilus
32457251	32457251	PRJNA812001_P_NODE_136919_length_228_cov_2.058065_g136673_i0	PRJNA812001	136919	228	2.058065	4.6923882	Hydrogenobacter thermophilus TK-6	608538	Bacteria	Bacteria	61.6	1.92e-10	NR	ADO45317.1	608538	g136673	i0	65.9	0.973684210526316	41	14	53.9	0	105	227	5	45	ADO45317.1 hypothetical protein Hydth_0921 [Hydrogenobacter thermophilus TK-6]	diamond	222	61.6	1	Bacteria	Pseudomonadati	Aquificota	Aquificia	Aquificales	Aquificaceae	Hydrogenobacter	Hydrogenobacter thermophilus

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