metadata: contig_metadata: 21 rows where bioproject = "PRJNA811725" and tax_clade = "Cyanobacteriota/Melainabacteria group"

21 rows where bioproject = "PRJNA811725" 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
809923	809923	PRJNA811725_P_NODE_18901_length_349_cov_1.025362_g18655_i0	PRJNA811725	18901	349	1.025362	3.57851338	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	577	4.3999999999999996e-160	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g18655	i0	99.065	135.469914040115	321	3	92	0	1	321	2779	2459	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	47279	577	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
2085638	2085638	PRJNA811725_P_NODE_25462_length_304_cov_3.562771_g25216_i0	PRJNA811725	25462	304	3.562771	10.83082384	uncultured cyanobacterium	1211	Bacteria	Bacteria	377	4.11e-100	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g25216	i0	89.145	16.8026315789474	304	31	99	2	1	303	5296353	5296655	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	5108	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
3360781	3360781	PRJNA811725_P_NODE_14523_length_394_cov_8.295950_g14278_i0	PRJNA811725	14523	394	8.29595	32.686043	Anabaenopsis circularis	109266	Bacteria	Bacteria	453	8.84e-123	NTclustered	gi\|1210095109\|dbj\|AP018174.1\|	1085406	g14278	i0	87.532	212.08883248731	393	47	99	2	3	394	3195224	3195615	Anabaenopsis circularis NIES-21 DNA, nearly complete genome	blastn	83563	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis circularis
3775796	3775796	PRJNA811725_P_NODE_23203_length_314_cov_1.348548_g22957_i0	PRJNA811725	23203	314	1.348548	4.23444072	Calotrichaceae	2661849	Bacteria	Bacteria	490	5.249999999999998e-134	NTclustered	gi\|283766156\|gb\|GQ980023.1\|	232991	g22957	i0	95.44	202.786624203822	307	14	98	0	7	313	179	485	Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence	blastn	63675	492	0.995934959349594	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
5051845	5051845	PRJNA811725_P_NODE_16784_length_369_cov_4.337838_g16538_i0	PRJNA811725	16784	369	4.337838	16.00662222	Cyanophyceae	3028117	Bacteria	Bacteria	499	1.04e-136	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g16538	i0	91.351	181.691056910569	370	25	100	6	1	369	1626467	1626830	Cyanothece sp. PCC 7822, complete genome	blastn	67044	503	0.992047713717694	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
7188085	7188085	PRJNA811725_P_NODE_13546_length_407_cov_17.634731_g13302_i0	PRJNA811725	13546	407	17.634731	71.77335517	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	699	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g13302	i0	97.778	260.157248157248	405	9	99	0	1	405	1858832	1858428	Calothrix sp. PCC 7716 DNA, complete genome	blastn	105884	699	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
10152560	10152560	PRJNA811725_P_NODE_27808_length_293_cov_2.072727_g27562_i0	PRJNA811725	27808	293	2.072727	6.07309011	Chroococcaceae	1890464	Bacteria	Bacteria	178	4.3e-40	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g27562	i0	81.14	9.44027303754266	228	37	76	5	33	256	4379902	4380127	Gloeocapsa sp. PCC 7428, complete genome	blastn	2766	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
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
14838332	14838332	PRJNA811725_P_NODE_9132_length_489_cov_1.379808_g8888_i0	PRJNA811725	9132	489	1.379808	6.74726112	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	425	2.44e-114	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g8888	i0	82.626	75.1288343558282	495	72	100	11	1	489	3681052	3681538	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	36738	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
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);;