metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA690124" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA690124" 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
669440	669440	PRJNA690124_P_NODE_40981_length_259_cov_3.467742_g40615_i0	PRJNA690124	40981	259	3.467742	8.98145178	Urbifossiella limnaea	2528023	Bacteria	Bacteria	283	7.679999999999999e-72	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g40615	i0	87.059	36.3938223938224	255	27	97	6	3	253	2020311	2020059	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	9426	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
669717	669717	PRJNA690124_P_NODE_53281_length_244_cov_0.912281_g52915_i0	PRJNA690124	53281	244	0.912281	2.22596564	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	134	7.640000000000001e-27	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g52915	i0	83.333	0.979508196721312	150	20	60	5	99	244	908301	908153	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	239	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
1945371	1945371	PRJNA690124_P_NODE_36462_length_275_cov_1.930693_g36096_i0	PRJNA690124	36462	275	1.930693	5.30940575	planctomycete str. 139	149588	Bacteria	Bacteria	374	4.7499999999999996e-99	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g36096	i0	91.071	147.865454545455	280	19	100	4	1	275	935	657	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	40663	374	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
3219950	3219950	PRJNA690124_P_NODE_25163_length_327_cov_1.692913_g24797_i0	PRJNA690124	25163	327	1.692913	5.53582551	Candidatus Piscichlamydia sp.	1977145	Bacteria	Bacteria	516	9.07e-142	NTclustered	gi\|1175896721\|gb\|KY380088.1\|	1977145	g24797	i0	95.137	88.8012232415902	329	12	100	3	1	327	680	354	Candidatus Piscichlamydia sp. strain EP 16S ribosomal RNA gene, partial sequence	blastn	29038	516	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Piscichlamydiaceae	Candidatus Piscichlamydia	Candidatus Piscichlamydia sp.
3220423	3220423	PRJNA690124_P_NODE_46483_length_250_cov_0.881356_g46117_i0	PRJNA690124	46483	250	0.881356	2.20339	Candidatus Piscichlamydia cyprini	1233676	Bacteria	Bacteria	355	1.54e-93	NTclustered	gi\|406857609\|gb\|JX470313.1\|	1233676	g46117	i0	92.43	100.044	251	16	100	3	1	250	17	265	Candidatus Piscichlamydia cyprinis isolate E4 16S ribosomal RNA gene, partial sequence	blastn	25011	355	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Piscichlamydiaceae	Candidatus Piscichlamydia	Candidatus Piscichlamydia cyprini
4497095	4497095	PRJNA690124_P_NODE_24204_length_333_cov_1.500000_g23838_i0	PRJNA690124	24204	333	1.5	4.995	Gimesia chilikensis	2605989	Bacteria	Bacteria	303	7.85e-78	NTclustered	gi\|1712562588\|gb\|CP036347.1\|	2605989	g23838	i0	84.466	87.1141141141141	309	46	93	2	12	320	2182358	2182664	Gimesia chilikensis strain V6 chromosome	blastn	29009	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia chilikensis
7048074	7048074	PRJNA690124_P_NODE_42906_length_253_cov_1.611111_g42540_i0	PRJNA690124	42906	253	1.611111	4.07611083	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	339	1.57e-88	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g42540	i0	90.945	133.25296442687701	254	19	100	3	1	253	1831194	1830944	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	33713	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
7048383	7048383	PRJNA690124_P_NODE_56006_length_242_cov_0.923077_g55640_i0	PRJNA690124	56006	242	0.923077	2.23384634	Stieleria magnilauensis	2527963	Bacteria	Bacteria	244	3.3499999999999997e-60	NTclustered	gi\|1712780605\|gb\|CP036432.1\|	2527963	g55640	i0	90	419.338842975207	190	17	78	2	25	213	3122755	3122567	Planctomycetes bacterium TBK1r chromosome	blastn	101480	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis
8322672	8322672	PRJNA690124_P_NODE_46447_length_250_cov_0.881356_g46081_i0	PRJNA690124	46447	250	0.881356	2.20339	Gemmataceae bacterium	2052164	Bacteria	Bacteria	161	3.61e-35	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g46081	i0	88.148	3	135	16	54	0	1	135	5186212	5186078	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	750	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
8831529	8831529	PRJNA690124_P_NODE_41207_length_259_cov_1.166667_g40841_i0	PRJNA690124	41207	259	1.166667	3.02166753	Humisphaera	2807511	Bacteria	Bacteria	289	1.65e-73	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g40841	i0	87.072	95.6640926640927	263	25	100	6	1	259	5064282	5064539	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	24777	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
9597935	9597935	PRJNA690124_P_NODE_40108_length_262_cov_2.227513_g39742_i0	PRJNA690124	40108	262	2.227513	5.83608406	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2621784474\|emb\|OY780932.1\|	2026780	g39742	i0	100	0.106870229007634	28	0	11	0	15	42	249191	249164	MAG: Planctomycetota bacterium isolate 8948a4fa-d588-4077-bf9d-2cdc62be6801 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
9598063	9598063	PRJNA690124_P_NODE_45988_length_251_cov_0.876404_g45622_i0	PRJNA690124	45988	251	0.876404	2.19977404	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	379	9.189999999999998e-101	NTclustered	gi\|2108353487\|gb\|CP070655.1\|	2035772	g45622	i0	94.332	5.0796812749004	247	14	98	0	1	247	390193	390439	MAG: Candidatus Omnitrophota bacterium isolate bin81 chromosome	blastn	1275	379	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
9598380	9598380	PRJNA690124_P_NODE_9248_length_528_cov_2.127473_g8883_i0	PRJNA690124	9248	528	2.127473	11.23305744	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	623	8.749999999999999e-174	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g8883	i0	87.985	148.619318181818	541	48	100	12	1	528	5936086	5936622	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	78471	623	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10107362	10107362	PRJNA690124_P_NODE_50608_length_246_cov_3.890173_g50242_i0	PRJNA690124	50608	246	3.890173	9.56982558	Planctomycetia	203683	Bacteria	Bacteria	361	3.25e-95	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g50242	i0	93.117	46.4268292682927	247	15	99	1	2	246	4318076	4317830	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	11421	361	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
12149082	12149082	PRJNA690124_P_NODE_5810_length_661_cov_1.302721_g5456_i0	PRJNA690124	5810	661	1.302721	8.61098581	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	760	0	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g5456	i0	88.995	110.332829046899	627	52	94	14	20	638	2503294	2502677	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	72930	760	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
18521067	18521067	PRJNA690124_P_NODE_21715_length_349_cov_2.199275_g21349_i0	PRJNA690124	21715	349	2.199275	7.67546975	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	420	7.84e-113	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g21349	i0	88.696	153.593123209169	345	37	99	2	6	349	4957774	4957431	Planctomyces sp. SH-PL14, complete genome	blastn	53604	420	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
18521145	18521145	PRJNA690124_P_NODE_25795_length_324_cov_0.864542_g25429_i0	PRJNA690124	25795	324	0.864542	2.80111608	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	433	9.299999999999999e-117	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g25429	i0	90.769	140.583333333333	325	28	100	2	1	324	1157171	1156848	Planctomyces sp. SH-PL62, complete genome	blastn	45549	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19795780	19795780	PRJNA690124_P_NODE_14016_length_430_cov_1.596639_g13651_i0	PRJNA690124	14016	430	1.596639	6.8655477	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	651	0	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g13651	i0	93.953	140.039534883721	430	26	100	0	1	430	1831806	1831377	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	60217	651	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
19795830	19795830	PRJNA690124_P_NODE_16856_length_394_cov_1.457944_g16490_i0	PRJNA690124	16856	394	1.457944	5.74429936	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	555	2.3599999999999993e-153	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g16490	i0	92.526	118.322335025381	388	28	98	1	8	394	1832228	1831841	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	46619	555	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
19796173	19796173	PRJNA690124_P_NODE_33196_length_288_cov_1.232558_g32830_i0	PRJNA690124	33196	288	1.232558	3.54976704	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	516	7.86e-142	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g32830	i0	98.958	169.302083333333	288	3	100	0	1	288	819	532	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	48759	516	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22346753	22346753	PRJNA690124_P_NODE_40258_length_262_cov_1.238095_g39892_i0	PRJNA690124	40258	262	1.238095	3.2438089	Paludisphaera borealis	1387353	Bacteria	Bacteria	396	9.589999999999997e-106	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g39892	i0	93.939	135.435114503817	264	12	100	4	1	262	122932	123193	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	35484	396	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
24895816	24895816	PRJNA690124_P_NODE_48620_length_248_cov_0.891429_g48254_i0	PRJNA690124	48620	248	0.891429	2.21074392	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	176	1.28e-39	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g48254	i0	81.991	3.35887096774194	211	34	84	4	1	209	3118673	3118465	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	833	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis

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