metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA356682" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA356682" 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
1672612	1672612	PRJNA356682_P_NODE_44682_length_241_cov_0.916667_g43991_i0	PRJNA356682	44682	241	0.916667	2.20916747	Leptolyngbya	47251	Bacteria	Bacteria	149	3.589999999999999e-42	NR	WP_088890706.1	1962290	g43991	i0	91.1	1.96680497925311	79	7	98.3	0	3	239	195	273	WP_088890706.1 branched-chain amino acid transaminase [Leptolyngbya ohadii]	diamond	474	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya ohadii
26902320	26902320	PRJNA356682_P_NODE_42101_length_244_cov_0.900585_g41410_i0	PRJNA356682	42101	244	0.900585	2.1974274	Cyanophyceae	3028117	Bacteria	Bacteria	47	0.00117	NR	WP_023073419.1	1385935	g41410	i0	34.5	3.02459016393443	87	45	98.4	3	241	2	207	288	WP_023073419.1 hypothetical protein [Leptolyngbya sp. Heron Island J]	diamond	738	47.4	0.991561181434599	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. Heron Island J
27359496	27359496	PRJNA356682_P_NODE_42123_length_244_cov_0.900585_g41432_i0	PRJNA356682	42123	244	0.900585	2.1974274	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	72.8	1.94e-13	NR	HCF28889.1	2055787	g41432	i0	97.4	0.467213114754098	38	1	46.7	0	129	242	1	38	HCF28889.1 phosphoribosylpyrophosphate synthetase [Cyanobacteria bacterium UBA11049]	diamond	114	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
28355181	28355181	PRJNA356682_P_NODE_44666_length_241_cov_0.916667_g43975_i0	PRJNA356682	44666	241	0.916667	2.20916747	Floridanema	3396149	Bacteria	Bacteria	147	2.64e-39	NR	WP_073592426.1	454136	g43975	i0	86.3	3.95850622406639	80	11	99.6	0	241	2	75	154	WP_073592426.1 CHASE2 domain-containing protein [[Phormidium ambiguum] IAM M-71]	diamond	954	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Floridanema	[Phormidium ambiguum] IAM M-71
29663881	29663881	PRJNA356682_P_NODE_39250_length_247_cov_0.885057_g38559_i0	PRJNA356682	39250	247	0.885057	2.18609079	Microcoleus sp. SIO2G3	2607795	Bacteria	Bacteria	130	9.13e-36	NR	NEQ24435.1	2607795	g38559	i0	91	1.62753036437247	67	6	81.4	0	46	246	1	67	NEQ24435.1 5'/3'-nucleotidase SurE [Microcoleus sp. SIO2G3]	diamond	402	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. SIO2G3
30454242	30454242	PRJNA356682_P_NODE_43913_length_242_cov_0.911243_g43222_i0	PRJNA356682	43913	242	0.911243	2.20520806	Stenomitos rutilans	1886682	Bacteria	Bacteria	82.8	1.32e-18	NR	MBW4474128.1	1382958	g43222	i0	62	0.880165289256198	71	24	84.3	1	204	1	1	71	MBW4474128.1 hypothetical protein [Stenomitos rutilans HA7619-LM2]	diamond	213	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos rutilans
30565561	30565561	PRJNA356682_P_NODE_38533_length_248_cov_0.880000_g37842_i0	PRJNA356682	38533	248	0.88	2.1824	Cyanophyceae	3028117	Bacteria	Bacteria	67	1.25e-12	NR	WP_015115018.1	317936	g37842	i0	84.8	6.78629032258065	33	5	39.9	0	84	182	1	33	WP_015115018.1 hypothetical protein [Nostoc sp. PCC 7107]	diamond	1683	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7107
31275491	31275491	PRJNA356682_P_NODE_37575_length_249_cov_0.875000_g36884_i0	PRJNA356682	37575	249	0.875	2.17875	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	182	7.28e-52	NR	WP_009631462.1	927677	g36884	i0	95.2	2	83	4	100	0	1	249	610	692	WP_009631462.1 alpha-amylase/alpha-mannosidase [Synechocystis sp. PCC 7509]	diamond	498	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
32115276	32115276	PRJNA356682_P_NODE_44818_length_241_cov_0.916667_g44127_i0	PRJNA356682	44818	241	0.916667	2.20916747	Scytonema	1203	Bacteria	Bacteria	63.9	2.92e-11	NR	WP_155752728.1	2304196	g44127	i0	87.9	1.23236514522822	33	4	41.1	0	241	143	49	81	WP_155752728.1 UPF0175 family protein [Scytonema sp. UIC 10036]	diamond	297	64.3	0.993779160186625	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. UIC 10036

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);;