metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJEB12366" and tax

19 rows where analysis = "blastn", bioproject = "PRJEB12366" 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
20755	20755	PRJEB12366_P_NODE_16301_length_174_cov_1.410072_g16111_i0	PRJEB12366	16301	174	1.410072	2.45352528	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	305	1.02e-78	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g16111	i0	98.276	166.431034482759	174	3	100	0	1	174	653981	654154	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	28959	305	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
2260935	2260935	PRJEB12366_P_NODE_8662_length_263_cov_2.105263_g8472_i0	PRJEB12366	8662	263	2.105263	5.53684169	Luteolibacter	518753	Bacteria	Bacteria	289	1.68e-73	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g8472	i0	87.121	412.346007604563	264	23	99	9	1	260	2216641	2216385	Luteolibacter sp. LG18 DNA, complete genome	blastn	108447	289	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
2570690	2570690	PRJEB12366_P_NODE_9803_length_242_cov_2.444444_g9613_i0	PRJEB12366	9803	242	2.444444	5.91555448	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	324	4.18e-84	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g9613	i0	91.286	201.946280991736	241	15	99	5	2	241	26599	26364	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	48871	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
3536251	3536251	PRJEB12366_P_NODE_17043_length_168_cov_3.353383_g16853_i0	PRJEB12366	17043	168	3.353383	5.63368344	Planctomycetia	203683	Bacteria	Bacteria	294	2.12e-75	NTclustered	gi\|908859\|emb\|X81960.1\|	41672	g16853	i0	98.214	117.458333333333	168	3	100	0	1	168	1479	1312	Isophaera sp. partial 16S rRNA gene (Schlesner 657)	blastn	19733	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp.
5123138	5123138	PRJEB12366_P_NODE_16245_length_174_cov_2.223022_g16055_i0	PRJEB12366	16245	174	2.223022	3.86805828	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	278	2.22e-70	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g16055	i0	96.45	131.568965517241	169	4	97	2	6	174	17102	17268	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	22893	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
5123189	5123189	PRJEB12366_P_NODE_7265_length_294_cov_1.536680_g7075_i0	PRJEB12366	7265	294	1.53668	4.5178392	Chthoniobacter flavus	191863	Bacteria	Bacteria	320	6.77e-83	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g7075	i0	86.486	123.309523809524	296	34	100	5	1	294	258	549	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	36253	320	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
7363339	7363339	PRJEB12366_S_NODE_3246_length_162_cov_1.976378_g3238_i0	PRJEB12366	3246	162	1.976378	3.20173236	root	1	Root_unresolved	Root_unresolved	222	9.709999999999999e-54	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g3238	i0	93.421	60.9567901234568	152	7	93	3	9	158	2002474	2002324	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	9875	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7672945	7672945	PRJEB12366_P_NODE_13327_length_198_cov_1.803681_g13137_i0	PRJEB12366	13327	198	1.803681	3.57128838	uncultured Phycisphaeraceae bacterium	904980	Bacteria	Bacteria	364	1.9399999999999995e-96	NTclustered	gi\|2259485739\|emb\|OW952296.1\|	904980	g13137	i0	100	99.2676767676768	197	0	99	0	2	198	38	234	uncultured Phycisphaeraceae bacterium DNA containing 16S-23S intergenic spacer region, clone 43	blastn	19655	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		uncultured Phycisphaeraceae bacterium
7672995	7672995	PRJEB12366_P_NODE_5547_length_349_cov_1.993631_g5357_i0	PRJEB12366	5547	349	1.993631	6.95777219	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	283	1.07e-71	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g5357	i0	81.714	95.3467048710602	350	54	100	8	1	349	2749806	2749466	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	33276	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10223534	10223534	PRJEB12366_P_NODE_19469_length_154_cov_1.680672_g19279_i0	PRJEB12366	19469	154	1.680672	2.58823488	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	257	2.5e-64	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g19279	i0	96.753	106.142857142857	154	5	100	0	1	154	1251332	1251485	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	16346	257	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
10223550	10223550	PRJEB12366_P_NODE_449_length_1259_cov_5.051471_g341_i1	PRJEB12366	449	1259	5.051471	63.59801989	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	1563	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g341	i1	90.29	150.033359809373	1205	101	95	13	1	1196	1600472	1599275	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	188892	1563	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
11498804	11498804	PRJEB12366_P_NODE_410_length_1302_cov_4.819258_g341_i0	PRJEB12366	410	1302	4.819258	62.74673916	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	1644	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g341	i0	89.558	151.218125960061	1312	115	99	18	1	1299	1600472	1599170	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	196886	1644	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
14048916	14048916	PRJEB12366_P_NODE_6712_length_310_cov_0.938182_g6522_i0	PRJEB12366	6712	310	0.938182	2.9083642	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	377	4.21e-100	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g6522	i0	88.71	137.916129032258	310	34	100	1	1	310	174091	174399	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	42754	377	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
19146226	19146226	PRJEB12366_P_NODE_10416_length_233_cov_2.348485_g10226_i0	PRJEB12366	10416	233	2.348485	5.47197005	uncultured Planctomycetia bacterium	411917	Bacteria	Bacteria	375	1.0899999999999998e-99	NTclustered	gi\|151349787\|gb\|EF662496.1\|	411917	g10226	i0	95.726	103.824034334764	234	8	100	2	1	233	29	261	Uncultured Planctomycetacia bacterium clone GASP-MA1S3_F03 16S ribosomal RNA gene, partial sequence	blastn	24191	375	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				uncultured Planctomycetia bacterium
20421439	20421439	PRJEB12366_P_NODE_4357_length_402_cov_2.482289_g4167_i0	PRJEB12366	4357	402	2.482289	9.97880178	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	427	5.48e-115	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g4167	i0	87.335	95.1442786069652	379	40	94	7	2	377	7728950	7728577	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	38248	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
20421468	20421468	PRJEB12366_S_NODE_2157_length_178_cov_3.475524_g2149_i0	PRJEB12366	2157	178	3.475524	6.18643272	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	191	3.06e-44	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2149	i0	88.75	10.3370786516854	160	12	88	6	1	157	2002958	2003114	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1840	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22972794	22972794	PRJEB12366_S_NODE_1119_length_208_cov_2.358382_g1111_i0	PRJEB12366	1119	208	2.358382	4.90543456	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	161	2.8999999999999997e-35	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g1111	i0	83.06	24.1057692307692	183	26	87	5	3	182	2002030	2001850	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	5014	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24246617	24246617	PRJEB12366_S_NODE_220_length_313_cov_3.535971_g212_i0	PRJEB12366	220	313	3.535971	11.06758923	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	459	1.48e-124	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g212	i0	93.038	580.798722044728	316	19	100	3	1	313	558698	558383	Gemmata sp. SH-PL17, complete genome	blastn	181790	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
25211718	25211718	PRJEB12366_P_NODE_18460_length_160_cov_0.952000_g18270_i0	PRJEB12366	18460	160	0.952	1.5232	Gemmata	113	Bacteria	Bacteria	226	7.389999999999999e-55	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g18270	i0	92.405	24.4	158	12	99	0	3	160	264	421	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	3904	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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