metadata: contig_metadata: 28 rows where bioproject = "PRJNA839281" and tax

28 rows where bioproject = "PRJNA839281" 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
829790	829790	PRJNA839281_S_NODE_30581_length_165_cov_0.879310_g30312_i0	PRJNA839281	30581	165	0.87931	1.4508615	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g30312	i0	100	2	165	0	100	0	1	165	4581901	4581737	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	330	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
3380639	3380639	PRJNA839281_S_NODE_33903_length_163_cov_0.894737_g33634_i0	PRJNA839281	33903	163	0.894737	1.45842131	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	143	7.839999999999999e-30	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g33634	i0	82.609	0.987730061349693	161	28	99	0	1	161	4079504	4079664	Gloeocapsa sp. PCC 7428, complete genome	blastn	161	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
4658213	4658213	PRJNA839281_S_NODE_33644_length_163_cov_0.894737_g33375_i0	PRJNA839281	33644	163	0.894737	1.45842131	Myxosarcina sp. GI1	1541065	Bacteria	Bacteria	95.1	4.51e-21	NR	WP_036480558.1	1541065	g33375	i0	88.9	0.993865030674847	54	6	99.4	0	162	1	246	299	WP_036480558.1 polyribonucleotide nucleotidyltransferase [Myxosarcina sp. GI1]	diamond	162	95.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Myxosarcina	Myxosarcina sp. GI1
5932899	5932899	PRJNA839281_S_NODE_27385_length_167_cov_0.864407_g27116_i0	PRJNA839281	27385	167	0.864407	1.44355969	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	296	5.86e-76	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g27116	i0	98.795	3.41317365269461	166	2	99	0	1	166	3549527	3549692	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	570	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
7208070	7208070	PRJNA839281_S_NODE_37286_length_161_cov_0.910714_g37017_i0	PRJNA839281	37286	161	0.910714	1.46624954	Anabaena cylindrica	1165	Bacteria	Bacteria	100	4.71e-17	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g37017	i0	88.372	2.48447204968944	86	7	52	3	6	88	5945247	5945162	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	400	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
8482695	8482695	PRJNA839281_S_NODE_38007_length_161_cov_0.910714_g37738_i0	PRJNA839281	38007	161	0.910714	1.46624954	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	270	3.389999999999999e-68	NTclustered	gi\|2245450223\|gb\|CP083762.1\|	155894	g37738	i0	96.894	2	161	5	100	0	1	161	170574	170414	Chroococcidiopsis sp. CCMEE 29 plasmid unnamed, complete sequence	blastn	322	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
13583375	13583375	PRJNA839281_S_NODE_27311_length_167_cov_0.864407_g27042_i0	PRJNA839281	27311	167	0.864407	1.44355969	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	226	7.799999999999999e-55	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g27042	i0	91.018	1	167	15	100	0	1	167	6088648	6088482	Allocoleopsis franciscana PCC 7113, complete genome	blastn	167	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
20356783	20356783	PRJNA839281_S_NODE_35936_length_162_cov_0.902655_g35667_i0	PRJNA839281	35936	162	0.902655	1.4623011	Chroococcidiopsis	54298	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g35667	i0	99.383	2	162	1	100	0	1	162	5727369	5727530	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	324	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
24182054	24182054	PRJNA839281_S_NODE_37479_length_161_cov_0.910714_g37210_i0	PRJNA839281	37479	161	0.910714	1.46624954	Nostoc	1177	Bacteria	Bacteria	191	2.72e-44	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g37210	i0	88.125	2.98136645962733	160	19	99	0	2	161	1298207	1298366	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	480	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
25055973	25055973	PRJNA839281_S_NODE_31680_length_164_cov_0.886957_g31411_i0	PRJNA839281	31680	164	0.886957	1.45460948	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	83.2	6.8e-17	NR	HEY9708894.1	3088181	g31411	i0	87	0.98780487804878	54	7	98.8	0	162	1	339	392	HEY9708894.1 ABC transporter permease subunit [Oculatellaceae cyanobacterium]	diamond	162	83.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
26737714	26737714	PRJNA839281_S_NODE_20521_length_184_cov_1.266667_g20252_i0	PRJNA839281	20521	184	1.266667	2.33066728	Cyanobium sp.	2164130	Bacteria	Bacteria	79	5.88e-16	NR	MFM8276556.1	2164130	g20252	i0	65.6	9.84782608695652	61	21	99.5	0	184	2	4	64	MFM8276556.1 EpsG family protein [Cyanobium sp.]	diamond	1812	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp.
26991157	26991157	PRJNA839281_S_NODE_28322_length_166_cov_0.871795_g28053_i0	PRJNA839281	28322	166	0.871795	1.4471797	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	110	8.38e-30	NR	HCF29805.1	2055787	g28053	i0	96.3	0.975903614457831	54	2	97.6	0	164	3	43	96	HCF29805.1 DNA-binding protein [Cyanobacteria bacterium UBA11049]	diamond	162	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
27117676	27117676	PRJNA839281_S_NODE_34182_length_163_cov_0.894737_g33913_i0	PRJNA839281	34182	163	0.894737	1.45842131	Microcoleus sp. SIO2G3	2607795	Bacteria	Bacteria	102	1.1399999999999999e-23	NR	NEQ23527.1	2607795	g33913	i0	92.5	0.975460122699387	53	4	97.5	0	161	3	246	298	NEQ23527.1 cyanophycin synthetase [Microcoleus sp. SIO2G3]	diamond	159	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. SIO2G3
27379473	27379473	PRJNA839281_S_NODE_29063_length_166_cov_0.871795_g28794_i0	PRJNA839281	29063	166	0.871795	1.4471797	Calotrichaceae	2661849	Bacteria	Bacteria	105	7.72e-25	NR	WP_127081456.1	32056	g28794	i0	90.9	3.97590361445783	55	5	99.4	0	165	1	62	116	WP_127081456.1 DNA polymerase III subunit gamma/tau [Dulcicalothrix desertica]	diamond	660	106	0.990566037735849	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
27497151	27497151	PRJNA839281_S_NODE_30823_length_165_cov_0.879310_g30554_i0	PRJNA839281	30823	165	0.87931	1.4508615	Hydrococcus sp. CRU_1_1	2720400	Bacteria	Bacteria	119	2.71e-30	NR	NJP19081.1	2720400	g30554	i0	88.9	0.981818181818182	54	6	98.2	0	2	163	117	170	NJP19081.1 beta-glucosidase [Hydrococcus sp. CRU_1_1]	diamond	162	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus sp. CRU_1_1
28326303	28326303	PRJNA839281_S_NODE_33246_length_163_cov_0.894737_g32977_i0	PRJNA839281	33246	163	0.894737	1.45842131	Nostocales	1161	Bacteria	Bacteria	88.2	8.92e-19	NR	WP_027846819.1	996925	g32977	i0	66.7	5.88957055214724	54	18	99.4	0	163	2	38	91	WP_027846819.1 TIGR02221 family CRISPR-associated protein [Mastigocoleus testarum]	diamond	960	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Mastigocoleus	Mastigocoleus testarum
28507521	28507521	PRJNA839281_S_NODE_35107_length_162_cov_0.902655_g34838_i0	PRJNA839281	35107	162	0.902655	1.4623011	Cyanobacteria bacterium M_surface_10_m2_179	2775528	Bacteria	Bacteria	60.5	5.75e-9	NR	MBM5807624.1	2775528	g34838	i0	76.3	0.703703703703704	38	9	70.4	0	2	115	271	308	MBM5807624.1 NAD(P)H-dependent glycerol-3-phosphate dehydrogenase [Cyanobacteria bacterium M_surface_10_m2_179]	diamond	114	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium M_surface_10_m2_179
28822896	28822896	PRJNA839281_S_NODE_14948_length_209_cov_1.468750_g14679_i0	PRJNA839281	14948	209	1.46875	3.0696875	Microcoleus sp. herbarium19	3055440	Bacteria	Bacteria	48.9	1.04e-4	NR	WP_333272797.1	3055440	g14679	i0	33.8	0.933014354066986	65	40	91.9	2	13	204	140	202	WP_333272797.1 hypothetical protein [Microcoleus sp. herbarium19]	diamond	195	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium19
28886196	28886196	PRJNA839281_S_NODE_34628_length_162_cov_2.141593_g34359_i0	PRJNA839281	34628	162	2.141593	3.46938066	Thermosynechococcaceae cyanobacterium MS004	2881380	Bacteria	Bacteria	42	0.0234	NR	MCG9891895.1	2881380	g34359	i0	50	0.777777777777778	42	19	74.1	1	34	153	21	62	MCG9891895.1 prohibitin family protein [Thermosynechococcaceae cyanobacterium MS004]	diamond	126	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae		Thermosynechococcaceae cyanobacterium MS004
29896854	29896854	PRJNA839281_S_NODE_31691_length_164_cov_0.886957_g31422_i0	PRJNA839281	31691	164	0.886957	1.45460948	Scytonema millei	1245922	Bacteria	Bacteria	48.9	7.63e-5	NR	WP_039714068.1	1245922	g31422	i0	42	0.914634146341463	50	29	91.5	0	4	153	181	230	WP_039714068.1 Clp protease N-terminal domain-containing protein [Scytonema millei]	diamond	150	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema millei
30654855	30654855	PRJNA839281_S_NODE_30433_length_165_cov_0.879310_g30164_i0	PRJNA839281	30433	165	0.87931	1.4508615	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	42	0.0241	NR	MEY3400504.1	2847862	g30164	i0	34.8	0.836363636363636	46	30	83.6	0	158	21	350	395	MEY3400504.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	138	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30718091	30718091	PRJNA839281_S_NODE_37154_length_161_cov_0.910714_g36885_i0	PRJNA839281	37154	161	0.910714	1.46624954	Allocoleopsis sp.	3088169	Bacteria	Bacteria	86.7	2.91e-18	NR	HEY9600056.1	3088169	g36885	i0	78.4	1.90062111801242	51	11	95	0	1	153	197	247	HEY9600056.1 TCR/Tet family MFS transporter [Allocoleopsis sp.]	diamond	306	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis sp.
30876151	30876151	PRJNA839281_S_NODE_30374_length_165_cov_0.879310_g30105_i0	PRJNA839281	30374	165	0.87931	1.4508615	Leptolyngbya sp. SIO3F4	2607780	Bacteria	Bacteria	70.5	1.29e-13	NR	NEQ50337.1	2607780	g30105	i0	61.2	1.78181818181818	49	19	89.1	0	16	162	61	109	NEQ50337.1 tyrosine-type recombinase/integrase [Leptolyngbya sp. SIO3F4]	diamond	294	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIO3F4
31065972	31065972	PRJNA839281_S_NODE_34015_length_163_cov_0.894737_g33746_i0	PRJNA839281	34015	163	0.894737	1.45842131	Chroococcidiopsis sp. SAG 2	3088168	Bacteria	Bacteria	91.3	2.06e-21	NR	WP_317112138.1	171389	g33746	i0	93.9	0.901840490797546	49	3	90.2	0	1	147	130	178	WP_317112138.1 GrpB family protein [Chroococcidiopsis sp. SAG 2025]	diamond	147	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
31476944	31476944	PRJNA839281_S_NODE_28076_length_166_cov_0.871795_g27807_i0	PRJNA839281	28076	166	0.871795	1.4471797	Aphanocapsa sp. GSE-SYN-MK-11-07L	2835086	Bacteria	Bacteria	95.5	2.06e-21	NR	MBW4550112.1	2835086	g27807	i0	83.3	0.975903614457831	54	9	97.6	0	164	3	92	145	MBW4550112.1 MFS transporter [Aphanocapsa sp. GSE-SYN-MK-11-07L]	diamond	162	95.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Aphanocapsa	Aphanocapsa sp. GSE-SYN-MK-11-07L
32331325	32331325	PRJNA839281_S_NODE_28319_length_166_cov_0.871795_g28050_i0	PRJNA839281	28319	166	0.871795	1.4471797	Chroococcus sp. CMT-3BRIN-NPC107	2499659	Bacteria	Bacteria	58.5	1.7e-9	NR	MBW4665364.1	2499659	g28050	i0	84.4	0.578313253012048	32	4	57.8	1	69	164	1	31	MBW4665364.1 hypothetical protein [Chroococcus sp. CMT-3BRIN-NPC107]	diamond	96	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. CMT-3BRIN-NPC107
32402769	32402769	PRJNA839281_S_NODE_28699_length_166_cov_0.871795_g28430_i0	PRJNA839281	28699	166	0.871795	1.4471797	Cyanophyceae	3028117	Bacteria	Bacteria	74.3	8.1e-15	NR	NET40366.1	2607788	g28430	i0	63.6	1.98795180722892	55	20	99.4	0	1	165	86	140	NET40366.1 TAXI family TRAP transporter solute-binding subunit [Cyanothece sp. SIO1E1]	diamond	330	74.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. SIO1E1
32561170	32561170	PRJNA839281_S_NODE_28499_length_166_cov_0.871795_g28230_i0	PRJNA839281	28499	166	0.871795	1.4471797	Cyanophyceae	3028117	Bacteria	Bacteria	99	1.09e-24	NR	WP_009458839.1	1190	g28230	i0	83.6	7.95180722891566	55	9	99.4	0	2	166	75	129	WP_009458839.1 MULTISPECIES: ribosome maturation factor RimP [Fischerella]	diamond	1320	100	0.99	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella

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