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

19 rows where analysis = "blastn", bioproject = "PRJNA432257" 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
1088626	1088626	PRJNA432257_S_NODE_17241_length_338_cov_64.365449_g16860_i0	PRJNA432257	17241	338	64.365449	217.55521762	Oscillatoriales	1150	Bacteria	Bacteria	553	7.179999999999998e-153	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g16860	i0	99.669	145.757396449704	302	1	89	0	1	302	484	183	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	49266	558	0.991039426523297	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
1088834	1088834	PRJNA432257_S_NODE_71781_length_201_cov_60.878049_g71400_i0	PRJNA432257	71781	201	60.878049	122.36487849	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	326	9.33e-85	NTclustered	gi\|199584193\|gb\|FJ028685.1\|	1211	g71400	i0	98.901	90.5422885572139	182	2	91	0	20	201	139	320	Uncultured cyanobacterium clone SSB-42 16S ribosomal RNA gene, partial sequence	blastn	18199	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2363948	2363948	PRJNA432257_S_NODE_100882_length_175_cov_83.123188_g100501_i0	PRJNA432257	100882	175	83.123188	145.465579	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	252	1.3499999999999999e-62	NTclustered	gi\|199584193\|gb\|FJ028685.1\|	1211	g100501	i0	98.601	81.5485714285714	143	1	81	1	1	142	320	178	Uncultured cyanobacterium clone SSB-42 16S ribosomal RNA gene, partial sequence	blastn	14271	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2979584	2979584	PRJNA432257_S_NODE_101363_length_175_cov_2.666667_g100982_i0	PRJNA432257	101363	175	2.666667	4.66666725	Microcoleus vaginatus	119532	Bacteria	Bacteria	274	2.89e-69	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g100982	i0	97.5	2.74285714285714	160	4	91	0	16	175	6548983	6548824	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	480	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
2979909	2979909	PRJNA432257_S_NODE_15943_length_347_cov_793.603226_g15562_i0	PRJNA432257	15943	347	793.603226	2753.80319422	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	473	5.919999999999999e-129	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g15562	i0	97.826	147.371757925072	276	3	79	3	42	314	1234	1509	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	51138	473	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
2980437	2980437	PRJNA432257_S_NODE_49083_length_232_cov_304.164103_g48702_i0	PRJNA432257	49083	232	304.164103	705.66071896	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	298	2.41e-76	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g48702	i0	93.909	152.137931034483	197	12	85	0	1	197	33430	33626	Allocoleopsis franciscana PCC 7113, complete genome	blastn	35296	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
3639876	3639876	PRJNA432257_S_NODE_68123_length_205_cov_116.976190_g67742_i0	PRJNA432257	68123	205	116.97619	239.8011895	Nostocaceae	1162	Bacteria	Bacteria	283	5.83e-72	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g67742	i0	97.024	247.853658536585	168	5	82	0	1	168	2136915	2137082	Nostoc sp. PCC 7524, complete genome	blastn	50810	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
5533114	5533114	PRJNA432257_S_NODE_24845_length_298_cov_237.862069_g24464_i0	PRJNA432257	24845	298	237.862069	708.82896562	Aliterella chasmolithica	2739056	Bacteria	Bacteria	407	5.1299999999999995e-109	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g24464	i0	94.656	112.201342281879	262	14	88	0	36	297	1965	2226	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	33436	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
6807243	6807243	PRJNA432257_S_NODE_33606_length_268_cov_4.796537_g33225_i0	PRJNA432257	33606	268	4.796537	12.85471916	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	359	1.29e-94	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g33225	i0	94.118	141.305970149254	238	11	88	3	1	235	1272	1509	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	37870	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
11909030	11909030	PRJNA432257_S_NODE_86370_length_187_cov_2.760000_g85989_i0	PRJNA432257	86370	187	2.76	5.1612	Microcoleus vaginatus	119532	Bacteria	Bacteria	182	1.96e-41	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g85989	i0	86.471	4.03743315508021	170	17	89	4	1	166	4866790	4866957	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	755	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
13183133	13183133	PRJNA432257_S_NODE_25311_length_296_cov_224.227799_g24930_i0	PRJNA432257	25311	296	224.227799	663.71428504	Microcystis aeruginosa	1126	Bacteria	Bacteria	318	2.4499999999999996e-82	NTclustered	gi\|2719083847\|gb\|CP142375.1\|	3113711	g24930	i0	88.846	147.804054054054	260	28	88	1	37	296	3287890	3288148	Microcystis aeruginosa 1339 chromosome, complete genome	blastn	43750	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
13183487	13183487	PRJNA432257_S_NODE_5271_length_513_cov_7.077731_g5004_i0	PRJNA432257	5271	513	7.077731	36.30876003	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	662	0	NTclustered	gi\|225696220\|gb\|FJ805887.1\|	259957	g5004	i0	90.637	185.768031189084	502	41	97	5	1	498	2168	1669	Uncultured Chroococcidiopsis sp. clone NA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	95299	662	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13842104	13842104	PRJNA432257_S_NODE_14271_length_361_cov_5.891975_g13890_i0	PRJNA432257	14271	361	5.891975	21.27002975	Nostocales	1161	Bacteria	Bacteria	496	1.3199999999999999e-135	NTclustered	gi\|427347790\|gb\|CP003943.1\|	99598	g13890	i0	92.775	297.299168975069	346	20	96	5	17	361	1915379	1915720	Calothrix sp. PCC 7507 chromosome, complete genome	blastn	107325	501	0.99001996007984	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7507
14458486	14458486	PRJNA432257_S_NODE_39392_length_252_cov_260.576744_g39011_i0	PRJNA432257	39392	252	260.576744	656.65339488	Gloeothece verrucosa	2546359	Bacteria	Bacteria	233	7.6e-57	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g39011	i0	86.175	115.575396825397	217	29	86	1	1	217	1627545	1627760	Cyanothece sp. PCC 7822, complete genome	blastn	29125	233	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
17006252	17006252	PRJNA432257_S_NODE_101634_length_175_cov_1.673913_g101253_i0	PRJNA432257	101634	175	1.673913	2.92934775	Brasilonema sennae	1397703	Bacteria	Bacteria	62.1	2.45e-5	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g101253	i0	92.857	0.24	42	3	24	0	62	103	2945385	2945426	Brasilonema sennae CENA114 chromosome	blastn	42	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
19555496	19555496	PRJNA432257_S_NODE_39956_length_251_cov_13.219626_g39575_i0	PRJNA432257	39956	251	13.219626	33.18126126	Chroococcales cyanobacterium Hutten-14142-NP3B	2499642	Bacteria	Bacteria	370	5.53e-98	NTclustered	gi\|1560769880\|gb\|MG869759.1\|	2499642	g39575	i0	97.26	68.6215139442231	219	5	87	1	1	218	1245	1027	Chroococcales cyanobacterium Hutten-14142-NP3B clone PCI6A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17224	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales			Chroococcales cyanobacterium Hutten-14142-NP3B
19555631	19555631	PRJNA432257_S_NODE_48556_length_233_cov_191.280612_g48175_i0	PRJNA432257	48556	233	191.280612	445.68382596	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	272	1.47e-68	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g48175	i0	91.837	157.278969957082	196	14	83	1	38	231	1671	1866	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36646	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20214756	20214756	PRJNA432257_S_NODE_102316_length_174_cov_4.496350_g101935_i0	PRJNA432257	102316	174	4.49635	7.823649	Bacteria	2	Bacteria	Bacteria	246	6.26e-61	NTclustered	gi\|192337910\|gb\|EU751519.1\|	1211	g101935	i0	95.513	89.6551724137931	156	3	87	3	1	152	383	228	Uncultured cyanobacterium clone HK03-F07 16S ribosomal RNA gene, partial sequence	blastn	15600	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20214916	20214916	PRJNA432257_S_NODE_32396_length_271_cov_138.867521_g32015_i0	PRJNA432257	32396	271	138.867521	376.33098191	Gloeocapsopsis	693222	Bacteria	Bacteria	307	4.8e-79	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g32015	i0	90.254	145.878228782288	236	21	87	2	1	235	2689	2455	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	39533	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis

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