metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA493827" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA493827" and tax_phylum = "Chlorobiota"

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
471686	471686	PRJNA493827_P_NODE_198681_length_248_cov_0.880000_g196483_i0	PRJNA493827	198681	248	0.88	2.1824	Chlorobiota bacterium	2268192	Bacteria	Bacteria	153	4.05e-41	NR	MBL7986715.1	2268192	g196483	i0	92.7	0.991935483870968	82	6	99.2	0	246	1	309	390	MBL7986715.1 type I DNA topoisomerase [Chlorobiota bacterium]	diamond	246	153	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
27029173	27029173	PRJNA493827_P_NODE_122782_length_308_cov_2.217021_g120584_i0	PRJNA493827	122782	308	2.217021	6.82842468	FCB group	1783270	Bacteria	Bacteria	65.5	3.12e-11	NR	KXK56021.1	1619898	g120584	i0	100	0.603896103896104	31	0	30.2	0	215	307	1	31	KXK56021.1 MAG: RRM domain RNA-binding protein, partial [Chlorobi bacterium OLB7]	diamond	186	65.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium OLB7
27803462	27803462	PRJNA493827_P_NODE_187364_length_251_cov_0.865169_g185166_i0	PRJNA493827	187364	251	0.865169	2.17157419	Chlorobiota bacterium	2268192	Bacteria	Bacteria	110	6.08e-26	NR	MBK8912195.1	2268192	g185166	i0	98.1	0.645418326693227	54	1	64.5	0	2	163	907	960	MBK8912195.1 T9SS type A sorting domain-containing protein [Chlorobiota bacterium]	diamond	162	110	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
27803490	27803490	PRJNA493827_P_NODE_215484_length_245_cov_0.860465_g213286_i0	PRJNA493827	215484	245	0.860465	2.10813925	Chlorobiota bacterium	2268192	Bacteria	Bacteria	144	6.61e-38	NR	MBL7986852.1	2268192	g213286	i0	87.7	0.991836734693878	81	10	99.2	0	244	2	536	616	MBL7986852.1 T9SS type A sorting domain-containing protein [Chlorobiota bacterium]	diamond	243	144	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
28276790	28276790	PRJNA493827_P_NODE_191086_length_250_cov_0.870056_g188888_i0	PRJNA493827	191086	250	0.870056	2.17514	Chlorobi bacterium OLB7	1619898	Bacteria	Bacteria	110	8.3e-26	NR	KXK53786.1	1619898	g188888	i0	98.3	0.696	58	1	69.6	0	1	174	918	975	KXK53786.1 MAG: hypothetical protein UZ07_CHB004002708 [Chlorobi bacterium OLB7]	diamond	174	110	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium OLB7
28545454	28545454	PRJNA493827_P_NODE_191187_length_250_cov_0.870056_g188989_i0	PRJNA493827	191187	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	157	9.999999999999999e-43	NR	KXK56843.1	1619898	g188989	i0	98.8	1.968	82	1	98.4	0	3	248	674	755	KXK56843.1 MAG: cell wall anchor domain-containing protein [Chlorobi bacterium OLB7]	diamond	492	158	0.993670886075949	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium OLB7
29476462	29476462	PRJNA493827_P_NODE_224630_length_243_cov_0.905882_g222432_i0	PRJNA493827	224630	243	0.905882	2.20129326	Chlorobi bacterium OLB7	1619898	Bacteria	Bacteria	154	1.47e-41	NR	KXK57528.1	1619898	g222432	i0	98.8	0.987654320987654	80	1	98.8	0	242	3	416	495	KXK57528.1 MAG: ATP-dependent DNA helicase, RecQ family [Chlorobi bacterium OLB7]	diamond	240	154	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium OLB7
29823909	29823909	PRJNA493827_P_NODE_229451_length_242_cov_0.911243_g227253_i0	PRJNA493827	229451	242	0.911243	2.20520806	Chlorobi bacterium CHB2	2293705	Bacteria	Bacteria	152	5.58e-41	NR	MCE7933947.1	2293705	g227253	i0	98.8	0.991735537190083	80	1	99.2	0	240	1	623	702	MCE7933947.1 T9SS C-terminal target domain-containing protein [Chlorobi bacterium CHB2]	diamond	240	152	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium CHB2
30298469	30298469	PRJNA493827_P_NODE_209472_length_246_cov_0.890173_g207274_i0	PRJNA493827	209472	246	0.890173	2.18982558	Chlorobi bacterium OLB7	1619898	Bacteria	Bacteria	162	2.72e-45	NR	KXK57485.1	1619898	g207274	i0	98.8	0.98780487804878	81	1	98.8	0	245	3	422	502	KXK57485.1 MAG: hypothetical protein UZ07_CHB004000565 [Chlorobi bacterium OLB7]	diamond	243	162	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium OLB7
31372552	31372552	PRJNA493827_P_NODE_172656_length_260_cov_1.625668_g170458_i0	PRJNA493827	172656	260	1.625668	4.2267368	Chlorobi bacterium OLB7	1619898	Bacteria	Bacteria	167	4.25e-49	NR	KXK58025.1	1619898	g170458	i0	97.7	1.98461538461538	86	2	99.2	0	260	3	240	325	KXK58025.1 MAG: PBP superfamily domain protein [Chlorobi bacterium OLB7]	diamond	516	167	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium OLB7
31577914	31577914	PRJNA493827_P_NODE_228356_length_242_cov_0.911243_g226158_i0	PRJNA493827	228356	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	97.8	5.77e-23	NR	MEI7707270.1	1095	g226158	i0	75.4	12.396694214876	57	14	70.7	0	70	240	2	58	MEI7707270.1 pirin family protein [Chlorobium sp.]	diamond	3000	98.2	0.995926680244399	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium sp.
31704341	31704341	PRJNA493827_P_NODE_18577_length_913_cov_10.436905_g16849_i0	PRJNA493827	18577	913	10.436905	95.28894265	Pseudomonadati	3379134	Bacteria	Bacteria	94.4	1.61e-18	NR	WP_012502589.1	274539	g16849	i0	35.9	3.38444687842278	170	100	55.9	4	858	349	68	228	WP_012502589.1 CAP domain-containing protein [Chlorobaculum parvum]	diamond	3090	94.4	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum parvum
32036627	32036627	PRJNA493827_P_NODE_140278_length_288_cov_2.074419_g138080_i0	PRJNA493827	140278	288	2.074419	5.97432672	Chlorobi bacterium OLB7	1619898	Bacteria	Bacteria	141	1.38e-41	NR	KXK54577.1	1619898	g138080	i0	83.1	0.864583333333333	83	13	86.5	1	39	287	1	82	KXK54577.1 MAG: hypothetical protein UZ07_CHB004002523 [Chlorobi bacterium OLB7]	diamond	249	141	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium OLB7
32700329	32700329	PRJNA493827_P_NODE_195620_length_249_cov_0.875000_g193422_i0	PRJNA493827	195620	249	0.875	2.17875	Chlorobiota bacterium	2268192	Bacteria	Bacteria	169	1.8899999999999998e-46	NR	MBK8910240.1	2268192	g193422	i0	98.8	1	83	1	100	0	249	1	1237	1319	MBK8910240.1 hypothetical protein [Chlorobiota bacterium]	diamond	249	169	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota 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);;