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

20 rows where analysis = "blastn", bioproject = "PRJNA669701" 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
635326	635326	PRJNA669701_P_NODE_126441_length_245_cov_2.575581_g126046_i0	PRJNA669701	126441	245	2.575581	6.31017345	Geitlerinema sp. PCC 7407	1173025	Bacteria	Bacteria	342	1.17e-89	NTclustered	gi\|485099144\|ref\|NR_102539.1\|	1173025	g126046	i0	91.87	137.281632653061	246	19	100	1	1	245	496	251	Geitlerinema sp. PCC 7407 strain PCC 7407 23S ribosomal RNA, complete sequence	blastn	33634	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 7407
1911015	1911015	PRJNA669701_P_NODE_100222_length_259_cov_1.129032_g99827_i0	PRJNA669701	100222	259	1.129032	2.92419288	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	169	2.24e-37	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g99827	i0	78.788	2.5019305019305	264	46	100	9	1	259	4258263	4258521	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	648	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5738331	5738331	PRJNA669701_P_NODE_104045_length_254_cov_2.574586_g103650_i0	PRJNA669701	104045	254	2.574586	6.53944844	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g103650	i0	100	0.110236220472441	28	0	11	0	29	56	718005	718032	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
5738350	5738350	PRJNA669701_P_NODE_105045_length_253_cov_2.527778_g104650_i0	PRJNA669701	105045	253	2.527778	6.39527834	Prochloraceae cyanobacterium	2692183	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|2166239973\|dbj\|LC662891.1\|	2692183	g104650	i0	99.605	1	253	1	100	0	1	253	2016	1764	Prochloraceae cyanobacterium ARSSAG-00000791 DNA, putative prophage region, clone: 00000791_pp1	blastn	253	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Prochloraceae		Prochloraceae cyanobacterium
5738932	5738932	PRJNA669701_P_NODE_147785_length_226_cov_3.117647_g147390_i0	PRJNA669701	147785	226	3.117647	7.04588222	uncultured cyanobacterium	1211	Bacteria	Bacteria	180	8.84e-41	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g147390	i0	81.057	23.8938053097345	227	41	100	2	1	226	255871	256096	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	5400	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9563451	9563451	PRJNA669701_P_NODE_110528_length_250_cov_1.480226_g110133_i0	PRJNA669701	110528	250	1.480226	3.700565	Leptolyngbya boryana	1184	Bacteria	Bacteria	207	4.57e-49	NTclustered	gi\|2591986406\|gb\|CP130144.1\|	3060204	g110133	i0	83.482	5.592	224	35	89	2	1	223	4883001	4883223	Leptolyngbya boryana CZ1 chromosome, complete genome	blastn	1398	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
9563917	9563917	PRJNA669701_P_NODE_143968_length_238_cov_2.545455_g143573_i0	PRJNA669701	143968	238	2.545455	6.0581829	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	405	1.42e-108	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g143573	i0	97.468	2.82352941176471	237	6	99	0	2	238	2811103	2811339	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	672	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
13389441	13389441	PRJNA669701_P_NODE_141431_length_241_cov_0.916667_g141036_i0	PRJNA669701	141431	241	0.916667	2.20916747	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	224	4.3399999999999996e-54	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g141036	i0	83.471	165.224066390041	242	38	99	2	2	241	3202	2961	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39819	224	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14665509	14665509	PRJNA669701_P_NODE_98552_length_260_cov_3.203209_g98157_i0	PRJNA669701	98552	260	3.203209	8.3283434	Leptolyngbya sp. O-77	1080068	Bacteria	Bacteria	257	4.68e-64	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g98157	i0	85.2	6.78076923076923	250	37	96	0	4	253	762721	762472	Leptolyngbya sp. O-77 DNA, complete genome	blastn	1763	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77
15192379	15192379	PRJNA669701_P_NODE_113112_length_249_cov_4.170455_g112717_i0	PRJNA669701	113112	249	4.170455	10.38443295	Cyanophyceae	3028117	Bacteria	Bacteria	248	2.68e-61	NTclustered	gi\|1861038533\|dbj\|LC557452.1\|	1126	g112717	i0	88.406	124.907630522088	207	23	83	1	30	236	160	365	Microcystis aeruginosa NIES-1082 gene for 23S rRNA, partial sequence	blastn	31102	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
15937884	15937884	PRJNA669701_P_NODE_115053_length_249_cov_0.875000_g114658_i0	PRJNA669701	115053	249	0.875	2.17875	Tolypothrix sp. PCC 7910	2099387	Bacteria	Bacteria	115	2.83e-21	NTclustered	gi\|1826566097\|gb\|CP050440.1\|	2099387	g114658	i0	77.723	2.42168674698795	202	35	79	9	3	199	3834610	3834806	Tolypothrix sp. PCC 7910 chromosome, complete genome	blastn	603	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7910
16467357	16467357	PRJNA669701_P_NODE_57953_length_319_cov_2.699187_g57558_i0	PRJNA669701	57953	319	2.699187	8.61040653	Oscillatoriales	1150	Bacteria	Bacteria	568	2.3999999999999993e-157	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g57558	i0	98.746	149.407523510972	319	4	100	0	1	319	1373612	1373294	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	47661	568	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
19015792	19015792	PRJNA669701_P_NODE_23955_length_480_cov_3.321867_g23560_i0	PRJNA669701	23955	480	3.321867	15.9449616	Oscillatoriales	1150	Bacteria	Bacteria	859	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g23560	i0	98.958	136.877083333333	480	5	100	0	1	480	2877	2398	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	65701	865	0.993063583815029	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19761889	19761889	PRJNA669701_P_NODE_110516_length_250_cov_1.497175_g110121_i0	PRJNA669701	110516	250	1.497175	3.7429375	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	213	9.81e-51	NTclustered	gi\|2804745243\|gb\|CP166621.1\|	3104317	g110121	i0	82.573	4.056	241	42	96	0	1	241	3669219	3668979	MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome	blastn	1014	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
21037505	21037505	PRJNA669701_P_NODE_113177_length_249_cov_3.045455_g112782_i0	PRJNA669701	113177	249	3.045455	7.58318295	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	388	1.51e-103	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g112782	i0	94.821	163.843373493976	251	9	100	4	1	249	4389491	4389243	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	40797	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
22313066	22313066	PRJNA669701_P_NODE_36098_length_392_cov_2.037618_g35703_i0	PRJNA669701	36098	392	2.037618	7.98746256	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	612	1.37e-170	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g35703	i0	94.924	162.704081632653	394	14	100	4	1	392	2847	2458	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	63780	612	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22842264	22842264	PRJNA669701_P_NODE_96578_length_263_cov_1.215789_g96183_i0	PRJNA669701	96578	263	1.215789	3.19752507	Oscillatoriales	1150	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g96183	i0	100	148.167300380228	263	0	100	0	1	263	102393	102131	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	38968	486	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
23587622	23587622	PRJNA669701_P_NODE_100479_length_258_cov_2.389189_g100084_i0	PRJNA669701	100479	258	2.389189	6.16410762	Nodosilinea epilithica	1123966	Bacteria	Bacteria	455	1.53e-123	NTclustered	gi\|1435360276\|gb\|MH688851.1\|	2290992	g100084	i0	98.45	184.306201550388	258	4	100	0	1	258	2526	2269	Nodosilinea cf. epilithica Us-2-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47551	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea epilithica
24861821	24861821	PRJNA669701_P_NODE_26700_length_455_cov_1.000000_g26305_i0	PRJNA669701	26700	455	1	4.55	Calothrix sp. PCC 7507	99598	Bacteria	Bacteria	69.4	4.38e-7	NTclustered	gi\|427347790\|gb\|CP003943.1\|	99598	g26305	i0	100	1.87472527472527	37	0	8	0	413	449	3022158	3022194	Calothrix sp. PCC 7507 chromosome, complete genome	blastn	853	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7507
24862567	24862567	PRJNA669701_P_NODE_87520_length_273_cov_1.475000_g87125_i0	PRJNA669701	87520	273	1.475	4.02675	Synechococcus sp. CBW1107	2789857	Bacteria	Bacteria	220	6.49e-53	NTclustered	gi\|2638498304\|emb\|OY986430.1\|	2789857	g87125	i0	82.879	66.3333333333333	257	32	92	11	1	251	917622	917872	Synechococcus sp. CBW1107 isolate KAC_114 genome assembly, chromosome: 1	blastn	18109	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107

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