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

17 rows where analysis = "blastn", bioproject = "PRJNA1182301" 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
2869320	2869320	PRJNA1182301_P_NODE_33483_length_270_cov_2.289340_g33358_i0	PRJNA1182301	33483	270	2.28934	6.181218	Macrochaete lichenoides	1844961	Bacteria	Bacteria	436	5.8499999999999985e-118	NTclustered	gi\|1026355709\|gb\|KU559618.1\|	1521517	g33358	i0	95.926	308.9	270	9	100	2	1	270	1697	1964	Macrochaete lichenoides SAG 32.92 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	83403	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete lichenoides
7971324	7971324	PRJNA1182301_P_NODE_15047_length_310_cov_2.569620_g14922_i0	PRJNA1182301	15047	310	2.56962	7.965822	uncultured cyanobacterium	1211	Bacteria	Bacteria	532	8.48e-147	NTclustered	gi\|1774712280\|gb\|MN664716.1\|	1211	g14922	i0	96.774	97.6258064516129	310	9	100	1	1	310	386	78	Uncultured cyanobacterium clone abc2027 16S ribosomal RNA gene, partial sequence	blastn	30264	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7972015	7972015	PRJNA1182301_P_NODE_43747_length_257_cov_1.673913_g43622_i0	PRJNA1182301	43747	257	1.673913	4.30195641	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	348	2.6600000000000004e-91	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g43622	i0	91.085	111.311284046693	258	21	99	2	1	256	3036	3293	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28607	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7972272	7972272	PRJNA1182301_P_NODE_54167_length_247_cov_1.770115_g54042_i0	PRJNA1182301	54167	247	1.770115	4.37218405	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	143	1.29e-29	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g54042	i0	86.131	0.554655870445344	137	14	55	3	111	247	3178294	3178163	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	137	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
9245946	9245946	PRJNA1182301_P_NODE_14368_length_310_cov_3.084388_g14243_i0	PRJNA1182301	14368	310	3.084388	9.5616028	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	189	2.12e-43	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g14243	i0	89.333	0.574193548387097	150	16	48	0	161	310	2142733	2142882	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	178	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
11796702	11796702	PRJNA1182301_P_NODE_1550_length_647_cov_2.689895_g1430_i0	PRJNA1182301	1550	647	2.689895	17.40362065	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	981	0	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g1430	i0	94.118	108.527047913447	646	36	99	2	4	647	2811	2166	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	70217	981	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11797366	11797366	PRJNA1182301_P_NODE_42450_length_259_cov_1.360215_g42325_i0	PRJNA1182301	42450	259	1.360215	3.52295685	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	390	4.3999999999999996e-104	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g42325	i0	93.822	3.98841698841699	259	16	100	0	1	259	2307402	2307660	Nodosilinea sp. E11 chromosome	blastn	1033	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
11797605	11797605	PRJNA1182301_P_NODE_53490_length_248_cov_0.880000_g53365_i0	PRJNA1182301	53490	248	0.88	2.1824	Phormidium nigroviride	482564	Bacteria	Bacteria	300	7.26e-77	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g53365	i0	88.618	2.98387096774194	246	28	99	0	1	246	5912728	5912973	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	740	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
14347840	14347840	PRJNA1182301_P_NODE_45112_length_255_cov_2.181319_g44987_i0	PRJNA1182301	45112	255	2.181319	5.56236345	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	435	1.97e-117	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g44987	i0	97.297	117.423529411765	259	2	99	5	2	255	2068	1810	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29943	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14348130	14348130	PRJNA1182301_P_NODE_58672_length_244_cov_1.485380_g58547_i0	PRJNA1182301	58672	244	1.48538	3.6243272	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	143	1.27e-29	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g58547	i0	82.036	0.684426229508197	167	30	68	0	65	231	1206094	1206260	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	167	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
15621539	15621539	PRJNA1182301_P_NODE_43753_length_257_cov_1.673913_g43628_i0	PRJNA1182301	43753	257	1.673913	4.30195641	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	217	7.829999999999999e-52	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g43628	i0	82.143	2.09727626459144	252	45	98	0	4	255	7486317	7486568	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	539	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
16895517	16895517	PRJNA1182301_P_NODE_2734_length_524_cov_2.239468_g2610_i0	PRJNA1182301	2734	524	2.239468	11.73481232	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	939	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g2610	i0	99.044	202.320610687023	523	5	99	0	2	524	9969675	9969153	Calothrix sp. PCC 7716 DNA, complete genome	blastn	106016	939	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
18893250	18893250	PRJNA1182301_P_NODE_55315_length_246_cov_2.514451_g55190_i0	PRJNA1182301	55315	246	2.514451	6.18554946	Synechococcus	1129	Bacteria	Bacteria	226	1.2399999999999997e-54	NTclustered	gi\|1940477070\|gb\|CP060398.1\|	1353134	g55190	i0	83.784	5.13008130081301	259	21	97	8	8	246	2007653	2007396	Synechococcus sp. CBW1002 chromosome, complete genome	blastn	1262	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1002
19444711	19444711	PRJNA1182301_P_NODE_4036_length_460_cov_3.023256_g3911_i0	PRJNA1182301	4036	460	3.023256	13.9069776	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	604	2.729999999999999e-168	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g3911	i0	90.591	169.913043478261	457	42	99	1	1	457	2195	1740	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	78160	604	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19445310	19445310	PRJNA1182301_P_NODE_65656_length_234_cov_2.602484_g65531_i0	PRJNA1182301	65656	234	2.602484	6.08981256	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	387	5.06e-103	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g65531	i0	96.581	190.75641025641	234	7	100	1	1	234	1858844	1859076	Calothrix sp. PCC 7716 DNA, complete genome	blastn	44637	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
20719895	20719895	PRJNA1182301_P_NODE_34617_length_269_cov_1.571429_g34492_i0	PRJNA1182301	34617	269	1.571429	4.22714401	Egbenema sp. FJBBOT/2019	3398834	Bacteria	Bacteria	409	1.27e-109	NTclustered	gi\|2917372002\|gb\|CP182236.1\|	3398834	g34492	i0	94.052	167.702602230483	269	16	100	0	1	269	260534	260802	Egbenema sp. FJBBOT/2019 chromosome, complete genome	blastn	45112	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Egbenema	Egbenema sp. FJBBOT/2019
20720120	20720120	PRJNA1182301_P_NODE_43257_length_258_cov_1.281081_g43132_i0	PRJNA1182301	43257	258	1.281081	3.30518898	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	89.8	1.79e-13	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g43132	i0	85.227	1.74031007751938	88	12	34	1	59	145	6206353	6206440	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	449	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus

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