metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1068830" 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
15486463	15486463	PRJNA1068830_P_NODE_82653_length_246_cov_0.901734_g81950_i0	PRJNA1068830	82653	246	0.901734	2.21826564	Akkermansia glycaniphila	1679444	Bacteria	Bacteria	82	5.33e-18	NR	OCA02583.1	1679444	g81950	i0	95.3	1.04878048780488	43	2	52.4	0	246	118	71	113	OCA02583.1 transposase [Akkermansia glycaniphila]	diamond	258	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia glycaniphila
27098914	27098914	PRJNA1068830_P_NODE_78602_length_249_cov_0.886364_g77899_i0	PRJNA1068830	78602	249	0.886364	2.20704636	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	57.4	2.62e-7	NR	MBV9009557.1	2026799	g77899	i0	53.7	2.12048192771084	54	24	65.1	1	2	163	82	134	MBV9009557.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	528	57.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27541384	27541384	PRJNA1068830_P_NODE_70124_length_257_cov_1.695652_g69421_i0	PRJNA1068830	70124	257	1.695652	4.35782564	Opitutaceae bacterium	2006848	Bacteria	Bacteria	42.7	0.045	NR	HEY1764242.1	2006848	g69421	i0	33.8	0.793774319066148	68	37	70	2	47	226	499	566	HEY1764242.1 right-handed parallel beta-helix repeat-containing protein [Opitutaceae bacterium]	diamond	204	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28101057	28101057	PRJNA1068830_P_NODE_83745_length_245_cov_0.906977_g83042_i0	PRJNA1068830	83745	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	53.5	3.19e-6	NR	MCX6961305.1	2026799	g83042	i0	42.7	6.24489795918367	75	39	86.9	2	7	219	104	178	MCX6961305.1 YbjN domain-containing protein [Verrucomicrobiota bacterium]	diamond	1530	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28606322	28606322	PRJNA1068830_P_NODE_86647_length_243_cov_0.917647_g85944_i0	PRJNA1068830	86647	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	140	5.54e-38	NR	MBI4658269.1	2026799	g85944	i0	77.8	9	81	18	100	0	1	243	288	368	MBI4658269.1 terpene cyclase/mutase family protein [Verrucomicrobiota bacterium]	diamond	2187	140	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28804005	28804005	PRJNA1068830_P_NODE_83028_length_245_cov_3.627907_g82325_i0	PRJNA1068830	83028	245	3.627907	8.88837215	Verrucomicrobiia bacterium Tous-C3TDCM	1982330	Bacteria	Bacteria	44.3	0.0107	NR	PAW61727.1	1982330	g82325	i0	34.7	0.918367346938776	75	49	91.8	0	2	226	324	398	PAW61727.1 MAG: RIP metalloprotease RseP [Verrucomicrobiia bacterium Tous-C3TDCM]	diamond	225	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium Tous-C3TDCM
31489664	31489664	PRJNA1068830_P_NODE_24696_length_471_cov_1.070352_g23995_i0	PRJNA1068830	24696	471	1.070352	5.04135792	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	163	1.34e-47	NR	MAD23566.1	2026801	g23995	i0	59	0.853503184713376	134	50	82.2	1	402	16	1	134	MAD23566.1 thymidylate synthase (FAD) [Verrucomicrobiales bacterium]	diamond	402	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31837185	31837185	PRJNA1068830_P_NODE_76417_length_250_cov_1.305085_g75714_i0	PRJNA1068830	76417	250	1.305085	3.2627125	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	52.4	1.08e-5	NR	HXT85908.1	2499141	g75714	i0	37.1	0.744	62	38	74.4	1	3	188	167	227	HXT85908.1 lipid-binding SYLF domain-containing protein [Verrucomicrobiia bacterium]	diamond	186	52.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31932132	31932132	PRJNA1068830_P_NODE_25357_length_463_cov_1.748718_g24655_i0	PRJNA1068830	25357	463	1.748718	8.09656434	Methylacidimicrobium sp. B4	2796139	Bacteria	Bacteria	277	3.3499999999999998e-90	NR	WP_206863961.1	2796139	g24655	i0	90.9	1.97624190064795	154	14	99.8	0	462	1	194	347	WP_206863961.1 IS256 family transposase [Methylacidimicrobium sp. B4]	diamond	915	277	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. B4
32090483	32090483	PRJNA1068830_P_NODE_65018_length_269_cov_1.326531_g64315_i0	PRJNA1068830	65018	269	1.326531	3.56836839	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	81.3	9.86e-16	NR	NNE90836.1	2026801	g64315	i0	47.7	1.97397769516729	88	43	98.1	2	264	1	64	148	NNE90836.1 2-aminoethylphosphonate--pyruvate transaminase [Verrucomicrobiales bacterium]	diamond	531	81.3	1	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);;