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

18 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
392119	392119	PRJNA340009_P_NODE_31701_length_222_cov_1.179191_g31394_i0	PRJNA340009	31701	222	1.179191	2.61780402	Cyanobacteria bacterium LVE1205-1	2903134	Bacteria	Bacteria	399	6.099999999999999e-107	NTclustered	gi\|2800745465\|gb\|CP089922.1\|	2903134	g31394	i0	99.099	1	222	2	100	0	1	222	2462218	2461997	MAG: Cyanobacteria bacterium LVE1205-1 chromosome, complete genome	blastn	222	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium LVE1205-1
392641	392641	PRJNA340009_P_NODE_78701_length_157_cov_32.564815_g78394_i0	PRJNA340009	78701	157	32.564815	51.12675955	Anthocerotibacter panamensis	2857077	Bacteria	Bacteria	62.1	2.15e-5	NTclustered	gi\|2040348944\|gb\|CP062698.1\|	2778476	g78394	i0	94.872	0.496815286624204	39	2	25	0	119	157	375542	375504	Anthocerotibacter panamensis C109 chromosome, complete genome	blastn	78	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Anthocerotibacteraceae	Anthocerotibacter	Anthocerotibacter panamensis
1667133	1667133	PRJNA340009_P_NODE_71402_length_163_cov_0.894737_g71095_i0	PRJNA340009	71402	163	0.894737	1.45842131	Annamia dubia	2815909	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2663421582\|dbj\|AP025630.1\|	2759045	g71095	i0	100	0.171779141104294	28	0	17	0	44	71	2681131	2681104	Annamia dubia NIES-4383 DNA, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia
2942981	2942981	PRJNA340009_P_NODE_53743_length_178_cov_1.186047_g53436_i0	PRJNA340009	53743	178	1.186047	2.11116366	Dolichospermum heterosporum	747522	Bacteria	Bacteria	63.9	6.96e-6	NTclustered	gi\|2283110535\|gb\|CP099464.1\|	747523	g53436	i0	93.023	8.30337078651685	43	3	25	0	124	166	3543385	3543343	Dolichospermum heterosporum TAC447 strain NIES-1697 chromosome, complete genome	blastn	1478	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum heterosporum
2943100	2943100	PRJNA340009_P_NODE_64443_length_166_cov_0.871795_g64136_i0	PRJNA340009	64443	166	0.871795	1.4471797	Stanieria cyanosphaera	102116	Bacteria	Bacteria	172	1.02e-38	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g64136	i0	87.755	0.885542168674699	147	18	89	0	13	159	426	572	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	147	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
2943252	2943252	PRJNA340009_P_NODE_77623_length_160_cov_7.189189_g77316_i0	PRJNA340009	77623	160	7.189189	11.5027024	Phormidium yuhuli	2974039	Bacteria	Bacteria	128	2.14e-25	NTclustered	gi\|2260356645\|gb\|CP098611.1\|	2940671	g77316	i0	84.921	1.15625	126	19	79	0	35	160	431158	431283	Phormidium yuhuli AB48 chromosome, complete genome	blastn	185	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium yuhuli
4219772	4219772	PRJNA340009_P_NODE_69744_length_164_cov_0.886957_g69437_i0	PRJNA340009	69744	164	0.886957	1.45460948	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	281	1.6000000000000001e-71	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g69437	i0	97.561	7.10975609756098	164	4	100	0	1	164	3874908	3875071	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	1166	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
4897980	4897980	PRJNA340009_P_NODE_67164_length_165_cov_0.879310_g66857_i0	PRJNA340009	67164	165	0.87931	1.4508615	Nostocales	1161	Bacteria	Bacteria	135	1.33e-27	NTclustered	gi\|924287285\|gb\|CP011456.1\|	1647413	g66857	i0	83.448	4.18181818181818	145	24	88	0	21	165	1587890	1587746	Anabaena sp. WA102 chromosome, complete sequence	blastn	690	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. WA102
5495735	5495735	PRJNA340009_P_NODE_32525_length_219_cov_10.394118_g32218_i0	PRJNA340009	32525	219	10.394118	22.76311842	Gloeotrichia echinulata	212360	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2813986847\|gb\|CP170511.1\|	3350243	g32218	i0	96.875	0.146118721461187	32	0	14	1	130	160	3472006	3472037	MAG: Gloeotrichia echinulata GP01 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Gloeotrichiaceae	Gloeotrichia	Gloeotrichia echinulata
8045649	8045649	PRJNA340009_P_NODE_59207_length_170_cov_2.107438_g58900_i0	PRJNA340009	59207	170	2.107438	3.5826446	Calothrix sp. NIES-4101	2005461	Bacteria	Bacteria	270	3.61e-68	NTclustered	gi\|1210217881\|dbj\|AP018280.1\|	2005461	g58900	i0	95.294	178.317647058824	170	8	100	0	1	170	1243359	1243190	Calothrix sp. NIES-4101 DNA, complete genome	blastn	30314	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-4101
11871004	11871004	PRJNA340009_P_NODE_56950_length_173_cov_2.177419_g56643_i0	PRJNA340009	56950	173	2.177419	3.76693487	Chamaesiphon minutus	1173032	Bacteria	Bacteria	265	1.7099999999999998e-66	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g56643	i0	97.419	141.294797687861	155	4	90	0	9	163	1056	902	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	24444	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
11871123	11871123	PRJNA340009_P_NODE_67930_length_164_cov_5.052174_g67623_i0	PRJNA340009	67930	164	5.052174	8.28556536	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	189	1e-43	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g67623	i0	87.654	2.84756097560976	162	20	99	0	2	163	3262602	3262763	Calothrix sp. PCC 7716 DNA, complete genome	blastn	467	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
13823618	13823618	PRJNA340009_P_NODE_70471_length_163_cov_2.438596_g70164_i0	PRJNA340009	70471	163	2.438596	3.97491148	Synechococcales	1890424	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|1940477070\|gb\|CP060398.1\|	1353134	g70164	i0	99.387	133.423312883436	163	1	100	0	1	163	476597	476435	Synechococcus sp. CBW1002 chromosome, complete genome	blastn	21748	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1002
14420944	14420944	PRJNA340009_P_NODE_38432_length_205_cov_1.038462_g38125_i0	PRJNA340009	38432	205	1.038462	2.1288471	Spirirestis rafaelensis	293980	Bacteria	Bacteria	274	3.51e-69	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g38125	i0	90.777	218.980487804878	206	18	100	1	1	205	279	484	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	44891	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
18244096	18244096	PRJNA340009_P_NODE_70995_length_163_cov_1.324561_g70688_i0	PRJNA340009	70995	163	1.324561	2.15903443	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g70688	i0	100	106.41717791411	163	0	100	0	1	163	1187	1025	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	17346	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
20793477	20793477	PRJNA340009_P_NODE_30817_length_224_cov_4.440000_g30510_i0	PRJNA340009	30817	224	4.44	9.9456	Synechocystis sp. B12	2764086	Bacteria	Bacteria	58.4	4.28e-4	NTclustered	gi\|2563367767\|gb\|CP101709.1\|	2764086	g30510	i0	88	0.53125	50	4	21	2	26	73	1707984	1707935	Synechocystis sp. B12 chromosome, complete genome	blastn	119	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. B12
24618457	24618457	PRJNA340009_P_NODE_51000_length_182_cov_1.496241_g50693_i0	PRJNA340009	51000	182	1.496241	2.72315862	Oscillatoria acuminata	118323	Bacteria	Bacteria	171	4.1e-38	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g50693	i0	84.091	0.967032967032967	176	28	97	0	6	181	4850223	4850048	Oscillatoria acuminata PCC 6304, complete genome	blastn	176	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
24618700	24618700	PRJNA340009_P_NODE_73280_length_162_cov_1.752212_g72973_i0	PRJNA340009	73280	162	1.752212	2.83858344	Nostoc edaphicum	264686	Bacteria	Bacteria	143	7.78e-30	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g72973	i0	90	0.679012345679012	110	11	68	0	53	162	3734990	3735099	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	110	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum

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