metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1144090" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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
287881	287881	PRJNA1144090_P_NODE_96281_length_255_cov_1.686813_g95746_i0	PRJNA1144090	96281	255	1.686813	4.30137315	Gimesia benthica	2608982	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1779265081\|gb\|CP043930.1\|	2608982	g95746	i0	100	0.109803921568627	28	0	11	0	15	42	5621148	5621121	Gimesia benthica strain E7 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia benthica
4114501	4114501	PRJNA1144090_P_NODE_61004_length_325_cov_1.507937_g60469_i0	PRJNA1144090	61004	325	1.507937	4.90079525	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	387	7.37e-103	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g60469	i0	88.182	176.289230769231	330	32	100	7	1	325	2169111	2168784	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	57294	387	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8686196	8686196	PRJNA1144090_P_NODE_92247_length_261_cov_1.638298_g91712_i0	PRJNA1144090	92247	261	1.638298	4.27595778	Verrucomicrobiota	74201	Bacteria	Bacteria	416	7.329999999999999e-112	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g91712	i0	95.402	42.3486590038314	261	12	100	0	1	261	5153121	5152861	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	11053	416	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13786351	13786351	PRJNA1144090_P_NODE_42371_length_395_cov_2.838509_g41836_i0	PRJNA1144090	42371	395	2.838509	11.21211055	Engelhardtia	139931	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g41836	i0	94.286	0.177215189873418	35	1	9	1	78	111	2862071	2862037	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	70	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
14315866	14315866	PRJNA1144090_P_NODE_114812_length_242_cov_0.911243_g114277_i0	PRJNA1144090	114812	242	0.911243	2.20520806	Urbifossiella limnaea	2528023	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g114277	i0	100	0.115702479338843	28	0	12	0	130	157	5292034	5292061	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20688334	20688334	PRJNA1144090_P_NODE_109757_length_245_cov_0.895349_g109222_i0	PRJNA1144090	109757	245	0.895349	2.19360505	Gemmataceae bacterium	2052164	Bacteria	Bacteria	58.4	4.75e-4	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g109222	i0	97.059	0.138775510204082	34	1	14	0	178	211	1646108	1646075	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	34	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
20689203	20689203	PRJNA1144090_P_NODE_82497_length_277_cov_1.882353_g81962_i0	PRJNA1144090	82497	277	1.882353	5.21411781	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	412	1.0099999999999997e-110	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g81962	i0	93.571	163.158844765343	280	12	99	5	2	277	1726856	1727133	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	45195	412	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21963672	21963672	PRJNA1144090_P_NODE_111678_length_243_cov_3.741176_g111143_i0	PRJNA1144090	111678	243	3.741176	9.09105768	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	363	8.909999999999999e-96	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g111143	i0	94.828	126.604938271605	232	12	95	0	11	242	5152287	5152518	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	30765	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21964337	21964337	PRJNA1144090_P_NODE_67298_length_308_cov_4.582979_g66763_i0	PRJNA1144090	67298	308	4.582979	14.11557532	Gemmata massiliana	1210884	Bacteria	Bacteria	60.2	1.72e-4	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g66763	i0	100	0.194805194805195	32	0	10	0	131	162	1771805	1771836	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	60	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana

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