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

28 rows where bioproject = "PRJNA385073", 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
2957326	2957326	PRJNA385073_P_NODE_8363_length_435_cov_2.889503_g8202_i0	PRJNA385073	8363	435	2.889503	12.56933805	Allocoleopsis sp.	3088169	Bacteria	Bacteria	122	5.9200000000000005e-33	NR	HEY9657652.1	3088169	g8202	i0	61	0.56551724137931	82	32	56.6	0	188	433	1	82	HEY9657652.1 hypothetical protein [Allocoleopsis sp.]	diamond	246	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis sp.
4232848	4232848	PRJNA385073_P_NODE_25044_length_294_cov_2.411765_g24882_i0	PRJNA385073	25044	294	2.411765	7.0905891	Prochlorococcus marinus	1219	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|123199600\|gb\|CP000552.1\|	167542	g24882	i0	100	0.0952380952380952	28	0	10	0	220	247	653994	653967	Prochlorococcus marinus str. MIT 9515, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
13159479	13159479	PRJNA385073_P_NODE_27131_length_287_cov_1.752336_g26969_i0	PRJNA385073	27131	287	1.752336	5.02920432	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	451	2.24e-122	NTclustered	gi\|225696178\|gb\|FJ805845.1\|	259957	g26969	i0	95.122	110.344947735192	287	12	100	2	1	287	2212	2496	Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31669	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15104240	15104240	PRJNA385073_P_NODE_65092_length_201_cov_4.703125_g64930_i0	PRJNA385073	65092	201	4.703125	9.45328125	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	146	1.4e-42	NR	WP_009632567.1	927677	g64930	i0	98.5	1	67	1	100	0	1	201	59	125	WP_009632567.1 CRISPR-associated protein Cas4 [Synechocystis sp. PCC 7509]	diamond	201	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
16983810	16983810	PRJNA385073_P_NODE_57434_length_242_cov_0.911243_g57272_i0	PRJNA385073	57434	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	161	6.1e-48	NR	MEN9870446.1	2847862	g57272	i0	92.5	1.98347107438017	80	6	99.2	0	242	3	130	209	MEN9870446.1 synthetase [Cyanobacteriota bacterium]	diamond	480	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
18257282	18257282	PRJNA385073_P_NODE_25975_length_290_cov_7.322581_g25813_i0	PRJNA385073	25975	290	7.322581	21.2354849	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	425	1.37e-114	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g25813	i0	93.151	99.3931034482759	292	16	100	4	1	290	3680015	3679726	Leptolyngbya sp. 7M chromosome	blastn	28824	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
18257888	18257888	PRJNA385073_P_NODE_55595_length_243_cov_0.905882_g55433_i0	PRJNA385073	55595	243	0.905882	2.20129326	uncultured cyanobacterium	1211	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874254044\|emb\|OY970368.1\|	1211	g55433	i0	100	0.11522633744856	28	0	12	0	72	99	1499725	1499698	MAG: uncultured cyanobacterium isolate MFD04716.bin.1.71 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22081866	22081866	PRJNA385073_P_NODE_11418_length_387_cov_2.324841_g11257_i0	PRJNA385073	11418	387	2.324841	8.99713467	Thermosynechococcus vestitus	146786	Bacteria	Bacteria	211	5.76e-50	NTclustered	gi\|47118315\|dbj\|BA000039.2\|	197221	g11257	i0	85.859	8.6640826873385	198	28	51	0	110	307	2311600	2311403	Thermosynechococcus elongatus BP-1 DNA, complete genome	blastn	3353	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus vestitus
26822174	26822174	PRJNA385073_P_NODE_28361_length_283_cov_3.142857_g28199_i0	PRJNA385073	28361	283	3.142857	8.89428531	Calothrix sp. SM1_5_4	2720460	Bacteria	Bacteria	77.8	1.38e-14	NR	NJL25388.1	2720460	g28199	i0	56.2	0.773851590106007	73	32	77.4	0	29	247	235	307	NJL25388.1 threonylcarbamoyl-AMP synthase [Calothrix sp. SM1_5_4]	diamond	219	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. SM1_5_4
27770371	27770371	PRJNA385073_P_NODE_18924_length_325_cov_1.527778_g18762_i0	PRJNA385073	18924	325	1.527778	4.9652785	Cyanobacteria bacterium P01_G01_bin.19	3023302	Bacteria	Bacteria	53.9	9.41e-7	NR	MEM8831954.1	3023302	g18762	i0	34.1	0.84	91	52	76.6	1	270	22	1	91	MEM8831954.1 hypothetical protein [Cyanobacteria bacterium P01_G01_bin.19]	diamond	273	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_G01_bin.19
27787215	27787215	PRJNA385073_P_NODE_21584_length_310_cov_3.518987_g21422_i0	PRJNA385073	21584	310	3.518987	10.9088597	Aphanizomenon	1175	Bacteria	Bacteria	75.5	2.72e-13	NR	OBQ45619.1	1710896	g21422	i0	63.3	0.948387096774194	49	18	47.4	0	309	163	816	864	OBQ45619.1 MAG: hypothetical protein AN484_01235 [Aphanizomenon flos-aquae WA102]	diamond	294	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
28117338	28117338	PRJNA385073_P_NODE_33125_length_270_cov_2.284264_g32963_i0	PRJNA385073	33125	270	2.284264	6.1675128	Calothrix parasitica NIES-267	1973488	Bacteria	Bacteria	63.5	2.45e-9	NR	BAY86391.1	1973488	g32963	i0	49.1	0.633333333333333	57	26	63.3	1	49	219	409	462	BAY86391.1 serine/threonine protein kinase [Calothrix parasitica NIES-267]	diamond	171	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parasitica
28180402	28180402	PRJNA385073_P_NODE_37646_length_259_cov_1.967742_g37484_i0	PRJNA385073	37646	259	1.967742	5.09645178	Calothrix sp. SM1_5_4	2720460	Bacteria	Bacteria	42.7	0.0319	NR	NJL25819.1	2720460	g37484	i0	52.4	0.486486486486487	42	18	46.3	1	124	5	1	42	NJL25819.1 hypothetical protein [Calothrix sp. SM1_5_4]	diamond	126	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. SM1_5_4
28228812	28228812	PRJNA385073_P_NODE_46826_length_248_cov_0.880000_g46664_i0	PRJNA385073	46826	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	154	1.6e-44	NR	WP_280690966.1	75695	g46664	i0	90.2	1.98387096774194	82	8	99.2	0	3	248	119	200	WP_280690966.1 T9SS type A sorting domain-containing protein, partial [Umezakia ovalisporum]	diamond	492	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Umezakia	Umezakia ovalisporum
29001956	29001956	PRJNA385073_P_NODE_38148_length_258_cov_1.605405_g37986_i0	PRJNA385073	38148	258	1.605405	4.1419449	Trichormus sp.	3088172	Bacteria	Bacteria	108	2.4e-27	NR	HEY9717286.1	3088172	g37986	i0	65.5	0.976744186046512	84	29	97.7	0	2	253	108	191	HEY9717286.1 sigma-70 family RNA polymerase sigma factor [Trichormus sp.]	diamond	252	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus sp.
29145034	29145034	PRJNA385073_P_NODE_38969_length_256_cov_1.677596_g38807_i0	PRJNA385073	38969	256	1.677596	4.29464576	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	43.1	0.0281	NR	WP_051469894.1	1173024	g38807	i0	61.3	1.13671875	31	12	36.3	0	95	3	4	34	WP_051469894.1 ABC transporter permease [Fischerella sp. PCC 9605]	diamond	291	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. PCC 9605
29253914	29253914	PRJNA385073_P_NODE_38369_length_257_cov_2.755435_g38207_i0	PRJNA385073	38369	257	2.755435	7.08146795	Calothrix sp. SM1_5_4	2720460	Bacteria	Bacteria	82.4	4.63e-17	NR	NJL24223.1	2720460	g38207	i0	54.9	0.828793774319066	71	31	82.9	1	255	43	148	217	NJL24223.1 hypothetical protein [Calothrix sp. SM1_5_4]	diamond	213	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. SM1_5_4
29790696	29790696	PRJNA385073_P_NODE_58931_length_241_cov_0.916667_g58769_i0	PRJNA385073	58931	241	0.916667	2.20916747	Cyanobacteria bacterium UBA11367	2055774	Bacteria	Bacteria	47.8	6.34e-4	NR	HBE18313.1	2055774	g58769	i0	62.5	0.398340248962656	32	12	39.8	0	146	241	794	825	HBE18313.1 hypothetical protein [Cyanobacteria bacterium UBA11367]	diamond	96	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11367
30945267	30945267	PRJNA385073_P_NODE_40874_length_252_cov_1.284916_g40712_i0	PRJNA385073	40874	252	1.284916	3.23798832	Bacillati	1783272	Bacteria	Bacteria	105	2.1599999999999998e-24	NR	MBA3858136.1	2067978	g40712	i0	59.8	3.78571428571429	82	33	97.6	0	247	2	265	346	MBA3858136.1 secretion protein HlyD [Cyanobacteria bacterium PR.3.49]	diamond	954	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.3.49
30959955	30959955	PRJNA385073_P_NODE_57514_length_242_cov_0.911243_g57352_i0	PRJNA385073	57514	242	0.911243	2.20520806	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	64.3	9.25e-10	NR	MBS2001349.1	2807734	g57352	i0	43	1.06611570247934	86	43	99.2	2	3	242	428	513	MBS2001349.1 HAMP domain-containing histidine kinase [Cyanobacteria bacterium SZAS LIN-5]	diamond	258	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
31134391	31134391	PRJNA385073_P_NODE_30055_length_279_cov_1.252427_g29893_i0	PRJNA385073	30055	279	1.252427	3.49427133	Cyanophyceae	3028117	Bacteria	Bacteria	87.4	5.25e-18	NR	NEO40436.1	2607817	g29893	i0	52.3	5.64516129032258	88	28	91.4	3	3	257	259	335	NEO40436.1 formylglycine-generating enzyme family protein [Moorena sp. SIOASIH]	diamond	1575	87.8	0.995444191343964	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIOASIH
31212205	31212205	PRJNA385073_P_NODE_40515_length_252_cov_3.067039_g40353_i0	PRJNA385073	40515	252	3.067039	7.72893828	Calothrix sp. SM1_5_4	2720460	Bacteria	Bacteria	144	2.3299999999999998e-38	NR	NJL24372.1	2720460	g40353	i0	73.8	2	84	22	100	0	1	252	327	410	NJL24372.1 cell wall-associated protein wapA [Calothrix sp. SM1_5_4]	diamond	504	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. SM1_5_4
31244211	31244211	PRJNA385073_P_NODE_55415_length_243_cov_0.905882_g55253_i0	PRJNA385073	55415	243	0.905882	2.20129326	Planktothrix sp.	3088171	Bacteria	Bacteria	107	3.9099999999999997e-28	NR	HEY9778352.1	3088171	g55253	i0	66.7	1	81	26	100	1	243	1	12	91	HEY9778352.1 hypothetical protein [Planktothrix sp.]	diamond	243	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp.
31261190	31261190	PRJNA385073_P_NODE_39635_length_254_cov_3.022099_g39473_i0	PRJNA385073	39635	254	3.022099	7.67613146	Cyanophyceae	3028117	Bacteria	Bacteria	107	7.79e-25	NR	WP_190569663.1	1521621	g39473	i0	65.9	14.5275590551181	82	27	95.7	1	252	10	1017	1098	WP_190569663.1 non-ribosomal peptide synthetase [Nostoc parmelioides]	diamond	3690	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc parmelioides
31275829	31275829	PRJNA385073_P_NODE_33995_length_268_cov_1.579487_g33833_i0	PRJNA385073	33995	268	1.579487	4.23302516	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	76.3	7.32e-14	NR	HEY9755838.1	3088181	g33833	i0	47	0.92910447761194	83	43	91.8	1	266	21	358	440	HEY9755838.1 efflux RND transporter periplasmic adaptor subunit [Oculatellaceae cyanobacterium]	diamond	249	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
31402582	31402582	PRJNA385073_P_NODE_33176_length_270_cov_1.954315_g33014_i0	PRJNA385073	33176	270	1.954315	5.2766505	Cyanobacteria bacterium PR.3.49	2067978	Bacteria	Bacteria	92.8	1.03e-19	NR	MBA3857487.1	2067978	g33014	i0	82.1	2.48888888888889	56	10	62.2	0	169	2	209	264	MBA3857487.1 2-nitropropane dioxygenase [Cyanobacteria bacterium PR.3.49]	diamond	672	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.3.49
31767150	31767150	PRJNA385073_P_NODE_42377_length_251_cov_0.865169_g42215_i0	PRJNA385073	42377	251	0.865169	2.17157419	Synechococcus	1129	Bacteria	Bacteria	42.7	0.0397	NR	WP_011432368.1	321332	g42215	i0	42.6	1.12350597609562	47	25	53.8	1	139	5	261	307	WP_011432368.1 HD domain-containing phosphohydrolase [Synechococcus sp. JA-2-3B'a(2-13)]	diamond	282	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. JA-2-3B'a(2-13)
31781810	31781810	PRJNA385073_P_NODE_52637_length_244_cov_3.210526_g52475_i0	PRJNA385073	52637	244	3.210526	7.83368344	Cyanobium sp.	2164130	Bacteria	Bacteria	44.3	0.00935	NR	MFM7265693.1	2164130	g52475	i0	45.2	1.67213114754098	73	30	78.7	4	229	38	160	231	MFM7265693.1 glycosyltransferase family 2 protein [Cyanobium sp.]	diamond	408	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium 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);;