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

15 rows where analysis = "blastn", bioproject = "PRJNA379145" 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
2349401	2349401	PRJNA379145_P_NODE_7742_length_1093_cov_17.508491_g6814_i0	PRJNA379145	7742	1093	17.508491	191.36780663	Cyanophyceae	3028117	Bacteria	Bacteria	1502	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g6814	i0	91.606	113.360475754803	1096	79	99	11	1	1089	2103	3192	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	123903	1502	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3624710	3624710	PRJNA379145_P_NODE_19903_length_598_cov_11.421239_g18038_i0	PRJNA379145	19903	598	11.421239	68.29900922	Chroococcidiopsidales	1890505	Bacteria	Bacteria	699	0	NTclustered	gi\|225696214\|gb\|FJ805881.1\|	259957	g18038	i0	89.818	104.627090301003	550	49	91	6	54	598	2163	1616	Uncultured Chroococcidiopsis sp. clone A3_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	62567	699	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6778609	6778609	PRJNA379145_P_NODE_38986_length_312_cov_2.032258_g36835_i0	PRJNA379145	38986	312	2.032258	6.34064496	Prochlorococcus marinus	1219	Bacteria	Bacteria	86.1	2.88e-12	NTclustered	gi\|91070580\|gb\|DQ366742.1\|	379394	g36835	i0	86.076	0.868589743589744	79	11	25	0	14	92	27224	27302	Uncultured Prochlorococcus marinus clone HOT0M-8E2 genomic sequence	blastn	271	86.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
6778785	6778785	PRJNA379145_P_NODE_57986_length_196_cov_13.153374_g55832_i0	PRJNA379145	57986	196	13.153374	25.78061304	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	302	1.5200000000000001e-77	NTclustered	gi\|225696268\|gb\|FJ805935.1\|	259957	g55832	i0	94.416	168.571428571429	197	10	100	1	1	196	1512	1708	Uncultured Chroococcidiopsis sp. clone NA1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33040	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9329047	9329047	PRJNA379145_P_NODE_49388_length_237_cov_1.500000_g47234_i0	PRJNA379145	49388	237	1.5	3.555	Synechococcus sp. MIT S9503	3082547	Bacteria	Bacteria	167	7.279999999999999e-37	NTclustered	gi\|2895599907\|gb\|CP138955.1\|	3082547	g47234	i0	84.393	184.071729957806	173	23	72	4	66	235	4230	4401	Synechococcus sp. MIT S9503 chromosome, complete genome	blastn	43625	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. MIT S9503
10002158	10002158	PRJNA379145_P_NODE_53568_length_215_cov_1.758242_g51414_i0	PRJNA379145	53568	215	1.758242	3.7802203	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2552542308\|gb\|CP130602.1\|	1140	g51414	i0	100	1.3953488372093	30	0	14	0	32	61	1838493	1838522	Synechococcus elongatus PCC 7942 = FACHB-805 strain UTEX 2434 chromosome, complete genome	blastn	300	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus elongatus
10604943	10604943	PRJNA379145_P_NODE_8229_length_1060_cov_4.227848_g7251_i0	PRJNA379145	8229	1060	4.227848	44.8151888	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g7251	i0	100	0.0584905660377358	31	0	3	0	141	171	2739457	2739487	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	62	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
12552595	12552595	PRJNA379145_P_NODE_63070_length_178_cov_1.986207_g60916_i0	PRJNA379145	63070	178	1.986207	3.53544846	Oscillatoriales	1150	Bacteria	Bacteria	318	1.34e-82	NTclustered	gi\|1345606773\|gb\|MG968507.1\|	1521532	g60916	i0	98.876	147.331460674157	178	2	100	0	1	178	780	603	Oscillatoria amoena SAG 1459-7 23S ribosomal RNA gene, partial sequence	blastn	26225	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria amoena
16376472	16376472	PRJNA379145_P_NODE_32553_length_381_cov_4.956897_g30417_i0	PRJNA379145	32553	381	4.956897	18.88577757	Hassallia	482629	Bacteria	Bacteria	412	1.4499999999999998e-110	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g30417	i0	91.558	264.314960629921	308	13	81	3	75	381	2483	2188	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	100704	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
16978179	16978179	PRJNA379145_P_NODE_33994_length_364_cov_1.540785_g31849_i0	PRJNA379145	33994	364	1.540785	5.6084574	Nostoc sp. UHCC 0926	3025190	Bacteria	Bacteria	69.4	3.43e-7	NTclustered	gi\|2444439127\|gb\|CP117768.1\|	3025190	g31849	i0	91.837	0.43956043956044	49	4	13	0	81	129	267138	267090	Nostoc sp. UHCC 0926 chromosome, complete genome	blastn	160	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0926
18252453	18252453	PRJNA379145_P_NODE_33495_length_369_cov_6.642857_g31353_i0	PRJNA379145	33495	369	6.642857	24.51214233	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	418	2.999999999999999e-112	NTclustered	gi\|225696175\|gb\|FJ805842.1\|	259957	g31353	i0	92.203	90.2547425474255	295	23	80	0	1	295	1756	2050	Uncultured Chroococcidiopsis sp. clone AU1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33304	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18252622	18252622	PRJNA379145_P_NODE_50015_length_233_cov_2.310000_g47861_i0	PRJNA379145	50015	233	2.31	5.3823	Spirirestis rafaelensis	293980	Bacteria	Bacteria	370	5.07e-98	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g47861	i0	95.319	266.579399141631	235	8	99	2	2	233	225	459	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	62113	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
22077349	22077349	PRJNA379145_P_NODE_34458_length_358_cov_6.301538_g32313_i0	PRJNA379145	34458	358	6.301538	22.55950604	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	462	1.32e-125	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g32313	i0	90.055	112.45251396648	362	28	100	5	1	358	3264	2907	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	40258	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23353188	23353188	PRJNA379145_P_NODE_72039_length_155_cov_1.139344_g69884_i0	PRJNA379145	72039	155	1.139344	1.7659832	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	187	3.3499999999999995e-43	NTclustered	gi\|225696268\|gb\|FJ805935.1\|	259957	g69884	i0	88.462	46.1870967741935	156	17	100	1	1	155	3135	2980	Uncultured Chroococcidiopsis sp. clone NA1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	7159	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25300268	25300268	PRJNA379145_P_NODE_61680_length_183_cov_1.533333_g59526_i0	PRJNA379145	61680	183	1.533333	2.80599939	Cyanophyceae	3028117	Bacteria	Bacteria	111	2.54e-20	NTclustered	gi\|453199514\|gb\|JQ997494.1\|	259957	g59526	i0	96.97	50.9508196721311	66	2	36	0	117	182	215	150	Uncultured Chroococcidiopsis sp. clone GKJWQY101BW03X 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	9324	111	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);;