metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJEB8827" and tax

16 rows where analysis = "blastn", bioproject = "PRJEB8827" and tax_phylum = "Planctomycetota"

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
25529479	25529479	PRJEB8827b_S_NODE_37353_length_165_cov_1.846154_g37301_i0	PRJEB8827	37353	165	1.846154	3.0461541	Limnoglobus roseus	2598579	Bacteria	Bacteria	244	2.12e-60	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g37301	i0	93.333	91.4484848484849	165	11	100	0	1	165	2958270	2958434	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	15089	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
25529638	25529638	PRJEB8827e_S_NODE_29329_length_168_cov_3.796992_g29301_i0	PRJEB8827	29329	168	3.796992	6.37894656	Polystyrenella longa	2528007	Bacteria	Bacteria	195	2.22e-45	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g29301	i0	87.5	22.9642857142857	168	21	100	0	1	168	1415640	1415473	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	3858	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
25530053	25530053	PRJEB8827f_S_NODE_3905_length_228_cov_58.772021_g3885_i0	PRJEB8827	3905	228	58.772021	134.00020788	Rubinisphaera brasiliensis DSM 53	119	Bacteria	Bacteria	174	4.16e-39	NTclustered	gi\|324966854\|gb\|CP002546.1\|	756272	g3885	i0	86.624	156.328947368421	157	21	69	0	39	195	103576	103420	Rubinisphaera brasiliensis DSM 5305 chromosome, complete genome	blastn	35643	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera brasiliensis
25530138	25530138	PRJEB8827f_S_NODE_7185_length_192_cov_2.751592_g7165_i0	PRJEB8827	7185	192	2.751592	5.28305664	Limnoglobus roseus	2598579	Bacteria	Bacteria	193	9.34e-45	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g7165	i0	87.135	28.6302083333333	171	21	89	1	1	171	2958716	2958885	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	5497	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
25665685	25665685	PRJEB8827e_S_NODE_41674_length_154_cov_7.210084_g41646_i0	PRJEB8827	41674	154	7.210084	11.10352936	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	106	9.56e-19	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g41646	i0	81.481	3.12987012987013	135	19	84	5	26	154	560116	559982	Gemmata sp. SH-PL17, complete genome	blastn	482	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
25666047	25666047	PRJEB8827f_S_NODE_5194_length_208_cov_1.589595_g5174_i0	PRJEB8827	5194	208	1.589595	3.3063576	Planctomycetes bacterium Pan216	2527975	Bacteria	Bacteria	213	7.9e-51	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g5174	i0	87.234	31.6346153846154	188	22	90	2	22	208	1829288	1829474	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	6580	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
25889769	25889769	PRJEB8827h_S_NODE_1195_length_276_cov_4679.543568_g1176_i0	PRJEB8827	1195	276	4679.543568	12915.54024768	Engelhardtia	139931	Bacteria	Bacteria	228	3.9299999999999985e-55	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g1176	i0	85.78	33.5688405797101	218	28	78	3	61	276	5248967	5249183	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	9265	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
25938409	25938409	PRJEB8827f_S_NODE_380_length_481_cov_7.959641_g361_i0	PRJEB8827	380	481	7.959641	38.28587321	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	156	3.47e-33	NTclustered	gi\|2621705104\|emb\|OY763327.1\|	2026777	g361	i0	82.486	22.024948024948	177	31	37	0	59	235	3235899	3235723	MAG: Phycisphaeraceae bacterium isolate 55aab3a5-de4e-4c55-acd5-ede7382e386b genome assembly, chromosome: 1	blastn	10594	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
26025998	26025998	PRJEB8827f_S_NODE_27364_length_159_cov_1.419355_g27344_i0	PRJEB8827	27364	159	1.419355	2.25677445	Frigoriglobus	2774146	Bacteria	Bacteria	200	4.439999999999999e-47	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g27344	i0	95.276	53.1194968553459	127	4	79	2	2	127	2002405	2002530	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	8446	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26074110	26074110	PRJEB8827e_S_NODE_93_length_906_cov_4.159587_g90_i0	PRJEB8827	93	906	4.159587	37.68585822	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	1214	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g90	i0	91.573	376.164459161148	890	59	97	16	5	883	2003118	2002234	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	340805	1214	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26162092	26162092	PRJEB8827f_S_NODE_10957_length_179_cov_2.104167_g10937_i0	PRJEB8827	10957	179	2.104167	3.76645893	Isosphaera	127	Bacteria	Bacteria	180	6.67e-41	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g10937	i0	87.037	36.9329608938547	162	17	90	4	18	178	1239	1081	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	6611	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
26162105	26162105	PRJEB8827f_S_NODE_15173_length_171_cov_1.845588_g15153_i0	PRJEB8827	15173	171	1.845588	3.15595548	Telmatocola	1382832	Bacteria	Bacteria	241	2.85e-59	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g15153	i0	94.805	43.0701754385965	154	8	90	0	1	154	3722199	3722352	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	7365	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
26210250	26210250	PRJEB8827e_S_NODE_37414_length_161_cov_1.476190_g37386_i0	PRJEB8827	37414	161	1.47619	2.3766659	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	219	1.2499999999999996e-52	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g37386	i0	96.241	289.590062111801	133	5	83	0	1	133	4960230	4960362	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	46624	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
26210700	26210700	PRJEB8827f_S_NODE_686_length_403_cov_9.823370_g666_i0	PRJEB8827	686	403	9.82337	39.5881811	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	366	1.2199999999999996e-96	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g666	i0	85.593	105.436724565757	354	45	87	6	53	403	2002169	2001819	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	42491	366	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26297896	26297896	PRJEB8827f_S_NODE_134_length_631_cov_3.402685_g121_i0	PRJEB8827	134	631	3.402685	21.47094235	Frigoriglobus	2774146	Bacteria	Bacteria	806	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g121	i0	91.29	352.231378763867	597	43	94	9	42	631	2003097	2002503	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	222258	809	0.996291718170581	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26346087	26346087	PRJEB8827e_S_NODE_3071_length_247_cov_2.867925_g3043_i0	PRJEB8827	3071	247	2.867925	7.08377475	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	274	4.38e-69	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g3043	i0	86.8	117.198380566802	250	28	100	5	1	247	2002104	2001857	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	28948	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;