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

10 rows where analysis = "diamond", bioproject = "PRJNA1145997" 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
15592607	15592607	PRJNA1145997_P_NODE_50553_length_228_cov_3.909677_g47934_i0	PRJNA1145997	50553	228	3.909677	8.91406356	Pseudomonadati	3379134	Bacteria	Bacteria	125	8.229999999999999e-32	NR	MCC7519260.1	2499141	g47934	i0	91.3	2.72368421052632	69	6	90.8	0	20	226	318	386	MCC7519260.1 chaperonin GroEL [Verrucomicrobiia bacterium]	diamond	621	125	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26943908	26943908	PRJNA1145997_P_NODE_47102_length_245_cov_0.906977_g44483_i0	PRJNA1145997	47102	245	0.906977	2.22209365	Opitutaceae bacterium	2006848	Bacteria	Bacteria	130	9.94e-34	NR	MEO6567161.1	2006848	g44483	i0	71.6	0.991836734693878	81	23	99.2	0	243	1	182	262	MEO6567161.1 DUF1592 domain-containing protein [Opitutaceae bacterium]	diamond	243	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27544551	27544551	PRJNA1145997_P_NODE_43404_length_251_cov_0.876404_g40785_i0	PRJNA1145997	43404	251	0.876404	2.19977404	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	77	3.4e-14	NR	MEK7340032.1	2026799	g40785	i0	97.3	0.884462151394422	37	1	44.2	0	112	2	1	37	MEK7340032.1 excinuclease ABC subunit UvrB [Verrucomicrobiota bacterium]	diamond	222	77	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27765738	27765738	PRJNA1145997_P_NODE_48244_length_243_cov_1.376471_g45625_i0	PRJNA1145997	48244	243	1.376471	3.34482453	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	129	5.38e-36	NR	MDP4792931.1	2026801	g45625	i0	76.3	3.93827160493827	80	19	98.8	0	242	3	76	155	MDP4792931.1 YbjN domain-containing protein [Verrucomicrobiales bacterium]	diamond	957	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28238941	28238941	PRJNA1145997_P_NODE_42946_length_252_cov_0.871508_g40327_i0	PRJNA1145997	42946	252	0.871508	2.19620016	Roseimicrobium gellanilyticum	748857	Bacteria	Bacteria	117	1.74e-28	NR	WP_147263542.1	748857	g40327	i0	65.4	0.964285714285714	81	28	96.4	0	252	10	1519	1599	WP_147263542.1 discoidin domain-containing protein [Roseimicrobium gellanilyticum]	diamond	243	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium gellanilyticum
29470225	29470225	PRJNA1145997_P_NODE_46890_length_245_cov_1.813953_g44271_i0	PRJNA1145997	46890	245	1.813953	4.44418485	Opitutus sp.	1913982	Bacteria	Bacteria	137	8.31e-36	NR	MCS6244044.1	1913982	g44271	i0	83.3	0.955102040816327	78	13	95.5	0	1	234	177	254	MCS6244044.1 hypothetical protein [Opitutus sp.]	diamond	234	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
30028023	30028023	PRJNA1145997_P_NODE_36851_length_290_cov_2.672811_g34232_i0	PRJNA1145997	36851	290	2.672811	7.7511519	Bacteria	2	Bacteria	Bacteria	173	9.27e-48	NR	MBP6782823.1	2026801	g34232	i0	90.1	5.60689655172414	91	9	94.1	0	273	1	431	521	MBP6782823.1 [protein-PII] uridylyltransferase [Verrucomicrobiales bacterium]	diamond	1626	173	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30817766	30817766	PRJNA1145997_P_NODE_50534_length_228_cov_5.361290_g47915_i0	PRJNA1145997	50534	228	5.36129	12.2237412	Pseudomonadati	3379134	Bacteria	Bacteria	106	4.19e-26	NR	MBL9138937.1	2026801	g47915	i0	82.3	4.31578947368421	62	11	81.6	0	12	197	110	171	MBL9138937.1 PH domain-containing protein [Verrucomicrobiales bacterium]	diamond	984	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31650636	31650636	PRJNA1145997_P_NODE_49397_length_242_cov_0.887574_g46778_i0	PRJNA1145997	49397	242	0.887574	2.14792908	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	71.6	2.48e-12	NR	MDB6062098.1	2026800	g46778	i0	49.3	0.929752066115702	75	36	93	1	225	1	859	931	MDB6062098.1 hypothetical protein [Verrucomicrobiaceae bacterium]	diamond	225	71.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32568566	32568566	PRJNA1145997_P_NODE_44459_length_249_cov_1.255682_g41840_i0	PRJNA1145997	44459	249	1.255682	3.12664818	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	75.9	8.83e-14	NR	MBX7211201.1	2026800	g41840	i0	84.6	0.963855421686747	39	6	47	0	123	7	1	39	MBX7211201.1 asparagine synthase (glutamine-hydrolyzing) [Verrucomicrobiaceae bacterium]	diamond	240	75.9	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);;