metadata: contig_metadata: 24 rows where bioproject = "PRJNA195897" and tax_clade = "Cyanobacteriota/Melainabacteria group"

24 rows where bioproject = "PRJNA195897" 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
2916670	2916670	PRJNA195897_P_NODE_443_length_803_cov_1.472149_g416_i0	PRJNA195897	443	803	1.472149	11.82135647	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	90.9	2.7e-18	NR	MBL8086383.1	2711154	g416	i0	80.4	0.209215442092154	56	11	20.9	0	168	1	58	113	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	168	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
4193064	4193064	PRJNA195897_P_NODE_2844_length_293_cov_1.065574_g2811_i0	PRJNA195897	2844	293	1.065574	3.12213182	Cyanophyceae	3028117	Bacteria	Bacteria	114	3.53e-29	NR	WP_277866285.1	1522304	g2811	i0	66.7	9.48122866894198	78	26	79.9	0	57	290	1	78	WP_277866285.1 peroxiredoxin [Candidatus Synechococcus calcipolaris]	diamond	2778	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Candidatus Synechococcus calcipolaris
6743642	6743642	PRJNA195897_P_NODE_246_length_1028_cov_1.882533_g227_i0	PRJNA195897	246	1028	1.882533	19.35243924	Nostocaceae	1162	Bacteria	Bacteria	88.2	6.3e-15	NR	WP_016951150.1	163908	g227	i0	33.2	1.715953307393	196	125	55.7	4	1027	455	332	526	WP_016951150.1 Calx-beta domain-containing protein [Anabaena sp. PCC 7108]	diamond	1764	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. PCC 7108
22042581	22042581	PRJNA195897_P_NODE_1278_length_469_cov_1.609524_g1246_i0	PRJNA195897	1278	469	1.609524	7.54866756	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	243	1.09e-75	NR	WP_026732738.1	1173024	g1246	i0	76.1	13.8805970149254	155	35	99.1	1	467	3	176	328	WP_026732738.1 isocitrate lyase [Fischerella sp. PCC 9605]	diamond	6510	244	0.995901639344262	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. PCC 9605
22042656	22042656	PRJNA195897_P_NODE_918_length_558_cov_12.261297_g887_i0	PRJNA195897	918	558	12.261297	68.41803726	Cyanobium sp. ARS6	2024869	Bacteria	Bacteria	219	2.19e-69	NR	CAI8350359.1	2024869	g887	i0	70.3	2.38709677419355	148	44	79.6	0	511	68	46	193	CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6]	diamond	1332	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ARS6
27136723	27136723	PRJNA195897_P_NODE_1182_length_490_cov_2.285714_g1151_i0	PRJNA195897	1182	490	2.285714	11.1999986	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	240	8.899999999999999e-75	NR	MBX3149802.1	2364082	g1151	i0	67.3	4.86734693877551	159	52	97.3	0	477	1	154	312	MBX3149802.1 NAD(P)-binding domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	2385	240	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27642816	27642816	PRJNA195897_P_NODE_12804_length_154_cov_2.209524_g12771_i0	PRJNA195897	12804	154	2.209524	3.40266696	Pleurocapsa sp. SU_196_0	2720476	Bacteria	Bacteria	74.3	7.87e-14	NR	NJK44942.1	2720476	g12771	i0	68.6	0.993506493506494	51	16	99.4	0	1	153	316	366	NJK44942.1 nicotinate phosphoribosyltransferase [Pleurocapsa sp. SU_196_0]	diamond	153	74.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. SU_196_0
27755388	27755388	PRJNA195897_P_NODE_884_length_568_cov_3.055877_g854_i0	PRJNA195897	884	568	3.055877	17.35738136	Bacteria	2	Bacteria	Bacteria	95.1	7e-19	NR	WP_016951956.1	163908	g854	i0	39.1	1.93838028169014	184	99	96.1	5	568	23	887	1059	WP_016951956.1 S8 family peptidase [Anabaena sp. PCC 7108]	diamond	1101	95.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. PCC 7108
27926784	27926784	PRJNA195897_P_NODE_7505_length_182_cov_1.533835_g7472_i0	PRJNA195897	7505	182	1.533835	2.7915797	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	59.3	7.17e-9	NR	MBL8086383.1	2711154	g7472	i0	63.8	0.774725274725275	47	16	77.5	1	175	35	98	143	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	141	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28418394	28418394	PRJNA195897_P_NODE_626_length_685_cov_8.883648_g596_i0	PRJNA195897	626	685	8.883648	60.8529888	Bacillati	1783272	Bacteria	Bacteria	67.8	5.17e-10	NR	WP_168694645.1	1166	g596	i0	60.4	0.398540145985401	48	19	21	0	97	240	38	85	WP_168694645.1 AbfB domain-containing protein [Dolichospermum flos-aquae]	diamond	273	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum flos-aquae
29662972	29662972	PRJNA195897_P_NODE_1050_length_520_cov_2.524416_g1019_i0	PRJNA195897	1050	520	2.524416	13.1269632	unclassified Microcoleus	2642155	Bacteria	Bacteria	120	2.3399999999999997e-31	NR	WP_333266733.1	2642155	g1019	i0	44.3	0.859615384615385	149	78	83.1	2	469	38	6	154	WP_333266733.1 MULTISPECIES: hypothetical protein [unclassified Microcoleus]	diamond	447	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus
29820988	29820988	PRJNA195897_P_NODE_6351_length_195_cov_1.424658_g6318_i0	PRJNA195897	6351	195	1.424658	2.7780831	Nostoc commune	1178	Bacteria	Bacteria	53.1	2.47e-6	NR	WP_196524438.1	1178	g6318	i0	43.6	0.846153846153846	55	25	84.6	1	11	175	72	120	WP_196524438.1 CAP domain-containing protein, partial [Nostoc commune]	diamond	165	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
29902295	29902295	PRJNA195897_P_NODE_9851_length_167_cov_1.305085_g9818_i0	PRJNA195897	9851	167	1.305085	2.17949195	Cyanobacteriota	1117	Bacteria	Bacteria	60.1	9.75e-9	NR	MEB3284567.1	2762020	g9818	i0	55.8	3.75449101796407	52	23	93.4	0	157	2	199	250	MEB3284567.1 4-hydroxyphenylpyruvate dioxygenase [Candidatus Sericytochromatia bacterium]	diamond	627	60.5	0.993388429752066	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
30358784	30358784	PRJNA195897_P_NODE_10792_length_165_cov_1.344828_g10759_i0	PRJNA195897	10792	165	1.344828	2.2189662	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	62	5.22e-10	NR	MBL8086383.1	2711154	g10759	i0	77.8	0.654545454545455	36	8	65.5	0	164	57	109	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	108	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30516260	30516260	PRJNA195897_P_NODE_2233_length_339_cov_1.600000_g2200_i0	PRJNA195897	2233	339	1.6	5.424	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	45.1	0.0139	NR	HEY9814218.1	2364082	g2200	i0	31.8	0.778761061946903	88	40	77	4	77	337	40	108	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	264	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30927234	30927234	PRJNA195897_P_NODE_7114_length_187_cov_1.043478_g7081_i0	PRJNA195897	7114	187	1.043478	1.95130386	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	70.5	4e-13	NR	MBL8086383.1	2711154	g7081	i0	68	0.802139037433155	50	16	80.2	0	187	38	95	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	150	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31053693	31053693	PRJNA195897_P_NODE_2775_length_297_cov_2.967742_g2742_i0	PRJNA195897	2775	297	2.967742	8.81419374	Leptolyngbyaceae cyanobacterium C42_A2020_001	2811131	Bacteria	Bacteria	52	3.6e-5	NR	MBF2028644.1	2811131	g2742	i0	41.4	1.75757575757576	58	34	58.6	0	175	2	21	78	MBF2028644.1 fatty acid desaturase [Leptolyngbyaceae cyanobacterium C42_A2020_001]	diamond	522	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium C42_A2020_001
31622505	31622505	PRJNA195897_P_NODE_6396_length_195_cov_1.061644_g6363_i0	PRJNA195897	6396	195	1.061644	2.0702058	Gloeothece citriformis	2546356	Bacteria	Bacteria	62.8	1.66e-9	NR	WP_015954287.1	2546356	g6363	i0	45.3	0.984615384615385	64	34	96.9	1	2	190	210	273	WP_015954287.1 pyridoxal phosphate-dependent decarboxylase family protein [Gloeothece citriformis]	diamond	192	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece citriformis
31798280	31798280	PRJNA195897_P_NODE_3977_length_240_cov_2.246073_g3944_i0	PRJNA195897	3977	240	2.246073	5.3905752	Bacteria	2	Bacteria	Bacteria	100	4.03e-24	NR	WP_413174192.1	197653	g3944	i0	65.8	18.225	76	23	95	1	235	8	138	210	WP_413174192.1 SDR family oxidoreductase [Anabaena azotica]	diamond	4374	101	0.99009900990099	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica
31956593	31956593	PRJNA195897_P_NODE_6717_length_191_cov_1.098592_g6684_i0	PRJNA195897	6717	191	1.098592	2.09831072	Cyanophyceae	3028117	Bacteria	Bacteria	109	1.17e-28	NR	WP_224410038.1	331517	g6684	i0	77.8	13.8534031413613	63	14	99	0	3	191	56	118	WP_224410038.1 nucleoside-diphosphate kinase [Oscillatoria salina]	diamond	2646	110	0.990909090909091	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria salina
32287255	32287255	PRJNA195897_P_NODE_12459_length_162_cov_0.920354_g12426_i0	PRJNA195897	12459	162	0.920354	1.49097348	Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11	1801609	Bacteria	Bacteria	52.4	4.81e-6	NR	OGI09100.1	1801609	g12426	i0	58.3	0.666666666666667	36	15	66.7	0	108	1	125	160	OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11]	diamond	108	52.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11
32350419	32350419	PRJNA195897_P_NODE_199_length_1113_cov_2.134398_g183_i0	PRJNA195897	199	1113	2.134398	23.75584974	Microcystis sp. BLCC-F21	1127	Bacteria	Bacteria	126	1.7300000000000003e-27	NR	WP_375329244.1	3342751	g183	i0	33.4	6.45822102425876	335	199	87.1	8	1072	104	1246	1568	WP_375329244.1 Calx-beta domain-containing protein [Microcystis sp. BLCC-F210]	diamond	7188	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. BLCC-F210
32381930	32381930	PRJNA195897_P_NODE_7959_length_178_cov_1.170543_g7926_i0	PRJNA195897	7959	178	1.1705429999999999	2.08356654	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	72.4	6.12e-14	NR	MBL8086383.1	2711154	g7926	i0	63.8	0.97752808988764	58	20	97.8	1	176	3	71	127	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	174	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32540298	32540298	PRJNA195897_P_NODE_11699_length_164_cov_0.860870_g11666_i0	PRJNA195897	11699	164	0.86087	1.4118268	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	55.5	1.64e-7	NR	MBL8086383.1	2711154	g11666	i0	75	0.585365853658537	32	8	58.5	0	162	67	113	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	96	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.

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