metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA1218816" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA1218816" 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
333294	333294	PRJNA1218816_P_NODE_38481_length_313_cov_1.208333_g38048_i0	PRJNA1218816	38481	313	1.208333	3.78208229	Adhaeretor mobilis	1930276	Bacteria	Bacteria	292	1.58e-74	NTclustered	gi\|1712449852\|gb\|CP036263.1\|	1930276	g38048	i0	85.512	194.297124600639	283	37	90	4	3	284	3977258	3976979	Adhaeretor mobilis strain HG15A2 chromosome, complete genome	blastn	60815	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
1607972	1607972	PRJNA1218816_P_NODE_25822_length_409_cov_1.752976_g25389_i0	PRJNA1218816	25822	409	1.752976	7.16967184	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	481	4.23e-131	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g25389	i0	88.01	123.095354523227	417	36	99	12	1	406	7052109	7051696	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	50346	481	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4874375	4874375	PRJNA1218816_P_NODE_36424_length_324_cov_1.577689_g35991_i0	PRJNA1218816	36424	324	1.577689	5.11171236	Pirellulaceae	2691357	Bacteria	Bacteria	394	4.39e-105	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g35991	i0	88.58	174.08024691358	324	37	100	0	1	324	2674033	2673710	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	56402	394	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
5436466	5436466	PRJNA1218816_P_NODE_20405_length_485_cov_2.616505_g19972_i0	PRJNA1218816	20405	485	2.616505	12.69004925	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	501	3.91e-137	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g19972	i0	85.253	115.350515463918	495	63	100	8	1	485	7050780	7050286	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	55945	501	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8699295	8699295	PRJNA1218816_P_NODE_53367_length_252_cov_1.329609_g52934_i0	PRJNA1218816	53367	252	1.329609	3.35061468	Planctomycetaceae	126	Bacteria	Bacteria	303	5.71e-78	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g52934	i0	88.538	177.988095238095	253	26	99	3	1	251	1042880	1042629	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	44853	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
9261528	9261528	PRJNA1218816_P_NODE_58228_length_246_cov_0.890173_g57795_i0	PRJNA1218816	58228	246	0.890173	2.18982558	Gemmataceae bacterium	2052164	Bacteria	Bacteria	180	9.77e-41	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g57795	i0	83.673	1.77642276422764	196	26	78	6	54	246	7620165	7619973	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	437	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
9974361	9974361	PRJNA1218816_P_NODE_52588_length_255_cov_1.148352_g52155_i0	PRJNA1218816	52588	255	1.148352	2.9282976	Bacteria	2	Bacteria	Bacteria	322	1.6e-83	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g52155	i0	89.764	152.670588235294	254	22	99	3	1	253	3921429	3921679	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	38931	324	0.993827160493827	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10537162	10537162	PRJNA1218816_P_NODE_33249_length_344_cov_1.136531_g32816_i0	PRJNA1218816	33249	344	1.136531	3.90966664	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	287	8.190000000000001e-73	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g32816	i0	92.118	78.671511627907	203	16	59	0	142	344	2582459	2582661	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	27063	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10537383	10537383	PRJNA1218816_P_NODE_56389_length_248_cov_0.880000_g55956_i0	PRJNA1218816	56389	248	0.88	2.1824	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	159	1.28e-34	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g55956	i0	78.431	36.4072580645161	255	47	100	8	1	248	2749712	2749459	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	9029	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11812234	11812234	PRJNA1218816_P_NODE_59370_length_245_cov_0.895349_g58937_i0	PRJNA1218816	59370	245	0.895349	2.19360505	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	320	5.49e-83	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g58937	i0	90.204	6.28979591836735	245	24	100	0	1	245	5161619	5161863	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1541	320	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
13799624	13799624	PRJNA1218816_P_NODE_41711_length_297_cov_1.629464_g41278_i0	PRJNA1218816	41711	297	1.629464	4.83950808	Planctopirus	1649480	Bacteria	Bacteria	351	2.43e-92	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g41278	i0	88.294	81.1515151515152	299	28	99	5	3	297	1251	1546	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	24102	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
14362509	14362509	PRJNA1218816_P_NODE_53692_length_251_cov_1.297753_g53259_i0	PRJNA1218816	53692	251	1.297753	3.25736003	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	287	5.73e-73	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g53259	i0	87.402	260.06374501992	254	26	100	3	1	251	4469367	4469617	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	65276	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
14362527	14362527	PRJNA1218816_P_NODE_55532_length_249_cov_0.875000_g55099_i0	PRJNA1218816	55532	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	75	4.81e-9	NTclustered	gi\|2621786370\|emb\|OY782828.1\|	2026780	g55099	i0	88.889	2.46184738955823	63	4	24	2	1	60	1647434	1647496	MAG: Planctomycetota bacterium isolate f721c43d-afcc-485d-8b21-b21defd39baa genome assembly, chromosome: 1	blastn	613	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
14362561	14362561	PRJNA1218816_P_NODE_58892_length_245_cov_1.505814_g58459_i0	PRJNA1218816	58892	245	1.505814	3.6892443	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	303	5.53e-78	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g58459	i0	89.069	86.3836734693878	247	23	100	4	1	245	7867896	7867652	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	21164	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14362609	14362609	PRJNA1218816_P_NODE_63112_length_241_cov_0.916667_g62679_i0	PRJNA1218816	63112	241	0.916667	2.20916747	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	411	3.109999999999999e-110	NTclustered	gi\|403081880\|gb\|JX240789.1\|	156588	g62679	i0	97.51	99.8921161825726	241	5	100	1	1	241	1426	1187	Uncultured Verrucomicrobia bacterium clone MLS125 16S ribosomal RNA gene, partial sequence	blastn	24074	411	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
15636506	15636506	PRJNA1218816_P_NODE_61073_length_243_cov_0.905882_g60640_i0	PRJNA1218816	61073	243	0.905882	2.20129326	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	165	2.6999999999999997e-36	NTclustered	gi\|2921913114\|gb\|CP182803.1\|	2026777	g60640	i0	79.435	51.8765432098765	248	39	100	12	1	243	1301295	1301055	MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome	blastn	12606	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
15636551	15636551	PRJNA1218816_P_NODE_8873_length_892_cov_1.905983_g8520_i0	PRJNA1218816	8873	892	1.905983	17.00136836	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	1227	0	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g8520	i0	91.648	410.902466367713	898	58	99	15	4	890	7050838	7051729	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	366525	1227	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18897756	18897756	PRJNA1218816_P_NODE_34095_length_338_cov_1.743396_g33662_i0	PRJNA1218816	34095	338	1.743396	5.89267848	Engelhardtia	139931	Bacteria	Bacteria	257	6.3e-64	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g33662	i0	87.013	83.6686390532544	231	27	67	2	111	338	5248750	5248520	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	28280	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
22010263	22010263	PRJNA1218816_P_NODE_59418_length_245_cov_0.895349_g58985_i0	PRJNA1218816	59418	245	0.895349	2.19360505	Candidatus Syngnamydia medusae	3141954	Bacteria	Bacteria	387	5.34e-103	NTclustered	gi\|1127901232\|emb\|LT599033.1\|	3141954	g58985	i0	95.102	311.473469387755	245	12	100	0	1	245	3048	3292	Uncultured Simkania sp. partial 23S rRNA gene, isolate M1	blastn	76311	387	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia medusae
22010268	22010268	PRJNA1218816_P_NODE_59978_length_244_cov_0.900585_g59545_i0	PRJNA1218816	59978	244	0.900585	2.1974274	Alienimonas californiensis	2527989	Bacteria	Bacteria	183	7.479999999999997e-42	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g59545	i0	82.938	215.110655737705	211	29	86	6	36	244	373630	373425	Alienimonas californiensis strain CA12 chromosome	blastn	52487	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
22723210	22723210	PRJNA1218816_P_NODE_59558_length_245_cov_0.895349_g59125_i0	PRJNA1218816	59558	245	0.895349	2.19360505	Coraliomargarita	442430	Bacteria	Bacteria	191	4.49e-44	NTclustered	gi\|470486190\|ref\|NR_076741.1\|	395922	g59125	i0	81.048	166.216326530612	248	40	100	6	1	245	1714	1471	Coraliomargarita akajimensis strain 04OKA010-24 23S ribosomal RNA gene, complete sequence	blastn	40723	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita akajimensis
23285747	23285747	PRJNA1218816_P_NODE_55539_length_249_cov_0.875000_g55106_i0	PRJNA1218816	55539	249	0.875	2.17875	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	350	7.14e-92	NTclustered	gi\|2738637493\|gb\|PP859054.1\|	464461	g55106	i0	92.032	103.698795180723	251	16	100	4	1	249	285	37	Uncultured Parachlamydiaceae bacterium clone AS-Z4G7 16S ribosomal RNA gene, partial sequence	blastn	25821	350	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
25272424	25272424	PRJNA1218816_P_NODE_23720_length_435_cov_1.273481_g23287_i0	PRJNA1218816	23720	435	1.273481	5.53964235	Planctomycetaceae	126	Bacteria	Bacteria	560	5.65e-155	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g23287	i0	89.931	156.418390804598	437	40	100	4	1	435	1057	623	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	68042	560	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639

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