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

20 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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
1023135	1023135	PRJNA1112809_P_NODE_134001_length_280_cov_1.454106_g130726_i0	PRJNA1112809	134001	280	1.454106	4.0714968	Oscillatoriales	1150	Bacteria	Bacteria	220	6.68e-53	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g130726	i0	81.034	6.425	290	44	100	9	1	280	7007944	7008232	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1799	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
2299036	2299036	PRJNA1112809_P_NODE_81342_length_378_cov_11.777049_g78067_i0	PRJNA1112809	81342	378	11.777049	44.51724522	Microcoleus	44471	Bacteria	Bacteria	595	1.3299999999999996e-165	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g78067	i0	95.225	30.8386243386243	377	16	99	1	1	377	4420671	4420297	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	11657	601	0.990016638935108	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
5322653	5322653	PRJNA1112809_P_NODE_166365_length_250_cov_1.502825_g163090_i0	PRJNA1112809	166365	250	1.502825	3.7570625	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	283	7.379999999999999e-72	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g163090	i0	87.398	115.524	246	31	98	0	5	250	2938	3183	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	28881	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6126313	6126313	PRJNA1112809_P_NODE_187645_length_243_cov_0.905882_g184370_i0	PRJNA1112809	187645	243	0.905882	2.20129326	Nodosilinea	1120752	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|1897879575\|gb\|MT946552.1\|	2768010	g184370	i0	98.77	136.102880658436	244	2	100	1	1	243	2246	2003	Nodosilinea bijugata OD-1-1-T 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33073	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea bijugata
9146419	9146419	PRJNA1112809_P_NODE_108408_length_315_cov_1.909091_g105133_i0	PRJNA1112809	108408	315	1.909091	6.01363665	Phormidium nigroviride	482564	Bacteria	Bacteria	329	1.22e-85	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g105133	i0	86.349	62.8857142857143	315	28	100	6	1	315	6282663	6282364	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	19809	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
9951766	9951766	PRJNA1112809_P_NODE_66748_length_435_cov_1.334254_g63474_i0	PRJNA1112809	66748	435	1.334254	5.8040049	Pleurocapsa	44474	Bacteria	Bacteria	632	1.1799999999999995e-176	NTclustered	gi\|2717502813\|gb\|PP667996.1\|	2601948	g63474	i0	92.906	201.43908045977	437	28	100	3	1	435	2287	2722	Pleurocapsales cyanobacterium PJS 27 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	87626	638	0.990595611285266	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			Pleurocapsales cyanobacterium PJS 27
11698012	11698012	PRJNA1112809_P_NODE_138790_length_275_cov_1.301980_g135515_i0	PRJNA1112809	138790	275	1.30198	3.580445	Microcoleus vaginatus	119532	Bacteria	Bacteria	375	1.3199999999999998e-99	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g135515	i0	91.273	16.6727272727273	275	24	100	0	1	275	2141460	2141734	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	4585	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
12502180	12502180	PRJNA1112809_P_NODE_171230_length_248_cov_4.571429_g167955_i0	PRJNA1112809	171230	248	4.571429	11.33714392	Bacteria	2	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|15212603\|gb\|AY038730.1\|	1211	g167955	i0	99.597	100.004032258065	248	1	100	0	1	248	632	385	Uncultured cyanobacterium clone TAF-A202 16S ribosomal RNA gene, partial sequence	blastn	24801	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12975688	12975688	PRJNA1112809_P_NODE_99051_length_333_cov_1.592308_g95776_i0	PRJNA1112809	99051	333	1.592308	5.30238564	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	555	1.9599999999999995e-153	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g95776	i0	96.707	155.018018018018	334	10	100	1	1	333	1586	1919	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	51621	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
13776360	13776360	PRJNA1112809_P_NODE_104471_length_322_cov_2.373494_g101196_i0	PRJNA1112809	104471	322	2.373494	7.64265068	Bacteria	2	Bacteria	Bacteria	348	3.44e-91	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g101196	i0	88.772	114.959627329193	285	30	89	2	6	289	2086050	2085767	Synechococcus sp. CB0101 chromosome, complete genome	blastn	37017	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
15522799	15522799	PRJNA1112809_P_NODE_189933_length_242_cov_0.911243_g186658_i0	PRJNA1112809	189933	242	0.911243	2.20520806	Coleofasciculus chthonoplastes	64178	Bacteria	Bacteria	300	7.05e-77	NTclustered	gi\|146740643\|emb\|AM709630.1\|	118168	g186658	i0	89.256	123.095041322314	242	23	100	3	1	242	2249	2011	Microcoleus chthonoplastes PCC 7420 partial ribosomal RNA operon, strain PCC 7420	blastn	29789	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
15523918	15523918	PRJNA1112809_P_NODE_70873_length_416_cov_8.279883_g67598_i0	PRJNA1112809	70873	416	8.279883	34.44431328	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	634	3.1199999999999998e-177	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g67598	i0	94.245	113.709134615385	417	20	100	3	1	416	2466	2879	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47303	634	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16797170	16797170	PRJNA1112809_P_NODE_183894_length_244_cov_0.900585_g180619_i0	PRJNA1112809	183894	244	0.900585	2.1974274	Microcoleus vaginatus	119532	Bacteria	Bacteria	276	1.1999999999999998e-69	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g180619	i0	87.19	0.991803278688525	242	31	99	0	3	244	1005687	1005446	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	242	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
16797212	16797212	PRJNA1112809_P_NODE_186394_length_243_cov_1.358824_g183119_i0	PRJNA1112809	186394	243	1.358824	3.30194232	uncultured cyanobacterium	1211	Bacteria	Bacteria	412	8.72e-111	NTclustered	gi\|781856379\|emb\|LN808460.1\|	1211	g183119	i0	99.558	119.893004115226	226	1	93	0	18	243	1	226	Uncultured cyanobacterium partial 16S rRNA gene, clone denovo4796	blastn	29134	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16797941	16797941	PRJNA1112809_P_NODE_45394_length_584_cov_2.886497_g42153_i0	PRJNA1112809	45394	584	2.886497	16.85714248	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	771	0	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g42153	i0	90.46	109.669520547945	587	53	100	3	1	584	2262	1676	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	64047	771	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18071681	18071681	PRJNA1112809_P_NODE_182855_length_244_cov_2.409357_g179580_i0	PRJNA1112809	182855	244	2.409357	5.87883108	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	394	3.17e-105	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g179580	i0	97.425	113.66803278688499	233	2	95	4	14	244	2481	2711	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27735	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21895724	21895724	PRJNA1112809_P_NODE_120358_length_296_cov_2.695067_g117083_i0	PRJNA1112809	120358	296	2.695067	7.97739832	Phormidium nigroviride	482564	Bacteria	Bacteria	189	2.01e-43	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g117083	i0	89.333	2.01689189189189	150	16	51	0	147	296	6528981	6528832	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	597	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
22700289	22700289	PRJNA1112809_P_NODE_186858_length_243_cov_0.905882_g183583_i0	PRJNA1112809	186858	243	0.905882	2.20129326	Chlorogloeopsis	1123	Bacteria	Bacteria	189	1.6e-43	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g183583	i0	80.972	2.03292181069959	247	39	100	7	1	243	5912778	5913020	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	494	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
24447200	24447200	PRJNA1112809_P_NODE_59580_length_473_cov_2.752500_g56308_i0	PRJNA1112809	59580	473	2.7525	13.019325	uncultured Cyanothece sp.	259951	Bacteria	Bacteria	592	2.19e-164	NTclustered	gi\|643030817\|gb\|KF124702.1\|	259951	g56308	i0	98.802	39.5306553911205	334	1	70	3	141	473	410	79	Uncultured Cyanothece sp. clone GTFKKJB01DOFK1 genomic sequence	blastn	18698	592	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	uncultured Cyanothece sp.
24447898	24447898	PRJNA1112809_P_NODE_94740_length_342_cov_7.524164_g91465_i0	PRJNA1112809	94740	342	7.524164	25.73264088	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	455	2.11e-123	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g91465	i0	90.698	126.599415204678	344	28	100	4	1	342	3146	2805	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	43297	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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