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

14 rows where analysis = "diamond", bioproject = "PRJNA846486" 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
26801508	26801508	PRJNA846486_P_NODE_79281_length_168_cov_0.873950_g79185_i0	PRJNA846486	79281	168	0.87395	1.468236	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	111	7.260000000000001e-27	NR	MBS1956467.1	2807733	g79185	i0	96.4	1.96428571428571	55	2	98.2	0	3	167	988	1042	MBS1956467.1 maltose alpha-D-glucosyltransferase [Cyanobacteria bacterium SZAS-4]	diamond	330	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
27568609	27568609	PRJNA846486_P_NODE_83444_length_166_cov_0.888889_g83348_i0	PRJNA846486	83444	166	0.888889	1.47555574	Scytonemataceae	1182	Bacteria	Bacteria	109	2.68e-27	NR	WP_414581541.1	1680591	g83348	i0	100	1.98795180722892	55	0	99.4	0	166	2	121	175	WP_414581541.1 DMT family transporter [Scytonema sp. PCC 10023]	diamond	330	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PCC 10023
27979134	27979134	PRJNA846486_P_NODE_75365_length_169_cov_2.400000_g75269_i0	PRJNA846486	75365	169	2.4	4.056	Nostoc	1177	Bacteria	Bacteria	63.9	2.5e-10	NR	WP_289798355.1	3056647	g75269	i0	56.9	1.81065088757396	51	21	90.5	1	157	5	62	111	WP_289798355.1 hypothetical protein [Nostoc sp. GT001]	diamond	306	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. GT001
28160404	28160404	PRJNA846486_P_NODE_36705_length_223_cov_1.189655_g36609_i0	PRJNA846486	36705	223	1.189655	2.65293065	Cyanobacteria bacterium J06642_9	3023224	Bacteria	Bacteria	41.6	0.0465	NR	MEO0827686.1	3023224	g36609	i0	64.5	0.417040358744395	31	11	41.7	0	93	1	128	158	MEO0827686.1 carboxypeptidase regulatory-like domain-containing protein [Cyanobacteria bacterium J06642_9]	diamond	93	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06642_9
28507595	28507595	PRJNA846486_P_NODE_91387_length_163_cov_0.912281_g91291_i0	PRJNA846486	91387	163	0.912281	1.48701803	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	60.1	8.09e-9	NR	MEY3930610.1	2847862	g91291	i0	52	0.920245398773006	50	24	92	0	157	8	231	280	MEY3930610.1 uncultured phage MedDCM-OCT-S37-C6 [Cyanobacteriota bacterium]	diamond	150	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28791536	28791536	PRJNA846486_P_NODE_67147_length_177_cov_1.468750_g67051_i0	PRJNA846486	67147	177	1.46875	2.5996875	Stenomitos sp.	3088177	Bacteria	Bacteria	75.1	5.86e-14	NR	HEY9857159.1	3088177	g67051	i0	66	0.796610169491525	47	16	79.7	0	37	177	11	57	HEY9857159.1 NCS2 family permease [Stenomitos sp.]	diamond	141	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
28886273	28886273	PRJNA846486_P_NODE_86768_length_165_cov_0.896552_g86672_i0	PRJNA846486	86768	165	0.896552	1.4793108	Cyanobacteria bacterium J06642_2	3023222	Bacteria	Bacteria	75.9	1.19e-16	NR	MEO0804461.1	3023222	g86672	i0	70.8	0.872727272727273	48	14	87.3	0	14	157	10	57	MEO0804461.1 hypothetical protein [Cyanobacteria bacterium J06642_2]	diamond	144	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06642_2
30189488	30189488	PRJNA846486_P_NODE_76792_length_169_cov_0.866667_g76696_i0	PRJNA846486	76792	169	0.866667	1.46466723	Microcoleaceae	1892252	Bacteria	Bacteria	68.9	6.96e-13	NR	WP_263746175.1	945768	g76696	i0	62.3	10.9349112426036	53	13	94.1	1	159	1	35	80	WP_263746175.1 IS200/IS605 family accessory protein TnpB-related protein [Plectonema radiosum]	diamond	1848	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema radiosum
30623302	30623302	PRJNA846486_P_NODE_48593_length_200_cov_1.377483_g48497_i0	PRJNA846486	48593	200	1.377483	2.754966	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	42	0.00601	NR	RYX99973.1	2847862	g48497	i0	66.7	0.54	36	8	52.5	2	53	157	31	63	RYX99973.1 MAG: hypothetical protein EOO34_00165 [Cyanobacteriota bacterium]	diamond	108	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31445236	31445236	PRJNA846486_P_NODE_88376_length_164_cov_0.904348_g88280_i0	PRJNA846486	88376	164	0.904348	1.48313072	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	112	9.64e-28	NR	MBS2002349.1	2807734	g88280	i0	98.1	0.98780487804878	54	1	98.8	0	162	1	104	157	MBS2002349.1 adenylosuccinate synthase [Cyanobacteria bacterium SZAS LIN-5]	diamond	162	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
31643244	31643244	PRJNA846486_P_NODE_73256_length_171_cov_1.704918_g73160_i0	PRJNA846486	73256	171	1.704918	2.91540978	root	1	Root_unresolved	Root_unresolved	48.9	3.54e-6	NR	MFN5978759.1	1153	g73160	i0	63.3	4.71929824561404	30	11	52.6	0	9	98	6	35	MFN5978759.1 iron ABC transporter substrate-binding protein [Pseudanabaena sp.]	diamond	807	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
32046327	32046327	PRJNA846486_P_NODE_88798_length_164_cov_0.904348_g88702_i0	PRJNA846486	88798	164	0.904348	1.48313072	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	100	3.2699999999999995e-23	NR	MBS1955344.1	2807733	g88702	i0	90.7	0.98780487804878	54	5	98.8	0	164	3	116	169	MBS1955344.1 glycosyltransferase family 39 protein [Cyanobacteria bacterium SZAS-4]	diamond	162	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
32489436	32489436	PRJNA846486_P_NODE_89639_length_163_cov_2.157895_g89543_i0	PRJNA846486	89639	163	2.157895	3.51736885	Nodosilinea sp. P-11	2497642	Bacteria	Bacteria	89	6.57e-19	NR	WP_169612643.1	2546229	g89543	i0	68.5	1.98773006134969	54	17	99.4	0	163	2	291	344	WP_169612643.1 asparagine synthetase B family protein [Nodosilinea sp. P-1105]	diamond	324	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. P-1105
32615560	32615560	PRJNA846486_P_NODE_81300_length_167_cov_0.881356_g81204_i0	PRJNA846486	81300	167	0.881356	1.47186452	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	73.9	1.19e-13	NR	MBS1956509.1	2807733	g81204	i0	91.4	0.62874251497006	35	3	62.9	0	1	105	266	300	MBS1956509.1 WG repeat-containing protein [Cyanobacteria bacterium SZAS-4]	diamond	105	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4

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