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

23 rows where bioproject = "PRJNA1031674" 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
7819515	7819515	PRJNA1031674_P_NODE_447_length_1114_cov_3.278578_g302_i0	PRJNA1031674	447	1114	3.278578	36.52335892	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1469	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g302	i0	90.721	120.259425493716	1110	91	99	9	12	1114	1780	2884	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	133969	1469	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9094377	9094377	PRJNA1031674_P_NODE_29348_length_199_cov_4.055556_g29137_i0	PRJNA1031674	29348	199	4.055556	8.07055644	Stenomitos frigidus	1886765	Bacteria	Bacteria	305	1.2e-78	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g29137	i0	94.472	158.51256281407	199	10	100	1	1	199	18889	19086	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	31544	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus
12485800	12485800	PRJNA1031674_P_NODE_4470_length_391_cov_1.672956_g4260_i0	PRJNA1031674	4470	391	1.672956	6.54125796	Cyanophyceae	3028117	Bacteria	Bacteria	706	0	NTclustered	gi\|151350398\|gb\|EF663107.1\|	1211	g4260	i0	99.233	99.5217391304348	391	3	100	0	1	391	630	240	Uncultured cyanobacterium clone GASP-MA2W1_A08 16S ribosomal RNA gene, partial sequence	blastn	38913	712	0.991573033707865	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14195360	14195360	PRJNA1031674_P_NODE_25192_length_246_cov_0.890173_g24981_i0	PRJNA1031674	25192	246	0.890173	2.18982558	Gloeotrichia echinulata	212360	Bacteria	Bacteria	95.3	3.64e-15	NTclustered	gi\|2707826471\|gb\|CP051186.1\|	2723855	g24981	i0	86.905	0.682926829268293	84	11	34	0	1	84	2863279	2863362	MAG: Gloeotrichia echinulata IR180 chromosome, complete genome	blastn	168	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Gloeotrichiaceae	Gloeotrichia	Gloeotrichia echinulata
14195436	14195436	PRJNA1031674_P_NODE_4092_length_404_cov_1.262840_g3882_i0	PRJNA1031674	4092	404	1.26284	5.1018736	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	667	0	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g3882	i0	96.977	185.108910891089	397	12	98	0	1	397	1958	1562	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	74784	667	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16743750	16743750	PRJNA1031674_P_NODE_28214_length_239_cov_2.283133_g28003_i0	PRJNA1031674	28214	239	2.283133	5.45668787	Aliterella chasmolithica	2739056	Bacteria	Bacteria	303	5.37e-78	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g28003	i0	89.916	152.581589958159	238	20	99	4	1	236	2052	2287	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	36467	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
27129493	27129493	PRJNA1031674_P_NODE_14402_length_279_cov_1.495146_g14191_i0	PRJNA1031674	14402	279	1.495146	4.17145734	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	146	3.13e-39	NR	HCF29194.1	2055787	g14191	i0	82.6	1.98924731182796	92	15	97.8	1	3	275	137	228	HCF29194.1 hypothetical protein [Cyanobacteria bacterium UBA11049]	diamond	555	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
27153142	27153142	PRJNA1031674_P_NODE_27602_length_241_cov_2.726190_g27391_i0	PRJNA1031674	27602	241	2.72619	6.5701179	Bacillati	1783272	Bacteria	Bacteria	121	5.400000000000001e-30	NR	HNB20838.1	2052166	g27391	i0	87.9	7.39419087136929	66	8	82.2	0	200	3	1	66	HNB20838.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Melainabacteria bacterium]	diamond	1782	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27446223	27446223	PRJNA1031674_P_NODE_18923_length_263_cov_1.621053_g18712_i0	PRJNA1031674	18923	263	1.621053	4.26336939	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	173	1.44e-52	NR	MDQ5935313.1	3070899	g18712	i0	97.7	0.992395437262357	87	2	99.2	0	2	262	40	126	MDQ5935313.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	261	173	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
27477521	27477521	PRJNA1031674_P_NODE_16863_length_271_cov_1.267677_g16652_i0	PRJNA1031674	16863	271	1.267677	3.43540467	Phormidium pseudopriestleyi	1759527	Bacteria	Bacteria	43.1	0.039	NR	WP_207089505.1	1759527	g16652	i0	45.3	0.586715867158672	53	28	58.7	1	17	175	671	722	WP_207089505.1 CHASE2 domain-containing protein [Phormidium pseudopriestleyi]	diamond	159	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium pseudopriestleyi
28227090	28227090	PRJNA1031674_P_NODE_28986_length_227_cov_3.993506_g28775_i0	PRJNA1031674	28986	227	3.993506	9.06525862	Bacillati	1783272	Bacteria	Bacteria	68.2	3.29e-11	NR	MBA4076998.1	2067979	g28775	i0	60.4	3.11894273127753	53	21	70	0	53	211	1	53	MBA4076998.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	708	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
28266655	28266655	PRJNA1031674_P_NODE_15366_length_276_cov_1.384236_g15155_i0	PRJNA1031674	15366	276	1.384236	3.82049136	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	164	1.19e-47	NR	WP_346016859.1	155894	g15155	i0	88	2	92	11	100	0	1	276	178	269	WP_346016859.1 glutathione synthase [Chroococcidiopsis sp. CCMEE 29]	diamond	552	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
28329911	28329911	PRJNA1031674_P_NODE_15406_length_276_cov_1.241379_g15195_i0	PRJNA1031674	15406	276	1.241379	3.42620604	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	89.7	7.43e-20	NR	MFA6559124.1	2364082	g15195	i0	100	3.65217391304348	48	0	52.2	0	2	145	158	205	MFA6559124.1 Na+ dependent nucleoside transporter N-terminal domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	1008	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28740496	28740496	PRJNA1031674_P_NODE_17687_length_268_cov_1.205128_g17476_i0	PRJNA1031674	17687	268	1.205128	3.22974304	Dolichospermum circinale	109265	Bacteria	Bacteria	115	4.400000000000001e-28	NR	MDB9459302.1	3021747	g17476	i0	64.8	1.97014925373134	88	31	98.5	0	3	266	87	174	MDB9459302.1 sigma-70 family RNA polymerase sigma factor [Dolichospermum circinale CS-545/17]	diamond	528	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum circinale
29174748	29174748	PRJNA1031674_P_NODE_18549_length_264_cov_2.214660_g18338_i0	PRJNA1031674	18549	264	2.21466	5.8467024	Bacillati	1783272	Bacteria	Bacteria	130	2.63e-33	NR	MDP3508783.1	2052166	g18338	i0	68.2	5.04545454545455	88	28	100	0	1	264	101	188	MDP3508783.1 GIY-YIG nuclease family protein [Candidatus Melainabacteria bacterium]	diamond	1332	131	0.99236641221374	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29300903	29300903	PRJNA1031674_P_NODE_27249_length_242_cov_0.911243_g27038_i0	PRJNA1031674	27249	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	170	5.029999999999999e-52	NR	MBA4079589.1	2067979	g27038	i0	95	1.98347107438017	80	4	99.2	0	240	1	67	146	MBA4079589.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	480	170	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
29845588	29845588	PRJNA1031674_P_NODE_27011_length_242_cov_3.207101_g26800_i0	PRJNA1031674	27011	242	3.207101	7.76118442	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	63.5	2.19e-11	NR	MDQ5935482.1	3070899	g26800	i0	93.8	0.396694214876033	32	2	39.7	0	97	2	1	32	MDQ5935482.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	96	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
30066648	30066648	PRJNA1031674_P_NODE_26612_length_243_cov_1.470588_g26401_i0	PRJNA1031674	26612	243	1.470588	3.57352884	Dolichospermum sp.	2720786	Bacteria	Bacteria	134	6.840000000000001e-36	NR	MFM6698514.1	2720786	g26401	i0	84	0.925925925925926	75	12	92.6	0	225	1	27	101	MFM6698514.1 IS30 family transposase [Dolichospermum sp.]	diamond	225	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.
30161270	30161270	PRJNA1031674_P_NODE_27072_length_242_cov_1.822485_g26861_i0	PRJNA1031674	27072	242	1.822485	4.4104137	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	119	1.15e-29	NR	WP_250122175.1	155894	g26861	i0	72.5	1.98347107438017	80	22	99.2	0	240	1	279	358	WP_250122175.1 sensor histidine kinase [Chroococcidiopsis sp. CCMEE 29]	diamond	480	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
30383100	30383100	PRJNA1031674_P_NODE_21193_length_254_cov_1.701657_g20982_i0	PRJNA1031674	21193	254	1.701657	4.32220878	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	148	2.38e-39	NR	MDQ5935870.1	3070899	g20982	i0	97.2	1.67716535433071	71	2	83.9	0	1	213	590	660	MDQ5935870.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	426	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
30532666	30532666	PRJNA1031674_P_NODE_8313_length_310_cov_3.573840_g8102_i0	PRJNA1031674	8313	310	3.57384	11.078904	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	67	5.64e-12	NR	WP_190877020.1	1179	g8102	i0	68.8	1.82903225806452	48	15	46.5	0	162	305	17	64	WP_190877020.1 hypothetical protein [Desmonostoc muscorum]	diamond	567	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Desmonostoc	Desmonostoc muscorum
30793326	30793326	PRJNA1031674_P_NODE_24014_length_248_cov_0.880000_g23803_i0	PRJNA1031674	24014	248	0.88	2.1824	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	149	9.9e-40	NR	MBX9724063.1	2364082	g23803	i0	85.4	0.991935483870968	82	12	99.2	0	248	3	379	460	MBX9724063.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	246	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30919998	30919998	PRJNA1031674_P_NODE_24794_length_246_cov_1.780347_g24583_i0	PRJNA1031674	24794	246	1.780347	4.37965362	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	104	8.289999999999999e-24	NR	MFA7339202.1	2364082	g24583	i0	59.3	2.96341463414634	81	33	98.8	0	2	244	1040	1120	MFA7339202.1 diguanylate cyclase [Candidatus Obscuribacterales bacterium]	diamond	729	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium

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