metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1061474" 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
178850	178850	PRJNA1061474_P_NODE_45401_length_251_cov_0.865169_g45155_i0	PRJNA1061474	45401	251	0.865169	2.17157419	Opitutus terrae	107709	Bacteria	Bacteria	331	2.6100000000000006e-86	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g45155	i0	90.438	3.88446215139442	251	24	100	0	1	251	1312130	1312380	Opitutus terrae PB90-1, complete genome	blastn	975	331	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
178981	178981	PRJNA1061474_P_NODE_50981_length_246_cov_1.456647_g50735_i0	PRJNA1061474	50981	246	1.456647	3.58335162	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	163	9.84e-36	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g50735	i0	80.09	10.7642276422764	221	42	89	2	14	233	2913006	2913225	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	2648	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
1453611	1453611	PRJNA1061474_P_NODE_51242_length_246_cov_0.890173_g50996_i0	PRJNA1061474	51242	246	0.890173	2.18982558	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	183	7.549999999999997e-42	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g50996	i0	80.672	60.150406504065	238	44	96	2	10	246	4778938	4778702	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	14797	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2729458	2729458	PRJNA1061474_P_NODE_51923_length_246_cov_0.890173_g51677_i0	PRJNA1061474	51923	246	0.890173	2.18982558	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	303	5.56e-78	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g51677	i0	91.403	0.898373983739837	221	19	90	0	1	221	5177837	5178057	Tautonia plasticadhaerens strain ElP chromosome	blastn	221	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
2729459	2729459	PRJNA1061474_P_NODE_51943_length_246_cov_0.890173_g51697_i0	PRJNA1061474	51943	246	0.890173	2.18982558	Pirellulimonas nuda	2528009	Bacteria	Bacteria	250	7.34e-62	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g51697	i0	85.081	6.85772357723577	248	33	100	4	1	246	405234	405479	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	1687	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
2729499	2729499	PRJNA1061474_P_NODE_53623_length_244_cov_0.900585_g53377_i0	PRJNA1061474	53623	244	0.900585	2.1974274	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	71.3	6.08e-8	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g53377	i0	90.566	0.217213114754098	53	5	22	0	190	242	4537125	4537177	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	53	71.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
2729501	2729501	PRJNA1061474_P_NODE_53903_length_244_cov_0.900585_g53657_i0	PRJNA1061474	53903	244	0.900585	2.1974274	Opitutus terrae	107709	Bacteria	Bacteria	239	1.57e-58	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g53657	i0	84.81	1.94262295081967	237	36	97	0	8	244	555781	555545	Opitutus terrae PB90-1, complete genome	blastn	474	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
2729516	2729516	PRJNA1061474_P_NODE_54343_length_244_cov_0.900585_g54097_i0	PRJNA1061474	54343	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	248	2.6199999999999997e-61	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g54097	i0	85.417	7.82786885245902	240	34	98	1	1	239	5786207	5786446	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1910	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2729533	2729533	PRJNA1061474_P_NODE_54783_length_243_cov_0.905882_g54537_i0	PRJNA1061474	54783	243	0.905882	2.20129326	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	183	7.44e-42	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g54537	i0	80.579	2.11522633744856	242	44	99	3	1	241	1399082	1398843	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	514	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4005516	4005516	PRJNA1061474_P_NODE_56184_length_242_cov_0.911243_g55938_i0	PRJNA1061474	56184	242	0.911243	2.20520806	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	215	2.63e-51	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g55938	i0	82.845	1.97520661157025	239	41	99	0	3	241	791575	791813	Gemmata sp. SH-PL17, complete genome	blastn	478	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
5281747	5281747	PRJNA1061474_P_NODE_53685_length_244_cov_0.900585_g53439_i0	PRJNA1061474	53685	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	219	2.05e-52	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g53439	i0	84.375	0.918032786885246	224	34	91	1	18	240	1803932	1804155	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	224	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6556851	6556851	PRJNA1061474_P_NODE_50026_length_247_cov_0.885057_g49780_i0	PRJNA1061474	50026	247	0.885057	2.18609079	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	159	1.28e-34	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g49780	i0	79.31	17.1457489878543	232	44	93	4	3	232	907325	907096	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	4235	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
6556887	6556887	PRJNA1061474_P_NODE_51526_length_246_cov_0.890173_g51280_i0	PRJNA1061474	51526	246	0.890173	2.18982558	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	220	5.76e-53	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g51280	i0	83.065	61.4634146341463	248	37	99	5	1	245	3416394	3416149	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	15120	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10382289	10382289	PRJNA1061474_P_NODE_54849_length_243_cov_0.905882_g54603_i0	PRJNA1061474	54849	243	0.905882	2.20129326	Bremerella sp. P1	3026424	Bacteria	Bacteria	139	1.63e-28	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g54603	i0	80.628	1.39917695473251	191	27	77	8	1	186	1453193	1453378	Bremerella sp. P1 chromosome, complete genome	blastn	340	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
11215124	11215124	PRJNA1061474_P_NODE_57649_length_241_cov_0.916667_g57403_i0	PRJNA1061474	57649	241	0.916667	2.20916747	Verrucomicrobiota	74201	Bacteria	Bacteria	279	9.14e-71	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g57403	i0	87.705	4.8298755186722	244	24	100	5	1	241	2231844	2232084	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	1164	281	0.99288256227758	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11657128	11657128	PRJNA1061474_P_NODE_38990_length_285_cov_1.363208_g38744_i0	PRJNA1061474	38990	285	1.363208	3.8851428	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	300	8.52e-77	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g38744	i0	85.714	41.0315789473684	287	37	100	4	1	285	4967081	4966797	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	11694	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11657385	11657385	PRJNA1061474_P_NODE_47710_length_249_cov_0.875000_g47464_i0	PRJNA1061474	47710	249	0.875	2.17875	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	167	7.709999999999999e-37	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g47464	i0	100	33.5301204819277	90	0	36	0	53	142	5401604	5401515	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	8349	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11657635	11657635	PRJNA1061474_P_NODE_57610_length_241_cov_0.916667_g57364_i0	PRJNA1061474	57610	241	0.916667	2.20916747	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	182	2.65e-41	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g57364	i0	81.9	1.67634854771784	221	34	90	6	1	217	947938	947720	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	404	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13765068	13765068	PRJNA1061474_P_NODE_48111_length_249_cov_0.875000_g47865_i0	PRJNA1061474	48111	249	0.875	2.17875	Gemmata	113	Bacteria	Bacteria	207	4.54e-49	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g47865	i0	82.143	72.8192771084337	252	35	99	10	1	247	8308656	8308410	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	18132	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
15481909	15481909	PRJNA1061474_P_NODE_58073_length_241_cov_0.916667_g57827_i0	PRJNA1061474	58073	241	0.916667	2.20916747	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	67.6	7.75e-7	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g57827	i0	95.238	6.94605809128631	42	2	17	0	200	241	2455969	2456010	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	1674	67.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16755806	16755806	PRJNA1061474_P_NODE_48234_length_249_cov_0.875000_g47988_i0	PRJNA1061474	48234	249	0.875	2.17875	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	289	1.58e-73	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g47988	i0	87.6	26.9397590361446	250	29	100	2	1	249	1217775	1218023	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	6708	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
18030501	18030501	PRJNA1061474_P_NODE_45835_length_251_cov_0.865169_g45589_i0	PRJNA1061474	45835	251	0.865169	2.17157419	Urbifossiella limnaea	2528023	Bacteria	Bacteria	163	1.01e-35	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g45589	i0	80.66	0.844621513944223	212	39	84	2	39	249	4409409	4409619	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	212	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
19304576	19304576	PRJNA1061474_P_NODE_48376_length_249_cov_0.875000_g48130_i0	PRJNA1061474	48376	249	0.875	2.17875	Pirellulimonas nuda	2528009	Bacteria	Bacteria	189	1.6499999999999999e-43	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g48130	i0	80.645	3.88353413654618	248	44	99	4	1	246	440749	440504	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	967	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
19304581	19304581	PRJNA1061474_P_NODE_48576_length_249_cov_0.875000_g48330_i0	PRJNA1061474	48576	249	0.875	2.17875	Ereboglobus luteus	1796921	Bacteria	Bacteria	167	7.709999999999999e-37	NTclustered	gi\|1387286769\|gb\|CP023004.1\|	1796921	g48330	i0	83.333	1.65863453815261	180	30	72	0	70	249	351077	351256	Ereboglobus luteus strain Ho45, complete genome	blastn	413	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Ereboglobus	Ereboglobus luteus
19304733	19304733	PRJNA1061474_P_NODE_54916_length_243_cov_0.905882_g54670_i0	PRJNA1061474	54916	243	0.905882	2.20129326	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g54670	i0	98.354	208.008230452675	243	4	100	0	1	243	1315562	1315804	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	50546	427	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;