metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA670521" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA670521" 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
1164911	1164911	PRJNA670521_P_NODE_36961_length_333_cov_2.073077_g36216_i0	PRJNA670521	36961	333	2.073077	6.90334641	Chlamydiia	204429	Bacteria	Bacteria	292	1.7e-74	NTclustered	gi\|1000729566\|gb\|KT030899.1\|	1345621	g36216	i0	87.795	149.558558558559	254	25	75	6	84	333	1937	1686	Candidatus Similichlamydia labri strain SM160513-33 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	49803	292	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Parilichlamydiaceae	Candidatus Similichlamydia	Candidatus Similichlamydia labri
3188968	3188968	PRJNA670521_P_NODE_2723_length_1064_cov_1.718466_g2205_i0	PRJNA670521	2723	1064	1.718466	18.28447824	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	1478	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2205	i0	91.791	201.417293233083	1072	72	99	15	1	1063	2002345	2003409	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	214308	1478	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6268789	6268789	PRJNA670521_P_NODE_12165_length_518_cov_1.384270_g11430_i0	PRJNA670521	12165	518	1.38427	7.1705186	Isosphaeraceae	1763524	Bacteria	Bacteria	595	1.8699999999999998e-165	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g11430	i0	88.063	145.015444015444	511	50	98	9	11	518	9143435	9143937	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	75118	599	0.993322203672788	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
8291356	8291356	PRJNA670521_P_NODE_37547_length_331_cov_1.922481_g36802_i0	PRJNA670521	37547	331	1.922481	6.36341211	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	440	5.689999999999998e-119	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g36802	i0	91.385	297.247734138973	325	23	98	5	3	325	2001897	2002218	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	98389	440	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10093606	10093606	PRJNA670521_P_NODE_71908_length_250_cov_1.774011_g71163_i0	PRJNA670521	71908	250	1.774011	4.4350275	Akkermansia	239934	Bacteria	Bacteria	331	2.6e-86	NTclustered	gi\|2634178342\|gb\|CP139035.1\|	3040764	g71163	i0	92.308	285.42	234	17	94	1	15	248	789850	790082	Akkermansia sp. N21116 chromosome, complete genome	blastn	71355	331	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp. N21116
10093607	10093607	PRJNA670521_P_NODE_73468_length_250_cov_0.870056_g72723_i0	PRJNA670521	73468	250	0.870056	2.17514	Isosphaeraceae	1763524	Bacteria	Bacteria	329	9.34e-86	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g72723	i0	94.811	356.672	212	10	85	1	1	212	5179190	5179400	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	89168	331	0.993957703927492	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
14667088	14667088	PRJNA670521_P_NODE_31312_length_355_cov_1.014184_g30567_i0	PRJNA670521	31312	355	1.014184	3.6003532	Opitutales bacterium	2026772	Bacteria	Bacteria	241	6.68e-59	NTclustered	gi\|2626245913\|emb\|OY829953.1\|	2026772	g30567	i0	79.444	86.7492957746479	360	58	99	13	1	350	680583	680230	MAG: Opitutales bacterium isolate cf0dc631-26ae-4be7-9546-4b6096dd6533 genome assembly, chromosome: 1	blastn	30796	241	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
16467842	16467842	PRJNA670521_P_NODE_42913_length_315_cov_0.954545_g42168_i0	PRJNA670521	42913	315	0.954545	3.00681675	Parachlamydia	83551	Bacteria	Bacteria	359	1.55e-94	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g42168	i0	90.741	180.536507936508	270	23	85	2	1	269	1971	2239	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	56869	359	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
20291377	20291377	PRJNA670521_P_NODE_74476_length_249_cov_0.875000_g73731_i0	PRJNA670521	74476	249	0.875	2.17875	Pirellulaceae	2691357	Bacteria	Bacteria	355	1.53e-93	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g73731	i0	92.369	173.763052208835	249	19	100	0	1	249	3095525	3095277	Pirellula sp. SH-Sr6A, complete genome	blastn	43267	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
21040686	21040686	PRJNA670521_P_NODE_49917_length_296_cov_1.354260_g49172_i0	PRJNA670521	49917	296	1.35426	4.0086096	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	501	2.27e-137	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g49172	i0	97.288	126.760135135135	295	8	99	0	2	296	3894724	3895018	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	37521	501	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22315552	22315552	PRJNA670521_P_NODE_57618_length_278_cov_1.502439_g56873_i0	PRJNA670521	57618	278	1.502439	4.17678042	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	407	4.74e-109	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g56873	i0	92.933	250.115107913669	283	15	100	3	1	278	2004109	2004391	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	69532	407	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22842451	22842451	PRJNA670521_P_NODE_9918_length_568_cov_1.975758_g9186_i0	PRJNA670521	9918	568	1.975758	11.22230544	Verrucomicrobiota	74201	Bacteria	Bacteria	486	1.3e-132	NTclustered	gi\|297180506\|gb\|GU474845.1\|	710995	g9186	i0	83.271	140.75176056338	538	80	94	9	34	568	1169	1699	Uncultured Verrucomicrobiales bacterium HF0010_05E02 genomic sequence	blastn	79947	488	0.995901639344262	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium HF0010_05E02
23590866	23590866	PRJNA670521_P_NODE_10079_length_564_cov_1.401222_g9347_i0	PRJNA670521	10079	564	1.401222	7.90289208	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1009	0	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g9347	i0	98.938	251.606382978723	565	5	100	1	1	564	3892248	3892812	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	141906	1009	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24864358	24864358	PRJNA670521_P_NODE_62340_length_267_cov_3.381443_g61595_i0	PRJNA670521	62340	267	3.381443	9.02845281	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	311	3.65e-80	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g61595	i0	87.687	173.089887640449	268	31	100	2	1	267	2001633	2001899	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	46215	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;