metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA846486" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA846486" 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
833252	833252	PRJNA846486_P_NODE_29881_length_241_cov_11.135417_g29785_i0	PRJNA846486	29881	241	11.135417	26.83635497	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	217	7.269999999999999e-52	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g29785	i0	83.128	432.394190871369	243	35	100	6	1	241	2364133	2364371	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	104207	217	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
2506937	2506937	PRJNA846486_P_NODE_70402_length_174_cov_1.248000_g70306_i0	PRJNA846486	70402	174	1.248	2.17152	Opitutus	178440	Bacteria	Bacteria	145	2.35e-30	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g70306	i0	82.249	7.66091954022988	169	29	97	1	1	168	1371	1203	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	1333	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
5936471	5936471	PRJNA846486_P_NODE_58405_length_187_cov_1.130435_g58309_i0	PRJNA846486	58405	187	1.130435	2.11391345	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	111	2.6e-20	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g58309	i0	83.471	1.62032085561497	121	18	64	2	1	120	300727	300846	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	303	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7211476	7211476	PRJNA846486_P_NODE_81806_length_167_cov_0.881356_g81710_i0	PRJNA846486	81806	167	0.881356	1.47186452	Limnoglobus roseus	2598579	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g81710	i0	100	0.173652694610778	29	0	17	0	5	33	11497	11525	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
19959785	19959785	PRJNA846486_P_NODE_92296_length_162_cov_1.831858_g92200_i0	PRJNA846486	92296	162	1.831858	2.96760996	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	76.8	8e-10	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g92200	i0	80.392	0.62962962962963	102	18	62	2	52	152	6103107	6103007	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	102	76.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08

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