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

10 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
7829917	7829917	PRJNA1059246_P_NODE_61847_length_251_cov_0.865169_g61221_i0	PRJNA1059246	61847	251	0.865169	2.17157419	Candidatus Atelocyanobacterium thalassae	713887	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2117893480\|dbj\|AP024987.1\|	1285375	g61221	i0	100	0.111553784860558	28	0	11	0	29	56	651681	651708	Cyanobacterium endosymbiont of Braarudosphaera bigelowii CPSB-1 DNA, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Candidatus Atelocyanobacterium	Candidatus Atelocyanobacterium thalassae
9105090	9105090	PRJNA1059246_P_NODE_7888_length_868_cov_2.939623_g7379_i0	PRJNA1059246	7888	868	2.939623	25.51592764	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	965	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g7379	i0	86.797	313.306451612903	871	108	100	6	1	868	3680910	3681776	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	271950	965	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12930541	12930541	PRJNA1059246_P_NODE_20251_length_505_cov_2.587963_g19633_i0	PRJNA1059246	20251	505	2.587963	13.06921315	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	833	0	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g19633	i0	96.436	149.485148514851	505	18	100	0	1	505	2011	1507	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	75490	833	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17589312	17589312	PRJNA1059246_P_NODE_52014_length_283_cov_1.390476_g51388_i0	PRJNA1059246	52014	283	1.390476	3.93504708	Leptolyngbya	47251	Bacteria	Bacteria	477	3.639999999999999e-130	NTclustered	gi\|338221247\|gb\|JF925321.1\|	1048838	g51388	i0	97.173	113.604240282686	283	6	100	1	1	283	289	9	Leptolyngbya sp. CYN83 16S ribosomal RNA gene, partial sequence	blastn	32150	477	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. CYN83
18028936	18028936	PRJNA1059246_P_NODE_49535_length_290_cov_2.271889_g48909_i0	PRJNA1059246	49535	290	2.271889	6.5884781	Oscillatoria acuminata	118323	Bacteria	Bacteria	448	2.9299999999999995e-121	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g48909	i0	94.774	185.268965517241	287	15	100	0	4	290	2201269	2200983	Oscillatoria acuminata PCC 6304, complete genome	blastn	53728	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
18029082	18029082	PRJNA1059246_P_NODE_62055_length_251_cov_0.865169_g61429_i0	PRJNA1059246	62055	251	0.865169	2.17157419	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	331	2.6100000000000006e-86	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g61429	i0	91.949	78.2908366533864	236	19	94	0	14	249	6131779	6131544	Leptolyngbya sp. 7M chromosome	blastn	19651	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
19302992	19302992	PRJNA1059246_P_NODE_54716_length_275_cov_1.044554_g54090_i0	PRJNA1059246	54716	275	1.044554	2.8725235	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	62.1	4.2e-5	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g54090	i0	94.872	4.32	39	2	14	0	45	83	2274404	2274366	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	1188	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
21854263	21854263	PRJNA1059246_P_NODE_67818_length_245_cov_1.343023_g67192_i0	PRJNA1059246	67818	245	1.343023	3.29040635	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	202	2.08e-47	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g67192	i0	83.111	17.4612244897959	225	34	91	4	20	242	4828801	4828579	Leptolyngbya sp. 7M chromosome	blastn	4278	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
22688373	22688373	PRJNA1059246_P_NODE_60818_length_253_cov_1.572222_g60192_i0	PRJNA1059246	60818	253	1.572222	3.97772166	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	147	1.02e-30	NTclustered	gi\|308205634\|gb\|HQ291116.1\|	676037	g60192	i0	89.655	24.3201581027668	116	11	46	1	1	116	1545	1431	Nostoc flagelliforme str. Sunitezuoqi clone 44 hypothetical protein (Nfla_4401), hypothetical protein (Nfla_4402), amidohydrolase (Nfla_4403), brefeldin A esterase (Nfla_4404), and 6-phosphogluconate dehydrogenase (Nfla_4405) genes, complete cds	blastn	6153	148	0.993243243243243	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
23129073	23129073	PRJNA1059246_P_NODE_15979_length_582_cov_4.220039_g15377_i0	PRJNA1059246	15979	582	4.220039	24.56062698	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1009	0	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g15377	i0	97.938	105.278350515464	582	12	100	0	1	582	2155	2736	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	61272	1009	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);;