metadata: contig_metadata: 10 rows where bioproject = "PRJNA577226", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA577226", 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_species
1837477	1837477	PRJNA577226_S_NODE_44502_length_186_cov_18.456376_g43563_i0	PRJNA577226	44502	186	18.456376	34.32885936	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	239	1.14e-58	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g43563	i0	94.231	334.327956989247	156	9	84	0	1	156	2852942	2853097	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	62185	239	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
4388684	4388684	PRJNA577226_S_NODE_14244_length_342_cov_3.491803_g13305_i0	PRJNA577226	14244	342	3.491803	11.94196626	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	195	5.08e-45	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g13305	i0	84.541	83.9736842105263	207	21	59	10	103	304	2851001	2850801	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	28719	195	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
9489572	9489572	PRJNA577226_S_NODE_14888_length_334_cov_3.292929_g13949_i0	PRJNA577226	14888	334	3.292929	10.99838286	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	231	3.7699999999999995e-56	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g13949	i0	89.785	36	186	12	54	6	3	184	2852482	2852300	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	12024	231	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
9489853	9489853	PRJNA577226_S_NODE_2448_length_1106_cov_3.617399_g1685_i0	PRJNA577226	2448	1106	3.617399	40.00843294	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	850	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g1685	i0	87.929	179.008137432188	729	79	81	9	381	1106	2851103	2851825	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	197983	850	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
13316283	13316283	PRJNA577226_S_NODE_52411_length_172_cov_3.525926_g51472_i0	PRJNA577226	52411	172	3.525926	6.06459272	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	207	2.91e-49	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g51472	i0	88.372	157.127906976744	172	20	100	0	1	172	2851210	2851039	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	27026	207	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
17138965	17138965	PRJNA577226_S_NODE_20194_length_282_cov_2.240816_g19255_i0	PRJNA577226	20194	282	2.240816	6.31910112	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	294	3.91e-75	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g19255	i0	85.512	263.719858156028	283	39	100	2	1	282	2851822	2851541	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	74369	294	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
18414671	18414671	PRJNA577226_S_NODE_7655_length_487_cov_4.095556_g6724_i0	PRJNA577226	7655	487	4.095556	19.94535772	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	353	1.16e-92	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g6724	i0	80.321	24.1683778234086	498	73	100	21	1	487	2852344	2851861	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	11770	353	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
19688665	19688665	PRJNA577226_S_NODE_5156_length_618_cov_3.853701_g4255_i0	PRJNA577226	5156	618	3.853701	23.81587218	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	529	2.3199999999999994e-145	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g4255	i0	82.547	35.1974110032362	636	77	99	26	3	618	2852482	2851861	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	21752	529	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
22238422	22238422	PRJNA577226_S_NODE_19898_length_284_cov_5.951417_g18959_i0	PRJNA577226	19898	284	5.951417	16.90202428	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	379	1.06e-100	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g18959	i0	90.941	76.3802816901408	287	18	99	6	1	283	2851779	2852061	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	21692	379	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
24788511	24788511	PRJNA577226_S_NODE_58040_length_164_cov_4.322835_g57101_i0	PRJNA577226	58040	164	4.322835	7.0894494	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	172	1.0099999999999999e-38	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g57101	i0	86.503	133.469512195122	163	15	99	4	2	164	2853589	2853434	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	21889	172	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);;