metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA811725" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA811725" 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
13977591	13977591	PRJNA811725_P_NODE_11331_length_442_cov_5.398374_g11087_i0	PRJNA811725	11331	442	5.398374	23.86081308	Cyanophyceae	3028117	Bacteria	Bacteria	127	1.0999999999999999e-33	NR	WP_009634298.1	927677	g11087	i0	84.9	1.48642533936652	73	11	49.5	0	219	1	1	73	WP_009634298.1 translation elongation factor Ts [Synechocystis sp. PCC 7509]	diamond	657	128	0.9921875	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
25036347	25036347	PRJNA811725_P_NODE_23520_length_312_cov_1.288703_g23274_i0	PRJNA811725	23520	312	1.288703	4.02075336	Chroococcus sp. CMT-3BRIN-NPC107	2499659	Bacteria	Bacteria	83.6	7.72e-17	NR	MBW4664848.1	2499659	g23274	i0	62.1	0.634615384615385	66	25	63.5	0	198	1	1	66	MBW4664848.1 DUF4394 domain-containing protein [Chroococcus sp. CMT-3BRIN-NPC107]	diamond	198	83.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. CMT-3BRIN-NPC107
28096547	28096547	PRJNA811725_P_NODE_7725_length_529_cov_5.627193_g7482_i0	PRJNA811725	7725	529	5.627193	29.76785097	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	105	8.250000000000001e-26	NR	WP_009634329.1	927677	g7482	i0	79.7	0.782608695652174	69	14	39.1	0	380	174	57	125	WP_009634329.1 hypothetical protein [Synechocystis sp. PCC 7509]	diamond	414	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
29769837	29769837	PRJNA811725_P_NODE_27211_length_296_cov_1.928251_g26965_i0	PRJNA811725	27211	296	1.928251	5.70762296	Nodularia sp. (in: cyanobacteria)	2047085	Bacteria	Bacteria	50.4	3.81e-6	NR	MDP5338622.1	2047085	g26965	i0	62.5	0.324324324324324	32	12	32.4	0	276	181	1	32	MDP5338622.1 pentapeptide repeat-containing protein [Nodularia sp. (in: cyanobacteria)]	diamond	96	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia sp. (in: cyanobacteria)
30939096	30939096	PRJNA811725_P_NODE_6094_length_592_cov_4.493256_g5855_i0	PRJNA811725	6094	592	4.493256	26.60007552	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	115	5.1e-30	NR	PSB34970.1	2107693	g5855	i0	70.1	0.390202702702703	77	22	38.5	1	484	257	1	77	PSB34970.1 replication restart DNA helicase PriA [Chlorogloea sp. CCALA 695]	diamond	231	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
31223119	31223119	PRJNA811725_P_NODE_6095_length_592_cov_4.171484_g5856_i0	PRJNA811725	6095	592	4.171484	24.69518528	Aliterella atlantica	1827278	Bacteria	Bacteria	125	9.689999999999999e-30	NR	WP_045056891.1	1827278	g5856	i0	89.2	0.329391891891892	65	7	32.9	0	590	396	435	499	WP_045056891.1 carotenoid oxygenase family protein [Aliterella atlantica]	diamond	195	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31286428	31286428	PRJNA811725_P_NODE_23015_length_315_cov_2.929752_g22769_i0	PRJNA811725	23015	315	2.929752	9.2287188	Aliterella atlantica	1827278	Bacteria	Bacteria	96.7	6.680000000000001e-21	NR	WP_045053294.1	1827278	g22769	i0	91.8	0.466666666666667	49	4	46.7	0	167	313	26	74	WP_045053294.1 response regulator [Aliterella atlantica]	diamond	147	96.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31666030	31666030	PRJNA811725_P_NODE_8057_length_519_cov_6.127803_g7814_i0	PRJNA811725	8057	519	6.127803	31.80329757	Aliterella atlantica	1827278	Bacteria	Bacteria	223	3.86e-72	NR	WP_045055142.1	1827278	g7814	i0	95.9	0.705202312138728	122	5	70.5	0	519	154	3	124	WP_045055142.1 DUF2267 domain-containing protein [Aliterella atlantica]	diamond	366	223	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31666031	31666031	PRJNA811725_P_NODE_9237_length_486_cov_3.949153_g8993_i0	PRJNA811725	9237	486	3.949153	19.19288358	Aliterella atlantica	1827278	Bacteria	Bacteria	268	2.19e-87	NR	WP_045054870.1	1827278	g8993	i0	91.2	0.839506172839506	136	12	84	0	409	2	1	136	WP_045054870.1 glutathione S-transferase family protein [Aliterella atlantica]	diamond	408	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31760984	31760984	PRJNA811725_P_NODE_9417_length_482_cov_12.481663_g9173_i0	PRJNA811725	9417	482	12.481663	60.16161566	Aliterella atlantica	1827278	Bacteria	Bacteria	241	3.9e-73	NR	WP_045054561.1	1827278	g9173	i0	78.3	1.00207468879668	161	33	99.6	2	1	480	230	389	WP_045054561.1 serine/threonine-protein kinase [Aliterella atlantica]	diamond	483	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
32457246	32457246	PRJNA811725_P_NODE_9239_length_486_cov_2.404358_g8995_i0	PRJNA811725	9239	486	2.404358	11.68517988	Aliterella atlantica	1827278	Bacteria	Bacteria	176	5.95e-53	NR	WP_045056616.1	1827278	g8995	i0	84.6	0.641975308641975	104	16	64.2	0	1	312	80	183	WP_045056616.1 DUF6658 family protein [Aliterella atlantica]	diamond	312	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
32615089	32615089	PRJNA811725_P_NODE_9240_length_486_cov_2.237288_g8996_i0	PRJNA811725	9240	486	2.237288	10.87321968	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	204	3.11e-63	NR	WP_106369524.1	2107693	g8996	i0	69.5	0.950617283950617	154	46	95.1	1	3	464	87	239	WP_106369524.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	462	204	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
32803871	32803871	PRJNA811725_P_NODE_25320_length_305_cov_3.146552_g25074_i0	PRJNA811725	25320	305	3.146552	9.5969836	Aliterella atlantica	1827278	Bacteria	Bacteria	86.7	3.01e-18	NR	WP_052672496.1	1827278	g25074	i0	90	0.491803278688525	50	5	49.2	0	62	211	190	239	WP_052672496.1 DUF6658 family protein [Aliterella atlantica]	diamond	150	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica

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