metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA977246" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA977246" 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_genus	tax_species
3502101	3502101	PRJNA977246_S_NODE_37643_length_190_cov_3.397516_g36651_i0	PRJNA977246	37643	190	3.397516	6.4552804	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	329	6.730000000000001e-86	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g36651	i0	97.895	93.9052631578947	190	4	100	0	1	190	4356769	4356958	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	17842	329	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6054757	6054757	PRJNA977246_S_NODE_35605_length_198_cov_5514.224852_g34613_i0	PRJNA977246	35605	198	5514.224852	10918.16520696	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	200	5.79e-47	NTclustered	gi\|217038890\|gb\|EU810980.1\|	171953	g34613	i0	89.375	4.80808080808081	160	15	80	2	41	198	78	237	Uncultured Acidobacteria bacterium clone H11-00YKB 23S ribosomal RNA gene, partial sequence	blastn	952	200	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8603791	8603791	PRJNA977246_S_NODE_14667_length_383_cov_2610.949153_g13678_i0	PRJNA977246	14667	383	2610.949153	9999.93525599	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	363	1.49e-95	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g13678	i0	85.756	163.362924281984	344	48	90	1	41	383	3298163	3298506	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	62568	363	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8604126	8604126	PRJNA977246_S_NODE_25327_length_259_cov_3.586957_g24335_i0	PRJNA977246	25327	259	3.586957	9.29021863	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	263	1e-65	NTclustered	gi\|112980849\|gb\|DQ829653.1\|	171953	g24335	i0	85.227	133.474903474903	264	29	100	7	1	259	949	691	Uncultured Acidobacteria bacterium clone DON8 23S ribosomal RNA gene, partial sequence	blastn	34570	263	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16254279	16254279	PRJNA977246_S_NODE_34153_length_205_cov_3.215909_g33161_i0	PRJNA977246	34153	205	3.215909	6.59261345	Edaphobacter paludis	3035702	Bacteria	Bacteria	379	7.229999999999999e-101	NTclustered	gi\|2737763816\|gb\|CP121194.1\|	3035702	g33161	i0	100	35.219512195122	205	0	100	0	1	205	662436	662640	Edaphobacter paludis strain DSM 109919 chromosome, complete genome	blastn	7220	379	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter paludis
21352967	21352967	PRJNA977246_S_NODE_15377_length_371_cov_4.511696_g14387_i0	PRJNA977246	15377	371	4.511696	16.73839216	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	211	5.5e-50	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g14387	i0	78.916	57.9056603773585	332	55	89	13	22	350	4536685	4537004	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	21483	211	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
22628935	22628935	PRJNA977246_S_NODE_7418_length_577_cov_5189.538321_g6609_i0	PRJNA977246	7418	577	5189.538321	29943.63611217	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	758	0	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g6609	i0	94.705	75.9878682842288	491	21	85	4	41	529	31681	31194	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	43845	758	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25178017	25178017	PRJNA977246_S_NODE_9760_length_491_cov_4159.452381_g8846_i0	PRJNA977246	9760	491	4159.452381	20422.91119071	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	584	3.8199999999999983e-162	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g8846	i0	90.625	75.5213849287169	448	31	90	10	49	491	31194	31635	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	37081	584	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured 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);;