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

9 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax_clade = "PVC group"

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
1045110	1045110	PRJNA1204310_P_NODE_56881_length_247_cov_2.195402_g56584_i0	PRJNA1204310	56881	247	2.195402	5.42264294	Gemmata	113	Bacteria	Bacteria	193	1.26e-44	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g56584	i0	87.805	63.0161943319838	164	20	66	0	54	217	7686573	7686410	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	15565	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
1604441	1604441	PRJNA1204310_P_NODE_58102_length_246_cov_1.323699_g57805_i0	PRJNA1204310	58102	246	1.323699	3.25629954	Aquisphaera giovannonii	406548	Bacteria	Bacteria	259	1.22e-64	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g57805	i0	86.498	96.9349593495935	237	30	96	2	10	245	9188053	9187818	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	23846	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
5432144	5432144	PRJNA1204310_P_NODE_24925_length_368_cov_1.450847_g24628_i0	PRJNA1204310	24925	368	1.450847	5.33911696	Gemmataceae bacterium	2052164	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g24628	i0	100	0.0760869565217391	28	0	8	0	290	317	655180	655153	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
5432762	5432762	PRJNA1204310_P_NODE_52125_length_252_cov_0.871508_g51828_i0	PRJNA1204310	52125	252	0.871508	2.19620016	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	433	6.98e-117	NTclustered	gi\|544315378\|gb\|KF318288.1\|	156588	g51828	i0	97.619	108	252	6	100	0	1	252	1136	885	Uncultured Verrucomicrobia bacterium clone ATW049 16S ribosomal RNA gene, partial sequence	blastn	27216	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18180181	18180181	PRJNA1204310_P_NODE_10695_length_536_cov_4.777538_g10400_i0	PRJNA1204310	10695	536	4.777538	25.60760368	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	67.6	1.88e-6	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g10400	i0	90.196	0.0951492537313433	51	5	10	0	391	441	3497854	3497904	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	51	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
18896619	18896619	PRJNA1204310_P_NODE_55375_length_249_cov_0.886364_g55078_i0	PRJNA1204310	55375	249	0.886364	2.20704636	Akkermansia	239934	Bacteria	Bacteria	355	1.53e-93	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g55078	i0	92.369	296	249	19	100	0	1	249	137916	137668	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	73704	355	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
22005444	22005444	PRJNA1204310_P_NODE_13058_length_488_cov_1.691566_g12761_i0	PRJNA1204310	13058	488	1.691566	8.25484208	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	296	1.99e-75	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g12761	i0	78.252	39.0532786885246	492	85	99	19	1	481	2593371	2592891	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	19058	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
22721934	22721934	PRJNA1204310_P_NODE_39478_length_295_cov_1.090090_g39181_i0	PRJNA1204310	39478	295	1.09009	3.2157655	Bacteria	2	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2916408352\|gb\|CP170455.1\|	2052180	g39181	i0	100	0.189830508474576	28	0	9	0	250	277	2839900	2839927	MAG: Phycisphaerales bacterium isolate tig00000072 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
24555519	24555519	PRJNA1204310_P_NODE_45580_length_273_cov_1.560000_g45283_i0	PRJNA1204310	45580	273	1.56	4.2588	Isosphaera pallida	128	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|319748837\|gb\|CP002353.1\|	575540	g45283	i0	94.444	0.450549450549451	36	1	13	1	88	123	3881135	3881169	Isosphaera pallida ATCC 43644, complete genome	blastn	123	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida

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);;