metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA939369" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA939369" 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
3465253	3465253	PRJNA939369_S_NODE_5383_length_528_cov_4.575824_g4967_i0	PRJNA939369	5383	528	4.575824	24.16035072	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	795	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4967	i0	93.785	77.907196969697	531	30	100	3	1	528	2002824	2003354	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	41135	795	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8567555	8567555	PRJNA939369_S_NODE_75087_length_241_cov_1.821429_g74670_i0	PRJNA939369	75087	241	1.821429	4.38964389	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g74670	i0	97.51	112.423236514523	241	6	100	0	1	241	735640	735880	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	27094	412	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8908872	8908872	PRJNA939369_S_NODE_18967_length_343_cov_2.959259_g18550_i0	PRJNA939369	18967	343	2.959259	10.15025837	Akkermansia	239934	Bacteria	Bacteria	573	5.599999999999998e-159	NTclustered	gi\|2051360498\|gb\|CP072032.1\|	239935	g18550	i0	96.793	296	343	11	100	0	1	343	395293	394951	Akkermansia muciniphila strain Akk1613 chromosome, complete genome	blastn	101528	573	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
8908881	8908881	PRJNA939369_S_NODE_22207_length_327_cov_2.791339_g21790_i0	PRJNA939369	22207	327	2.791339	9.12767853	Gemmataceae	1914233	Bacteria	Bacteria	453	7.210000000000001e-123	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g21790	i0	91.743	130.834862385321	327	25	100	2	1	327	1034777	1035101	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	42783	455	0.995604395604396	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
9842216	9842216	PRJNA939369_S_NODE_19488_length_340_cov_2.741573_g19071_i0	PRJNA939369	19488	340	2.741573	9.3213482	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	309	1.7300000000000003e-79	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g19071	i0	83.988	184.055882352941	331	43	96	9	1	326	2161657	2161982	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	62579	309	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
11118007	11118007	PRJNA939369_S_NODE_38129_length_280_cov_2.130435_g37712_i0	PRJNA939369	38129	280	2.130435	5.965218	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	496	9.92e-136	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g37712	i0	98.571	109.475	280	4	100	0	1	280	1250535	1250814	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	30653	496	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
13667855	13667855	PRJNA939369_S_NODE_18671_length_345_cov_1.470588_g18254_i0	PRJNA939369	18671	345	1.470588	5.0735286	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	363	1.33e-95	NTclustered	gi\|2225500096\|gb\|CP095464.1\|	2026799	g18254	i0	87.077	331.91884057971	325	36	93	6	1	322	594236	594557	MAG: Verrucomicrobia bacterium isolate LL51 chromosome, complete genome	blastn	114512	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
14942427	14942427	PRJNA939369_S_NODE_61652_length_248_cov_0.880000_g61235_i0	PRJNA939369	61652	248	0.88	2.1824	uncultured Opitutaceae bacterium	333967	Bacteria	Bacteria	106	1.7e-18	NTclustered	gi\|2518551946\|emb\|OX638348.1\|	333967	g61235	i0	75.833	4.23387096774194	240	41	94	15	16	248	4609834	4609605	MAG: uncultured Opitutaceae bacterium isolate b1b57f99-08c0-43d1-969e-fd0ef39b1292 genome assembly, chromosome: 1	blastn	1050	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		uncultured Opitutaceae bacterium
16217244	16217244	PRJNA939369_S_NODE_2833_length_674_cov_5.935108_g2437_i0	PRJNA939369	2833	674	5.935108	40.00262792	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	1201	0	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g2437	i0	98.813	119.197329376855	674	8	100	0	1	674	1092265	1092938	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	80339	1201	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
16558579	16558579	PRJNA939369_S_NODE_3933_length_593_cov_4.084615_g3527_i0	PRJNA939369	3933	593	4.084615	24.22176695	Akkermansia	239934	Bacteria	Bacteria	1085	0	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g3527	i0	99.663	296	593	2	100	0	1	593	137908	137316	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	175528	1085	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
18766104	18766104	PRJNA939369_S_NODE_43235_length_270_cov_1.172589_g42818_i0	PRJNA939369	43235	270	1.172589	3.1659903	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	346	1.01e-90	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g42818	i0	90.637	127.751851851852	267	15	97	7	4	264	1316478	1316740	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	34493	346	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18766313	18766313	PRJNA939369_S_NODE_68755_length_244_cov_1.426901_g68338_i0	PRJNA939369	68755	244	1.426901	3.48163844	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	200	7.4299999999999985e-47	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g68338	i0	81.855	89.0081967213115	248	36	100	6	1	244	1866433	1866675	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	21718	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20041227	20041227	PRJNA939369_S_NODE_73236_length_242_cov_1.284024_g72819_i0	PRJNA939369	73236	242	1.284024	3.10733808	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	392	1.1299999999999999e-104	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g72819	i0	95.885	204.107438016529	243	8	100	2	1	242	1315546	1315787	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	49394	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21316265	21316265	PRJNA939369_S_NODE_16157_length_361_cov_1.479167_g15740_i0	PRJNA939369	16157	361	1.479167	5.33979287	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	623	5.779999999999999e-174	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g15740	i0	97.784	137.02216066482	361	8	100	0	1	361	2003835	2003475	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	49465	623	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21316420	21316420	PRJNA939369_S_NODE_41157_length_274_cov_1.437811_g40740_i0	PRJNA939369	41157	274	1.437811	3.93960214	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	368	2.1999999999999996e-97	NTclustered	gi\|2225500096\|gb\|CP095464.1\|	2026799	g40740	i0	91.144	133.890510948905	271	24	99	0	4	274	594369	594639	MAG: Verrucomicrobia bacterium isolate LL51 chromosome, complete genome	blastn	36686	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
21316439	21316439	PRJNA939369_S_NODE_43297_length_270_cov_1.126904_g42880_i0	PRJNA939369	43297	270	1.126904	3.0426408	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	291	4.82e-74	NTclustered	gi\|2225500096\|gb\|CP095464.1\|	2026799	g42880	i0	86.296	159.3	270	34	100	3	1	270	594661	594927	MAG: Verrucomicrobia bacterium isolate LL51 chromosome, complete genome	blastn	43011	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
21658318	21658318	PRJNA939369_S_NODE_2057_length_769_cov_4.298851_g1685_i0	PRJNA939369	2057	769	4.298851	33.05816419	Gemmataceae	1914233	Bacteria	Bacteria	1254	0	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g1685	i0	96.224	174.561768530559	768	25	99	3	1	766	3634444	3633679	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	134238	1260	0.995238095238095	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana

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