metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax_phylum = "Verrucomicrobiota"

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
1129884	1129884	PRJNA558770_P_NODE_388301_length_183_cov_1.000000_g386296_i0	PRJNA558770	388301	183	1	1.83	Prosthecobacter	48463	Bacteria	Bacteria	195	2.45e-45	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g386296	i0	85.87	2.01092896174863	184	24	100	2	1	183	250	432	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	368	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
1816340	1816340	PRJNA558770_P_NODE_293862_length_234_cov_1.452261_g291857_i0	PRJNA558770	293862	234	1.452261	3.39829074	Coraliomargarita akajimensis	395922	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|293612874\|gb\|CP001998.1\|	583355	g291857	i0	100	0.11965811965812	28	0	12	0	167	194	3683871	3683898	Coraliomargarita akajimensis DSM 45221, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita akajimensis
7508215	7508215	PRJNA558770_P_NODE_76566_length_237_cov_9.316832_g74561_i0	PRJNA558770	76566	237	9.316832	22.08089184	Akkermansia	239934	Bacteria	Bacteria	274	4.17e-69	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g74561	i0	96.386	208.729957805907	166	6	70	0	2	167	139033	138868	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	49469	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
8195375	8195375	PRJNA558770_P_NODE_63327_length_262_cov_6.189427_g61322_i0	PRJNA558770	63327	262	6.189427	16.21629874	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	375	1.25e-99	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g61322	i0	92.996	270.553435114504	257	18	98	0	3	259	2442	2186	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	70885	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
8195433	8195433	PRJNA558770_P_NODE_65947_length_256_cov_17.398190_g63942_i0	PRJNA558770	65947	256	17.39819	44.5393664	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	148	2.89e-31	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g63942	i0	98.795	80.41796875	83	1	32	0	6	88	3894553	3894471	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	20587	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11332993	11332993	PRJNA558770_P_NODE_381729_length_210_cov_5.514286_g379724_i0	PRJNA558770	381729	210	5.514286	11.5800006	Akkermansia	239934	Bacteria	Bacteria	309	9.9e-80	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g379724	i0	95.385	276.719047619048	195	8	92	1	16	209	138839	139033	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	58111	309	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
12017292	12017292	PRJNA558770_P_NODE_156850_length_234_cov_5.959799_g154845_i0	PRJNA558770	156850	234	5.959799	13.94592966	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	117	7.33e-22	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g154845	i0	94.667	2.95726495726496	75	4	32	0	160	234	2558774	2558848	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	692	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12019406	12019406	PRJNA558770_P_NODE_27190_length_405_cov_5.116216_g25234_i0	PRJNA558770	27190	405	5.116216	20.7206748	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	99	4.92e-16	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g25234	i0	92.647	0.167901234567901	68	5	17	0	1	68	1902554	1902621	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	68	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13293293	13293293	PRJNA558770_P_NODE_204211_length_234_cov_3.623116_g202206_i0	PRJNA558770	204211	234	3.623116	8.47809144	Fontisphaera persica	2974023	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g202206	i0	100	0.247863247863248	30	0	13	0	194	223	2258446	2258475	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	58	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
15842264	15842264	PRJNA558770_P_NODE_215793_length_234_cov_3.221106_g213788_i0	PRJNA558770	215793	234	3.221106	7.53738804	Akkermansia muciniphila	239935	Bacteria	Bacteria	139	1.56e-28	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g213788	i0	100	55.9786324786325	75	0	62	0	160	234	306967	307041	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	13099	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
15843159	15843159	PRJNA558770_P_NODE_271493_length_234_cov_1.879397_g269488_i0	PRJNA558770	271493	234	1.879397	4.39778898	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	93.5	1.23e-14	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g269488	i0	93.548	3.87179487179487	62	4	59	0	170	231	3450656	3450717	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	906	93.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
17120193	17120193	PRJNA558770_P_NODE_63754_length_261_cov_6.805310_g61749_i0	PRJNA558770	63754	261	6.80531	17.7618591	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	147	1.06e-30	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g61749	i0	97.647	99.4061302681992	85	2	33	0	157	241	2702	2786	Luteolibacter sp. SL250 chromosome	blastn	25945	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
18393725	18393725	PRJNA558770_P_NODE_395915_length_157_cov_3.131148_g393910_i0	PRJNA558770	395915	157	3.131148	4.91590236	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	69.4	1.29e-7	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g393910	i0	100	1.99363057324841	37	0	24	0	31	67	2365014	2364978	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	313	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18980941	18980941	PRJNA558770_P_NODE_288895_length_234_cov_1.587940_g286890_i0	PRJNA558770	288895	234	1.58794	3.7157796	Prosthecobacter	48463	Bacteria	Bacteria	141	4.35e-29	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g286890	i0	100	5.04273504273504	76	0	32	0	159	234	2312	2387	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	1180	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
19663305	19663305	PRJNA558770_P_NODE_101836_length_234_cov_12.040201_g99831_i0	PRJNA558770	101836	234	12.040201	28.17407034	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g99831	i0	96.97	0.141025641025641	33	1	14	0	41	73	872581	872549	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19665885	19665885	PRJNA558770_P_NODE_217936_length_234_cov_3.155779_g215931_i0	PRJNA558770	217936	234	3.155779	7.38452286	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g215931	i0	96.97	0.141025641025641	33	0	14	1	186	217	1492060	1492028	Lacunisphaera limnophila strain IG16b, complete genome	blastn	33	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
20256372	20256372	PRJNA558770_P_NODE_382396_length_207_cov_5.906977_g380391_i0	PRJNA558770	382396	207	5.906977	12.22744239	Akkermansia	239934	Bacteria	Bacteria	283	5.9e-72	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g380391	i0	95.977	248.004830917874	174	7	84	0	33	206	138860	139033	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	51337	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20939017	20939017	PRJNA558770_P_NODE_100277_length_234_cov_12.366834_g98272_i0	PRJNA558770	100277	234	12.366834	28.93839156	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	137	5.62e-28	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g98272	i0	100	11.9273504273504	74	0	62	0	4	77	3894249	3894176	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	2791	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20940889	20940889	PRJNA558770_P_NODE_180537_length_234_cov_4.618090_g178532_i0	PRJNA558770	180537	234	4.61809	10.8063306	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	69.4	2.08e-7	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g178532	i0	95.349	0.183760683760684	43	2	18	0	192	234	5823120	5823162	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	43	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
22805871	22805871	PRJNA558770_P_NODE_142238_length_234_cov_7.010050_g140233_i0	PRJNA558770	142238	234	7.01005	16.403517	Pseudomonadati	3379134	Bacteria	Bacteria	76.8	1.24e-9	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g140233	i0	89.831	0.658119658119658	59	6	25	0	174	232	642353	642411	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	154	76.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23491398	23491398	PRJNA558770_P_NODE_190559_length_234_cov_4.160804_g188554_i0	PRJNA558770	190559	234	4.160804	9.73628136	Luteolibacter sp.	1962973	Bacteria	Bacteria	89.8	1.6e-13	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g188554	i0	88.889	0.611111111111111	72	8	31	0	162	233	101123	101194	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	143	89.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
24765811	24765811	PRJNA558770_P_NODE_221920_length_234_cov_3.035176_g219915_i0	PRJNA558770	221920	234	3.035176	7.10231184	Luteolibacter sp.	1962973	Bacteria	Bacteria	119	2.04e-22	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g219915	i0	94.872	17.9871794871795	78	0	65	4	1	75	1009816	1009892	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	4209	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.

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