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

11 rows where analysis = "diamond", bioproject = "PRJNA758087" and tax_phylum = "Cyanobacteriota"

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
12682479	12682479	PRJNA758087_P_NODE_39190_length_282_cov_2.459330_g37870_i0	PRJNA758087	39190	282	2.45933	6.9353106	Drouetiella sp.	3088174	Bacteria	Bacteria	110	2.53e-26	NR	HEY9732054.1	3088174	g37870	i0	100	0.531914893617021	50	0	53.2	0	131	280	1	50	HEY9732054.1 MFS transporter [Drouetiella sp.]	diamond	150	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
16036291	16036291	PRJNA758087_P_NODE_36473_length_316_cov_1.296296_g35153_i0	PRJNA758087	36473	316	1.296296	4.09629536	Cyanobacteria bacterium RM1_2_2	2720432	Bacteria	Bacteria	167	1.42e-45	NR	NJO77397.1	2720432	g35153	i0	94.2	5.71518987341772	86	5	81.6	0	2	259	228	313	NJO77397.1 TIGR03960 family B12-binding radical SAM protein [Cyanobacteria bacterium RM1_2_2]	diamond	1806	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium RM1_2_2
18585757	18585757	PRJNA758087_P_NODE_7475_length_1218_cov_4.045415_g6558_i0	PRJNA758087	7475	1218	4.045415	49.2731547	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	427	6.019999999999998e-145	NR	WP_190379852.1	2650499	g6558	i0	94.1	1.6256157635468	220	13	54.2	0	1185	526	126	345	WP_190379852.1 MULTISPECIES: zinc-dependent alcohol dehydrogenase [unclassified Leptolyngbya]	diamond	1980	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
21604854	21604854	PRJNA758087_P_NODE_13257_length_836_cov_68.372215_g12068_i0	PRJNA758087	13257	836	68.372215	571.5917174	Cyanophyceae	3028117	Bacteria	Bacteria	77	8.34e-12	NR	WP_190763162.1	3028117	g12068	i0	41.1	0.566985645933014	158	80	53.8	8	796	347	262	414	WP_190763162.1 MULTISPECIES: SBBP repeat-containing protein [Cyanophyceae]	diamond	474	77	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
22410685	22410685	PRJNA758087_P_NODE_24638_length_509_cov_19.823394_g23318_i0	PRJNA758087	24638	509	19.823394	100.90107546	Cyanophyceae	3028117	Bacteria	Bacteria	236	4.77e-77	NR	WP_179046445.1	2576904	g23318	i0	80	8.63457760314342	145	29	85.5	0	5	439	13	157	WP_179046445.1 GNAT family N-acetyltransferase [Nostoc sp. TCL26-01]	diamond	4395	237	0.9957805907173	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL26-01
27716742	27716742	PRJNA758087_P_NODE_13484_length_827_cov_2.259947_g12290_i0	PRJNA758087	13484	827	2.259947	18.68976169	Leptolyngbya sp. ERB_1_1	2083155	Bacteria	Bacteria	366	9.2e-125	NR	MER3435257.1	2083155	g12290	i0	93.2	0.696493349455865	192	13	69.6	0	804	229	77	268	MER3435257.1 hypothetical protein [Leptolyngbya sp. ERB_1_1]	diamond	576	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. ERB_1_1
27905541	27905541	PRJNA758087_P_NODE_23265_length_539_cov_1.156652_g21948_i0	PRJNA758087	23265	539	1.156652	6.23435428	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	202	9.84e-61	NR	HEY9781437.1	3088178	g21948	i0	66.1	0.951762523191095	171	52	92.4	4	36	533	3	172	HEY9781437.1 FAD-dependent oxidoreductase [Leptolyngbyaceae cyanobacterium]	diamond	513	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
28347818	28347818	PRJNA758087_P_NODE_15566_length_747_cov_3.488131_g14322_i0	PRJNA758087	15566	747	3.488131	26.05633857	Drouetiella sp.	3088174	Bacteria	Bacteria	444	2.4899999999999993e-152	NR	HEY9730898.1	3088174	g14322	i0	99.6	0.943775100401606	235	1	94.4	0	727	23	49	283	HEY9730898.1 hypothetical protein [Drouetiella sp.]	diamond	705	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
29011284	29011284	PRJNA758087_P_NODE_42888_length_245_cov_1.343023_g41568_i0	PRJNA758087	42888	245	1.343023	3.29040635	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	88.6	2.77e-18	NR	WP_202807234.1	927677	g41568	i0	58.7	1.99591836734694	92	26	99.2	2	3	245	320	410	WP_202807234.1 DUF1565 domain-containing protein [Synechocystis sp. PCC 7509]	diamond	489	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
30526825	30526825	PRJNA758087_P_NODE_41733_length_251_cov_0.865169_g40413_i0	PRJNA758087	41733	251	0.865169	2.17157419	Trichocoleus sp. Lan	2933927	Bacteria	Bacteria	167	4.66e-50	NR	WP_348239706.1	2933927	g40413	i0	91.1	7.58964143426295	79	7	94.4	0	13	249	110	188	WP_348239706.1 IS1 family transposase [Trichocoleus sp. Lan]	diamond	1905	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. Lan
32739830	32739830	PRJNA758087_P_NODE_7580_length_1208_cov_22.822907_g6656_i0	PRJNA758087	7580	1208	22.822907	275.70071656	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	166	6.79e-41	NR	MBX9696243.1	2847862	g6656	i0	46.7	0.824503311258278	332	167	81.7	6	151	1137	90	414	MBX9696243.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	996	166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota 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);;