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

22 rows where analysis = "blastn", bioproject = "PRJNA675042" 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
645764	645764	PRJNA675042_P_NODE_113101_length_250_cov_0.870056_g112651_i0	PRJNA675042	113101	250	0.870056	2.17514	uncultured cyanobacterium	1211	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2874253827\|emb\|OY969811.1\|	1211	g112651	i0	96.875	0.128	32	0	13	1	104	135	740440	740470	MAG: uncultured cyanobacterium isolate MFD02832.bin.c.1 genome assembly, chromosome: 1	blastn	32	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
646609	646609	PRJNA675042_P_NODE_20861_length_409_cov_0.726190_g20411_i0	PRJNA675042	20861	409	0.72619	2.9701171	Cyanobacterium sp. DS4	2878255	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2667402313\|gb\|CP084098.1\|	2878255	g20411	i0	96.97	0.0806845965770171	33	1	8	0	259	291	683339	683371	Cyanobacterium sp. Dongsha4 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium sp. DS4
1922569	1922569	PRJNA675042_P_NODE_166782_length_243_cov_0.905882_g166332_i0	PRJNA675042	166782	243	0.905882	2.20129326	Candidatus Atelocyanobacterium thalassae	713887	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|284809060\|gb\|CP001842.1\|	1453429	g166332	i0	100	0.11522633744856	28	0	12	0	28	55	647752	647725	Candidatus Atelocyanobacterium thalassa isolate ALOHA, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Candidatus Atelocyanobacterium	Candidatus Atelocyanobacterium thalassae
1923349	1923349	PRJNA675042_P_NODE_63302_length_303_cov_1.004348_g62852_i0	PRJNA675042	63302	303	1.004348	3.04317444	Planktothricoides raciborskii	132608	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g62852	i0	100	0.0924092409240924	28	0	9	0	243	270	7137794	7137821	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
2443715	2443715	PRJNA675042_P_NODE_76822_length_284_cov_2.919431_g76372_i0	PRJNA675042	76822	284	2.919431	8.29118404	Nostocaceae	1162	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|47118303\|dbj\|BA000020.2\|	103690	g76372	i0	100	8.84154929577465	284	0	100	0	1	284	196047	196330	Nostoc sp. PCC 7120 plasmid pCC7120alpha DNA, complete genome	blastn	2511	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
4475054	4475054	PRJNA675042_P_NODE_49324_length_325_cov_1.222222_g48874_i0	PRJNA675042	49324	325	1.222222	3.9722215	Phormidium yuhuli	2974039	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2260356645\|gb\|CP098611.1\|	2940671	g48874	i0	100	0.0861538461538462	28	0	9	0	63	90	185317	185344	Phormidium yuhuli AB48 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium yuhuli
4475669	4475669	PRJNA675042_P_NODE_98364_length_259_cov_2.543011_g97914_i0	PRJNA675042	98364	259	2.543011	6.58639849	Phormidium sp. NIES-2115	2510784	Bacteria	Bacteria	353	5.77e-93	NTclustered	gi\|1566846238\|dbj\|LC455616.1\|	2510784	g97914	i0	99.485	192.065637065637	194	1	100	0	66	259	842	1035	Phormidium sp. NIES-2115 gene for 23S ribosomal RNA, partial sequence	blastn	49745	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2115
7024759	7024759	PRJNA675042_P_NODE_130826_length_248_cov_0.880000_g130376_i0	PRJNA675042	130826	248	0.88	2.1824	Planktothricoides raciborskii	132608	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g130376	i0	100	0.112903225806452	28	0	11	0	92	119	7199273	7199300	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
10096863	10096863	PRJNA675042_P_NODE_43008_length_337_cov_1.534091_g42558_i0	PRJNA675042	43008	337	1.534091	5.16988667	Nostocaceae	1162	Bacteria	Bacteria	623	5.369999999999999e-174	NTclustered	gi\|47118303\|dbj\|BA000020.2\|	103690	g42558	i0	100	5.57270029673591	337	0	100	0	1	337	275643	275979	Nostoc sp. PCC 7120 plasmid pCC7120alpha DNA, complete genome	blastn	1878	623	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
10097041	10097041	PRJNA675042_P_NODE_69808_length_293_cov_2.040909_g69358_i0	PRJNA675042	69808	293	2.040909	5.97986337	Nostocaceae	1162	Bacteria	Bacteria	542	1.32e-149	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g69358	i0	100	8.31058020477816	293	0	100	0	1	293	2894878	2895170	Nostoc sp. PCC 7120 DNA, complete genome	blastn	2435	542	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
12647140	12647140	PRJNA675042_P_NODE_137070_length_247_cov_0.885057_g136620_i0	PRJNA675042	137070	247	0.885057	2.18609079	Nostocaceae	1162	Bacteria	Bacteria	342	1.1799999999999997e-89	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g136620	i0	100	5.06477732793522	185	0	98	0	5	189	3545294	3545478	Nostoc sp. PCC 7120 DNA, complete genome	blastn	1251	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
12647384	12647384	PRJNA675042_P_NODE_23570_length_396_cov_2.383901_g23120_i0	PRJNA675042	23570	396	2.383901	9.44024796	Nostocaceae	1162	Bacteria	Bacteria	641	1.7699999999999994e-179	NTclustered	gi\|47118303\|dbj\|BA000020.2\|	103690	g23120	i0	100	2.01010101010101	347	0	98	0	9	355	118574	118228	Nostoc sp. PCC 7120 plasmid pCC7120alpha DNA, complete genome	blastn	796	641	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
12647543	12647543	PRJNA675042_P_NODE_44990_length_333_cov_2.034615_g44540_i0	PRJNA675042	44990	333	2.034615	6.77526795	Nostocaceae	1162	Bacteria	Bacteria	555	1.9599999999999995e-153	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g44540	i0	99.67	5.29129129129129	303	1	100	0	1	303	5719345	5719043	Nostoc sp. PCC 7120 DNA, complete genome	blastn	1762	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
13400299	13400299	PRJNA675042_P_NODE_147211_length_245_cov_1.081395_g146761_i0	PRJNA675042	147211	245	1.081395	2.64941775	cyanobacterium endosymbiont of Epithemia turgida	718217	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|667665922\|dbj\|AP012549.1\|	1228987	g146761	i0	94.286	0.142857142857143	35	2	14	0	70	104	2045195	2045161	Cyanobacterium endosymbiont of Epithemia turgida isolate EtSB Lake Yunoko DNA, complete genome	blastn	35	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Epithemia turgida
13401660	13401660	PRJNA675042_P_NODE_90171_length_269_cov_1.056122_g89721_i0	PRJNA675042	90171	269	1.056122	2.84096818	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1210235159\|dbj\|AP018289.1\|	2005458	g89721	i0	100	0.107806691449814	29	0	11	0	127	155	19213	19185	Nostoc sp. NIES-4103 plasmid plasmid1 DNA, nearly complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
15196768	15196768	PRJNA675042_P_NODE_50932_length_322_cov_1.931727_g50482_i0	PRJNA675042	50932	322	1.931727	6.22016094	Nostocaceae	1162	Bacteria	Bacteria	595	1.1099999999999995e-165	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g50482	i0	100	19.0652173913043	322	0	100	0	1	322	2194259	2194580	Nostoc sp. PCC 7120 DNA, complete genome	blastn	6139	595	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
19019406	19019406	PRJNA675042_P_NODE_100515_length_257_cov_1.266304_g100065_i0	PRJNA675042	100515	257	1.266304	3.25440128	Prochlorococcus	1218	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|78711884\|gb\|CP000111.1\|	74546	g100065	i0	100	0.22568093385214	29	0	11	0	18	46	1266401	1266429	Prochlorococcus marinus str. MIT 9312, complete genome	blastn	58	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
19019576	19019576	PRJNA675042_P_NODE_139695_length_246_cov_3.508671_g139245_i0	PRJNA675042	139695	246	3.508671	8.63133066	Nostocaceae	1162	Bacteria	Bacteria	294	3.34e-75	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g139245	i0	100	50.9715447154472	159	0	100	0	88	246	2094813	2094971	Nostoc sp. PCC 7120 DNA, complete genome	blastn	12539	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
21049553	21049553	PRJNA675042_P_NODE_45017_length_333_cov_1.607692_g44567_i0	PRJNA675042	45017	333	1.607692	5.35361436	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g44567	i0	100	0.0840840840840841	28	0	8	0	33	60	1801863	1801890	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
24119697	24119697	PRJNA675042_P_NODE_116659_length_250_cov_0.870056_g116209_i0	PRJNA675042	116659	250	0.870056	2.17514	Nostoc	1177	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g116209	i0	100	0.24	30	0	12	0	32	61	5672604	5672575	Nostoc sp. NIES-3756 DNA, complete genome	blastn	60	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
24872039	24872039	PRJNA675042_P_NODE_114360_length_250_cov_0.870056_g113910_i0	PRJNA675042	114360	250	0.870056	2.17514	Nostoc punctiforme	272131	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g113910	i0	100	0.228	29	0	12	0	180	208	3515862	3515834	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	57	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
25394814	25394814	PRJNA675042_P_NODE_82760_length_277_cov_1.509804_g82310_i0	PRJNA675042	82760	277	1.509804	4.18215708	Nostocaceae	1162	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|47118303\|dbj\|BA000020.2\|	103690	g82310	i0	100	2	277	0	100	0	1	277	118238	117962	Nostoc sp. PCC 7120 plasmid pCC7120alpha DNA, complete genome	blastn	554	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418

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