metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA416866" and tax_clade = "Cyanobacteriota/Melainabacteria group"

13 rows where analysis = "diamond", bioproject = "PRJNA416866" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
18271313	18271313	PRJNA416866_P_NODE_8875_length_216_cov_1.238710_g8731_i0	PRJNA416866	8875	216	1.23871	2.6756136	Bacillati	1783272	Bacteria	Bacteria	124	9.17e-32	NR	WP_190647199.1	47251	g8731	i0	77.5	28.5972222222222	71	16	98.6	0	214	2	209	279	WP_190647199.1 MULTISPECIES: acetylornithine/succinylornithine family transaminase [Leptolyngbya]	diamond	6177	125	0.992	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
26600470	26600470	PRJNA416866_P_NODE_881_length_777_cov_4.741620_g752_i0	PRJNA416866	881	777	4.74162	36.8423874	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	192	9.51e-59	NR	MBX9692690.1	2847862	g752	i0	76.1	0.451737451737452	117	28	45.2	0	252	602	1	117	MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium]	diamond	351	192	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
26790863	26790863	PRJNA416866_P_NODE_9481_length_209_cov_0.864865_g9337_i0	PRJNA416866	9481	209	0.864865	1.80756785	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	57.8	1.13e-7	NR	MBX9671732.1	2364082	g9337	i0	46	1.89473684210526	63	34	90.4	0	6	194	86	148	MBX9671732.1 calcium/proton exchanger [Candidatus Obscuribacterales bacterium]	diamond	396	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27043976	27043976	PRJNA416866_P_NODE_11842_length_201_cov_0.914286_g11698_i0	PRJNA416866	11842	201	0.914286	1.83771486	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	89.7	2.98e-19	NR	MBX9692038.1	2847862	g11698	i0	60.6	0.985074626865672	66	26	98.5	0	2	199	35	100	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	198	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27423486	27423486	PRJNA416866_P_NODE_5043_length_292_cov_1.099567_g4899_i0	PRJNA416866	5043	292	1.099567	3.21073564	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	112	1.36e-29	NR	MBX9695543.1	2847862	g4899	i0	94.5	0.565068493150685	55	3	56.5	0	165	1	1	55	MBX9695543.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	165	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27503166	27503166	PRJNA416866_P_NODE_8643_length_219_cov_1.620253_g8499_i0	PRJNA416866	8643	219	1.620253	3.54835407	Cyanophyceae	3028117	Bacteria	Bacteria	99	8.000000000000001e-23	NR	WP_414412619.1	2291959	g8499	i0	63	6	73	25	100	1	219	1	26	96	WP_414412619.1 leucyl aminopeptidase, partial [Synechococcus sp. R8-2]	diamond	1314	99.4	0.995975855130785	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. R8-2
27707867	27707867	PRJNA416866_P_NODE_384_length_1181_cov_17.496429_g304_i0	PRJNA416866	384	1181	17.496429	206.63282649	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	467	8.359999999999998e-162	NR	MBX9694561.1	2847862	g304	i0	74	2.45385266723116	308	75	77	2	1133	225	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2898	467	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27865116	27865116	PRJNA416866_P_NODE_385_length_1181_cov_15.877679_g304_i1	PRJNA416866	385	1181	15.877679	187.51538899	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	467	8.359999999999998e-162	NR	MBX9694561.1	2847862	g304	i1	74	2.45385266723116	308	75	77	2	1133	225	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2898	467	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28117750	28117750	PRJNA416866_P_NODE_10065_length_207_cov_0.876712_g9921_i0	PRJNA416866	10065	207	0.876712	1.81479384	Coleofasciculus sp.	3100458	Bacteria	Bacteria	45.4	8.38e-4	NR	MFP4410547.1	3100458	g9921	i0	52.6	1.10144927536232	38	18	55.1	0	116	3	79	116	MFP4410547.1 tetratricopeptide repeat protein [Coleofasciculus sp.]	diamond	228	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp.
28212334	28212334	PRJNA416866_P_NODE_11366_length_203_cov_0.901408_g11222_i0	PRJNA416866	11366	203	0.901408	1.82985824	Cyanobium sp. NAT70	2024872	Bacteria	Bacteria	42.7	0.0219	NR	MAR08260.1	2024872	g11222	i0	42.1	0.842364532019704	57	27	79.8	2	198	37	144	197	MAR08260.1 sodium-dependent transporter [Cyanobium sp. NAT70]	diamond	171	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NAT70
29349326	29349326	PRJNA416866_P_NODE_3949_length_333_cov_0.930147_g3806_i0	PRJNA416866	3949	333	0.930147	3.09738951	Cyanobacteria bacterium SBLK	2821505	Bacteria	Bacteria	46.2	0.0062	NR	MBP0022222.1	2821505	g3806	i0	51.3	1.13513513513514	39	19	35.1	0	118	2	453	491	MBP0022222.1 HAMP domain-containing protein [Cyanobacteria bacterium SBLK]	diamond	378	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SBLK
30580889	30580889	PRJNA416866_P_NODE_10753_length_205_cov_0.888889_g10609_i0	PRJNA416866	10753	205	0.888889	1.82222245	Microcystis sp. M53600_WE12	3030673	Bacteria	Bacteria	69.3	5.09e-12	NR	MDJ0527183.1	3030673	g10609	i0	53.3	2.64878048780488	60	28	87.8	0	200	21	181	240	MDJ0527183.1 histone deacetylase [Microcystis sp. M53600_WE12]	diamond	543	69.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M53600_WE12
31055336	31055336	PRJNA416866_P_NODE_1395_length_595_cov_1.275281_g1256_i0	PRJNA416866	1395	595	1.275281	7.58792195	Microcoleaceae cyanobacterium	3087179	Bacteria	Bacteria	99.4	2.08e-20	NR	HEY9617596.1	3087179	g1256	i0	38	5.28403361344538	179	80	90.3	6	6	542	65	212	HEY9617596.1 DASH family cryptochrome [Microcoleaceae cyanobacterium]	diamond	3144	99.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae		Microcoleaceae cyanobacterium

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