metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_phylum = "Ignavibacteriota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3707660	3707660	PRJNA641707_P_NODE_108783_length_246_cov_3.050761_g106120_i0	PRJNA641707	108783	246	3.050761	7.50487206	Pseudomonadati	3379134	Bacteria	Bacteria	126	1.29e-24	NTclustered	gi\|470490116\|ref\|NR_076968.1\|	591197	g106120	i0	93.023	132.471544715447	86	6	35	0	147	232	627	542	Ignavibacterium album strain Mat9-16 23S ribosomal RNA gene, complete sequence	blastn	32588	126	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium album
4985052	4985052	PRJNA641707_P_NODE_2044_length_1338_cov_39.722265_g599_i1	PRJNA641707	2044	1338	39.722265	531.4839057	Pseudomonadati	3379134	Bacteria	Bacteria	1306	0	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g599	i1	86.224	152.394618834081	1234	137	98	23	1	1221	1603587	1602374	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	203904	1306	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
4986185	4986185	PRJNA641707_P_NODE_43504_length_329_cov_22.407143_g40858_i0	PRJNA641707	43504	329	22.407143	73.71950047	Pseudomonadati	3379134	Bacteria	Bacteria	298	3.6e-76	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g40858	i0	93.103	371.87537993921	203	14	62	0	2	204	1604369	1604571	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	122347	298	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
4986627	4986627	PRJNA641707_P_NODE_88424_length_246_cov_6.010152_g85761_i0	PRJNA641707	88424	246	6.010152	14.78497392	Pseudomonadati	3379134	Bacteria	Bacteria	75	4.74e-9	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g85761	i0	81	0.82520325203252	100	14	39	5	1	97	1564654	1564751	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	203	75	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
6990480	6990480	PRJNA641707_P_NODE_154666_length_228_cov_3.106145_g152003_i0	PRJNA641707	154666	228	3.106145	7.0820106	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	200	6.859999999999999e-47	NTclustered	gi\|1850839647\|gb\|CP053446.1\|	2026749	g152003	i0	83.721	975.276315789474	215	31	93	4	6	218	2154365	2154577	Ignavibacteriae bacterium isolate IGN2 chromosome	blastn	222363	200	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
10819368	10819368	PRJNA641707_P_NODE_29129_length_401_cov_8.193182_g26523_i0	PRJNA641707	29129	401	8.193182	32.85465982	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	147	1.71e-30	NTclustered	gi\|2621786307\|emb\|OY782765.1\|	2614255	g26523	i0	100	24.1795511221945	79	0	20	0	19	97	2846282	2846360	MAG: Melioribacteraceae bacterium isolate b49f5fa7-6043-4eb4-88a3-53a29b1f0925 genome assembly, chromosome: 1	blastn	9696	147	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
11361761	11361761	PRJNA641707_P_NODE_95669_length_246_cov_4.832487_g93006_i0	PRJNA641707	95669	246	4.832487	11.88791802	Pseudomonadati	3379134	Bacteria	Bacteria	169	2.11e-37	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g93006	i0	98.936	31.2113821138211	94	1	79	0	146	239	1602670	1602577	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	7678	169	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
12636095	12636095	PRJNA641707_P_NODE_239090_length_186_cov_21.379562_g236427_i0	PRJNA641707	239090	186	21.379562	39.76598532	Pseudomonadati	3379134	Bacteria	Bacteria	281	1.86e-71	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g236427	i0	94.972	142.655913978495	179	9	96	0	8	186	1604051	1604229	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	26534	281	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
15186628	15186628	PRJNA641707_P_NODE_70912_length_248_cov_11.587940_g68249_i0	PRJNA641707	70912	248	11.58794	28.7380912	Pseudomonadati	3379134	Bacteria	Bacteria	152	2.15e-32	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g68249	i0	86.014	5.30645161290323	143	19	57	1	98	239	1604571	1604429	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	1316	152	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria 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);;