metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA572587" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA572587" 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
559089	559089	PRJNA572587_P_NODE_3781_length_668_cov_99.817447_g3493_i0	PRJNA572587	3781	668	99.817447	666.78054596	Pirellula staleyi	125	Bacteria	Bacteria	671	0	NTclustered	gi\|283436255\|gb\|CP001848.1\|	530564	g3493	i0	85.54	190.711077844311	657	77	96	11	27	668	3346595	3347248	Pirellula staleyi DSM 6068 chromosome, complete genome	blastn	127395	671	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
559125	559125	PRJNA572587_P_NODE_4261_length_623_cov_76.367596_g3962_i0	PRJNA572587	4261	623	76.367596	475.77012308	Aureliella sp.	2795609	Bacteria	Bacteria	747	0	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g3962	i0	95.319	122.534510433387	470	22	98	0	1	470	5638308	5638777	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	76339	747	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
3109701	3109701	PRJNA572587_P_NODE_20383_length_250_cov_51.203980_g20055_i0	PRJNA572587	20383	250	51.20398	128.00995	Caulifigura coniformis	2527983	Bacteria	Bacteria	368	1.98e-97	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g20055	i0	95.633	14.344	229	10	92	0	20	248	2924955	2925183	Caulifigura coniformis strain Pan44 chromosome	blastn	3586	368	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
4386529	4386529	PRJNA572587_P_NODE_39044_length_175_cov_10.452381_g38716_i0	PRJNA572587	39044	175	10.452381	18.29166675	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	196	6.44e-46	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g38716	i0	89.744	14.8857142857143	156	12	87	3	23	175	7051358	7051512	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	2605	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5662364	5662364	PRJNA572587_P_NODE_10205_length_371_cov_30.354037_g9878_i0	PRJNA572587	10205	371	30.354037	112.61347727	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	414	3.91e-111	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g9878	i0	90.252	99.7870619946092	318	29	85	2	3	319	1316737	1316421	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	37021	414	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5662664	5662664	PRJNA572587_P_NODE_27625_length_212_cov_11.932515_g27297_i0	PRJNA572587	27625	212	11.932515	25.2969318	Caulifigura coniformis	2527983	Bacteria	Bacteria	300	6.03e-77	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g27297	i0	96.667	173.882075471698	180	6	85	0	11	190	2925545	2925366	Caulifigura coniformis strain Pan44 chromosome	blastn	36863	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
7513772	7513772	PRJNA572587_P_NODE_16826_length_278_cov_45.995633_g16498_i0	PRJNA572587	16826	278	45.995633	127.86785974	Planctopirus	1649480	Bacteria	Bacteria	342	1.36e-89	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g16498	i0	91.016	121.834532374101	256	19	91	4	3	256	1038	785	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	33870	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
8211617	8211617	PRJNA572587_P_NODE_10007_length_376_cov_2.113150_g9680_i0	PRJNA572587	10007	376	2.11315	7.945444	Fontisphaera persica	2974023	Bacteria	Bacteria	278	5.4300000000000006e-70	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g9680	i0	86.853	64.9601063829787	251	29	66	4	127	376	3863933	3863686	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	24425	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
8211895	8211895	PRJNA572587_P_NODE_24507_length_227_cov_5.146067_g24179_i0	PRJNA572587	24507	227	5.146067	11.68157209	planctomycete str. 140	69477	Bacteria	Bacteria	268	1.84e-67	NTclustered	gi\|12583968\|gb\|AF245372.1\|AF245372	69477	g24179	i0	93.37	11.0044052863436	181	12	80	0	29	209	199	19	Planctomycete str. 140 23S ribosomal RNA gene, partial sequence	blastn	2498	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 140
8212173	8212173	PRJNA572587_P_NODE_5347_length_544_cov_286.056566_g5027_i0	PRJNA572587	5347	544	286.056566	1556.14771904	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	667	0	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g5027	i0	90.173	94.8841911764706	519	41	94	10	1	514	3833087	3833600	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	51617	667	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9487468	9487468	PRJNA572587_P_NODE_44048_length_165_cov_2.784483_g43720_i0	PRJNA572587	44048	165	2.784483	4.59439695	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	169	1.31e-37	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g43720	i0	85.714	50.5515151515152	161	21	97	2	1	160	7631057	7630898	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	8341	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
10763124	10763124	PRJNA572587_P_NODE_20009_length_253_cov_20.696078_g19681_i0	PRJNA572587	20009	253	20.696078	52.36107734	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	243	1.27e-59	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g19681	i0	85.593	10.7628458498024	236	29	92	5	21	252	2480404	2480170	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2723	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14588016	14588016	PRJNA572587_P_NODE_8892_length_403_cov_78.319209_g8565_i0	PRJNA572587	8892	403	78.319209	315.62641227	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	340	7.36e-89	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g8565	i0	87.097	56.6774193548387	310	29	74	5	82	380	3832143	3832452	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	22841	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15861359	15861359	PRJNA572587_P_NODE_16613_length_280_cov_267.956710_g16285_i0	PRJNA572587	16613	280	267.95671	750.278788	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	294	3.88e-75	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g16285	i0	89.7	108.939285714286	233	20	82	4	21	250	3833369	3833600	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	30503	294	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17136300	17136300	PRJNA572587_P_NODE_12654_length_327_cov_23.694245_g12326_i0	PRJNA572587	12654	327	23.694245	77.48018115	Pedosphaera parvula	1032527	Bacteria	Bacteria	411	4.4e-110	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g12326	i0	91.118	233.590214067278	304	25	93	2	22	325	768	1069	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	76384	411	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
17136619	17136619	PRJNA572587_P_NODE_3054_length_749_cov_21.682857_g2797_i0	PRJNA572587	3054	749	21.682857	162.40459893	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	636	1.6299999999999995e-177	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g2797	i0	83.287	69.8651535380507	724	87	96	18	26	746	3083397	3082705	Stratiformator vulcanicus strain Pan189 chromosome	blastn	52329	636	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
18410769	18410769	PRJNA572587_P_NODE_23955_length_230_cov_3.729282_g23627_i0	PRJNA572587	23955	230	3.729282	8.5773486	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	270	5.21e-68	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g23627	i0	90.385	131.295652173913	208	17	90	3	1	206	2665602	2665396	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	30198	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19685369	19685369	PRJNA572587_P_NODE_25976_length_219_cov_120.982353_g25648_i0	PRJNA572587	25976	219	120.982353	264.95135307	Lacipirellula parvula	2650471	Bacteria	Bacteria	344	2.85e-90	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g25648	i0	98.958	29.2739726027397	192	2	88	0	24	215	5164241	5164050	Lacipirellula parvula PX69 DNA, complete genome	blastn	6411	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula

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