metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB82358" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB82358" 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_species
26907729	26907729	PRJEB82358_P_NODE_15902_length_256_cov_3.420765_g15891_i0	PRJEB82358	15902	256	3.420765	8.7571584	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0178	NR	MBN2490516.1	2026780	g15891	i0	44.9	0.57421875	49	27	57.4	0	202	56	382	430	MBN2490516.1 tetratricopeptide repeat protein [Planctomycetota bacterium]	diamond	147	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
28708244	28708244	PRJEB82358_P_NODE_18587_length_242_cov_1.568047_g18576_i0	PRJEB82358	18587	242	1.568047	3.79467374	Planctomycetia bacterium	2052181	Bacteria	Bacteria	100	1.2999999999999998e-24	NR	MCI0699697.1	2052181	g18576	i0	74.6	1.56198347107438	63	16	78.1	0	52	240	1	63	MCI0699697.1 hypothetical protein [Planctomycetia bacterium]	diamond	378	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Planctomycetia bacterium
29181896	29181896	PRJEB82358_P_NODE_22589_length_209_cov_6.977941_g22578_i0	PRJEB82358	22589	209	6.977941	14.58389669	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	75.5	4.54e-14	NR	MFQ5463896.1	2026778	g22578	i0	56.1	3.81818181818182	66	29	94.7	0	2	199	191	256	MFQ5463896.1 tyrosine-type recombinase/integrase [Phycisphaerae bacterium]	diamond	798	75.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae			Phycisphaerae bacterium
29465481	29465481	PRJEB82358_P_NODE_16910_length_250_cov_0.870056_g16899_i0	PRJEB82358	16910	250	0.870056	2.17514	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0499	NR	MBI4024351.1	2026799	g16899	i0	35.2	0.852	71	35	82.8	3	214	8	118	179	MBI4024351.1 phosphoglycolate phosphatase [Verrucomicrobiota bacterium]	diamond	213	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
31329809	31329809	PRJEB82358_P_NODE_12676_length_283_cov_1.123810_g12665_i0	PRJEB82358	12676	283	1.12381	3.1803823	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	159	8.38e-49	NR	MDE0837280.1	2562705	g12665	i0	100	0.858657243816254	81	0	85.9	0	40	282	1	81	MDE0837280.1 helix-turn-helix transcriptional regulator [Akkermansiaceae bacterium]	diamond	243	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansiaceae bacterium
32025828	32025828	PRJEB82358_P_NODE_17318_length_248_cov_0.880000_g17307_i0	PRJEB82358	17318	248	0.88	2.1824	Planctomycetota bacterium	2026780	Bacteria	Bacteria	83.6	1.58e-16	NR	HZL71289.1	2026780	g17307	i0	53.7	1.98387096774194	82	36	98	2	244	2	194	274	HZL71289.1 class I adenylate-forming enzyme family protein [Planctomycetota bacterium]	diamond	492	83.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
32184083	32184083	PRJEB82358_P_NODE_22158_length_214_cov_4.595745_g22147_i0	PRJEB82358	22158	214	4.595745	9.8348943	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	42.4	0.0351	NR	MBL7223638.1	2517210	g22147	i0	48.4	0.434579439252336	31	16	43.5	0	9	101	902	932	MBL7223638.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	93	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia			Candidatus Brocadiia 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);;