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

9 rows where analysis = "blastn", bioproject = "PRJNA285816" 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
2334418	2334418	PRJNA285816_S_NODE_6742_length_270_cov_1.674208_g6640_i0	PRJNA285816	6742	270	1.674208	4.5203616	Bacillati	1783272	Bacteria	Bacteria	422	1.64e-113	NTclustered	gi\|527170040\|emb\|HE858145.1\|	1211	g6640	i0	94.815	99.1518518518518	270	14	100	0	1	270	438	169	Uncultured cyanobacterium partial 16S rRNA gene, clone TB_21	blastn	26771	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2922817	2922817	PRJNA285816_S_NODE_7303_length_261_cov_3.316038_g7201_i0	PRJNA285816	7303	261	3.316038	8.65485918	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g7201	i0	100	0.10727969348659	28	0	11	0	220	247	1626661	1626688	Nostoc sp. PCC 7524, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
4199026	4199026	PRJNA285816_S_NODE_1404_length_553_cov_1.710317_g1308_i0	PRJNA285816	1404	553	1.710317	9.45805301	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	599	1.55e-166	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1308	i0	86.388	91.871609403255	551	72	99	2	4	553	3681453	3680905	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	50805	599	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8025293	8025293	PRJNA285816_S_NODE_22807_length_172_cov_1.268293_g22705_i0	PRJNA285816	22807	172	1.268293	2.18146396	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	235	1.33e-57	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g22705	i0	95.27	60.8372093023256	148	7	86	0	4	151	2367628	2367481	Nodosilinea sp. E11 chromosome	blastn	10464	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
8025382	8025382	PRJNA285816_S_NODE_29207_length_162_cov_1.371681_g29105_i0	PRJNA285816	29207	162	1.371681	2.22212322	Cyanobium gracile	59930	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g29105	i0	100	0.172839506172839	28	0	17	0	6	33	3220391	3220364	Cyanobium gracile PCC 6307, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
11262325	11262325	PRJNA285816_S_NODE_2209_length_447_cov_1.505025_g2107_i0	PRJNA285816	2209	447	1.505025	6.72746175	Chroococcidiopsis	54298	Bacteria	Bacteria	815	0	NTclustered	gi\|146141742\|gb\|EF522246.1\|	1211	g2107	i0	99.553	99.7046979865772	447	2	100	0	1	447	749	303	Uncultured cyanobacterium clone FQSS026 16S ribosomal RNA gene, partial sequence	blastn	44568	815	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11262360	11262360	PRJNA285816_S_NODE_889_length_673_cov_4.498397_g821_i0	PRJNA285816	889	673	4.498397	30.27421181	Nodosilinea	1120752	Bacteria	Bacteria	1232	0	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g821	i0	99.703	148.493313521545	673	2	100	0	1	673	3371	2699	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	99936	1232	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
14401107	14401107	PRJNA285816_S_NODE_4472_length_322_cov_5.285714_g4370_i0	PRJNA285816	4472	322	5.285714	17.01999908	Nodosilinea sp. 2.2B	2876719	Bacteria	Bacteria	568	2.4299999999999993e-157	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g4370	i0	98.447	216.959627329193	322	5	100	0	1	322	2286	2607	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	69861	568	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
16949432	16949432	PRJNA285816_S_NODE_2674_length_409_cov_5.369444_g2572_i0	PRJNA285816	2674	409	5.369444	21.96102596	Nodosilinea signiensis	2768016	Bacteria	Bacteria	704	0	NTclustered	gi\|1897879578\|gb\|MT946555.1\|	2768018	g2572	i0	97.579	148.540342298289	413	6	100	3	1	409	1937	2349	Nodosilinea cf. signiensis NN-3-1-CD 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	60753	704	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea signiensis

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