metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax_phylum = "Verrucomicrobiota"

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
28297711	28297711	PRJNA1005695_P_NODE_14946_length_394_cov_1.171340_g14094_i0	PRJNA1005695	14946	394	1.17134	4.6150796	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	49.3	9.25e-4	NR	MEM7011732.1	2026799	g14094	i0	42.6	0.357868020304569	47	24	35.8	1	379	239	93	136	MEM7011732.1 RICIN domain-containing protein [Verrucomicrobiota bacterium]	diamond	141	49.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28424253	28424253	PRJNA1005695_P_NODE_37646_length_247_cov_0.896552_g36794_i0	PRJNA1005695	37646	247	0.896552	2.21448344	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	109	1.04e-28	NR	MBS0634828.1	2026799	g36794	i0	81.7	0.728744939271255	60	11	72.9	0	182	3	1	60	MBS0634828.1 type II toxin-antitoxin system VapC family toxin [Verrucomicrobiota bacterium]	diamond	180	109	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30003043	30003043	PRJNA1005695_P_NODE_39991_length_242_cov_0.923077_g39139_i0	PRJNA1005695	39991	242	0.923077	2.23384634	Akkermansia sp. N21116	3040764	Bacteria	Bacteria	58.2	1.28e-7	NR	WP_322190066.1	3040764	g39139	i0	42.7	0.929752066115702	75	43	93	0	229	5	101	175	WP_322190066.1 hypothetical protein [Akkermansia sp. N21116]	diamond	225	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp. N21116
30761289	30761289	PRJNA1005695_P_NODE_40014_length_242_cov_0.923077_g39162_i0	PRJNA1005695	40014	242	0.923077	2.23384634	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	94	3.51e-20	NR	MCU0749224.1	2562705	g39162	i0	62.8	0.966942148760331	78	29	96.7	0	7	240	656	733	MCU0749224.1 family 16 glycosylhydrolase [Akkermansiaceae bacterium]	diamond	234	94	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
31171678	31171678	PRJNA1005695_P_NODE_40975_length_235_cov_2.290123_g40123_i0	PRJNA1005695	40975	235	2.290123	5.38178905	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	109	5.0700000000000006e-27	NR	QTN31624.1	2562705	g40123	i0	59	2.98723404255319	78	30	97	1	233	6	105	182	QTN31624.1 ROK family protein [Akkermansiaceae bacterium]	diamond	702	109	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32437547	32437547	PRJNA1005695_P_NODE_28919_length_278_cov_1.346341_g28067_i0	PRJNA1005695	28919	278	1.346341	3.74282798	Puniceicoccales bacterium	2478473	Bacteria	Bacteria	117	7.23e-29	NR	MDR2812906.1	2478473	g28067	i0	61.8	0.960431654676259	89	34	96	0	12	278	178	266	MDR2812906.1 M48 family metallopeptidase [Puniceicoccales bacterium]	diamond	267	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales			Puniceicoccales bacterium
32532423	32532423	PRJNA1005695_P_NODE_35639_length_251_cov_0.876404_g34787_i0	PRJNA1005695	35639	251	0.876404	2.19977404	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	134	2.87e-37	NR	MCC6883823.1	2026801	g34787	i0	76.5	0.968127490039841	81	19	96.8	0	4	246	20	100	MCC6883823.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	243	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32776707	32776707	PRJNA1005695_P_NODE_36300_length_249_cov_2.965909_g35448_i0	PRJNA1005695	36300	249	2.965909	7.38511341	Bacteria	2	Bacteria	Bacteria	57	3.95e-7	NR	MBL9136906.1	2026801	g35448	i0	50	7.33734939759036	54	24	65.1	1	88	249	667	717	MBL9136906.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	1827	57.4	0.993031358885017	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales 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);;