metadata: contig_metadata: 7 rows where bioproject = "PRJNA1198392", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA1198392", tax_kingdom = "Pseudomonadati" 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_species
9252628	9252628	PRJNA1198392_P_NODE_2888_length_441_cov_2.334239_g2747_i0	PRJNA1198392	2888	441	2.334239	10.29399399	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	496	1.6399999999999998e-135	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2747	i0	88.462	90.5056689342404	416	41	93	5	31	439	2852152	2851737	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	39913	496	1	Bacteria	Pseudomonadati	Abditibacteriota				Abditibacteriota bacterium
15627470	15627470	PRJNA1198392_P_NODE_3333_length_416_cov_1.586006_g3192_i0	PRJNA1198392	3333	416	1.586006	6.59778496	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	366	1.2599999999999995e-96	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3192	i0	83.135	107.043269230769	421	51	99	15	3	416	2850842	2851249	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	44530	366	1	Bacteria	Pseudomonadati	Abditibacteriota				Abditibacteriota bacterium
20726156	20726156	PRJNA1198392_P_NODE_8817_length_288_cov_1.176744_g8676_i0	PRJNA1198392	8817	288	1.176744	3.38902272	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	123	7.239999999999999e-32	NR	HEX8234374.1	2800791	g8676	i0	68.4	0.989583333333333	95	26	99	1	3	287	110	200	HEX8234374.1 diaminopimelate epimerase [Abditibacteriaceae bacterium]	diamond	285	123	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacteriaceae bacterium
26723878	26723878	PRJNA1198392_P_NODE_18641_length_246_cov_0.890173_g18500_i0	PRJNA1198392	18641	246	0.890173	2.18982558	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	49.3	1.88e-4	NR	HEX8235082.1	2800791	g18500	i0	41.1	0.682926829268293	56	33	68.3	0	170	3	545	600	HEX8235082.1 hypothetical protein [Abditibacteriaceae bacterium]	diamond	168	49.3	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacteriaceae bacterium
27072471	27072471	PRJNA1198392_P_NODE_11982_length_272_cov_2.070352_g11841_i0	PRJNA1198392	11982	272	2.070352	5.63135744	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	72.4	1.75e-12	NR	HEY0072877.1	2800791	g11841	i0	62.9	2.05147058823529	62	23	68.4	0	6	191	343	404	HEY0072877.1 gephyrin-like molybdotransferase Glp [Abditibacteriaceae bacterium]	diamond	558	72.4	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacteriaceae bacterium
27956977	27956977	PRJNA1198392_P_NODE_11985_length_272_cov_2.015075_g11844_i0	PRJNA1198392	11985	272	2.015075	5.481004	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	129	1.2e-33	NR	HEX8237184.1	2800791	g11844	i0	69.7	2.94485294117647	89	27	98.2	0	271	5	136	224	HEX8237184.1 phosphoglycolate/pyridoxal phosphate family phosphatase [Abditibacteriaceae bacterium]	diamond	801	129	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacteriaceae bacterium
31463200	31463200	PRJNA1198392_P_NODE_20236_length_243_cov_0.905882_g20095_i0	PRJNA1198392	20236	243	0.905882	2.20129326	Abditibacteriaceae bacterium	2800791	Bacteria	Bacteria	125	1.5899999999999998e-31	NR	HEX8235936.1	2800791	g20095	i0	71.6	1	81	22	98.8	1	242	3	251	331	HEX8235936.1 ABC transporter substrate-binding protein [Abditibacteriaceae bacterium]	diamond	243	125	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacteriaceae 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);;