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

13 rows where analysis = "blastn", bioproject = "PRJNA917598" 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
895517	895517	PRJNA917598_P_NODE_24661_length_465_cov_3.000000_g23718_i0	PRJNA917598	24661	465	3	13.95	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	135	4.36e-27	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g23718	i0	79.512	1.35913978494624	205	31	44	9	67	269	2366807	2367002	Leptolyngbya sp. 7M chromosome	blastn	632	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
895982	895982	PRJNA917598_P_NODE_42001_length_354_cov_1.854093_g41057_i0	PRJNA917598	42001	354	1.854093	6.56348922	Limnospira platensis	118562	Bacteria	Bacteria	412	1.3299999999999995e-110	NTclustered	gi\|83777317\|gb\|DQ120927.1\|	357682	g41057	i0	88.922	0.943502824858757	334	37	94	0	21	354	507	174	Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds	blastn	334	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
896199	896199	PRJNA917598_P_NODE_50481_length_322_cov_2.277108_g49537_i0	PRJNA917598	50481	322	2.277108	7.33228776	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	235	2.8e-57	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g49537	i0	80.363	1.62422360248447	331	48	100	13	1	322	125729	126051	Leptolyngbya sp. 7M chromosome	blastn	523	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
896428	896428	PRJNA917598_P_NODE_59501_length_292_cov_2.146119_g58557_i0	PRJNA917598	59501	292	2.146119	6.26666748	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	235	2.5e-57	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g58557	i0	81.605	20.7397260273973	299	42	100	11	1	292	3680992	3681284	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	6056	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
3446479	3446479	PRJNA917598_P_NODE_25723_length_456_cov_1.245431_g24779_i0	PRJNA917598	25723	456	1.245431	5.67916536	Oculatella lusitanica	2928764	Bacteria	Bacteria	804	0	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g24779	i0	98.465	126.767543859649	456	7	100	0	1	456	3298	2843	Oculatella lusitanica LEGE 161147 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	57806	804	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
5999794	5999794	PRJNA917598_P_NODE_65085_length_282_cov_0.784689_g64141_i0	PRJNA917598	65085	282	0.784689	2.21282298	Synechococcus sp. PCC 7502	1173263	Bacteria	Bacteria	244	4e-60	NTclustered	gi\|427993480\|gb\|CP003594.1\|	1173263	g64141	i0	82.686	174.152482269504	283	41	99	6	2	282	1848307	1848583	Synechococcus sp. PCC 7502, complete genome	blastn	49111	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PCC 7502
7273844	7273844	PRJNA917598_P_NODE_26806_length_446_cov_1.010724_g25862_i0	PRJNA917598	26806	446	1.010724	4.50782904	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	597	4.4199999999999985e-166	NTclustered	gi\|225696180\|gb\|FJ805847.1\|	259957	g25862	i0	92.019	99.8520179372197	426	32	96	1	1	426	2461	2884	Uncultured Chroococcidiopsis sp. clone AU1_6 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44534	597	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11098715	11098715	PRJNA917598_P_NODE_10289_length_743_cov_5.497015_g9396_i0	PRJNA917598	10289	743	5.497015	40.84282145	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	499	2.21e-136	NTclustered	gi\|1280084619\|gb\|MF574181.1\|	119533	g9396	i0	80.261	216.555854643338	689	114	92	20	1	680	3076	3751	Scytonema hyalinum rrn type 1 operon, precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, 23S ribosomal RNA, 23S-5S ITS, and 5S ribosomal RNA genes, complete sequence	blastn	160901	499	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
12374453	12374453	PRJNA917598_P_NODE_13930_length_632_cov_2.171735_g12998_i0	PRJNA917598	13930	632	2.171735	13.7253652	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	597	6.429999999999999e-166	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g12998	i0	84.345	140.346518987342	626	80	98	17	4	623	3159	3772	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	88699	597	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
14923809	14923809	PRJNA917598_P_NODE_36812_length_378_cov_1.996721_g35868_i0	PRJNA917598	36812	378	1.996721	7.54760538	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	514	3.82e-141	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g35868	i0	92.758	171.94708994709	359	20	95	6	21	378	2151838	2151485	Leptolyngbya sp. 7M chromosome	blastn	64996	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
17475100	17475100	PRJNA917598_P_NODE_7774_length_863_cov_1.200000_g6956_i0	PRJNA917598	7774	863	1.2	10.356	Oculatella lusitanica	2928764	Bacteria	Bacteria	1493	0	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g6956	i0	97.914	214.173812282735	863	16	99	1	1	861	2904	2042	Oculatella lusitanica LEGE 161147 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	184832	1493	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
20022639	20022639	PRJNA917598_P_NODE_39636_length_365_cov_1.003425_g38692_i0	PRJNA917598	39636	365	1.003425	3.66250125	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	298	4.03e-76	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g38692	i0	82.065	438.098630136986	368	49	100	13	1	365	3650	3297	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	159906	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
23848284	23848284	PRJNA917598_P_NODE_41099_length_358_cov_1.603509_g40155_i0	PRJNA917598	41099	358	1.603509	5.74056222	uncultured Microcoleus sp.	259945	Bacteria	Bacteria	579	1.2599999999999999e-160	NTclustered	gi\|430000732\|gb\|JX877658.1\|	259945	g40155	i0	95.81	106.717877094972	358	15	100	0	1	358	40	397	Uncultured Microcoleus sp. clone HP02 16S ribosomal RNA gene, partial sequence	blastn	38205	579	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	uncultured Microcoleus 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);;