metadata: contig_metadata: 9 rows where bioproject = "PRJNA330616" and tax

9 rows where bioproject = "PRJNA330616" and tax_phylum = "Abditibacteriota"

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
1664592	1664592	PRJNA330616_P_NODE_9562_length_268_cov_5.570776_g9153_i0	PRJNA330616	9562	268	5.570776	14.92967968	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	457	4.45e-124	NTclustered	gi\|1124890760\|gb\|KY386300.1\|	1960156	g9153	i0	97.388	96.4179104477612	268	7	100	0	1	268	1205	1472	Abditibacterium utsteinense strain R-68168 16S ribosomal RNA gene, partial sequence	blastn	25840	457	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
4217128	4217128	PRJNA330616_P_NODE_5064_length_375_cov_3.920245_g4655_i0	PRJNA330616	5064	375	3.920245	14.70091875	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	547	3.7299999999999984e-151	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g4655	i0	92.765	151.2	387	15	100	6	1	375	2851671	2852056	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	56700	547	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
5493387	5493387	PRJNA330616_P_NODE_3585_length_456_cov_3.017199_g3178_i0	PRJNA330616	3585	456	3.017199	13.75842744	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	610	5.82e-170	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3178	i0	91.972	168.050438596491	436	34	95	1	2	436	2851899	2851464	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	76631	610	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
6767312	6767312	PRJNA330616_P_NODE_24086_length_172_cov_1.658537_g23677_i0	PRJNA330616	24086	172	1.658537	2.85268364	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	274	2.83e-69	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g23677	i0	95.349	51.6976744186046	172	8	100	0	1	172	2851302	2851473	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	8892	274	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
8042945	8042945	PRJNA330616_P_NODE_22647_length_177_cov_4.398438_g22238_i0	PRJNA330616	22647	177	4.398438	7.78523526	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	255	1.06e-63	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g22238	i0	92.697	350.112994350282	178	12	100	1	1	177	2852295	2852472	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	61970	255	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
8042999	8042999	PRJNA330616_P_NODE_2607_length_550_cov_10.752495_g2204_i0	PRJNA330616	2607	550	10.752495	59.1387225	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	806	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2204	i0	93.091	224.212727272727	550	38	100	0	1	550	2853268	2852719	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	123317	806	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
9317875	9317875	PRJNA330616_P_NODE_5308_length_365_cov_2.268987_g4899_i0	PRJNA330616	5308	365	2.268987	8.28180255	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	586	7.68e-163	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g4899	i0	95.64	527.668493150685	367	12	100	3	1	365	2852719	2853083	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	192599	586	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
19515576	19515576	PRJNA330616_P_NODE_2436_length_574_cov_2.708571_g2036_i0	PRJNA330616	2436	574	2.708571	15.54719754	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	564	5.879999999999998e-156	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2036	i0	84.722	133.810104529617	576	74	99	10	2	574	2851447	2850883	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	76807	564	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
20790990	20790990	PRJNA330616_P_NODE_10557_length_254_cov_2.048780_g10148_i0	PRJNA330616	10557	254	2.04878	5.2039012	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	239	1.65e-58	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g10148	i0	83.922	37.4055118110236	255	36	99	4	1	253	2850750	2851001	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	9501	239	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota 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);;