metadata: contig_metadata: 15 rows where bioproject = "PRJEB10320", tax_kingdom = "Pseudomonadati" and tax

15 rows where bioproject = "PRJEB10320", tax_kingdom = "Pseudomonadati" 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_genus	tax_species
7360134	7360134	PRJEB10320_P_NODE_16626_length_219_cov_2.347826_g16368_i0	PRJEB10320	16626	219	2.347826	5.14173894	Pseudomonadati	3379134	Bacteria	Bacteria	272	1.37e-68	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g16368	i0	89.091	161.2100456621	220	23	100	1	1	219	715114	715333	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	35305	274	0.992700729927007	Bacteria	Pseudomonadati	Acidobacteriota			uncultured Acidobacteriota bacterium
8635580	8635580	PRJEB10320_P_NODE_7587_length_370_cov_1.289552_g7331_i0	PRJEB10320	7587	370	1.289552	4.7713424	Pseudomonadati	3379134	Bacteria	Bacteria	91.7	1.23e-18	NR	MCS6817120.1	2052146	g7331	i0	78.9	4.8	57	12	46.2	0	2	172	1394	1450	MCS6817120.1 glutamate synthase large subunit [Blastocatellia bacterium]	diamond	1776	91.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia		Blastocatellia bacterium
11491511	11491511	PRJEB10320_P_NODE_17690_length_210_cov_1.502857_g17432_i0	PRJEB10320	17690	210	1.502857	3.1559997	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	276	1e-69	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g17432	i0	90.476	38.8238095238095	210	19	99	1	2	210	317476	317267	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	8153	276	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
25208514	25208514	PRJEB10320_P_NODE_14980_length_236_cov_1.179104_g14722_i0	PRJEB10320	14980	236	1.179104	2.78268544	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	127	4.08e-33	NR	MDQ2948540.1	1978231	g14722	i0	74.4	6.85169491525424	78	20	99.2	0	234	1	232	309	MDQ2948540.1 cystathionine gamma-synthase [Acidobacteriota bacterium]	diamond	1617	127	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
27127119	27127119	PRJEB10320_P_NODE_20062_length_192_cov_2.038217_g19804_i0	PRJEB10320	20062	192	2.038217	3.91337664	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	42	0.0356	NR	HEX6179364.1	2651171	g19804	i0	40.9	1.03125	66	30	98.4	4	4	192	66	125	HEX6179364.1 post-COAP-1 domain-containing protein [Thermoanaerobaculia bacterium]	diamond	198	42	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia		Thermoanaerobaculia bacterium
28169765	28169765	PRJEB10320_P_NODE_24406_length_167_cov_1.181818_g24148_i0	PRJEB10320	24406	167	1.181818	1.97363606	Terriglobia bacterium	2081523	Bacteria	Bacteria	49.3	6.54e-5	NR	MBZ5500761.1	2081523	g24148	i0	52.9	0.916167664670659	51	24	91.6	0	1	153	1141	1191	MBZ5500761.1 MBG domain-containing protein [Terriglobia bacterium]	diamond	153	49.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia		Terriglobia bacterium
28359053	28359053	PRJEB10320_P_NODE_11706_length_280_cov_1.142857_g11448_i0	PRJEB10320	11706	280	1.142857	3.1999996	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42.7	0.0492	NR	MBM3785482.1	1978231	g11448	i0	34.2	0.846428571428571	79	47	79.3	2	263	42	9	87	MBM3785482.1 polysaccharide export protein [Acidobacteriota bacterium]	diamond	237	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
28542783	28542783	PRJEB10320_P_NODE_26787_length_156_cov_1.652893_g26529_i0	PRJEB10320	26787	156	1.652893	2.57851308	Bacteria	2	Bacteria	Bacteria	53.1	2.36e-6	NR	NBO65498.1	1978231	g26529	i0	55.1	1.88461538461538	49	22	94.2	0	154	8	146	194	NBO65498.1 transposase [Acidobacteriota bacterium]	diamond	294	53.1	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
28611860	28611860	PRJEB10320_P_NODE_27507_length_154_cov_1.008403_g27249_i0	PRJEB10320	27507	154	1.008403	1.55294062	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	58.5	2.83e-8	NR	MEM9554443.1	1978231	g27249	i0	56.9	5.00649350649351	51	19	93.5	1	146	3	293	343	MEM9554443.1 peroxidase family protein [Acidobacteriota bacterium]	diamond	771	58.5	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
29085541	29085541	PRJEB10320_P_NODE_11488_length_283_cov_1.846774_g11230_i0	PRJEB10320	11488	283	1.846774	5.22637042	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	121	9.85e-32	NR	MBW4038822.1	1978231	g11230	i0	71.4	0.816254416961131	77	22	81.6	0	1	231	168	244	MBW4038822.1 SDR family oxidoreductase [Acidobacteriota bacterium]	diamond	231	121	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
31612960	31612960	PRJEB10320_P_NODE_28476_length_150_cov_2.191304_g28218_i0	PRJEB10320	28476	150	2.191304	3.286956	Candidatus Angelobacter sp.	2976921	Bacteria	Bacteria	41.2	0.0366	NR	HEX2328524.1	2976921	g28218	i0	50	0.64	32	16	64	0	12	107	1071	1102	HEX2328524.1 nitrate reductase subunit alpha [Candidatus Angelobacter sp.]	diamond	96	41.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Angelobacter	Candidatus Angelobacter sp.
31764948	31764948	PRJEB10320_P_NODE_14137_length_246_cov_1.279621_g13879_i0	PRJEB10320	14137	246	1.279621	3.14786766	Bacteria	2	Bacteria	Bacteria	87	3.84e-18	NR	MFQ5927836.1	2081523	g13879	i0	51.3	4.78048780487805	80	38	97.6	1	240	1	253	331	MFQ5927836.1 TolB family protein [Terriglobia bacterium]	diamond	1176	87	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia		Terriglobia bacterium
31828073	31828073	PRJEB10320_P_NODE_28057_length_152_cov_1.111111_g27799_i0	PRJEB10320	28057	152	1.111111	1.68888872	Pseudomonadati	3379134	Bacteria	Bacteria	76.3	1.25e-15	NR	MCA1576595.1	1978231	g27799	i0	73.9	9.57236842105263	46	12	90.8	0	139	2	44	89	MCA1576595.1 peroxiredoxin [Acidobacteriota bacterium]	diamond	1455	77	0.990909090909091	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
32214130	32214130	PRJEB10320_P_NODE_26298_length_158_cov_1.626016_g26040_i0	PRJEB10320	26298	158	1.626016	2.56910528	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	54.3	9.65e-7	NR	NKB87241.1	1978231	g26040	i0	52	1.87974683544304	50	24	94.9	0	152	3	167	216	NKB87241.1 hypothetical protein [Acidobacteriota bacterium]	diamond	297	54.3	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
32403993	32403993	PRJEB10320_P_NODE_2919_length_627_cov_2.628378_g2710_i0	PRJEB10320	2919	627	2.628378	16.47993006	Blastocatellia bacterium	2052146	Bacteria	Bacteria	48.9	0.002	NR	HEY6328657.1	2052146	g2710	i0	29	0.69377990430622	145	88	67.5	5	521	99	29	162	HEY6328657.1 hypothetical protein [Blastocatellia bacterium]	diamond	435	48.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia		Blastocatellia 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);;