metadata: contig_metadata: 10 rows where bioproject = "PRJEB41113", tax_phylum = "Acidobacteriota" and tax

10 rows where bioproject = "PRJEB41113", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

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
7711560	7711560	PRJEB41113_S_NODE_8647_length_165_cov_2.742188_g8638_i0	PRJEB41113	8647	165	2.742188	4.5246102	Luteitalea pratensis	1855912	Bacteria	Bacteria	150	4.76e-32	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g8638	i0	84.416	3.5030303030303	154	22	92	2	5	156	1208916	1209069	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	578	150	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
10261987	10261987	PRJEB41113_S_NODE_7089_length_174_cov_1.598540_g7080_i0	PRJEB41113	7089	174	1.59854	2.7814596	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	161	2.33e-35	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g7080	i0	86.093	10.735632183908	151	20	86	1	25	174	3298376	3298226	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	1868	161	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27374806	27374806	PRJEB41113_S_NODE_8683_length_165_cov_2.062500_g8674_i0	PRJEB41113	8683	165	2.0625	3.403125	Bacteria	2	Bacteria	Bacteria	103	2.11e-26	NR	MBA3786076.1	1978231	g8674	i0	94.4	2.94545454545455	54	3	98.2	0	2	163	93	146	MBA3786076.1 glycosyltransferase family 2 protein [Acidobacteriota bacterium]	diamond	486	103	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28517869	28517869	PRJEB41113_S_NODE_9667_length_161_cov_1.903226_g9658_i0	PRJEB41113	9667	161	1.903226	3.06419386	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	112	3.33e-29	NR	MET0164830.1	2910147	g9658	i0	100	0.987577639751553	53	0	98.8	0	160	2	58	110	MET0164830.1 glutathione S-transferase family protein [Vicinamibacterales bacterium]	diamond	159	112	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
28612570	28612570	PRJEB41113_S_NODE_9027_length_163_cov_8.182540_g9018_i0	PRJEB41113	9027	163	8.18254	13.3375402	Terriglobales bacterium	2282142	Bacteria	Bacteria	99	1.37e-22	NR	HUB01659.1	2282142	g9018	i0	83	4.85889570552147	53	9	97.5	0	3	161	228	280	HUB01659.1 Ni/Fe hydrogenase subunit alpha [Terriglobales bacterium]	diamond	792	99	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
30696843	30696843	PRJEB41113_S_NODE_6254_length_179_cov_2.507042_g6245_i0	PRJEB41113	6254	179	2.507042	4.48760518	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	96.7	1.62e-21	NR	MCM3880203.1	2910147	g6245	i0	75	0.93854748603352	56	14	93.9	0	12	179	393	448	MCM3880203.1 carboxypeptidase-like regulatory domain-containing protein [Vicinamibacterales bacterium]	diamond	168	96.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31360790	31360790	PRJEB41113_S_NODE_5616_length_183_cov_3.650685_g5607_i0	PRJEB41113	5616	183	3.650685	6.68075355	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	115	3.11e-28	NR	MEO7674389.1	2283092	g5607	i0	93.2	4.78688524590164	59	4	96.7	0	182	6	68	126	MEO7674389.1 serine/threonine protein kinase [Pyrinomonadaceae bacterium]	diamond	876	115	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32151514	32151514	PRJEB41113_S_NODE_8658_length_165_cov_2.578125_g8649_i0	PRJEB41113	8658	165	2.578125	4.25390625	Terriglobus roseus	392734	Bacteria	Bacteria	91.3	2e-20	NR	WP_083346625.1	392734	g8649	i0	83.3	1.96363636363636	54	9	98.2	0	164	3	110	163	WP_083346625.1 DUF58 domain-containing protein [Terriglobus roseus]	diamond	324	91.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
32373109	32373109	PRJEB41113_S_NODE_3459_length_201_cov_6.926829_g3450_i0	PRJEB41113	3459	201	6.926829	13.92292629	Blastocatellia bacterium	2052146	Bacteria	Bacteria	65.1	2.83e-10	NR	HKQ91664.1	2052146	g3450	i0	58.6	1.04477611940298	70	23	98.5	2	201	4	183	250	HKQ91664.1 TIGR00366 family protein [Blastocatellia bacterium]	diamond	210	65.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
32625687	32625687	PRJEB41113_S_NODE_6980_length_174_cov_5.270073_g6971_i0	PRJEB41113	6980	174	5.270073	9.16992702	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	40	0.0324	NR	HSY50073.1	2651171	g6971	i0	61.5	0.448275862068966	26	10	44.8	0	71	148	48	73	HSY50073.1 DUF4160 domain-containing protein [Thermoanaerobaculia bacterium]	diamond	78	40	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia 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);;