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

16 rows where analysis = "blastn", bioproject = "PRJNA906294" 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
2161183	2161183	PRJNA906294_P_NODE_126022_length_351_cov_1.363309_g121906_i0	PRJNA906294	126022	351	1.363309	4.78521459	Stenomitos frigidus	1886765	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g121906	i0	90.476	0.11965811965812	42	4	12	0	2	43	5781250	5781291	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	42	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus
2523737	2523737	PRJNA906294_P_NODE_107482_length_394_cov_1.068536_g103367_i0	PRJNA906294	107482	394	1.068536	4.21003184	Gloeotrichia	92939	Bacteria	Bacteria	448	4.109999999999998e-121	NTclustered	gi\|2707832175\|gb\|CP051187.1\|	2723856	g103367	i0	87.345	246.421319796954	403	36	100	14	1	394	1860195	1859799	MAG: Gloeotrichia echinulata CP02 chromosome, complete genome	blastn	97090	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Gloeotrichiaceae	Gloeotrichia	Gloeotrichia echinulata
4715515	4715515	PRJNA906294_P_NODE_175124_length_280_cov_3.913043_g171008_i0	PRJNA906294	175124	280	3.913043	10.9565204	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	422	1.71e-113	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g171008	i0	94.505	117.192857142857	273	15	98	0	1	273	2208	1936	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32814	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4715850	4715850	PRJNA906294_P_NODE_188764_length_266_cov_2.813472_g184648_i0	PRJNA906294	188764	266	2.813472	7.48383552	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	429	9.62e-116	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g184648	i0	95.849	184.631578947368	265	11	99	0	1	265	3535	3799	Uncultured Chroococcidiopsis sp. clone A1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	49112	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5990503	5990503	PRJNA906294_P_NODE_181045_length_274_cov_1.616915_g176929_i0	PRJNA906294	181045	274	1.616915	4.4303471	Trichormus azollae	1164	Bacteria	Bacteria	398	2.8099999999999998e-106	NTclustered	gi\|470486451\|ref\|NR_076758.1\|	551115	g176929	i0	93.066	299.682481751825	274	16	99	3	1	272	286	14	'Nostoc azollae' 0708 strain 708 23S ribosomal RNA gene, complete sequence	blastn	82113	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus azollae
5991620	5991620	PRJNA906294_P_NODE_230445_length_241_cov_0.904762_g226329_i0	PRJNA906294	230445	241	0.904762	2.18047642	Synechococcus sp. CBW1002	1353134	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1940477070\|gb\|CP060398.1\|	1353134	g226329	i0	100	0.120331950207469	29	0	12	0	30	58	2717032	2717060	Synechococcus sp. CBW1002 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1002
5991663	5991663	PRJNA906294_P_NODE_232165_length_240_cov_2.329341_g228049_i0	PRJNA906294	232165	240	2.329341	5.5904184	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	281	2.53e-71	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g228049	i0	87.917	132.866666666667	240	28	100	1	1	240	3768	3530	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31888	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
6352733	6352733	PRJNA906294_P_NODE_233565_length_231_cov_5.531646_g229449_i0	PRJNA906294	233565	231	5.531646	12.77810226	Leptolyngbya	47251	Bacteria	Bacteria	337	5.09e-88	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g229449	i0	93.043	178.380952380952	230	16	99	0	2	231	247092	246863	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	41206	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
7263886	7263886	PRJNA906294_P_NODE_120946_length_361_cov_1.791667_g116831_i0	PRJNA906294	120946	361	1.791667	6.46791787	Petalonema sp. 04277-00001	1313248	Bacteria	Bacteria	569	7.639999999999997e-158	NTclustered	gi\|484980741\|gb\|KC848621.1\|	1313248	g116831	i0	95.211	164.939058171745	355	17	98	0	7	361	369	15	Petalonema sp. 04277-00001 23S ribosomal RNA gene, partial sequence	blastn	59543	569	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Petalonema	Petalonema sp. 04277-00001
7626950	7626950	PRJNA906294_P_NODE_74766_length_519_cov_2.040359_g70659_i0	PRJNA906294	74766	519	2.040359	10.58946321	Synechococcus	1129	Bacteria	Bacteria	80.5	2.33e-10	NTclustered	gi\|1895745142\|gb\|CP047933.1\|	1050655	g70659	i0	88.235	0.425818882466281	68	6	13	2	3	69	758384	758450	Synechococcus sp. A15-60 chromosome, complete genome	blastn	221	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A15-60
8540325	8540325	PRJNA906294_P_NODE_191927_length_263_cov_1.615789_g187811_i0	PRJNA906294	191927	263	1.615789	4.24952507	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2804745243\|gb\|CP166621.1\|	3104317	g187811	i0	100	0.110266159695817	29	0	11	0	51	79	1450751	1450723	MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
12366467	12366467	PRJNA906294_P_NODE_188750_length_266_cov_3.072539_g184634_i0	PRJNA906294	188750	266	3.072539	8.17295374	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	470	5.669999999999999e-128	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g184634	i0	98.496	140.567669172932	266	4	100	0	1	266	3488	3223	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37391	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12367471	12367471	PRJNA906294_P_NODE_232430_length_238_cov_2.830303_g228314_i0	PRJNA906294	232430	238	2.830303	6.73612114	Oculatella lusitanica	2928764	Bacteria	Bacteria	387	5.16e-103	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g228314	i0	95.833	118.420168067227	240	8	100	1	1	238	3245	3006	Oculatella lusitanica LEGE 161147 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28184	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
14002992	14002992	PRJNA906294_P_NODE_89171_length_453_cov_1.773684_g85057_i0	PRJNA906294	89171	453	1.773684	8.03478852	Picosynechococcus	3079908	Bacteria	Bacteria	261	6.7e-65	NTclustered	gi\|169884305\|gb\|CP000951.1\|	32049	g85057	i0	77.827	146.066225165563	451	81	99	15	15	453	1465110	1464667	Synechococcus sp. PCC 7002, complete genome	blastn	66168	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7002
16189729	16189729	PRJNA906294_P_NODE_169433_length_287_cov_1.261682_g165317_i0	PRJNA906294	169433	287	1.261682	3.62102734	Macrochaete psychrophila	1844959	Bacteria	Bacteria	324	5.09e-84	NTclustered	gi\|1026261016\|gb\|KT336439.2\|	1781141	g165317	i0	94.037	110.602787456446	218	6	75	6	1	215	2256	2043	Macrochaete psychrophila CCALA 32 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31743	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete psychrophila
23840596	23840596	PRJNA906294_P_NODE_234639_length_214_cov_5.304965_g230523_i0	PRJNA906294	234639	214	5.304965	11.3526251	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	300	6.1e-77	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g230523	i0	92.417	124.009345794393	211	15	98	1	1	210	3270	3060	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	26538	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis 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);;