metadata: contig_metadata: 9 rows where analysis = "diamond" and tax

9 rows where analysis = "diamond" and tax_clade = "Acidobacteriota subdivision 22"

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_species
7797698	7797698	PRJNA1000943_P_NODE_7627_length_298_cov_1.386667_g7489_i0	PRJNA1000943	7627	298	1.386667	4.13226766	Acidobacteria bacterium Mor1	1660251	Bacteria	Bacteria	136	5.99e-36	NR	ANM29890.1	1660251	g7489	i0	82.9	9.94630872483221	76	13	76.5	0	1	228	353	428	ANM29890.1 type I citrate synthase [Acidobacteria bacterium Mor1]	diamond	2964	136	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota	Acidobacteria bacterium Mor1
22124227	22124227	PRJNA478247_P_NODE_2638_length_200_cov_1.719298_g2532_i0	PRJNA478247	2638	200	1.719298	3.438596	Bacteria	2	Bacteria	Bacteria	124	9.599999999999999e-32	NR	ANM29890.1	1660251	g2532	i0	81.8	12.87	66	12	99	0	198	1	350	415	ANM29890.1 type I citrate synthase [Acidobacteria bacterium Mor1]	diamond	2574	125	0.992	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota	Acidobacteria bacterium Mor1
26805811	26805811	PRJNA1111077_P_NODE_18861_length_290_cov_2.603687_g18640_i0	PRJNA1111077	18861	290	2.603687	7.5506923	Acidobacteriota subdivision 22	1660250	Bacteria	Bacteria	79.3	8.75e-15	NR	ANM31230.1	1660251	g18640	i0	43.2	2.68965517241379	88	42	91	2	4	267	267	346	ANM31230.1 hypothetical protein ABI59_19105 [Acidobacteria bacterium Mor1]	diamond	780	80.1	0.990012484394507	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota	Acidobacteria bacterium Mor1
27501916	27501916	PRJNA1120203_P_NODE_106043_length_241_cov_0.910714_g105027_i0	PRJNA1120203	106043	241	0.910714	2.19482074	Candidatus Polarisedimenticola	2885992	Bacteria	Bacteria	118	2.69e-30	NR	ANM32041.1	1660251	g105027	i0	76.3	2.88796680497925	76	18	94.6	0	5	232	197	272	ANM32041.1 hypothetical protein ABI59_02750 [Acidobacteria bacterium Mor1]	diamond	696	119	0.991596638655462	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota	Acidobacteria bacterium Mor1
27728531	27728531	PRJEB17675_P_NODE_17744_length_188_cov_1.307190_g17440_i0	PRJEB17675	17744	188	1.30719	2.4575172	Acidobacteria bacterium Mor1	1660251	Bacteria	Bacteria	65.9	1.26e-10	NR	ANM28726.1	1660251	g17440	i0	58.1	0.98936170212766	62	21	98.9	2	2	187	404	460	ANM28726.1 hypothetical protein ABI59_02535 [Acidobacteria bacterium Mor1]	diamond	186	65.9	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota	Acidobacteria bacterium Mor1
29820868	29820868	PRJNA1255065_P_NODE_149771_length_162_cov_0.920354_g147543_i0	PRJNA1255065	149771	162	0.920354	1.49097348	Acidobacteria bacterium Mor1	1660251	Bacteria	Bacteria	51.2	1.23e-5	NR	ANM29950.1	1660251	g147543	i0	44.2	0.962962962962963	52	28	94.4	1	5	157	65	116	ANM29950.1 hypothetical protein ABI59_10765 [Acidobacteria bacterium Mor1]	diamond	156	51.2	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota	Acidobacteria bacterium Mor1
31860402	31860402	PRJNA1086823_P_NODE_13637_length_251_cov_0.876404_g13520_i0	PRJNA1086823	13637	251	0.876404	2.19977404	Bacteria	2	Bacteria	Bacteria	142	1.0099999999999999e-38	NR	ANM30298.1	1660251	g13520	i0	81.9	1.9840637450199201	83	15	99.2	0	250	2	195	277	ANM30298.1 cell division protein FtsA [Acidobacteria bacterium Mor1]	diamond	498	142	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota	Acidobacteria bacterium Mor1
31893714	31893714	PRJNA382357_P_NODE_6717_length_776_cov_4.261538_g6063_i0	PRJNA382357	6717	776	4.261538	33.06953488	Bacteria	2	Bacteria	Bacteria	234	1.6799999999999998e-69	NR	ANM30734.1	1660251	g6063	i0	63.4	3.57603092783505	183	63	70	3	769	227	414	594	ANM30734.1 hypothetical protein ABI59_15825 [Acidobacteria bacterium Mor1]	diamond	2775	236	0.991525423728814	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota	Acidobacteria bacterium Mor1
32886408	32886408	PRJNA235310_P_NODE_5060_length_168_cov_0.873950_g5034_i0	PRJNA235310	5060	168	0.87395	1.468236	Acidobacteria bacterium Mor1	1660251	Bacteria	Bacteria	67	1.46e-11	NR	ANM30664.1	1660251	g5034	i0	68.6	3.85714285714286	51	16	91.1	0	168	16	86	136	ANM30664.1 hypothetical protein ABI59_15425 [Acidobacteria bacterium Mor1]	diamond	648	67	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota	Acidobacteria bacterium Mor1

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