metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA415636" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA415636" and tax_kingdom = "Pseudomonadati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26980584	26980584	PRJNA415636_S_NODE_6242_length_208_cov_4.950311_g6195_i0	PRJNA415636	6242	208	4.950311	10.29664688	Horticoccus luteus	2862869	Bacteria	Bacteria	42.4	0.0279	NR	WP_220165494.1	2862869	g6195	i0	41.1	0.807692307692308	56	28	73.6	1	19	171	55	110	WP_220165494.1 ThuA domain-containing protein [Horticoccus luteus]	diamond	168	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
28717847	28717847	PRJNA415636_S_NODE_5327_length_222_cov_1.902857_g5280_i0	PRJNA415636	5327	222	1.902857	4.22434254	Treponema sp.	166	Bacteria	Bacteria	56.6	2.92e-7	NR	MBR5402350.1	166	g5280	i0	42.9	1.63513513513514	63	35	85.1	1	10	198	204	265	MBR5402350.1 FkbM family methyltransferase [Treponema sp.]	diamond	363	56.6	1	Bacteria		Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30201701	30201701	PRJNA415636_S_NODE_6132_length_210_cov_1.484663_g6085_i0	PRJNA415636	6132	210	1.484663	3.1177923	Planctomycetota bacterium	2026780	Bacteria	Bacteria	62.8	2.03e-9	NR	MBI4878578.1	2026780	g6085	i0	44.3	0.871428571428571	61	34	87.1	0	184	2	348	408	MBI4878578.1 hypothetical protein [Planctomycetota bacterium]	diamond	183	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30233538	30233538	PRJNA415636_S_NODE_4732_length_233_cov_1.370968_g4685_i0	PRJNA415636	4732	233	1.370968	3.19435544	Solemya velum gill symbiont	2340	Bacteria	Bacteria	43.1	0.0232	NR	WP_078456856.1	2340	g4685	i0	70.8	0.309012875536481	24	7	30.9	0	99	28	328	351	WP_078456856.1 reverse transcriptase domain-containing protein [Solemya velum gill symbiont]	diamond	72	43.1	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Solemya velum gill symbiont
30360394	30360394	PRJNA415636_S_NODE_5272_length_223_cov_1.448864_g5225_i0	PRJNA415636	5272	223	1.448864	3.23096672	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	46.2	0.00151	NR	TNE61774.1	1913988	g5225	i0	53.8	2.21973094170404	39	18	52.5	0	37	153	210	248	TNE61774.1 MAG: electron transfer flavoprotein subunit beta/FixA family protein [Alphaproteobacteria bacterium]	diamond	495	46.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
30360395	30360395	PRJNA415636_S_NODE_5772_length_215_cov_1.410714_g5725_i0	PRJNA415636	5772	215	1.410714	3.0330351	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.1	0.0186	NR	TMA74746.1	2026735	g5725	i0	48.8	0.6	43	22	60	0	148	20	68	110	TMA74746.1 MAG: alpha/beta fold hydrolase [Deltaproteobacteria bacterium]	diamond	129	43.1	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30612546	30612546	PRJNA415636_S_NODE_3833_length_253_cov_1.766990_g3786_i0	PRJNA415636	3833	253	1.76699	4.4704847	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	51.2	1.86e-5	NR	HIA48344.1	2030809	g3786	i0	47.3	1.30434782608696	55	24	65.2	1	219	55	101	150	HIA48344.1 hypothetical protein [Candidatus Hydrogenedentota bacterium]	diamond	330	51.2	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota					Candidatus Hydrogenedentota bacterium
31624133	31624133	PRJNA415636_S_NODE_5836_length_214_cov_1.526946_g5789_i0	PRJNA415636	5836	214	1.526946	3.26766444	Escherichia coli	562	Bacteria	Bacteria	80.5	1.16e-17	NR	WP_329792810.1	562	g5789	i0	57.4	2.56542056074766	61	26	85.5	0	196	14	23	83	WP_329792810.1 hypothetical protein, partial [Escherichia coli]	diamond	549	80.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli

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