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

12 rows where analysis = "blastn", bioproject = "PRJNA1166865" 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
313054	313054	PRJNA1166865_P_NODE_48041_length_318_cov_1.093878_g47800_i0	PRJNA1166865	48041	318	1.093878	3.47853204	uncultured Oscillatoriales cyanobacterium	156210	Bacteria	Bacteria	488	1.9199999999999997e-133	NTclustered	gi\|745734109\|gb\|KM458382.1\|	156210	g47800	i0	95.44	111.657232704403	307	13	97	1	12	318	70	375	Uncultured Oscillatoriales cyanobacterium isolate OTU 00129 23S ribosomal RNA gene, partial sequence	blastn	35507	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			uncultured Oscillatoriales cyanobacterium
5415828	5415828	PRJNA1166865_P_NODE_37965_length_353_cov_0.960714_g37724_i0	PRJNA1166865	37965	353	0.960714	3.39132042	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	409	1.72e-109	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g37724	i0	89.297	287.889518413598	327	34	93	1	1	327	3681802	3681477	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	101625	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
7965458	7965458	PRJNA1166865_P_NODE_1627_length_1371_cov_2.459938_g1540_i0	PRJNA1166865	1627	1371	2.459938	33.72574998	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1932	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g1540	i0	92.107	104.421590080233	1381	93	100	15	1	1371	3048	1674	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	143162	1932	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9240659	9240659	PRJNA1166865_P_NODE_36488_length_359_cov_1.622378_g36247_i0	PRJNA1166865	36488	359	1.622378	5.82433702	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	329	1.4e-85	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g36247	i0	88.806	76.5208913649025	268	30	75	0	5	272	3680254	3680521	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	27471	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
9967773	9967773	PRJNA1166865_P_NODE_8828_length_711_cov_2.557994_g1540_i1	PRJNA1166865	8828	711	2.557994	18.18733734	Cyanophyceae	3028117	Bacteria	Bacteria	1048	0	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g1540	i1	93.268	112.174402250352	713	44	100	4	1	711	2339	3049	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	79756	1048	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12518314	12518314	PRJNA1166865_P_NODE_67830_length_267_cov_2.381443_g67589_i0	PRJNA1166865	67830	267	2.381443	6.35845281	Cyanophyceae	3028117	Bacteria	Bacteria	403	5.8499999999999995e-108	NTclustered	gi\|1280084619\|gb\|MF574181.1\|	119533	g67589	i0	94.007	211.98127340824	267	15	100	1	1	267	4889	5154	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	56599	407	0.99017199017199	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
14342604	14342604	PRJNA1166865_P_NODE_73932_length_253_cov_1.627778_g73691_i0	PRJNA1166865	73932	253	1.627778	4.11827834	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	259	1.26e-64	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g73691	i0	85.271	147.359683794466	258	31	100	6	1	253	2152176	2151921	Leptolyngbya sp. 7M chromosome	blastn	37282	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
15615523	15615523	PRJNA1166865_P_NODE_36393_length_360_cov_1.027875_g36152_i0	PRJNA1166865	36393	360	1.027875	3.70035	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	505	2.18e-138	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g36152	i0	91.967	110.486111111111	361	28	100	1	1	360	2889	3249	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	39775	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15616543	15616543	PRJNA1166865_P_NODE_77633_length_250_cov_0.870056_g77392_i0	PRJNA1166865	77633	250	0.870056	2.17514	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	427	3.22e-115	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g77392	i0	97.6	128.376	250	5	99	1	2	250	1974	1725	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32094	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20714970	20714970	PRJNA1166865_P_NODE_72677_length_256_cov_1.672131_g72436_i0	PRJNA1166865	72677	256	1.672131	4.28065536	Limnothrix sp. BL-A-16	3104318	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2804687704\|gb\|CP166615.1\|	3104318	g72436	i0	96.97	0.41796875	33	1	13	0	34	66	691448	691416	MAG: Limnothrix sp. BL-A-16 chromosome, complete genome	blastn	107	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix sp. BL-A-16
21989014	21989014	PRJNA1166865_P_NODE_19338_length_488_cov_2.171084_g19097_i0	PRJNA1166865	19338	488	2.171084	10.59488992	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	710	0	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g19097	i0	92.901	143.270491803279	493	27	100	8	1	488	591	102	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	69916	710	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
24539295	24539295	PRJNA1166865_P_NODE_61380_length_282_cov_1.990431_g61139_i0	PRJNA1166865	61380	282	1.990431	5.61301542	uncultured Oscillatoriales cyanobacterium	156210	Bacteria	Bacteria	505	1.6599999999999995e-138	NTclustered	gi\|409969065\|gb\|JQ700671.1\|	156210	g61139	i0	98.936	99.9290780141844	282	3	100	0	1	282	699	418	Uncultured Oscillatoriales cyanobacterium clone Co_14 16S ribosomal RNA gene, partial sequence	blastn	28180	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			uncultured Oscillatoriales 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);;