metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA859990" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA859990" 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
845790	845790	PRJNA859990_S_NODE_12421_length_293_cov_0.954545_g12160_i0	PRJNA859990	12421	293	0.954545	2.79681685	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	422	1.7999999999999996e-113	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g12160	i0	95.131	132.286689419795	267	13	91	0	27	293	7052359	7052625	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	38760	422	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7224070	7224070	PRJNA859990_S_NODE_18106_length_250_cov_1.502825_g17845_i0	PRJNA859990	18106	250	1.502825	3.7570625	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	346	9.269999999999999e-91	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g17845	i0	91.667	126.276	252	18	100	3	1	250	3454599	3454349	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	31569	346	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
9773897	9773897	PRJNA859990_S_NODE_15488_length_266_cov_1.559585_g15227_i0	PRJNA859990	15488	266	1.559585	4.1484961	Tuwongella immobilis	692036	Bacteria	Bacteria	481	2.62e-131	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g15227	i0	99.248	50.8195488721804	266	2	100	0	1	266	2737478	2737213	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	13518	481	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
9773927	9773927	PRJNA859990_S_NODE_17748_length_251_cov_1.556180_g17487_i0	PRJNA859990	17748	251	1.55618	3.9060118	Tuwongella immobilis	692036	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g17487	i0	100	112.286852589641	251	0	100	0	1	251	2737985	2737735	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	28184	464	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
18697145	18697145	PRJNA859990_S_NODE_10135_length_319_cov_0.991870_g9874_i0	PRJNA859990	10135	319	0.99187	3.1640653	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	383	9.34e-102	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g9874	i0	91.727	102.648902821317	278	20	87	3	1	276	4959709	4959985	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	32745	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
22522529	22522529	PRJNA859990_S_NODE_10358_length_316_cov_1.111111_g10097_i0	PRJNA859990	10358	316	1.111111	3.51111076	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	398	3.3e-106	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g10097	i0	89.655	76.0981012658228	319	24	99	9	1	314	2272067	2271753	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	24047	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
25072141	25072141	PRJNA859990_S_NODE_7600_length_362_cov_0.871972_g7339_i0	PRJNA859990	7600	362	0.871972	3.15653864	Tuwongella immobilis	692036	Bacteria	Bacteria	641	1.5999999999999993e-179	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g7339	i0	98.619	102.325966850829	362	5	100	0	1	362	2740123	2739762	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	37042	641	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis

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