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

20 rows where analysis = "blastn", bioproject = "PRJNA980587" 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
2231725	2231725	PRJNA980587_P_NODE_94742_length_241_cov_0.916667_g93949_i0	PRJNA980587	94742	241	0.916667	2.20916747	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	163	9.61e-36	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g93949	i0	80.09	1.83402489626556	221	43	91	1	22	241	2991699	2991479	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	442	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
4783884	4783884	PRJNA980587_P_NODE_46924_length_337_cov_1.159091_g46131_i0	PRJNA980587	46924	337	1.159091	3.90613667	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	617	2.4999999999999997e-172	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g46131	i0	99.703	219.943620178042	337	1	100	0	1	337	4387	4723	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	74121	617	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
8608313	8608313	PRJNA980587_P_NODE_25147_length_494_cov_1.351544_g24356_i0	PRJNA980587	25147	494	1.351544	6.67662736	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	558	2.33e-154	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g24356	i0	93.817	89.1052631578947	372	21	75	2	1	372	2357	1988	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	44018	558	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9883895	9883895	PRJNA980587_P_NODE_53228_length_314_cov_1.680498_g52435_i0	PRJNA980587	53228	314	1.680498	5.27676372	Microcoleus vaginatus	119532	Bacteria	Bacteria	520	6.6999999999999985e-143	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g52435	i0	96.497	65.0764331210191	314	11	100	0	1	314	5006514	5006201	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	20434	520	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
9884206	9884206	PRJNA980587_P_NODE_77708_length_252_cov_1.541899_g76915_i0	PRJNA980587	77708	252	1.541899	3.88558548	Microcoleus vaginatus	119532	Bacteria	Bacteria	344	3.37e-90	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g76915	i0	91.27	41.5873015873016	252	22	100	0	1	252	2752134	2751883	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	10480	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
9884250	9884250	PRJNA980587_P_NODE_80208_length_250_cov_0.870056_g79415_i0	PRJNA980587	80208	250	0.870056	2.17514	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	333	7.219999999999999e-87	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g79415	i0	90.8	188.396	250	22	100	1	1	250	13	261	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	47099	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
12434541	12434541	PRJNA980587_P_NODE_17090_length_629_cov_1.606115_g16313_i0	PRJNA980587	17090	629	1.606115	10.10246335	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	913	0	NTclustered	gi\|225696274\|gb\|FJ805941.1\|	259957	g16313	i0	92.971	104.758346581876	626	44	99	0	4	629	2423	3048	Uncultured Chroococcidiopsis sp. clone NA1_11 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	65893	913	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14983454	14983454	PRJNA980587_P_NODE_38932_length_375_cov_1.476821_g38139_i0	PRJNA980587	38932	375	1.476821	5.53807875	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	516	1.05e-141	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g38139	i0	92.541	200.477333333333	362	23	96	3	17	375	1744	2104	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	75179	516	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14983633	14983633	PRJNA980587_P_NODE_53152_length_314_cov_3.443983_g52359_i0	PRJNA980587	53152	314	3.443983	10.81410662	Prochlorothrix hollandica	1223	Bacteria	Bacteria	337	7.239999999999998e-88	NTclustered	gi\|146740638\|emb\|AM709625.1\|	317619	g52359	i0	86.435	174.468152866242	317	32	99	11	1	313	2824	3133	Prochlorothrix hollandica SAG 10.89 partial ribosomal RNA operon, strain SAG 10.89	blastn	54783	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Prochlorotrichales	Prochlorotrichaceae	Prochlorothrix	Prochlorothrix hollandica
16259152	16259152	PRJNA980587_P_NODE_87433_length_245_cov_2.686047_g86640_i0	PRJNA980587	87433	245	2.686047	6.58081515	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|1280084616\|gb\|MF574178.1\|	119533	g86640	i0	98.367	267.902040816327	245	4	100	0	1	245	2589	2833	Scytonema hyalinum rrn type 2 operon, precursor RNA, transcribed leader region, and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes, 23S-5S internal transcribed spacer, and 5S ribosomal RNA gene, complete sequence	blastn	65636	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
16572064	16572064	PRJNA980587_P_NODE_57073_length_302_cov_1.834061_g56280_i0	PRJNA980587	57073	302	1.834061	5.53886422	Microcoleus	44471	Bacteria	Bacteria	398	3.1399999999999993e-106	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g56280	i0	90.397	17.7086092715232	302	29	100	0	1	302	3444455	3444154	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	5348	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
16572156	16572156	PRJNA980587_P_NODE_89133_length_244_cov_1.801170_g88340_i0	PRJNA980587	89133	244	1.80117	4.3948548	Microcoleus	44471	Bacteria	Bacteria	346	9.019999999999999e-91	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g88340	i0	92.562	5.66803278688525	242	16	99	2	3	243	6208936	6208696	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1383	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
18807606	18807606	PRJNA980587_P_NODE_54795_length_309_cov_1.699153_g54002_i0	PRJNA980587	54795	309	1.699153	5.25038277	Picosynechococcus sp. PCC 7003	374981	Bacteria	Bacteria	420	6.87e-113	NTclustered	gi\|2275105\|emb\|X97393.1\|	374981	g54002	i0	92.23	8.69902912621359	296	23	96	0	9	304	299	4	Synechococcus sp. rnpB gene, strain PCC7003	blastn	2688	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7003
22632634	22632634	PRJNA980587_P_NODE_37418_length_384_cov_1.585209_g36625_i0	PRJNA980587	37418	384	1.585209	6.08720256	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	599	1.0399999999999995e-166	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g36625	i0	94.805	149.424479166667	385	19	100	1	1	384	744428	744044	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	57379	599	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
22633182	22633182	PRJNA980587_P_NODE_76318_length_255_cov_1.692308_g75525_i0	PRJNA980587	76318	255	1.692308	4.3153854	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	344	3.41e-90	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g75525	i0	91.051	14.6117647058824	257	19	100	4	1	255	6116025	6116279	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	3726	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
22633229	22633229	PRJNA980587_P_NODE_79198_length_251_cov_0.865169_g78405_i0	PRJNA980587	79198	251	0.865169	2.17157419	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	292	1.2299999999999999e-74	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g78405	i0	88	158.729083665339	250	26	99	4	1	248	2901	3148	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	39841	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23908172	23908172	PRJNA980587_P_NODE_45759_length_341_cov_2.279851_g44966_i0	PRJNA980587	45759	341	2.279851	7.77429191	Cylindrospermum sp. UTEX LB 942	2137584	Bacteria	Bacteria	344	4.75e-90	NTclustered	gi\|1373447557\|gb\|KY979119.1\|	2137584	g44966	i0	85.044	69.8445747800587	341	47	99	3	2	341	690	353	Cylindrospermum sp. UTEX LB 942 23S ribosomal RNA gene, partial sequence	blastn	23817	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum sp. UTEX LB 942
23908772	23908772	PRJNA980587_P_NODE_89159_length_244_cov_1.795322_g88366_i0	PRJNA980587	89159	244	1.795322	4.38058568	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	278	3.34e-70	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g88366	i0	87.552	93.077868852459	241	29	99	1	3	243	2839	3078	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22711	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25182530	25182530	PRJNA980587_P_NODE_95460_length_241_cov_0.916667_g94667_i0	PRJNA980587	95460	241	0.916667	2.20916747	Phormidium nigroviride	482564	Bacteria	Bacteria	357	4.1099999999999997e-94	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g94667	i0	93.361	6.95850622406639	241	16	100	0	1	241	1034777	1034537	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1677	357	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
25496128	25496128	PRJNA980587_P_NODE_96760_length_200_cov_4.732283_g95967_i0	PRJNA980587	96760	200	4.732283	9.464566	Bacteria	2	Bacteria	Bacteria	370	4.22e-98	NTclustered	gi\|389547840\|gb\|JQ402768.1\|	1211	g95967	i0	100	99.115	200	0	100	0	1	200	692	493	Uncultured cyanobacterium clone CNY_03229 16S ribosomal RNA gene, partial sequence	blastn	19823	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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