metadata: contig_metadata: 27 rows where bioproject = "PRJNA795983" and tax_clade = "Cyanobacteriota/Melainabacteria group"

27 rows where bioproject = "PRJNA795983" 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
4608397	4608397	PRJNA795983_S_NODE_18204_length_317_cov_1.475410_g18079_i0	PRJNA795983	18204	317	1.47541	4.6770497	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	387	7.17e-103	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g18079	i0	88.785	276.889589905363	321	28	100	7	1	317	4390989	4391305	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	87774	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
5044648	5044648	PRJNA795983_S_NODE_25264_length_284_cov_1.454976_g25139_i0	PRJNA795983	25264	284	1.454976	4.1321318399999996	Chroococcidiopsis	54298	Bacteria	Bacteria	357	4.96e-94	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g25139	i0	89.51	148.552816901408	286	24	99	4	1	282	795218	795501	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	42189	357	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5044660	5044660	PRJNA795983_S_NODE_39504_length_245_cov_2.406977_g39379_i0	PRJNA795983	39504	245	2.406977	5.89709365	Gloeocapsopsis	693222	Bacteria	Bacteria	392	1.15e-104	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g39379	i0	99.083	115.930612244898	218	2	89	0	6	223	2928	3145	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28403	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
10984008	10984008	PRJNA795983_S_NODE_21149_length_302_cov_1.152838_g21024_i0	PRJNA795983	21149	302	1.152838	3.48157076	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	186	3.77e-58	NR	MBX9724270.1	2364082	g21024	i0	91	1.98675496688742	100	9	99.3	0	301	2	71	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	600	186	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
13533830	13533830	PRJNA795983_S_NODE_37171_length_249_cov_0.875000_g37046_i0	PRJNA795983	37171	249	0.875	2.17875	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	355	1.53e-93	NTclustered	gi\|2245130261\|gb\|CP097481.1\|	2653189	g37046	i0	92.369	1	249	19	100	0	1	249	282107	282355	Chroococcidiopsis sp. CCNUC1 plasmid pA, complete sequence	blastn	249	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
13970462	13970462	PRJNA795983_S_NODE_33431_length_257_cov_1.673913_g33306_i0	PRJNA795983	33431	257	1.673913	4.30195641	Chroococcidiopsis	54298	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g33306	i0	100	165.112840466926	257	0	100	0	1	257	810	1066	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	42434	475	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16082779	16082779	PRJNA795983_S_NODE_4893_length_505_cov_2.145833_g4769_i0	PRJNA795983	4893	505	2.145833	10.83645665	Cyanobium sp. ARS6	2024869	Bacteria	Bacteria	219	8.01e-70	NR	CAI8350359.1	2024869	g4769	i0	70.3	2.63762376237624	148	44	87.9	0	475	32	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
22457426	22457426	PRJNA795983_S_NODE_42338_length_242_cov_0.911243_g42213_i0	PRJNA795983	42338	242	0.911243	2.20520806	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	353	5.34e-93	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g42213	i0	92.975	1	242	17	100	0	1	242	2431501	2431260	Allocoleopsis franciscana PCC 7113, complete genome	blastn	242	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
23732763	23732763	PRJNA795983_S_NODE_11059_length_375_cov_1.529801_g10934_i0	PRJNA795983	11059	375	1.529801	5.73675375	Cyanobacterium sp. HL-69	2054282	Bacteria	Bacteria	76.8	2.12e-9	NTclustered	gi\|1298149266\|gb\|CP024912.1\|	2054282	g10934	i0	79.646	0.301333333333333	113	18	30	5	162	272	849429	849320	Cyanobacterium sp. HL-69 chromosome, complete genome	blastn	113	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium sp. HL-69
23732947	23732947	PRJNA795983_S_NODE_29399_length_270_cov_0.857868_g29274_i0	PRJNA795983	29399	270	0.857868	2.3162436	Nostoc sp. UHCC 0926	3025190	Bacteria	Bacteria	453	5.810000000000001e-123	NTclustered	gi\|2444439127\|gb\|CP117768.1\|	3025190	g29274	i0	97.048	285.862962962963	271	4	99	4	2	270	3627475	3627743	Nostoc sp. UHCC 0926 chromosome, complete genome	blastn	77183	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0926
27338404	27338404	PRJNA795983_S_NODE_43783_length_235_cov_2.820988_g43658_i0	PRJNA795983	43783	235	2.820988	6.6293218	Rivularia sp. MS3	3012223	Bacteria	Bacteria	51.2	3.53e-5	NR	MBV6624128.1	3012223	g43658	i0	40	0.893617021276596	70	40	89.4	1	25	234	36	103	MBV6624128.1 DUF4114 domain-containing protein [Rivularia sp. MS3]	diamond	210	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. MS3
27884219	27884219	PRJNA795983_S_NODE_37345_length_249_cov_0.875000_g37220_i0	PRJNA795983	37345	249	0.875	2.17875	Cyanophyceae	3028117	Bacteria	Bacteria	61.6	7.21e-9	NR	MBC6420387.1	2653674	g37220	i0	57.1	11.3253012048193	49	21	59	0	147	1	175	223	MBC6420387.1 NAD(+) kinase [Hormoscilla sp. SP12CHS1]	diamond	2820	62	0.993548387096774	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	Hormoscilla sp. SP12CHS1
28443615	28443615	PRJNA795983_S_NODE_19286_length_311_cov_1.693277_g19161_i0	PRJNA795983	19286	311	1.693277	5.26609147	Nostoc sphaeroides	446679	Bacteria	Bacteria	53.1	1.75e-5	NR	WP_118171756.1	446679	g19161	i0	37.4	0.877813504823151	91	53	87.8	1	27	299	220	306	WP_118171756.1 cytochrome P450 [Nostoc sphaeroides]	diamond	273	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
28538378	28538378	PRJNA795983_S_NODE_20767_length_304_cov_0.982684_g20642_i0	PRJNA795983	20767	304	0.982684	2.98735936	Synechococcus sp. MIT S9451	3082543	Bacteria	Bacteria	80.9	3.16e-15	NR	WP_413744073.1	3082543	g20642	i0	57.5	2.15131578947368	73	28	72	1	221	3	1816	1885	WP_413744073.1 cadherin-like domain-containing protein [Synechococcus sp. MIT S9451]	diamond	654	80.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. MIT S9451
28569661	28569661	PRJNA795983_S_NODE_38807_length_246_cov_2.560694_g38682_i0	PRJNA795983	38807	246	2.560694	6.29930724	uncultured Synechococcus sp.	154535	Bacteria	Bacteria	158	4.5599999999999985e-43	NR	WP_288916497.1	154535	g38682	i0	96.3	2.96341463414634	81	3	98.8	0	2	244	576	656	WP_288916497.1 30S ribosomal protein S12 [uncultured Synechococcus sp.]	diamond	729	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	uncultured Synechococcus sp.
28862918	28862918	PRJNA795983_S_NODE_44368_length_229_cov_2.576923_g44243_i0	PRJNA795983	44368	229	2.576923	5.90115367	Calothrix	1186	Bacteria	Bacteria	55.1	1.38e-6	NR	BAY80701.1	1973488	g44243	i0	37.7	7.46724890829694	69	38	83.8	1	192	1	45	113	BAY80701.1 dehydrogenase containing FAD binding domain protein [Calothrix parasitica NIES-267]	diamond	1710	55.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parasitica
29959028	29959028	PRJNA795983_S_NODE_35611_length_251_cov_1.893258_g35486_i0	PRJNA795983	35611	251	1.893258	4.75207758	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	64.7	1.52e-10	NR	MBL8086383.1	2711154	g35486	i0	56.7	0.800796812749004	67	21	80.1	2	50	250	61	119	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	201	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30211637	30211637	PRJNA795983_S_NODE_9152_length_401_cov_1.341463_g9027_i0	PRJNA795983	9152	401	1.341463	5.37926663	Okeania sp. SIO2C9	2607791	Bacteria	Bacteria	63.2	1.36e-8	NR	WP_293154749.1	2607791	g9027	i0	33.9	0.860349127182045	115	72	86	1	6	350	68	178	WP_293154749.1 glycosyltransferase family 4 protein [Okeania sp. SIO2C9]	diamond	345	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO2C9
30401840	30401840	PRJNA795983_S_NODE_20333_length_306_cov_1.150215_g20208_i0	PRJNA795983	20333	306	1.150215	3.5196579	Coleofasciculaceae cyanobacterium SM2_3_26	2720472	Bacteria	Bacteria	43.1	0.0413	NR	NJK27803.1	2720472	g20208	i0	58.6	0.284313725490196	29	12	28.4	0	229	143	178	206	NJK27803.1 CHAD domain-containing protein [Coleofasciculaceae cyanobacterium SM2_3_26]	diamond	87	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium SM2_3_26
31285992	31285992	PRJNA795983_S_NODE_14415_length_342_cov_1.572491_g14290_i0	PRJNA795983	14415	342	1.572491	5.37791922	Leptolyngbyaceae cyanobacterium JSC-12	864702	Bacteria	Bacteria	92.8	3.02e-19	NR	EKQ68290.1	864702	g14290	i0	37.3	0.964912280701754	110	65	96.5	1	3	332	287	392	EKQ68290.1 NAD-dependent aldehyde dehydrogenase [Leptolyngbyaceae cyanobacterium JSC-12]	diamond	330	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium JSC-12
31760525	31760525	PRJNA795983_S_NODE_31437_length_263_cov_1.621053_g31312_i0	PRJNA795983	31437	263	1.621053	4.26336939	Oculatellaceae cyanobacterium Prado106	2929566	Bacteria	Bacteria	60.8	2.06e-8	NR	MCU0566371.1	2929566	g31312	i0	43	0.901140684410646	79	42	90.1	2	242	6	1175	1250	MCU0566371.1 DUF4347 domain-containing protein [Oculatellaceae cyanobacterium Prado106]	diamond	237	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium Prado106
31792007	31792007	PRJNA795983_S_NODE_8817_length_406_cov_2.048048_g8692_i0	PRJNA795983	8817	406	2.048048	8.31507488	Limnospira platensis	118562	Bacteria	Bacteria	211	5.11e-68	NR	MDV7395947.1	3080829	g8692	i0	84.7	0.87192118226601	118	15	87.2	1	404	51	4	118	MDV7395947.1 citrate/2-methylcitrate synthase [Arthrospira platensis SPKY1]	diamond	354	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
31918758	31918758	PRJNA795983_S_NODE_37857_length_248_cov_0.880000_g37732_i0	PRJNA795983	37857	248	0.88	2.1824	Scytonema sp. PMC 1069.18	2684455	Bacteria	Bacteria	61.2	1.18e-8	NR	MEC4814498.1	2684455	g37732	i0	67.3	0.592741935483871	49	16	59.3	0	3	149	164	212	MEC4814498.1 DUF4335 domain-containing protein [Scytonema sp. PMC 1069.18]	diamond	147	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PMC 1069.18
31950273	31950273	PRJNA795983_S_NODE_12637_length_357_cov_2.140845_g12512_i0	PRJNA795983	12637	357	2.140845	7.64281665	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	45.1	0.02	NR	MEL7079402.1	3023143	g12512	i0	32.5	1.77310924369748	83	45	60.5	2	6	221	229	311	MEL7079402.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2]	diamond	633	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2
31950298	31950298	PRJNA795983_S_NODE_617_length_1129_cov_4.502841_g562_i0	PRJNA795983	617	1129	4.502841	50.83707489	Heteroscytonema crispum	439476	Bacteria	Bacteria	348	1.5899999999999998e-113	NR	MFH7027526.1	1735366	g562	i0	49.3	8.47121346324181	355	171	91.9	4	6	1043	95	449	MFH7027526.1 DUF6851 domain-containing protein [Heteroscytonema crispum UTEX LB 1556]	diamond	9564	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Heteroscytonemataceae	Heteroscytonema	Heteroscytonema crispum
32456821	32456821	PRJNA795983_S_NODE_19459_length_310_cov_1.763713_g19334_i0	PRJNA795983	19459	310	1.763713	5.4675103	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	43.1	0.0472	NR	MEB3259607.1	2847862	g19334	i0	38.9	0.52258064516129	54	24	52.3	1	14	175	166	210	MEB3259607.1 phosphoribosylanthranilate isomerase [Cyanobacteriota bacterium]	diamond	162	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32465997	32465997	PRJNA795983_S_NODE_29279_length_270_cov_1.441624_g29154_i0	PRJNA795983	29279	270	1.441624	3.8923848	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	45.4	0.00574	NR	MCC5645442.1	2780402	g29154	i0	44.1	1.51111111111111	59	22	53.3	2	124	267	147	205	MCC5645442.1 hypothetical protein [Nostoc sp. CHAB 5824]	diamond	408	45.8	0.991266375545852	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5824

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