metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA728642" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA728642" and tax_phylum = "Acidobacteriota"

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_species
10916804	10916804	PRJNA728642_P_NODE_12849_length_281_cov_1.480769_g12578_i0	PRJNA728642	12849	281	1.480769	4.16096089	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	140	2.67e-36	NR	HQU82238.1	2283092	g12578	i0	67.7	1.98576512455516	93	30	99.3	0	3	281	450	542	HQU82238.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	558	140	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
26672126	26672126	PRJNA728642_P_NODE_18481_length_244_cov_0.900585_g18210_i0	PRJNA728642	18481	244	0.900585	2.1974274	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	102	2.4099999999999998e-24	NR	HEX2461388.1	2910147	g18210	i0	66.7	1.99180327868852	81	27	99.6	0	2	244	14	94	HEX2461388.1 histidine kinase dimerization/phospho-acceptor domain-containing protein [Vicinamibacterales bacterium]	diamond	486	102	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
27431792	27431792	PRJNA728642_P_NODE_19823_length_238_cov_2.109091_g19552_i0	PRJNA728642	19823	238	2.109091	5.01963658	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	147	2.7499999999999993e-42	NR	MBS1795405.1	1978231	g19552	i0	94.9	1.99159663865546	79	4	99.6	0	2	238	27	105	MBS1795405.1 DUF4388 domain-containing protein [Acidobacteriota bacterium]	diamond	474	147	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
27873563	27873563	PRJNA728642_P_NODE_15065_length_258_cov_1.248649_g14794_i0	PRJNA728642	15065	258	1.248649	3.22151442	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	140	1.9399999999999997e-37	NR	HVE60112.1	2283092	g14794	i0	76.7	1	86	20	100	0	258	1	53	138	HVE60112.1 acetylxylan esterase [Pyrinomonadaceae bacterium]	diamond	258	140	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
29105147	29105147	PRJNA728642_P_NODE_17968_length_245_cov_0.895349_g17697_i0	PRJNA728642	17968	245	0.895349	2.19360505	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	107	6.07e-26	NR	HVE59523.1	2283092	g17697	i0	65	0.979591836734694	80	24	93.1	1	230	3	1	80	HVE59523.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	240	107	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
30715735	30715735	PRJNA728642_P_NODE_17994_length_245_cov_0.895349_g17723_i0	PRJNA728642	17994	245	0.895349	2.19360505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	107	2.1200000000000003e-27	NR	MBS1797069.1	1978231	g17723	i0	70.4	0.991836734693878	81	24	99.2	0	1	243	26	106	MBS1797069.1 GspH/FimT family pseudopilin [Acidobacteriota bacterium]	diamond	243	107	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
30810616	30810616	PRJNA728642_P_NODE_19574_length_241_cov_0.916667_g19303_i0	PRJNA728642	19574	241	0.916667	2.20916747	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	143	6.1e-39	NR	HEY8562912.1	2283092	g19303	i0	86.1	2.9253112033195	79	11	98.3	0	239	3	80	158	HEY8562912.1 competence/damage-inducible protein A [Pyrinomonadaceae bacterium]	diamond	705	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
31094911	31094911	PRJNA728642_P_NODE_20095_length_226_cov_2.686275_g19824_i0	PRJNA728642	20095	226	2.686275	6.0709815	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	146	5.999999999999998e-39	NR	HEY8559325.1	2283092	g19824	i0	90.7	2.98672566371681	75	7	99.6	0	1	225	90	164	HEY8559325.1 glycoside hydrolase family 15 protein [Pyrinomonadaceae bacterium]	diamond	675	146	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
31917229	31917229	PRJNA728642_P_NODE_19117_length_242_cov_0.911243_g18846_i0	PRJNA728642	19117	242	0.911243	2.20520806	Terriglobia bacterium	2081523	Bacteria	Bacteria	47	0.00114	NR	MBK5294833.1	2081523	g18846	i0	76.9	0.954545454545455	26	6	32.2	0	2	79	376	401	MBK5294833.1 thiol-disulfide isomerase [Terriglobia bacterium]	diamond	231	47	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia			Terriglobia bacterium
32675878	32675878	PRJNA728642_P_NODE_19740_length_241_cov_0.916667_g19469_i0	PRJNA728642	19740	241	0.916667	2.20916747	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	157	1.13e-43	NR	MBX7173244.1	2283092	g19469	i0	96.2	7.95435684647303	79	3	98.3	0	1	237	139	217	MBX7173244.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Pyrinomonadaceae bacterium]	diamond	1917	157	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium

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