metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA744060" 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
1999223	1999223	PRJNA744060_P_NODE_26882_length_314_cov_1.937759_g26553_i0	PRJNA744060	26882	314	1.937759	6.08456326	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	62.1	4.88e-5	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g26553	i0	92.857	0.133757961783439	42	3	13	0	241	282	4348239	4348280	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	42	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
1999618	1999618	PRJNA744060_P_NODE_52362_length_237_cov_2.853659_g52033_i0	PRJNA744060	52362	237	2.853659	6.76317183	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	422	1.41e-113	NTclustered	gi\|389545368\|gb\|JQ400296.1\|	156588	g52033	i0	99.567	97.915611814346	231	1	97	0	7	237	91	321	Uncultured Verrucomicrobia bacterium clone CNY_00102 16S ribosomal RNA gene, partial sequence	blastn	23206	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
3274950	3274950	PRJNA744060_P_NODE_51283_length_242_cov_0.923077_g50954_i0	PRJNA744060	51283	242	0.923077	2.23384634	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	440	3.9799999999999986e-119	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g50954	i0	99.587	1	242	0	100	1	1	242	2392000	2391760	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	242	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
4551589	4551589	PRJNA744060_P_NODE_1904_length_1081_cov_2.085317_g1700_i0	PRJNA744060	1904	1081	2.085317	22.54227677	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1472	0	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g1700	i0	91.236	127.072155411656	1084	91	100	4	1	1081	4421793	4422875	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	137365	1472	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
5826669	5826669	PRJNA744060_P_NODE_21525_length_349_cov_1.130435_g21196_i0	PRJNA744060	21525	349	1.130435	3.94521815	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	645	1.1899999999999993e-180	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g21196	i0	100	1	349	0	100	0	1	349	639430	639778	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	349	645	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
7101790	7101790	PRJNA744060_P_NODE_21126_length_352_cov_1.670251_g20797_i0	PRJNA744060	21126	352	1.670251	5.87928352	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	651	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g20797	i0	100	1	352	0	100	0	1	352	1147869	1147518	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	352	651	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
7101875	7101875	PRJNA744060_P_NODE_25166_length_324_cov_1.243028_g24837_i0	PRJNA744060	25166	324	1.243028	4.02741072	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g24837	i0	100	16.4043209876543	324	0	100	0	1	324	2024393	2024716	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	5315	599	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
9651494	9651494	PRJNA744060_P_NODE_17088_length_389_cov_3.022152_g16759_i0	PRJNA744060	17088	389	3.022152	11.75617128	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g16759	i0	96.774	0.0796915167095116	31	1	8	0	342	372	3097683	3097713	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	31	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
13477273	13477273	PRJNA744060_P_NODE_41451_length_259_cov_1.559140_g41122_i0	PRJNA744060	41451	259	1.55914	4.0381726	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g41122	i0	100	1.93436293436293	259	0	100	0	1	259	386592	386850	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	501	479	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
16025926	16025926	PRJNA744060_P_NODE_32973_length_286_cov_2.793427_g32644_i0	PRJNA744060	32973	286	2.793427	7.98920122	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	407	4.9e-109	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g32644	i0	92.334	143.076923076923	287	20	100	2	1	286	2620676	2620961	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	40920	407	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17301521	17301521	PRJNA744060_P_NODE_3814_length_800_cov_3.735901_g3532_i0	PRJNA744060	3814	800	3.735901	29.887208	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	918	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g3532	i0	87.863	92.565	791	84	98	10	1	782	1866224	1867011	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	74052	918	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
17776232	17776232	PRJNA744060_P_NODE_20754_length_355_cov_1.641844_g20425_i0	PRJNA744060	20754	355	1.641844	5.8285462	root	1	Root_unresolved	Root_unresolved	75	7.17e-9	NTclustered	gi\|1712520392\|gb\|CP036316.1\|	2528027	g20425	i0	86.111	3.10985915492958	72	7	20	2	178	249	4595780	4595712	Calycomorphotria hydatis strain V22 chromosome	blastn	1104	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Calycomorphotria	Calycomorphotria hydatis
18574821	18574821	PRJNA744060_P_NODE_20975_length_353_cov_2.085714_g20646_i0	PRJNA744060	20975	353	2.085714	7.36257042	Planctomycetes bacterium syqfu	2896527	Bacteria	Bacteria	180	1.47e-40	NTclustered	gi\|2155219436\|gb\|CP087563.1\|	2896527	g20646	i0	81.057	25.7252124645892	227	41	64	2	60	285	422844	422619	Planctomycetes bacterium syqfu chromosome, complete genome	blastn	9081	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium syqfu
19850526	19850526	PRJNA744060_P_NODE_44016_length_253_cov_0.866667_g43687_i0	PRJNA744060	44016	253	0.866667	2.19266751	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g43687	i0	100	1	253	0	100	0	1	253	1863055	1863307	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	253	468	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
19850662	19850662	PRJNA744060_P_NODE_53276_length_232_cov_2.893082_g52947_i0	PRJNA744060	53276	232	2.893082	6.71195024	Phycisphaerae bacterium RAS2	2528035	Bacteria	Bacteria	137	5.569999999999999e-28	NTclustered	gi\|1712788464\|gb\|CP036352.1\|	2528035	g52947	i0	81.437	9.22413793103448	167	31	72	0	5	171	3619968	3619802	Phycisphaerae bacterium RAS2 chromosome, complete genome	blastn	2140	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium RAS2
21125529	21125529	PRJNA744060_P_NODE_14877_length_416_cov_3.545190_g14548_i0	PRJNA744060	14877	416	3.54519	14.7479904	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	545	1.5099999999999996e-150	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g14548	i0	90.361	513.165865384615	415	40	99	0	1	415	192371	192785	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	213477	545	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22400531	22400531	PRJNA744060_P_NODE_19538_length_365_cov_2.493151_g19209_i0	PRJNA744060	19538	365	2.493151	9.10000115	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	538	2.1799999999999998e-148	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g19209	i0	93.048	130.78904109589	374	17	100	6	1	365	2582131	2581758	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	47738	538	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23676103	23676103	PRJNA744060_P_NODE_20279_length_359_cov_1.461538_g19950_i0	PRJNA744060	20279	359	1.461538	5.24692142	Actomonas aquatica	2866162	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g19950	i0	100	0.0779944289693593	28	0	8	0	245	272	6060374	6060401	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
23676574	23676574	PRJNA744060_P_NODE_47539_length_247_cov_1.729885_g47210_i0	PRJNA744060	47539	247	1.729885	4.27281595	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g47210	i0	100	1	247	0	100	0	1	247	1655820	1655574	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	247	457	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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