metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax_phylum = "Gemmatimonadota"

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
15221174	15221174	PRJNA716463_P_NODE_110292_length_242_cov_3.437870_g109874_i0	PRJNA716463	110292	242	3.43787	8.3196454	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	79	1.94e-15	NR	MDP1861294.1	2026741	g109874	i0	67.9	3.60743801652893	56	18	69.4	0	75	242	2	57	MDP1861294.1 ATP-binding cassette domain-containing protein [Gemmatimonadaceae bacterium]	diamond	873	79	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
18559197	18559197	PRJNA716463_P_NODE_11535_length_350_cov_3.877256_g11120_i0	PRJNA716463	11535	350	3.877256	13.570396	Pseudomonadati	3379134	Bacteria	Bacteria	204	2.32e-61	NR	HEU5170203.1	2448054	g11120	i0	81.4	1.93714285714286	113	21	96.9	0	341	3	240	352	HEU5170203.1 acetyl ornithine aminotransferase family protein [Gemmatimonadales bacterium]	diamond	678	206	0.990291262135922	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27178265	27178265	PRJNA716463_P_NODE_97582_length_253_cov_3.022222_g97165_i0	PRJNA716463	97582	253	3.022222	7.64622166	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	122	2.07e-30	NR	MEX0911858.1	2026742	g97165	i0	74.4	0.972332015810277	82	21	97.2	0	253	8	87	168	MEX0911858.1 HD domain-containing phosphohydrolase [Gemmatimonadota bacterium]	diamond	246	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27778725	27778725	PRJNA716463_P_NODE_36044_length_299_cov_3.367257_g35627_i0	PRJNA716463	36044	299	3.367257	10.06809843	Longimicrobium sp.	2029185	Bacteria	Bacteria	60.5	4.35e-8	NR	HEU0013141.1	2029185	g35627	i0	69.4	0.491638795986622	49	15	49.2	0	146	292	75	123	HEU0013141.1 SusC/RagA family TonB-linked outer membrane protein [Longimicrobium sp.]	diamond	147	60.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28325681	28325681	PRJNA716463_P_NODE_46646_length_293_cov_2.872727_g46229_i0	PRJNA716463	46646	293	2.872727	8.41709011	Pseudomonadati	3379134	Bacteria	Bacteria	65.9	4.8e-10	NR	MDH3272042.1	2026742	g46229	i0	56.8	1.37201365187713	44	19	45.1	0	2	133	385	428	MDH3272042.1 M20/M25/M40 family metallo-hydrolase [Gemmatimonadota bacterium]	diamond	402	65.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29073309	29073309	PRJNA716463_P_NODE_97928_length_253_cov_2.172222_g97511_i0	PRJNA716463	97928	253	2.172222	5.49572166	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	55.1	4.23e-7	NR	HXG45260.1	2448054	g97511	i0	48.2	0.66403162055336	56	29	66.4	0	207	40	93	148	HXG45260.1 DUF2380 domain-containing protein [Gemmatimonadales bacterium]	diamond	168	55.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29894195	29894195	PRJNA716463_P_NODE_123491_length_215_cov_4.070423_g123073_i0	PRJNA716463	123491	215	4.070423	8.75140945	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	127	2.42e-34	NR	HEX9755445.1	2448054	g123073	i0	85.9	2.97209302325581	71	10	99.1	0	2	214	171	241	HEX9755445.1 ABC transporter substrate-binding protein [Gemmatimonadales bacterium]	diamond	639	127	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30178296	30178296	PRJNA716463_P_NODE_122332_length_221_cov_5.587838_g121914_i0	PRJNA716463	122332	221	5.587838	12.34912198	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.7	4.54e-4	NR	HZB28403.1	2448054	g121914	i0	51.1	0.963800904977376	45	21	61.1	1	85	219	7	50	HZB28403.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	213	44.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30525895	30525895	PRJNA716463_P_NODE_81893_length_267_cov_1.922680_g81476_i0	PRJNA716463	81893	267	1.92268	5.1335556	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	122	1.78e-32	NR	MDQ4079748.1	2026742	g81476	i0	86.8	1.51685393258427	68	9	76.4	0	267	64	158	225	MDQ4079748.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	405	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30620632	30620632	PRJNA716463_P_NODE_20053_length_310_cov_3.717300_g19636_i0	PRJNA716463	20053	310	3.7173	11.52363	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	89.4	2.66e-18	NR	HET7250889.1	2448054	g19636	i0	87.2	0.454838709677419	47	6	45.5	0	164	304	31	77	HET7250889.1 acetyl ornithine aminotransferase family protein [Gemmatimonadales bacterium]	diamond	141	89.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31790210	31790210	PRJNA716463_P_NODE_90557_length_260_cov_1.395722_g90140_i0	PRJNA716463	90557	260	1.395722	3.6288772	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	122	4.48e-30	NR	HEU4630550.1	2026741	g90140	i0	77.9	0.992307692307692	86	18	99.2	1	260	3	593	677	HEU4630550.1 ABC transporter permease [Gemmatimonadaceae bacterium]	diamond	258	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;