metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA980585" and tax_clade = "Cyanobacteriota/Melainabacteria group"

26 rows where analysis = "blastn", bioproject = "PRJNA980585" 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
954412	954412	PRJNA980585_P_NODE_1381_length_978_cov_2.230939_g320_i1	PRJNA980585	1381	978	2.230939	21.81858342	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1663	0	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g320	i1	97.629	101.930470347648	970	21	99	2	1	969	2363	3331	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	99688	1663	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2230370	2230370	PRJNA980585_P_NODE_48062_length_247_cov_2.040230_g47808_i0	PRJNA980585	48062	247	2.04023	5.0393681	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	211	3.48e-50	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g47808	i0	85.047	16.4008097165992	214	25	85	7	38	247	3682361	3682571	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	4051	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
2230431	2230431	PRJNA980585_P_NODE_52982_length_245_cov_0.895349_g52728_i0	PRJNA980585	52982	245	0.895349	2.19360505	Picosynechococcus sp. PCC 7003	374981	Bacteria	Bacteria	254	5.65e-63	NTclustered	gi\|2275105\|emb\|X97393.1\|	374981	g52728	i0	85.425	46.5795918367347	247	33	100	3	1	245	291	46	Synechococcus sp. rnpB gene, strain PCC7003	blastn	11412	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7003
3505418	3505418	PRJNA980585_P_NODE_38283_length_257_cov_0.820652_g38029_i0	PRJNA980585	38283	257	0.820652	2.10907564	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	231	2.8e-56	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g38029	i0	83.012	33.5719844357977	259	40	100	3	1	257	3680995	3681251	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	8628	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
3505449	3505449	PRJNA980585_P_NODE_403_length_1538_cov_3.127645_g320_i0	PRJNA980585	403	1538	3.127645	48.1031801	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2431	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g320	i0	95.484	109.767880364109	1528	60	99	7	10	1533	3328	1806	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	168823	2431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4783350	4783350	PRJNA980585_P_NODE_57864_length_242_cov_1.136095_g57610_i0	PRJNA980585	57864	242	1.136095	2.7493499	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g57610	i0	98.844	172.409090909091	173	2	71	0	11	183	3410	3238	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41723	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4783435	4783435	PRJNA980585_P_NODE_6684_length_500_cov_3.163934_g6430_i0	PRJNA980585	6684	500	3.163934	15.81967	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	614	4.969999999999998e-171	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g6430	i0	88.8	206.824	500	56	100	0	1	500	3680618	3680119	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	103412	614	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
7332652	7332652	PRJNA980585_P_NODE_386_length_1569_cov_3.491310_g305_i0	PRJNA980585	386	1569	3.49131	54.7786539	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1733	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g305	i0	86.662	107.954110898662	1582	189	99	21	1	1568	3680926	3682499	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	169380	1733	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
10198085	10198085	PRJNA980585_P_NODE_59988_length_241_cov_0.916667_g59734_i0	PRJNA980585	59988	241	0.916667	2.20916747	Bacillati	1783272	Bacteria	Bacteria	433	6.63e-117	NTclustered	gi\|47118304\|dbj\|BA000022.2\|	1148	g59734	i0	99.167	170.103734439834	240	2	99	0	2	241	7695	7456	Synechocystis sp. PCC 6803 DNA, complete genome	blastn	40995	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
13708710	13708710	PRJNA980585_P_NODE_52591_length_245_cov_0.895349_g52337_i0	PRJNA980585	52591	245	0.895349	2.19360505	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	187	5.809999999999998e-43	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g52337	i0	80.658	2.00408163265306	243	45	99	2	4	245	4790727	4790486	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	491	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
14023191	14023191	PRJNA980585_P_NODE_26691_length_289_cov_1.143519_g26437_i0	PRJNA980585	26691	289	1.143519	3.30476991	Chroococcidiopsis	54298	Bacteria	Bacteria	518	2.19e-142	NTclustered	gi\|192337879\|gb\|EU751488.1\|	1211	g26437	i0	98.962	99.0484429065744	289	3	100	0	1	289	433	721	Uncultured cyanobacterium clone SD-H03 16S ribosomal RNA gene, partial sequence	blastn	28625	523	0.990439770554493	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14982676	14982676	PRJNA980585_P_NODE_35092_length_265_cov_1.901042_g34838_i0	PRJNA980585	35092	265	1.901042	5.0377613	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	246	1.0399999999999999e-60	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g34838	i0	83.521	37.8188679245283	267	41	100	3	1	265	3682643	3682378	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	10022	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
16257365	16257365	PRJNA980585_P_NODE_1653_length_905_cov_4.209135_g1440_i0	PRJNA980585	1653	905	4.209135	38.09267175	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	983	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1440	i0	86.448	223.641988950276	915	102	99	22	1	902	3681755	3682660	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	202396	983	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
16257854	16257854	PRJNA980585_P_NODE_46473_length_248_cov_0.880000_g46219_i0	PRJNA980585	46473	248	0.88	2.1824	Synechococcus sp. A15-24	1050635	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1895823488\|gb\|CP047960.1\|	1050635	g46219	i0	100	0.116935483870968	29	0	12	0	14	42	156031	156059	Synechococcus sp. A15-24 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A15-24
16257882	16257882	PRJNA980585_P_NODE_48773_length_247_cov_0.885057_g48519_i0	PRJNA980585	48773	247	0.885057	2.18609079	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	307	4.32e-79	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g48519	i0	89.113	2.68825910931174	248	26	100	1	1	247	8441474	8441721	Calothrix sp. PCC 7716 DNA, complete genome	blastn	664	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
17532996	17532996	PRJNA980585_P_NODE_5054_length_563_cov_1.361224_g4800_i0	PRJNA980585	5054	563	1.361224	7.66369112	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	833	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g4800	i0	93.75	268.097690941385	560	27	99	6	3	561	9969449	9970001	Calothrix sp. PCC 7716 DNA, complete genome	blastn	150939	833	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
18806316	18806316	PRJNA980585_P_NODE_19875_length_324_cov_1.454183_g19621_i0	PRJNA980585	19875	324	1.454183	4.71155292	Aphanizomenon flos-aquae	1176	Bacteria	Bacteria	71.3	8.4e-8	NTclustered	gi\|2004375065\|gb\|CP051188.1\|	2717882	g19621	i0	90.566	1.57716049382716	53	5	16	0	11	63	3356071	3356123	Aphanizomenon flos-aquae DEX188 chromosome, complete genome	blastn	511	71.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
18807053	18807053	PRJNA980585_P_NODE_7815_length_467_cov_4.550761_g7561_i0	PRJNA980585	7815	467	4.550761	21.25205387	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	453	1.06e-122	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g7561	i0	84.355	70.7280513918629	473	62	100	10	1	467	3681392	3680926	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	33030	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
20081579	20081579	PRJNA980585_P_NODE_50176_length_246_cov_1.410405_g49922_i0	PRJNA980585	50176	246	1.410405	3.4695963	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	303	5.56e-78	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g49922	i0	89.024	230.30487804878	246	26	100	1	1	246	1859183	1858939	Calothrix sp. PCC 7716 DNA, complete genome	blastn	56655	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
20081594	20081594	PRJNA980585_P_NODE_51316_length_246_cov_0.890173_g51062_i0	PRJNA980585	51316	246	0.890173	2.18982558	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	368	1.94e-97	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g51062	i0	93.852	149.524390243902	244	15	99	0	1	244	3063	2820	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36783	368	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21671787	21671787	PRJNA980585_P_NODE_39417_length_253_cov_1.755556_g39163_i0	PRJNA980585	39417	253	1.755556	4.44155668	Cyanophyceae	3028117	Bacteria	Bacteria	435	1.95e-117	NTclustered	gi\|1992526127\|gb\|CP070366.1\|	2811482	g39163	i0	97.628	141.351778656126	253	6	100	0	1	253	2493409	2493157	Thermoleptolyngbya sp. PKUAC-SCTB121 chromosome, complete genome	blastn	35762	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. PKUAC-SCTB121
22631941	22631941	PRJNA980585_P_NODE_40158_length_251_cov_1.724719_g39904_i0	PRJNA980585	40158	251	1.724719	4.32904469	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	124	4.7499999999999994e-24	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g39904	i0	96.104	0.306772908366534	77	1	31	2	175	251	3855717	3855791	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	77	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23907446	23907446	PRJNA980585_P_NODE_43839_length_250_cov_0.870056_g43585_i0	PRJNA980585	43839	250	0.870056	2.17514	Synechococcus sp. CBW1004	1353136	Bacteria	Bacteria	67.6	8.09e-7	NTclustered	gi\|1940480550\|gb\|CP060397.1\|	1353136	g43585	i0	95.238	0.312	42	2	17	0	121	162	2678529	2678488	Synechococcus sp. CBW1004 chromosome, complete genome	blastn	78	67.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1004
23907593	23907593	PRJNA980585_P_NODE_54219_length_244_cov_0.900585_g53965_i0	PRJNA980585	54219	244	0.900585	2.1974274	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	418	1.8799999999999994e-112	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g53965	i0	97.541	1	244	6	100	0	1	244	8513265	8513022	Calothrix sp. PCC 7716 DNA, complete genome	blastn	244	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
23907597	23907597	PRJNA980585_P_NODE_5439_length_544_cov_8.685775_g5185_i0	PRJNA980585	5439	544	8.685775	47.250616	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	878	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5185	i0	95.772	162.261029411765	544	23	100	0	1	544	3682122	3682665	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	88270	878	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23907686	23907686	PRJNA980585_P_NODE_60599_length_241_cov_0.916667_g60345_i0	PRJNA980585	60599	241	0.916667	2.20916747	Candidatus Paraprochloron terpiosi	2892031	Bacteria	Bacteria	62.1	3.6e-5	NTclustered	gi\|2030184695\|gb\|CP073341.1\|	2829509	g60345	i0	94.872	0.161825726141079	39	2	16	0	1	39	3044929	3044891	MAG: Candidatus Paraprochloron terpiosi LD05 chromosome, complete genome	blastn	39	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Prochloraceae	Candidatus Paraprochloron	Candidatus Paraprochloron terpiosi

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