metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA851399" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA851399" 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
4667596	4667596	PRJNA851399_P_NODE_14464_length_198_cov_1.369128_g14011_i0	PRJNA851399	14464	198	1.369128	2.71087344	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	259	9.42e-65	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g14011	i0	94.611	282.323232323232	167	9	84	0	1	167	17720	17554	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	55900	259	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9767226	9767226	PRJNA851399_P_NODE_16148_length_188_cov_2.287770_g15695_i0	PRJNA851399	16148	188	2.28777	4.3010076	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	281	1.89e-71	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g15695	i0	93.617	130.218085106383	188	12	100	0	1	188	28335	28148	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	24481	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
11042882	11042882	PRJNA851399_P_NODE_17689_length_184_cov_1.125926_g17236_i0	PRJNA851399	17689	184	1.125926	2.07170384	Urbifossiella limnaea	2528023	Bacteria	Bacteria	121	4.24e-23	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g17236	i0	79.444	7.58695652173913	180	29	96	7	1	176	3839205	3839380	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1396	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11437878	11437878	PRJNA851399_P_NODE_9409_length_262_cov_1.098592_g8956_i0	PRJNA851399	9409	262	1.098592	2.87831104	Gemmata	113	Bacteria	Bacteria	364	2.7e-96	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g8956	i0	91.698	145.87786259542	265	19	100	2	1	262	559795	560059	Gemmata sp. SH-PL17, complete genome	blastn	38220	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
14867349	14867349	PRJNA851399_P_NODE_28692_length_166_cov_0.871795_g28239_i0	PRJNA851399	28692	166	0.871795	1.4471797	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	171	3.68e-38	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g28239	i0	85.89	2.6144578313253	163	20	98	3	5	166	1317177	1317017	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	434	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15261917	15261917	PRJNA851399_P_NODE_22992_length_171_cov_1.254098_g22539_i0	PRJNA851399	22992	171	1.254098	2.14450758	Schlesneria	656899	Bacteria	Bacteria	187	3.76e-43	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g22539	i0	86.364	18.0116959064327	176	18	100	4	1	171	1264	1090	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	3080	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
16536421	16536421	PRJNA851399_P_NODE_12593_length_215_cov_0.921687_g12140_i0	PRJNA851399	12593	215	0.921687	1.98162705	Chthoniobacter	295577	Bacteria	Bacteria	303	4.74e-78	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g12140	i0	92.857	237.251162790698	210	14	98	1	1	210	16357	16565	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	51009	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18690607	18690607	PRJNA851399_P_NODE_24055_length_169_cov_1.125000_g23602_i0	PRJNA851399	24055	169	1.125	1.90125	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	252	1.3e-62	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g23602	i0	93.491	112.011834319527	169	11	100	0	1	169	4421391	4421559	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	18930	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
21241535	21241535	PRJNA851399_P_NODE_36017_length_163_cov_0.894737_g35564_i0	PRJNA851399	36017	163	0.894737	1.45842131	Lacipirellula parvula	2650471	Bacteria	Bacteria	241	2.7000000000000008e-59	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g35564	i0	93.252	1	163	11	100	0	1	163	3416837	3416999	Lacipirellula parvula PX69 DNA, complete genome	blastn	163	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
23791479	23791479	PRJNA851399_P_NODE_21359_length_174_cov_1.648000_g20906_i0	PRJNA851399	21359	174	1.648	2.86752	Urbifossiella limnaea	2528023	Bacteria	Bacteria	244	2.25e-60	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g20906	i0	91.954	161.540229885057	174	14	100	0	1	174	2018239	2018412	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	28108	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
24185661	24185661	PRJNA851399_P_NODE_879_length_1198_cov_2.429939_g719_i0	PRJNA851399	879	1198	2.429939	29.11066922	Verrucomicrobiota	74201	Bacteria	Bacteria	1057	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g719	i0	88.623	131.860601001669	879	87	88	11	44	915	1452	580	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	157969	1057	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
25460491	25460491	PRJNA851399_P_NODE_12580_length_215_cov_1.228916_g12127_i0	PRJNA851399	12580	215	1.228916	2.6421694	Schlesneria	656899	Bacteria	Bacteria	359	9.969999999999999e-95	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g12127	i0	96.744	122.423255813953	215	7	100	0	1	215	2177	2391	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	26321	359	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);;