metadata: contig_metadata: 17 rows where bioproject = "PRJNA631796", tax_clade = "PVC group" and tax

17 rows where bioproject = "PRJNA631796", tax_clade = "PVC group" 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
603416	603416	PRJNA631796_S_NODE_69841_length_217_cov_1.275641_g69674_i0	PRJNA631796	69841	217	1.275641	2.76814097	Phycisphaera sp.	2030824	Bacteria	Bacteria	172	1.41e-38	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g69674	i0	81.193	138.428571428571	218	38	100	3	1	217	3046752	3046537	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	30039	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
1879583	1879583	PRJNA631796_P_NODE_9502_length_223_cov_1.259259_g9224_i0	PRJNA631796	9502	223	1.259259	2.80814757	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	344	2.92e-90	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g9224	i0	94.619	279.304932735426	223	11	100	1	1	223	4318165	4317944	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	62285	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2427248	2427248	PRJNA631796_P_NODE_10482_length_213_cov_3.203947_g10204_i0	PRJNA631796	10482	213	3.203947	6.82440711	Botrimarina	2795782	Bacteria	Bacteria	344	2.76e-90	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g10204	i0	95.775	102.69014084507	213	9	100	0	1	213	4245523	4245311	Planctomycetes bacterium K2D chromosome, complete genome	blastn	21873	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
4431132	4431132	PRJNA631796_P_NODE_8584_length_233_cov_1.168605_g8306_i0	PRJNA631796	8584	233	1.168605	2.72284965	uncultured Gemmata sp.	459262	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|389547053\|gb\|JQ401981.1\|	459262	g8306	i0	99.571	101.802575107296	233	1	100	0	1	233	328	96	Uncultured Gemmata sp. clone CNY_02230 16S ribosomal RNA gene, partial sequence	blastn	23720	425	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	uncultured Gemmata sp.
8256564	8256564	PRJNA631796_P_NODE_5147_length_304_cov_1.563786_g4869_i0	PRJNA631796	5147	304	1.563786	4.75390944	Gemmataceae bacterium	2052164	Bacteria	Bacteria	429	1.12e-115	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g4869	i0	92.105	88.125	304	24	100	0	1	304	318286	318589	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	26790	429	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
9531852	9531852	PRJNA631796_P_NODE_10428_length_214_cov_1.522876_g10150_i0	PRJNA631796	10428	214	1.522876	3.25895464	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	263	8.000000000000002e-66	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g10150	i0	90.909	123.46261682243	198	15	92	3	18	214	4317283	4317088	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	26421	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10807628	10807628	PRJNA631796_P_NODE_9689_length_221_cov_1.575000_g9411_i0	PRJNA631796	9689	221	1.575	3.48075	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	259	1.08e-64	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g9411	i0	88	99.2217194570136	225	19	100	7	1	221	1600619	1600839	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	21928	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
11355395	11355395	PRJNA631796_P_NODE_10409_length_214_cov_1.712418_g10131_i0	PRJNA631796	10409	214	1.712418	3.66457452	Bacteria	2	Bacteria	Bacteria	76.8	1.12e-9	NTclustered	gi\|2621705864\|emb\|OY763926.1\|	2813034	g10131	i0	87.879	0.925233644859813	66	7	30	1	1	65	3277005	3276940	MAG: Sedimentisphaerales bacterium isolate 7f5c64f7-1a0d-4936-834e-775057159072 genome assembly, chromosome: 1	blastn	198	76.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
11355435	11355435	PRJNA631796_P_NODE_4649_length_322_cov_1.586207_g4371_i0	PRJNA631796	4649	322	1.586207	5.10758654	Singulisphaera	466152	Bacteria	Bacteria	444	4.27e-120	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g4371	i0	91.824	100.049689440994	318	26	99	0	5	322	1030	713	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	32216	444	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
18455501	18455501	PRJNA631796_P_NODE_9275_length_225_cov_2.396341_g8997_i0	PRJNA631796	9275	225	2.396341	5.39176725	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	399	6.199999999999999e-107	NTclustered	gi\|338188055\|gb\|JF988563.1\|	120965	g8997	i0	98.667	100.102222222222	225	3	100	0	1	225	253	29	Uncultured planctomycete clone Upland_120_7863 16S ribosomal RNA gene, partial sequence	blastn	22523	399	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
19003463	19003463	PRJNA631796_P_NODE_2475_length_451_cov_6.271795_g2199_i0	PRJNA631796	2475	451	6.271795	28.28579545	Isosphaera	127	Bacteria	Bacteria	621	2.6599999999999996e-173	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g2199	i0	91.593	271.620842572062	452	35	100	3	1	451	1115	666	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	122501	621	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
22829475	22829475	PRJNA631796_P_NODE_6498_length_269_cov_0.923077_g6220_i0	PRJNA631796	6498	269	0.923077	2.48307713	Botrimarina	2795782	Bacteria	Bacteria	475	1.2299999999999999e-129	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g6220	i0	98.513	207.624535315985	269	4	100	0	1	269	4245774	4246042	Planctomycetes bacterium K2D chromosome, complete genome	blastn	55851	475	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
23555997	23555997	PRJNA631796_P_NODE_9319_length_225_cov_1.274390_g9041_i0	PRJNA631796	9319	225	1.27439	2.8673775	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	115	2.5200000000000004e-21	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g9041	i0	82.353	0.604444444444444	136	21	60	3	91	225	3994427	3994560	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	136	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
24103894	24103894	PRJNA631796_P_NODE_1179_length_668_cov_4.034596_g922_i0	PRJNA631796	1179	668	4.034596	26.95110128	Isosphaera	127	Bacteria	Bacteria	697	0	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g922	i0	85.714	146.47754491018	679	75	99	19	3	668	8	677	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	97847	697	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
24829698	24829698	PRJNA631796_P_NODE_9200_length_226_cov_1.593939_g8922_i0	PRJNA631796	9200	226	1.593939	3.60230214	uncultured Pirellula sp.	298571	Bacteria	Bacteria	377	2.92e-100	NTclustered	gi\|192806515\|emb\|FM177023.1\|	298571	g8922	i0	97.717	97.3805309734513	219	5	97	0	1	219	294	512	Uncultured Pirellula sp. partial 16S rRNA gene, clone CL6-7.L440	blastn	22008	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	uncultured Pirellula sp.
25378399	25378399	PRJNA631796_P_NODE_2840_length_419_cov_1.558659_g2563_i0	PRJNA631796	2840	419	1.558659	6.53078121	Limnoglobus	2731450	Bacteria	Bacteria	599	1.1499999999999995e-166	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g2563	i0	93.366	165.198090692124	407	23	96	4	1	404	7050953	7051358	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	69218	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
27030163	27030163	PRJNA631796_S_NODE_1662_length_456_cov_3.675949_g1495_i0	PRJNA631796	1662	456	3.675949	16.76232744	Bacteria	2	Bacteria	Bacteria	45.4	0.00183	NR	GHT13140.1	2053591	g1495	i0	52.9	1.09868421052632	34	16	22.4	0	452	351	9	42	GHT13140.1 hypothetical protein FACS1894170_08790 [Planctomycetales bacterium]	diamond	501	45.8	0.991266375545852	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales 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);;