metadata: contig_metadata: 8 rows where bioproject = "PRJNA416866", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA416866", 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_order	tax_family	tax_species
27391824	27391824	PRJNA416866_P_NODE_6183_length_262_cov_1.029851_g6039_i0	PRJNA416866	6183	262	1.029851	2.69820962	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	42.7	0.0456	NR	HEV3253237.1	2952895	g6039	i0	39	0.675572519083969	59	31	61.8	2	179	18	241	299	HEV3253237.1 sodium:solute symporter family protein [Candidatus Acidiferrales bacterium]	diamond	177	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrales bacterium
28228945	28228945	PRJNA416866_P_NODE_9346_length_210_cov_1.288591_g9202_i0	PRJNA416866	9346	210	1.288591	2.7060411	Bacteria	2	Bacteria	Bacteria	47.8	4.09e-4	NR	MEW6736062.1	1978231	g9202	i0	43.1	2.3	51	28	71.4	1	27	176	630	680	MEW6736062.1 SMP-30/gluconolactonase/LRE family protein [Acidobacteriota bacterium]	diamond	483	48.1	0.993762993762994	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
28260597	28260597	PRJNA416866_P_NODE_2706_length_412_cov_1.871795_g2563_i0	PRJNA416866	2706	412	1.871795	7.7117954	Pseudomonadati	3379134	Bacteria	Bacteria	124	7.02e-30	NR	MBS1768271.1	1978231	g2563	i0	47.4	2.27184466019417	156	58	96.8	2	404	6	1127	1281	MBS1768271.1 hypothetical protein [Acidobacteriota bacterium]	diamond	936	124	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
28686452	28686452	PRJNA416866_P_NODE_5927_length_268_cov_1.236715_g5783_i0	PRJNA416866	5927	268	1.236715	3.3143962	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	53.5	7.82e-6	NR	HRH44546.1	2283092	g5783	i0	35.4	1.38805970149254	82	47	85.1	1	230	3	2	83	HRH44546.1 VIT domain-containing protein [Pyrinomonadaceae bacterium]	diamond	372	53.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
29160035	29160035	PRJNA416866_P_NODE_3769_length_342_cov_1.451957_g3626_i0	PRJNA416866	3769	342	1.451957	4.96569294	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	60.5	4.42e-8	NR	MCX6550006.1	1978231	g3626	i0	35.9	0.807017543859649	92	58	80.7	1	30	305	75	165	MCX6550006.1 GDSL-type esterase/lipase family protein [Acidobacteriota bacterium]	diamond	276	60.5	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
30503001	30503001	PRJNA416866_P_NODE_8213_length_225_cov_1.560976_g8069_i0	PRJNA416866	8213	225	1.560976	3.512196	Pseudomonadati	3379134	Bacteria	Bacteria	72.4	7.99e-14	NR	MCY4588591.1	2026791	g8069	i0	58.1	3.30666666666667	62	25	82.7	1	188	3	88	148	MCY4588591.1 SBBP repeat-containing protein [Bryobacterales bacterium]	diamond	744	72.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales		Bryobacterales bacterium
32320570	32320570	PRJNA416866_P_NODE_2099_length_473_cov_1.305825_g1956_i0	PRJNA416866	2099	473	1.305825	6.17655225	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	93.6	8.93e-19	NR	MDQ7006104.1	1978231	g1956	i0	41	0.881606765327696	139	72	88.2	3	456	40	1298	1426	MDQ7006104.1 reverse transcriptase domain-containing protein [Acidobacteriota bacterium]	diamond	417	93.6	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
32447022	32447022	PRJNA416866_P_NODE_9519_length_209_cov_0.864865_g9375_i0	PRJNA416866	9519	209	0.864865	1.80756785	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	84.7	1.73e-17	NR	HVO99650.1	2212468	g9375	i0	56.9	2.85645933014354	65	28	93.3	0	209	15	270	334	HVO99650.1 NADP-dependent oxidoreductase [Bryobacteraceae bacterium]	diamond	597	84.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae 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);;