metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA630877" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA630877" 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
603073	603073	PRJNA630877_S_NODE_131761_length_175_cov_3.201493_g112624_i0	PRJNA630877	131761	175	3.201493	5.60261275	Pedosphaera parvula	1032527	Bacteria	Bacteria	230	6.349999999999998e-56	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g112624	i0	90.341	97.9428571428571	176	15	100	2	1	175	1509	1683	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	17140	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
1151757	1151757	PRJNA630877_S_NODE_76201_length_313_cov_3.617647_g57064_i0	PRJNA630877	76201	313	3.617647	11.32323511	Bacteria	2	Bacteria	Bacteria	444	4.13e-120	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g57064	i0	92.308	153.702875399361	312	24	99	0	1	312	3831045	3830734	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	48109	444	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2427005	2427005	PRJNA630877_S_NODE_88042_length_262_cov_1.429864_g68905_i0	PRJNA630877	88042	262	1.429864	3.74624368	Bremerella	2714594	Bacteria	Bacteria	60.2	1.43e-4	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g68905	i0	97.143	0.267175572519084	35	1	13	0	172	206	2032779	2032745	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	70	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
5706726	5706726	PRJNA630877_S_NODE_159765_length_150_cov_1.990826_g140628_i0	PRJNA630877	159765	150	1.990826	2.986239	Pedosphaera parvula	1032527	Bacteria	Bacteria	213	5.3e-51	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g140628	i0	92.105	107.373333333333	152	10	100	2	1	150	1868	1717	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	16106	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
8256278	8256278	PRJNA630877_S_NODE_64327_length_397_cov_2.176966_g45195_i0	PRJNA630877	64327	397	2.176966	8.64255502	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	381	4.269999999999999e-101	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g45195	i0	91.429	85.3098236775819	280	20	70	4	1	277	2002730	2003008	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	33868	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10080216	10080216	PRJNA630877_S_NODE_67948_length_367_cov_2.230061_g48811_i0	PRJNA630877	67948	367	2.230061	8.18432387	Limnoglobus	2731450	Bacteria	Bacteria	446	1.3699999999999999e-120	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g48811	i0	89.167	186.264305177112	360	36	98	3	1	358	2002291	2002649	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	68359	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10807301	10807301	PRJNA630877_S_NODE_142649_length_164_cov_2.861789_g123512_i0	PRJNA630877	142649	164	2.861789	4.69333396	Urbifossiella limnaea	2528023	Bacteria	Bacteria	248	1.63e-61	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g123512	i0	93.902	164.69512195122	164	10	100	0	1	164	2019281	2019118	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	27010	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
12082566	12082566	PRJNA630877_S_NODE_45010_length_660_cov_13.894992_g27208_i0	PRJNA630877	45010	660	13.894992	91.7069472	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1208	0	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g27208	i0	99.697	105.922727272727	660	2	100	0	1	660	736430	737089	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	69909	1208	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13905674	13905674	PRJNA630877_S_NODE_107291_length_211_cov_2.505882_g88154_i0	PRJNA630877	107291	211	2.505882	5.28741102	Limnoglobus	2731450	Bacteria	Bacteria	313	7.7e-81	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g88154	i0	93.365	211.047393364929	211	14	100	0	1	211	3456689	3456479	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	44531	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
17729609	17729609	PRJNA630877_S_NODE_141854_length_165_cov_1.774194_g122717_i0	PRJNA630877	141854	165	1.774194	2.9274201	Gemmataceae	1914233	Bacteria	Bacteria	263	5.86e-66	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g122717	i0	97.403	113.866666666667	154	4	93	0	1	154	1837	1990	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	18788	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
19729746	19729746	PRJNA630877_S_NODE_78316_length_302_cov_6.720307_g59179_i0	PRJNA630877	78316	302	6.720307	20.29532714	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	475	1.4099999999999997e-129	NTclustered	gi\|389545847\|gb\|JQ400775.1\|	156588	g59179	i0	95.05	102.506622516556	303	13	100	2	1	302	330	29	Uncultured Verrucomicrobia bacterium clone CNY_00669 16S ribosomal RNA gene, partial sequence	blastn	30957	475	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
21005521	21005521	PRJNA630877_S_NODE_53477_length_517_cov_9.060924_g34601_i0	PRJNA630877	53477	517	9.060924	46.84497708	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	845	0	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g34601	i0	96.132	171.810444874275	517	20	100	0	1	517	737542	737026	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	88826	845	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21005527	21005527	PRJNA630877_S_NODE_84237_length_276_cov_1.680851_g65100_i0	PRJNA630877	84237	276	1.680851	4.63914876	Urbifossiella limnaea	2528023	Bacteria	Bacteria	342	1.3399999999999999e-89	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g65100	i0	88.968	60.5978260869565	281	26	100	3	1	276	2020028	2020308	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	16725	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
21553691	21553691	PRJNA630877_S_NODE_140857_length_166_cov_1.680000_g121720_i0	PRJNA630877	140857	166	1.68	2.7888	Gemmata	113	Bacteria	Bacteria	305	9.67e-79	NTclustered	gi\|307591227\|gb\|GQ889438.1\|	886811	g121720	i0	100	98.3975903614458	165	0	99	0	2	166	583	747	Gemmata sp. Io3-3 16S ribosomal RNA gene, partial sequence	blastn	16334	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. Io3-3
22280229	22280229	PRJNA630877_S_NODE_13918_length_1840_cov_7.908838_g7582_i0	PRJNA630877	13918	1840	7.908838	145.5226192	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	1947	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g7582	i0	85.961	191.945108695652	1852	224	100	31	1	1840	26740	28567	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	353179	1947	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22280230	22280230	PRJNA630877_S_NODE_148558_length_159_cov_1.864407_g129421_i0	PRJNA630877	148558	159	1.864407	2.96440713	Gemmataceae bacterium	2052164	Bacteria	Bacteria	122	9.889999999999999e-24	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g129421	i0	80.864	51.3207547169811	162	25	100	6	1	159	320222	320380	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	8160	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
22280233	22280233	PRJNA630877_S_NODE_44918_length_662_cov_13.652174_g27139_i0	PRJNA630877	44918	662	13.652174	90.37739188	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	948	0	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g27139	i0	92.62	105.519637462236	664	41	99	8	1	660	736430	737089	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	69854	948	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22280246	22280246	PRJNA630877_S_NODE_98758_length_230_cov_1.873016_g79621_i0	PRJNA630877	98758	230	1.873016	4.3079368	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g79621	i0	92.308	1.26086956521739	39	2	17	1	147	185	1050321	1050284	Luteolibacter sp. LG18 DNA, complete genome	blastn	290	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
22829183	22829183	PRJNA630877_S_NODE_124398_length_184_cov_1.846154_g105261_i0	PRJNA630877	124398	184	1.846154	3.39692336	Limnoglobus	2731450	Bacteria	Bacteria	207	3.16e-49	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g105261	i0	87.097	139.652173913043	186	20	100	3	1	184	2002300	2002117	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	25696	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24829372	24829372	PRJNA630877_S_NODE_116540_length_195_cov_1.707792_g97403_i0	PRJNA630877	116540	195	1.707792	3.3301944	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	243	9.32e-60	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g97403	i0	89.34	83.425641025641	197	16	100	5	1	195	3833222	3833415	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	16268	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24829381	24829381	PRJNA630877_S_NODE_37100_length_839_cov_3.810777_g21304_i0	PRJNA630877	37100	839	3.810777	31.97241903	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1066	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g21304	i0	89.94	131.07747318236	835	73	99	8	11	839	1316393	1315564	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	109974	1066	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;