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

9 rows where analysis = "diamond", bioproject = "PRJNA1245487" 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
8004377	8004377	PRJNA1245487_P_NODE_16647_length_274_cov_2.094527_g16309_i0	PRJNA1245487	16647	274	2.094527	5.73900398	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	69.7	1.09e-13	NR	WP_106368098.1	2107693	g16309	i0	97.3	0.405109489051095	37	1	40.5	0	162	272	1	37	WP_106368098.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	111	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
10555302	10555302	PRJNA1245487_P_NODE_8549_length_417_cov_1.360465_g8211_i0	PRJNA1245487	8549	417	1.360465	5.67313905	Cyanothece	43988	Bacteria	Bacteria	204	6.43e-65	NR	NEQ95720.1	2607797	g8211	i0	69.3	4.92805755395683	137	42	98.6	0	2	412	13	149	NEQ95720.1 nucleoside-diphosphate kinase [Cyanothece sp. SIO2G6]	diamond	2055	206	0.990291262135922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. SIO2G6
27957981	27957981	PRJNA1245487_P_NODE_19525_length_251_cov_1.651685_g19187_i0	PRJNA1245487	19525	251	1.651685	4.14572935	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	135	5.149999999999999e-37	NR	WP_190772833.1	2650499	g19187	i0	84.3	0.99203187250996006	83	12	99.2	1	1	249	183	264	WP_190772833.1 MULTISPECIES: carbonic anhydrase [unclassified Leptolyngbya]	diamond	249	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
27989653	27989653	PRJNA1245487_P_NODE_19845_length_250_cov_0.881356_g19507_i0	PRJNA1245487	19845	250	0.881356	2.20339	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	49.7	1.26e-4	NR	WP_190792778.1	2650499	g19507	i0	75.8	0.396	33	8	39.6	0	173	75	246	278	WP_190792778.1 MULTISPECIES: hypothetical protein [unclassified Leptolyngbya]	diamond	99	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
29775666	29775666	PRJNA1245487_P_NODE_20211_length_249_cov_0.886364_g19873_i0	PRJNA1245487	20211	249	0.886364	2.20704636	Trichocoleus	450526	Bacteria	Bacteria	148	1.51e-43	NR	MBD1925774.1	2692876	g19873	i0	89.2	2	83	8	100	1	1	249	54	135	MBD1925774.1 DUF262 domain-containing protein [Trichocoleus sp. FACHB-90]	diamond	498	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. FACHB-90
30376490	30376490	PRJNA1245487_P_NODE_9812_length_382_cov_1.262136_g9474_i0	PRJNA1245487	9812	382	1.262136	4.82135952	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	59.3	2.76e-7	NR	HAX77374.1	2055768	g9474	i0	38.1	1.22513089005236	84	48	64.4	2	360	115	9	90	HAX77374.1 hypothetical protein [Cyanobacteria bacterium UBA11372]	diamond	468	59.7	0.993299832495812	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11372
30673766	30673766	PRJNA1245487_P_NODE_19113_length_253_cov_0.866667_g18775_i0	PRJNA1245487	19113	253	0.866667	2.19266751	Oscillatoria sp. FACHB-14	1159	Bacteria	Bacteria	150	8.82e-44	NR	WP_190507627.1	2692847	g18775	i0	95.9	0.865612648221344	73	3	86.6	0	251	33	139	211	WP_190507627.1 peroxiredoxin [Oscillatoria sp. FACHB-1407]	diamond	219	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. FACHB-1407
31685320	31685320	PRJNA1245487_P_NODE_20277_length_248_cov_2.120000_g19939_i0	PRJNA1245487	20277	248	2.12	5.2576	Synechococcales cyanobacterium M55_K2018_004	2774347	Bacteria	Bacteria	54.7	8.11e-8	NR	HIK55099.1	2774347	g19939	i0	58.5	0.495967741935484	41	17	49.6	0	130	8	1	41	HIK55099.1 DUF4278 domain-containing protein [Synechococcales cyanobacterium M55_K2018_004]	diamond	123	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium M55_K2018_004
32634026	32634026	PRJNA1245487_P_NODE_21980_length_242_cov_0.923077_g21642_i0	PRJNA1245487	21980	242	0.923077	2.23384634	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	162	1.42e-47	NR	WP_190771010.1	2650499	g21642	i0	96.3	0.991735537190083	80	3	99.2	0	241	2	143	222	WP_190771010.1 MULTISPECIES: tRNA pseudouridine(38-40) synthase TruA [unclassified Leptolyngbya]	diamond	240	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya

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