metadata: contig_metadata: 23 rows where bioproject = "PRJNA1174234" and tax_clade = "Cyanobacteriota/Melainabacteria group"

23 rows where bioproject = "PRJNA1174234" 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
1590803	1590803	PRJNA1174234_P_NODE_32122_length_246_cov_1.179191_g31926_i0	PRJNA1174234	32122	246	1.179191	2.90080986	Nostoc sp. C057	2576903	Bacteria	Bacteria	342	1.1799999999999997e-89	NTclustered	gi\|1866646741\|gb\|CP040281.1\|	2576903	g31926	i0	92.683	106.463414634146	246	4	100	6	1	246	443378	443609	Nostoc sp. C057 chromosome, complete genome	blastn	26190	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C057
4142990	4142990	PRJNA1174234_P_NODE_164_length_1977_cov_3.238971_g144_i0	PRJNA1174234	164	1977	3.238971	64.03445667	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	2987	0	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g144	i0	94.937	141.889731917046	1916	81	96	15	73	1977	33628	31718	Allocoleopsis franciscana PCC 7113, complete genome	blastn	280516	2987	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
4143110	4143110	PRJNA1174234_P_NODE_6124_length_550_cov_1.939203_g5928_i0	PRJNA1174234	6124	550	1.939203	10.6656165	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	894	0	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g5928	i0	96.029	153.210909090909	554	14	99	5	1	548	2626730	2626179	Allocoleopsis franciscana PCC 7113, complete genome	blastn	84266	894	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
4868998	4868998	PRJNA1174234_P_NODE_27764_length_258_cov_1.481081_g27568_i0	PRJNA1174234	27764	258	1.481081	3.82118898	Oscillatoriales	1150	Bacteria	Bacteria	435	2e-117	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g27568	i0	99.17	148.399224806202	241	2	95	0	1	241	101725	101965	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	38287	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
4869005	4869005	PRJNA1174234_P_NODE_33544_length_244_cov_0.900585_g33348_i0	PRJNA1174234	33544	244	0.900585	2.1974274	Nostoc	1177	Bacteria	Bacteria	291	4.28e-74	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g33348	i0	92.611	12.7786885245902	203	14	83	1	42	244	1414693	1414894	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	3118	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
5419203	5419203	PRJNA1174234_P_NODE_27345_length_261_cov_0.925532_g27149_i0	PRJNA1174234	27345	261	0.925532	2.41563852	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	224	4.77e-54	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g27149	i0	82.9	174.804597701149	269	26	100	19	1	261	1356	1612	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	45624	224	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
7969442	7969442	PRJNA1174234_P_NODE_35527_length_241_cov_0.916667_g35331_i0	PRJNA1174234	35527	241	0.916667	2.20916747	Nostoc edaphicum	264686	Bacteria	Bacteria	370	5.27e-98	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g35331	i0	94.561	21.8257261410788	239	13	99	0	3	241	7431874	7431636	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	5260	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
9244052	9244052	PRJNA1174234_P_NODE_24208_length_280_cov_1.096618_g24012_i0	PRJNA1174234	24208	280	1.096618	3.0705304	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	287	6.5e-73	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g24012	i0	85.211	37.3214285714286	284	36	100	5	1	280	2152089	2151808	Leptolyngbya sp. 7M chromosome	blastn	10450	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
9969043	9969043	PRJNA1174234_P_NODE_27148_length_262_cov_1.111111_g26952_i0	PRJNA1174234	27148	262	1.111111	2.91111082	Cyanophyceae	3028117	Bacteria	Bacteria	412	9.52e-111	NTclustered	gi\|1949996095\|gb\|CP046155.1\|	1115757	g26952	i0	95.057	211.709923664122	263	12	100	1	1	262	786089	785827	Leptolyngbya sp. BL0902 chromosome, complete genome	blastn	55468	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL0902
11794794	11794794	PRJNA1174234_P_NODE_4950_length_605_cov_2.270677_g4757_i0	PRJNA1174234	4950	605	2.270677	13.73759585	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	900	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g4757	i0	93.575	108.171900826446	607	33	100	4	1	605	2440	3042	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	65444	900	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13069692	13069692	PRJNA1174234_P_NODE_21531_length_298_cov_0.875556_g21335_i0	PRJNA1174234	21531	298	0.875556	2.60915688	Aliterella chasmolithica	2739056	Bacteria	Bacteria	379	1.12e-100	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g21335	i0	90.102	119.939597315436	293	27	98	2	7	298	2287	1996	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35742	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
14345007	14345007	PRJNA1174234_P_NODE_10432_length_427_cov_1.330508_g10236_i0	PRJNA1174234	10432	427	1.330508	5.68126916	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	593	5.449999999999998e-165	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g10236	i0	91.822	165.461358313817	428	32	100	3	1	427	453	28	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	70652	593	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
26616499	26616499	PRJNA1174234_P_NODE_22101_length_293_cov_2.754545_g21905_i0	PRJNA1174234	22101	293	2.754545	8.07081685	Bacillati	1783272	Bacteria	Bacteria	102	1.36e-23	NR	WP_015134806.1	111781	g21905	i0	66.2	8.38566552901024	74	25	75.8	0	71	292	2	75	WP_015134806.1 cysteine synthase A [[Leptolyngbya] sp. PCC 7376]	diamond	2457	103	0.990291262135922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Leptolyngbya] sp. PCC 7376
26648024	26648024	PRJNA1174234_P_NODE_28921_length_251_cov_1.640449_g28725_i0	PRJNA1174234	28921	251	1.640449	4.11752699	Nostocales	1161	Bacteria	Bacteria	133	7.09e-35	NR	MBW4635042.1	1494767	g28725	i0	78.3	4.9601593625498	83	18	99.2	0	250	2	21	103	MBW4635042.1 MFS transporter [Iphinoe sp. HA4291-MV1]	diamond	1245	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Iphinoe	Iphinoe sp. HA4291-MV1
26977224	26977224	PRJNA1174234_P_NODE_30982_length_248_cov_0.880000_g30786_i0	PRJNA1174234	30982	248	0.88	2.1824	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	142	2.52e-37	NR	WP_009631933.1	927677	g30786	i0	89	0.991935483870968	82	9	99.2	0	248	3	36	117	WP_009631933.1 beta strand repeat-containing protein [Synechocystis sp. PCC 7509]	diamond	246	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
28619787	28619787	PRJNA1174234_P_NODE_15167_length_354_cov_1.370107_g14971_i0	PRJNA1174234	15167	354	1.370107	4.85017878	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	60.5	4.57e-8	NR	MSR89129.1	2053573	g14971	i0	35.9	0.779661016949153	92	55	77.1	2	4	276	71	159	MSR89129.1 DUF1295 domain-containing protein [Candidatus Margulisiibacteriota bacterium]	diamond	276	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
28840532	28840532	PRJNA1174234_P_NODE_19228_length_315_cov_0.954545_g19032_i0	PRJNA1174234	19228	315	0.954545	3.00681675	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	64.3	8.68e-10	NR	WP_190774651.1	2650499	g19032	i0	37.7	1.2	69	43	65.7	0	87	293	136	204	WP_190774651.1 MULTISPECIES: glutathione S-transferase family protein [unclassified Leptolyngbya]	diamond	378	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
29156614	29156614	PRJNA1174234_P_NODE_24509_length_278_cov_1.214634_g24313_i0	PRJNA1174234	24509	278	1.214634	3.37668252	Calothrix sp. CCY 0018	3103864	Bacteria	Bacteria	62	9.12e-9	NR	WP_414625200.1	3103864	g24313	i0	33.8	1.80215827338129	77	51	83.1	0	239	9	369	445	WP_414625200.1 protein kinase domain-containing protein [Calothrix sp. CCY 0018]	diamond	501	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. CCY 0018
29914397	29914397	PRJNA1174234_P_NODE_31711_length_247_cov_0.885057_g31515_i0	PRJNA1174234	31711	247	0.885057	2.18609079	Nostoc sp.	1180	Bacteria	Bacteria	164	6.6e-45	NR	WP_324981494.1	1180	g31515	i0	96.3	0.983805668016194	81	3	98.4	0	3	245	609	689	WP_324981494.1 AAA family ATPase, partial [Nostoc sp.]	diamond	243	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
31968664	31968664	PRJNA1174234_P_NODE_25318_length_273_cov_1.155000_g25122_i0	PRJNA1174234	25318	273	1.155	3.15315	Scytonema sp. HK-	1204	Bacteria	Bacteria	51.2	5.03e-5	NR	WP_143173024.1	1137095	g25122	i0	65.6	0.351648351648352	32	11	35.2	0	272	177	157	188	WP_143173024.1 WD40 repeat domain-containing protein, partial [Scytonema sp. HK-05]	diamond	96	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HK-05
32367838	32367838	PRJNA1174234_P_NODE_11059_length_416_cov_0.892128_g10863_i0	PRJNA1174234	11059	416	0.892128	3.71125248	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	126	7.719999999999998e-32	NR	MBR8839220.1	221294	g10863	i0	46.4	6.07211538461539	138	71	99.5	2	415	2	195	329	MBR8839220.1 alkene reductase [Stigonema ocellatum SAG 48.90 = DSM 106950]	diamond	2526	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Stigonema	Stigonema ocellatum
32411848	32411848	PRJNA1174234_P_NODE_32759_length_245_cov_1.343023_g32563_i0	PRJNA1174234	32759	245	1.343023	3.29040635	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	62.4	2e-9	NR	MFN4149726.1	2762020	g32563	i0	46.6	0.710204081632653	58	28	71	1	3	176	175	229	MFN4149726.1 2-hydroxychromene-2-carboxylate isomerase [Candidatus Sericytochromatia bacterium]	diamond	174	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32758857	32758857	PRJNA1174234_P_NODE_4820_length_612_cov_1.730983_g4627_i0	PRJNA1174234	4820	612	1.730983	10.59361596	Dolichospermum sp.	2720786	Bacteria	Bacteria	146	9.94e-40	NR	MFN7661193.1	2720786	g4627	i0	86.4	0.397058823529412	81	11	39.7	0	610	368	41	121	MFN7661193.1 hypothetical protein [Dolichospermum sp.]	diamond	243	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum 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);;