metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1068830" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1068830" 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
1014311	1014311	PRJNA1068830_P_NODE_71641_length_254_cov_1.464088_g70938_i0	PRJNA1068830	71641	254	1.464088	3.71878352	Akkermansia	239934	Bacteria	Bacteria	246	9.859999999999999e-61	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g70938	i0	100	49.1692913385827	133	0	52	0	1	133	1025891	1026023	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	12489	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
3564602	3564602	PRJNA1068830_P_NODE_21023_length_519_cov_1.553812_g20322_i0	PRJNA1068830	21023	519	1.553812	8.06428428	Bacteria	2	Bacteria	Bacteria	787	0	NTclustered	gi\|60266416\|gb\|AY921870.1\|	156588	g20322	i0	94.038	96.7976878612717	520	29	100	2	1	519	521	3	Uncultured Verrucomicrobia bacterium clone AKYG386 16S ribosomal RNA gene, partial sequence	blastn	50238	787	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4008961	4008961	PRJNA1068830_P_NODE_30224_length_415_cov_2.242690_g29521_i0	PRJNA1068830	30224	415	2.24269	9.3071635	Urbifossiella limnaea	2528023	Bacteria	Bacteria	449	1.2099999999999998e-121	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g29521	i0	86.473	99.0674698795181	414	50	99	5	6	415	2018222	2017811	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	41113	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
4009761	4009761	PRJNA1068830_P_NODE_63944_length_271_cov_1.833333_g63241_i0	PRJNA1068830	63944	271	1.833333	4.96833243	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	254	6.35e-63	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g63241	i0	93.529	64.2029520295203	170	11	63	0	1	170	3990701	3990870	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	17399	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
6117332	6117332	PRJNA1068830_P_NODE_41465_length_345_cov_0.797794_g40762_i0	PRJNA1068830	41465	345	0.797794	2.7523893	Gemmata	113	Bacteria	Bacteria	459	1.65e-124	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g40762	i0	90.778	141.214492753623	347	26	100	5	1	345	1916	1574	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	48719	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
7835474	7835474	PRJNA1068830_P_NODE_50147_length_309_cov_1.983051_g49444_i0	PRJNA1068830	50147	309	1.983051	6.12762759	Methylacidimicrobium sp. B4	2796139	Bacteria	Bacteria	370	7.01e-98	NTclustered	gi\|1999103383\|gb\|CP066203.1\|	2796139	g49444	i0	88.525	7.03883495145631	305	35	99	0	1	305	125508	125812	Methylacidimicrobium sp. B4 chromosome, complete genome	blastn	2175	370	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. B4
8667459	8667459	PRJNA1068830_P_NODE_59287_length_283_cov_0.928571_g58584_i0	PRJNA1068830	59287	283	0.928571	2.62785593	Akkermansia	239934	Bacteria	Bacteria	507	4.64e-139	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g58584	i0	98.94	94.9540636042403	283	3	100	0	1	283	2393422	2393140	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	26872	507	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
9111187	9111187	PRJNA1068830_P_NODE_7648_length_927_cov_2.555035_g7077_i0	PRJNA1068830	7648	927	2.555035	23.68517445	Pedosphaera parvula	1032527	Bacteria	Bacteria	1061	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g7077	i0	87.42	196.663430420712	938	99	100	18	1	927	1639	710	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	182307	1061	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
10386394	10386394	PRJNA1068830_P_NODE_57449_length_287_cov_1.457944_g56746_i0	PRJNA1068830	57449	287	1.457944	4.18429928	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	252	2.44e-62	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g56746	i0	83.158	166.933797909408	285	39	99	6	1	284	2362615	2362891	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	47910	252	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
10387112	10387112	PRJNA1068830_P_NODE_85269_length_244_cov_0.912281_g84566_i0	PRJNA1068830	85269	244	0.912281	2.22596564	Akkermansia muciniphila	239935	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g84566	i0	93.724	26.8729508196721	239	8	95	2	1	232	1849227	1849465	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	6557	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
15486570	15486570	PRJNA1068830_P_NODE_87153_length_243_cov_0.917647_g86450_i0	PRJNA1068830	87153	243	0.917647	2.22988221	Akkermansia muciniphila	239935	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g86450	i0	99.588	95.4444444444444	243	1	100	0	1	243	1490564	1490322	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	23193	444	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
16760578	16760578	PRJNA1068830_P_NODE_78634_length_249_cov_0.886364_g77931_i0	PRJNA1068830	78634	249	0.886364	2.20704636	Akkermansia muciniphila	239935	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2623923984\|gb\|CP115935.1\|	239935	g77931	i0	99.598	14	249	1	100	0	1	249	156275	156027	Akkermansia muciniphila strain SDLYAKK8 chromosome, complete genome	blastn	3486	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20584032	20584032	PRJNA1068830_P_NODE_49657_length_311_cov_1.457983_g48954_i0	PRJNA1068830	49657	311	1.457983	4.53432713	Akkermansia muciniphila	239935	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|2051353120\|gb\|CP072035.1\|	239935	g48954	i0	100	38.411575562701	311	0	100	0	1	311	2448027	2448337	Akkermansia muciniphila strain Akk1576 chromosome, complete genome	blastn	11946	575	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20584695	20584695	PRJNA1068830_P_NODE_77057_length_250_cov_0.881356_g76354_i0	PRJNA1068830	77057	250	0.881356	2.20339	Akkermansia muciniphila	239935	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g76354	i0	100	100	250	0	100	0	1	250	1338137	1338386	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	25000	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20584806	20584806	PRJNA1068830_P_NODE_81397_length_247_cov_0.896552_g80694_i0	PRJNA1068830	81397	247	0.896552	2.21448344	Akkermansia muciniphila	239935	Bacteria	Bacteria	407	4.14e-109	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g80694	i0	96.356	40.82995951417	247	9	100	0	1	247	1850486	1850732	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	10085	407	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
23135882	23135882	PRJNA1068830_P_NODE_74059_length_252_cov_0.871508_g73356_i0	PRJNA1068830	74059	252	0.871508	2.19620016	Akkermansia muciniphila	239935	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1510315172\|gb\|CP024736.1\|	239935	g73356	i0	100	99.9880952380952	252	0	100	0	1	252	1509647	1509898	Akkermansia muciniphila strain EB-AMDK-1 chromosome, complete genome	blastn	25197	466	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
23966715	23966715	PRJNA1068830_P_NODE_71919_length_253_cov_2.094444_g71216_i0	PRJNA1068830	71919	253	2.094444	5.29894332	Akkermansia	239934	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g71216	i0	100	94.9604743083004	253	0	100	0	1	253	1768351	1768099	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	24025	468	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
24409602	24409602	PRJNA1068830_P_NODE_78120_length_249_cov_0.886364_g77417_i0	PRJNA1068830	78120	249	0.886364	2.20704636	Akkermansia muciniphila	239935	Bacteria	Bacteria	453	5.29e-123	NTclustered	gi\|2623923984\|gb\|CP115935.1\|	239935	g77417	i0	99.598	8.36144578313253	249	0	100	1	1	249	176065	175818	Akkermansia muciniphila strain SDLYAKK8 chromosome, complete genome	blastn	2082	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila

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