metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA543299" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA543299" 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
14538466	14538466	PRJNA543299_P_NODE_24812_length_162_cov_0.902655_g24655_i0	PRJNA543299	24812	162	0.902655	1.4623011	Opitutaceae bacterium	2006848	Bacteria	Bacteria	88.2	1.15e-18	NR	MDP3072703.1	2006848	g24655	i0	88.7	0.981481481481482	53	6	98.1	0	160	2	211	263	MDP3072703.1 NAD+ synthase [Opitutaceae bacterium]	diamond	159	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
26634644	26634644	PRJNA543299_P_NODE_23521_length_164_cov_0.886957_g23364_i0	PRJNA543299	23521	164	0.886957	1.45460948	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	71.2	1.05e-12	NR	NDI17848.1	2026799	g23364	i0	77.4	0.969512195121951	53	11	97	1	159	1	69	120	NDI17848.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	159	71.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26919752	26919752	PRJNA543299_P_NODE_25082_length_162_cov_0.902655_g24925_i0	PRJNA543299	25082	162	0.902655	1.4623011	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	84	3.09e-17	NR	HEX4645818.1	2499141	g24925	i0	75.5	4.90740740740741	53	13	98.1	0	2	160	349	401	HEX4645818.1 carbohydrate porin [Verrucomicrobiia bacterium]	diamond	795	84	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27077903	27077903	PRJNA543299_P_NODE_26162_length_161_cov_0.910714_g26005_i0	PRJNA543299	26162	161	0.910714	1.46624954	Opitutaceae bacterium	2006848	Bacteria	Bacteria	50.8	1.63e-5	NR	MDO8539492.1	2006848	g26005	i0	42	0.93167701863354	50	27	89.4	1	5	148	41	90	MDO8539492.1 hypothetical protein [Opitutaceae bacterium]	diamond	150	50.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27140753	27140753	PRJNA543299_P_NODE_25642_length_161_cov_0.910714_g25485_i0	PRJNA543299	25642	161	0.910714	1.46624954	Opitutus sp.	1913982	Bacteria	Bacteria	54.7	1.18e-7	NR	HWL16800.1	1913982	g25485	i0	45.5	0.819875776397516	44	24	82	0	5	136	80	123	HWL16800.1 hypothetical protein [Opitutus sp.]	diamond	132	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
27583310	27583310	PRJNA543299_P_NODE_21304_length_166_cov_0.871795_g21147_i0	PRJNA543299	21304	166	0.871795	1.4471797	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	73.2	2.47e-13	NR	MCX6876972.1	2026799	g21147	i0	70	0.903614457831325	50	15	90.4	0	150	1	119	168	MCX6876972.1 Ig-like domain-containing protein [Verrucomicrobiota bacterium]	diamond	150	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27678439	27678439	PRJNA543299_P_NODE_23404_length_164_cov_0.886957_g23247_i0	PRJNA543299	23404	164	0.886957	1.45460948	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42	0.0224	NR	NOS72032.1	2026799	g23247	i0	44	0.914634146341463	50	27	91.5	1	163	14	19	67	NOS72032.1 DUF2786 domain-containing protein [Verrucomicrobiota bacterium]	diamond	150	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27898982	27898982	PRJNA543299_P_NODE_21305_length_166_cov_0.871795_g21148_i0	PRJNA543299	21305	166	0.871795	1.4471797	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	64.7	1.77e-10	NR	MEI6569515.1	2026799	g21148	i0	73.2	0.740963855421687	41	11	74.1	0	164	42	110	150	MEI6569515.1 N4-gp56 family major capsid protein [Verrucomicrobiota bacterium]	diamond	123	64.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28151933	28151933	PRJNA543299_P_NODE_22245_length_165_cov_0.879310_g22088_i0	PRJNA543299	22245	165	0.87931	1.4508615	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	76.3	1.8e-14	NR	MCX8090601.1	2499141	g22088	i0	66.7	0.981818181818182	54	18	98.2	0	163	2	23	76	MCX8090601.1 phage minor head protein [Verrucomicrobiia bacterium]	diamond	162	76.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30867704	30867704	PRJNA543299_P_NODE_24314_length_163_cov_0.894737_g24157_i0	PRJNA543299	24314	163	0.894737	1.45842131	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	89	1.77e-20	NR	MDQ5977815.1	2026799	g24157	i0	88	0.920245398773006	50	6	92	0	12	161	6	55	MDQ5977815.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	150	89	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31183463	31183463	PRJNA543299_P_NODE_22175_length_165_cov_0.879310_g22018_i0	PRJNA543299	22175	165	0.87931	1.4508615	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	51.2	3.5e-6	NR	MCB1225504.1	2026801	g22018	i0	54.2	0.872727272727273	48	22	87.3	0	2	145	91	138	MCB1225504.1 putative Ig domain-containing protein [Verrucomicrobiales bacterium]	diamond	144	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31341879	31341879	PRJNA543299_P_NODE_17236_length_181_cov_1.159091_g17079_i0	PRJNA543299	17236	181	1.159091	2.09795471	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	76.3	7.18e-15	NR	MDX2227926.1	2499141	g17079	i0	64	0.828729281767956	50	18	82.9	0	152	3	189	238	MDX2227926.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	150	76.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31784510	31784510	PRJNA543299_P_NODE_24197_length_163_cov_0.894737_g24040_i0	PRJNA543299	24197	163	0.894737	1.45842131	Opitutia bacterium	2026771	Bacteria	Bacteria	76.6	1.42e-14	NR	MFN7340690.1	2026771	g24040	i0	73.6	0.975460122699387	53	14	97.5	0	5	163	98	150	MFN7340690.1 hypothetical protein [Opitutia bacterium]	diamond	159	76.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
32037814	32037814	PRJNA543299_P_NODE_23898_length_163_cov_0.894737_g23741_i0	PRJNA543299	23898	163	0.894737	1.45842131	Limisphaerales bacterium	2052186	Bacteria	Bacteria	58.5	1.1e-8	NR	MFT4586190.1	2052186	g23741	i0	74.3	0.644171779141104	35	9	64.4	0	59	163	1	35	MFT4586190.1 Uma2 family endonuclease [Limisphaerales bacterium]	diamond	105	58.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
32259583	32259583	PRJNA543299_P_NODE_24798_length_162_cov_0.902655_g24641_i0	PRJNA543299	24798	162	0.902655	1.4623011	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	48.1	1.54e-4	NR	MBX7209729.1	2026800	g24641	i0	44.2	0.962962962962963	52	29	96.3	0	157	2	2519	2570	MBX7209729.1 DUF1800 family protein [Verrucomicrobiaceae bacterium]	diamond	156	48.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;