metadata: contig_metadata: 11 rows where bioproject = "PRJNA900999", tax_phylum = "Acidobacteriota" and tax

11 rows where bioproject = "PRJNA900999", 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_species
3428862	3428862	PRJNA900999_S_NODE_4963_length_196_cov_4.700599_g4907_i0	PRJNA900999	4963	196	4.700599	9.21317404	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	219	1.58e-52	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g4907	i0	86.869	3.51020408163265	198	22	100	3	1	196	31419	31224	Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds	blastn	688	219	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
3797980	3797980	PRJNA900999_S_NODE_8923_length_155_cov_12.793651_g8867_i0	PRJNA900999	8923	155	12.793651	19.83015905	Bacteria	2	Bacteria	Bacteria	171	3.37e-38	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g8867	i0	86.957	66.5806451612903	161	9	100	11	1	155	715995	716149	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	10320	171	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
4706732	4706732	PRJNA900999_S_NODE_504_length_428_cov_27.483709_g451_i0	PRJNA900999	504	428	27.483709	117.63027452	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	512	1.58e-140	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g451	i0	88.222	480.42523364486	433	45	100	5	1	428	4233442	4233873	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	205622	512	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
4706770	4706770	PRJNA900999_S_NODE_904_length_351_cov_35.108696_g848_i0	PRJNA900999	904	351	35.108696	123.23152296	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	444	4.68e-120	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g848	i0	89.855	443.518518518519	345	35	98	0	7	351	4233786	4233442	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	155675	444	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
7256213	7256213	PRJNA900999_S_NODE_6526_length_176_cov_14.605442_g6470_i0	PRJNA900999	6526	176	14.605442	25.70557792	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	241	2.950000000000001e-59	NTclustered	gi\|217038899\|gb\|EU810989.1\|	171953	g6470	i0	93.293	154.306818181818	164	9	93	2	7	169	163	1	Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence	blastn	27158	241	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
9805989	9805989	PRJNA900999_S_NODE_2388_length_258_cov_5.117904_g2332_i0	PRJNA900999	2388	258	5.117904	13.20419232	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	320	5.83e-83	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g2332	i0	89.641	111.445736434109	251	26	97	0	8	258	4648920	4648670	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	28753	320	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
12357030	12357030	PRJNA900999_S_NODE_3050_length_236_cov_24.130435_g2994_i0	PRJNA900999	3050	236	24.130435	56.9478266	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	261	3.23e-65	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g2994	i0	88.889	41.6059322033898	216	19	90	5	1	213	317465	317252	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	9819	261	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29392759	29392759	PRJNA900999_S_NODE_9009_length_155_cov_2.944444_g8953_i0	PRJNA900999	9009	155	2.944444	4.5638882	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	76.3	5.89e-15	NR	HEY8559731.1	2283092	g8953	i0	67.3	1.89677419354839	49	16	94.8	0	9	155	198	246	HEY8559731.1 polysaccharide biosynthesis/export family protein [Pyrinomonadaceae bacterium]	diamond	294	76.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
30750997	30750997	PRJNA900999_S_NODE_1794_length_285_cov_2.457031_g1738_i0	PRJNA900999	1794	285	2.457031	7.00253835	Blastocatellia bacterium	2052146	Bacteria	Bacteria	164	3.51e-48	NR	HMV82324.1	2052146	g1738	i0	83.2	2	95	16	100	0	1	285	48	142	HMV82324.1 M20/M25/M40 family metallo-hydrolase [Blastocatellia bacterium]	diamond	570	164	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia			Blastocatellia bacterium
31067068	31067068	PRJNA900999_S_NODE_4535_length_203_cov_5.724138_g4479_i0	PRJNA900999	4535	203	5.724138	11.62000014	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	50.1	3.82e-6	NR	MBA2493978.1	1978231	g4479	i0	89.3	0.413793103448276	28	3	41.4	0	117	200	1	28	MBA2493978.1 50S ribosomal protein L30 [Acidobacteriota bacterium]	diamond	84	50.1	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
31390779	31390779	PRJNA900999_S_NODE_8056_length_162_cov_3.308271_g8000_i0	PRJNA900999	8056	162	3.308271	5.35939902	Bacteria	2	Bacteria	Bacteria	57.8	1.04e-8	NR	MCB1023591.1	1978231	g8000	i0	93.3	1.66666666666667	30	2	55.6	0	161	72	113	142	MCB1023591.1 50S ribosomal protein L11 [Acidobacteriota bacterium]	diamond	270	57.8	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota 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);;