metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA608660" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA608660" and tax_phylum = "Cyanobacteriota"

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
584744	584744	PRJNA608660_P_NODE_40701_length_185_cov_3.661765_g40344_i0	PRJNA608660	40701	185	3.661765	6.77426525	Nostoc sp. C052	2576902	Bacteria	Bacteria	189	1.15e-43	NTclustered	gi\|1866639087\|gb\|CP040272.1\|	2576902	g40344	i0	88.125	1.74594594594595	160	18	86	1	10	168	6688448	6688289	Nostoc sp. C052 chromosome, complete genome	blastn	323	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C052
584825	584825	PRJNA608660_P_NODE_5101_length_643_cov_9.525253_g4802_i0	PRJNA608660	5101	643	9.525253	61.24737679	uncultured cyanobacterium	1211	Bacteria	Bacteria	1136	0	NTclustered	gi\|691483284\|gb\|KM006898.1\|	1211	g4802	i0	99.838	88.5443234836703	618	1	96	0	15	632	624	7	Uncultured cyanobacterium clone 3B-31 16S ribosomal RNA gene, partial sequence	blastn	56934	1136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2422246	2422246	PRJNA608660_P_NODE_5202_length_638_cov_12.005093_g4902_i0	PRJNA608660	5202	638	12.005093	76.59249334	Cyanophyceae	3028117	Bacteria	Bacteria	268	5.779999999999999e-67	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g4902	i0	82.895	21.8009404388715	304	47	91	5	9	309	902818	902517	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	13909	270	0.992592592592593	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5688440	5688440	PRJNA608660_P_NODE_34505_length_211_cov_3.185185_g34149_i0	PRJNA608660	34505	211	3.185185	6.72074035	Thermocoleostomius sinensis	3065396	Bacteria	Bacteria	158	3.8199999999999997e-34	NTclustered	gi\|2407448737\|gb\|CP113797.1\|	2016057	g34149	i0	83.815	7.37914691943128	173	20	80	6	33	200	643012	643181	Thermocoleostomius sinensis A174 chromosome, complete genome	blastn	1557	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermocoleostomius	Thermocoleostomius sinensis
9513057	9513057	PRJNA608660_P_NODE_26808_length_256_cov_1.004831_g26452_i0	PRJNA608660	26808	256	1.004831	2.57236736	Gloeothece citriformis	2546356	Bacteria	Bacteria	111	3.79e-20	NTclustered	gi\|218169741\|gb\|CP001291.1\|	65393	g26452	i0	80.263	0.59375	152	26	59	4	25	174	3703802	3703951	Cyanothece sp. PCC 7424, complete genome	blastn	152	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece citriformis
9513065	9513065	PRJNA608660_P_NODE_27428_length_251_cov_5.836634_g27072_i0	PRJNA608660	27428	251	5.836634	14.64995134	uncultured cyanobacterium	1211	Bacteria	Bacteria	67.6	8.12e-7	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g27072	i0	78.632	0.653386454183267	117	14	47	7	75	191	3970657	3970762	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	164	67.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9513310	9513310	PRJNA608660_P_NODE_828_length_1186_cov_8.473175_g706_i0	PRJNA608660	828	1186	8.473175	100.4918555	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	440	2.2099999999999995e-118	NTclustered	gi\|428012849\|gb\|CP003598.1\|	251229	g706	i0	80.033	6.82883642495784	611	108	98	13	572	1175	313600	314203	Chroococcidiopsis thermalis PCC 7203 plasmid pCHRO.01, complete sequence	blastn	8099	440	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
13900865	13900865	PRJNA608660_P_NODE_24171_length_276_cov_2.647577_g23815_i0	PRJNA608660	24171	276	2.647577	7.30731252	Cyanophyceae	3028117	Bacteria	Bacteria	335	2.25e-87	NTclustered	gi\|2814330024\|gb\|CP067995.1\|	309035	g23815	i0	90.272	179.594202898551	257	23	93	2	11	266	3326	3581	MAG: cyanobacterium endosymbiont of Rhopalodia gibba isolate 17Bon1-SB chromosome, complete genome	blastn	49568	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Rhopalodia gibba
14613506	14613506	PRJNA608660_P_NODE_15472_length_370_cov_91.694704_g15119_i0	PRJNA608660	15472	370	91.694704	339.2704048	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	457	6.38e-124	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g15119	i0	91.317	149.972972972973	334	29	90	0	1	334	1326	1659	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	55490	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
15175204	15175204	PRJNA608660_P_NODE_32912_length_219_cov_2.600000_g32556_i0	PRJNA608660	32912	219	2.6	5.694	Bacteria	2	Bacteria	Bacteria	291	3.77e-74	NTclustered	gi\|2814330024\|gb\|CP067995.1\|	309035	g32556	i0	93.367	141.808219178082	196	13	89	0	15	210	3336	3531	MAG: cyanobacterium endosymbiont of Rhopalodia gibba isolate 17Bon1-SB chromosome, complete genome	blastn	31056	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Rhopalodia gibba
15175251	15175251	PRJNA608660_P_NODE_45272_length_169_cov_4.966667_g44915_i0	PRJNA608660	45272	169	4.966667	8.39366723	Leptolyngbya	47251	Bacteria	Bacteria	274	2.7699999999999997e-69	NTclustered	gi\|46409895\|gb\|AY584520.1\|	212450	g44915	i0	98.701	164.769230769231	154	2	91	0	13	166	1424	1271	Leptolyngbya sp. PCC 7410 23S ribosomal RNA gene, partial sequence	blastn	27846	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 7410
15887552	15887552	PRJNA608660_P_NODE_2473_length_845_cov_195.445190_g2257_i0	PRJNA608660	2473	845	195.44519	1651.5118555	Aliterella chasmolithica	2739056	Bacteria	Bacteria	767	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g2257	i0	95.975	110.287573964497	472	19	56	0	374	845	1967	2438	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	93193	767	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
17162263	17162263	PRJNA608660_P_NODE_14954_length_378_cov_4.115502_g14601_i0	PRJNA608660	14954	378	4.115502	15.55659756	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	292	1.95e-74	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g14601	i0	80.978	4.68518518518519	368	70	97	0	1	368	578438	578805	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	1771	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
17162292	17162292	PRJNA608660_P_NODE_17494_length_344_cov_2.942373_g17139_i0	PRJNA608660	17494	344	2.942373	10.12176312	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	169	3.1e-37	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g17139	i0	85.03	4.74127906976744	167	23	48	2	79	244	7378611	7378776	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	1631	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
18436589	18436589	PRJNA608660_P_NODE_1555_length_974_cov_243.245405_g1389_i0	PRJNA608660	1555	974	243.245405	2369.2102447	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	789	0	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g1389	i0	94.706	113.028747433265	510	23	99	3	463	969	2143	2651	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	110090	789	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18436855	18436855	PRJNA608660_P_NODE_44515_length_172_cov_1.691057_g44158_i0	PRJNA608660	44515	172	1.691057	2.90861804	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	174	2.95e-39	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g44158	i0	85.976	0.953488372093023	164	21	95	2	10	172	426140	425978	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	164	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
20986870	20986870	PRJNA608660_P_NODE_14557_length_384_cov_8.767164_g14204_i0	PRJNA608660	14557	384	8.767164	33.66590976	uncultured cyanobacterium	1211	Bacteria	Bacteria	379	1.48e-100	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g14204	i0	85.754	31.5885416666667	358	51	93	0	14	371	5295985	5296342	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	12130	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22824355	22824355	PRJNA608660_P_NODE_8198_length_521_cov_3.711864_g7863_i0	PRJNA608660	8198	521	3.711864	19.33881144	Oscillatoriales	1150	Bacteria	Bacteria	935	0	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g7863	i0	99.04	137.447216890595	521	5	100	0	1	521	1647	1127	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	71610	941	0.993623804463337	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
24810947	24810947	PRJNA608660_P_NODE_24900_length_270_cov_2.303167_g24544_i0	PRJNA608660	24900	270	2.303167	6.2185509	Nostoc commune	1178	Bacteria	Bacteria	167	8.47e-37	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g24544	i0	82.54	12.9444444444444	189	33	70	0	65	253	67608	67796	Nostoc cf. commune SO-36 DNA, complete genome	blastn	3495	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
25373187	25373187	PRJNA608660_P_NODE_23040_length_286_cov_2.194093_g22684_i0	PRJNA608660	23040	286	2.194093	6.27510598	Nostoc	1177	Bacteria	Bacteria	58.4	5.68e-4	NTclustered	gi\|397789500\|gb\|JN857089.1\|	77194	g22684	i0	97.059	0.356643356643357	34	1	12	0	181	214	146	113	Nostoc sp. 'Nephroma arcticum cyanobiont' isolate U369 tRNA-Leu(UAA) (trnL) gene, intron	blastn	102	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Nephroma arcticum cyanobiont'

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