metadata: contig_metadata: 14 rows where bioproject = "PRJNA195897", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

14 rows where bioproject = "PRJNA195897", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
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
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
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
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
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

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