metadata: contig_metadata: 12 rows where bioproject = "PRJNA889065" and tax

12 rows where bioproject = "PRJNA889065" 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
3414116	3414116	PRJNA889065_S_NODE_19363_length_221_cov_2.325843_g19125_i0	PRJNA889065	19363	221	2.325843	5.14011303	Bacteria	2	Bacteria	Bacteria	131	4.74e-35	NR	MDE3195425.1	1978231	g19125	i0	84.9	43.5746606334842	73	11	99.1	0	220	2	225	297	MDE3195425.1 adenosylhomocysteinase [Acidobacteriota bacterium]	diamond	9630	131	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
22540116	22540116	PRJNA889065_S_NODE_13598_length_262_cov_1.849315_g13360_i0	PRJNA889065	13598	262	1.849315	4.8452053	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	58.4	5.14e-4	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13360	i0	100	1.44274809160305	31	0	12	0	103	133	5233030	5233060	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	378	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
22540169	22540169	PRJNA889065_S_NODE_23138_length_202_cov_2.025157_g22900_i0	PRJNA889065	23138	202	2.025157	4.09081714	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	300	5.69e-77	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g22900	i0	93.564	80.6485148514851	202	12	100	1	1	202	2366991	2367191	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	16291	300	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
26738542	26738542	PRJNA889065_S_NODE_22661_length_204_cov_2.285714_g22423_i0	PRJNA889065	22661	204	2.285714	4.66285656	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	41.6	0.0496	NR	HYR75838.1	2283092	g22423	i0	45.2	0.617647058823529	42	23	61.8	0	134	9	159	200	HYR75838.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	126	41.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
27434957	27434957	PRJNA889065_S_NODE_12743_length_270_cov_1.621145_g12505_i0	PRJNA889065	12743	270	1.621145	4.3770915	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	113	8.44e-28	NR	MCB1043044.1	1978231	g12505	i0	57.3	0.988888888888889	89	37	97.8	1	270	7	246	334	MCB1043044.1 methyltransferase domain-containing protein [Acidobacteriota bacterium]	diamond	267	113	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
28603087	28603087	PRJNA889065_S_NODE_7647_length_343_cov_2.296667_g7409_i0	PRJNA889065	7647	343	2.296667	7.87756781	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	47.4	0.00257	NR	MFC2157254.1	1978231	g7409	i0	35.6	0.760932944606414	87	46	76.1	2	7	267	301	377	MFC2157254.1 excinuclease ABC subunit UvrC [Acidobacteriota bacterium]	diamond	261	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29021651	29021651	PRJNA889065_S_NODE_12048_length_277_cov_2.653846_g11810_i0	PRJNA889065	12048	277	2.653846	7.35115342	Pseudomonadati	3379134	Bacteria	Bacteria	85.5	8.46e-18	NR	PYQ98020.1	1978231	g11810	i0	49.3	4.77617328519856	73	37	79.1	0	55	273	176	248	PYQ98020.1 MAG: dehydrogenase [Acidobacteriota bacterium]	diamond	1323	86.3	0.990730011587486	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29179321	29179321	PRJNA889065_S_NODE_25249_length_193_cov_2.553333_g25011_i0	PRJNA889065	25249	193	2.553333	4.92793269	Bacteria	2	Bacteria	Bacteria	52.8	5.54e-6	NR	MBX3279440.1	1978231	g25011	i0	40.7	1.78756476683938	54	32	83.9	0	165	4	86	139	MBX3279440.1 protein kinase [Acidobacteriota bacterium]	diamond	345	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29337056	29337056	PRJNA889065_S_NODE_21929_length_208_cov_1.115152_g21691_i0	PRJNA889065	21929	208	1.115152	2.31951616	Pseudomonadati	3379134	Bacteria	Bacteria	50.4	4.24e-5	NR	MEK6337409.1	1978231	g21691	i0	43.5	6.86538461538461	69	34	98.1	2	3	206	250	314	MEK6337409.1 DUF4157 domain-containing protein [Acidobacteriota bacterium]	diamond	1428	50.8	0.992125984251969	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
30876967	30876967	PRJNA889065_S_NODE_23894_length_199_cov_1.474359_g23656_i0	PRJNA889065	23894	199	1.474359	2.93397441	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	45.4	0.00238	NR	MDR3735585.1	2052142	g23656	i0	36.8	0.85929648241206	57	31	78.4	1	20	175	699	755	MDR3735585.1 C2 family cysteine protease [Acidobacteriaceae bacterium]	diamond	171	45.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacteriaceae bacterium
31256173	31256173	PRJNA889065_S_NODE_28255_length_182_cov_1.611511_g28017_i0	PRJNA889065	28255	182	1.611511	2.93295002	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	51.2	1.66e-5	NR	MBX3265733.1	1978231	g28017	i0	43.6	0.906593406593407	55	27	85.7	3	27	182	149	202	MBX3265733.1 hypothetical protein [Acidobacteriota bacterium]	diamond	165	51.2	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
32339832	32339832	PRJNA889065_S_NODE_8399_length_328_cov_5.147368_g8161_i0	PRJNA889065	8399	328	5.147368	16.88336704	Pseudomonadati	3379134	Bacteria	Bacteria	46.6	0.00455	NR	HEX4950403.1	2052146	g8161	i0	37.3	2.08536585365854	59	35	54	1	322	146	966	1022	HEX4950403.1 protein kinase [Blastocatellia bacterium]	diamond	684	47	0.991489361702128	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);;