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

15 rows where analysis = "blastn", bioproject = "PRJNA674308" 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
644624	644624	PRJNA674308_P_NODE_26741_length_194_cov_1.324138_g26506_i0	PRJNA674308	26741	194	1.324138	2.56882772	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	220	4.34e-53	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g26506	i0	87.179	41.1546391752577	195	24	100	1	1	194	3679730	3679924	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	7984	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
1166548	1166548	PRJNA674308_P_NODE_24601_length_201_cov_1.546053_g24366_i0	PRJNA674308	24601	201	1.546053	3.10756653	Cyanophyceae	3028117	Bacteria	Bacteria	361	2.5599999999999998e-95	NTclustered	gi\|161723086\|gb\|EU282445.1\|	1211	g24366	i0	99.005	100.064676616915	201	2	100	0	1	201	532	732	Uncultured cyanobacterium clone ES35D6 16S ribosomal RNA gene, partial sequence	blastn	20113	361	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
3195599	3195599	PRJNA674308_P_NODE_31923_length_179_cov_1.600000_g31688_i0	PRJNA674308	31923	179	1.6	2.864	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	246	6.48e-61	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g31688	i0	92.09	162.061452513966	177	10	98	3	5	179	2151906	2151732	Leptolyngbya sp. 7M chromosome	blastn	29009	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
4472854	4472854	PRJNA674308_P_NODE_48564_length_164_cov_0.904348_g48329_i0	PRJNA674308	48564	164	0.904348	1.48313072	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	167	4.689999999999999e-37	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g48329	i0	86.842	7.56707317073171	152	16	91	3	1	150	1766710	1766561	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	1241	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
6270454	6270454	PRJNA674308_P_NODE_24865_length_200_cov_1.880795_g24630_i0	PRJNA674308	24865	200	1.880795	3.76159	Chroococcidiopsis	54298	Bacteria	Bacteria	331	1.99e-86	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g24630	i0	96.517	259.855	201	6	100	1	1	200	793096	792896	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	51971	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
6270533	6270533	PRJNA674308_P_NODE_32965_length_176_cov_1.637795_g32730_i0	PRJNA674308	32965	176	1.637795	2.8825192	Oscillatoriales	1150	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g32730	i0	100	143.289772727273	176	0	100	0	1	176	812904	812729	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	25219	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
7023351	7023351	PRJNA674308_P_NODE_23526_length_205_cov_1.583333_g23291_i0	PRJNA674308	23526	205	1.583333	3.24583265	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	279	7.54e-71	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g23291	i0	91.22	109.419512195122	205	18	100	0	1	205	3680349	3680553	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	22431	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12124072	12124072	PRJNA674308_P_NODE_35730_length_169_cov_1.516667_g35495_i0	PRJNA674308	35730	169	1.516667	2.56316723	Aliterella chasmolithica	2739056	Bacteria	Bacteria	268	1.29e-67	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g35495	i0	95.266	80.0650887573965	169	8	100	0	1	169	2270	2102	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	13531	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
12124153	12124153	PRJNA674308_P_NODE_44050_length_166_cov_0.888889_g43815_i0	PRJNA674308	44050	166	0.888889	1.47555574	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	139	1.04e-28	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g43815	i0	87.097	2.24698795180723	124	14	75	2	1	124	125981	125860	Leptolyngbya sp. 7M chromosome	blastn	373	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
14673986	14673986	PRJNA674308_P_NODE_7472_length_347_cov_11.157718_g7237_i0	PRJNA674308	7472	347	11.157718	38.71728146	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	372	2.22e-98	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g7237	i0	88.599	126.789625360231	307	34	88	1	1	307	3680024	3679719	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	43996	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
15195150	15195150	PRJNA674308_P_NODE_32132_length_178_cov_2.844961_g31897_i0	PRJNA674308	32132	178	2.844961	5.06403058	Cyanophyceae	3028117	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|55741013\|gb\|AY672718.1\|	54297	g31897	i0	100	102	178	0	100	0	1	178	417	594	Arthrospira fusiformis strain AICB 664 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	18156	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira fusiformis
15947293	15947293	PRJNA674308_P_NODE_19433_length_222_cov_3.005780_g19198_i0	PRJNA674308	19433	222	3.00578	6.6728316	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	399	6.099999999999999e-107	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g19198	i0	99.099	165.045045045045	222	2	100	0	1	222	3234	3455	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	36640	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21047224	21047224	PRJNA674308_P_NODE_27837_length_191_cov_0.950704_g27602_i0	PRJNA674308	27837	191	0.950704	1.81584464	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	309	8.83e-80	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g27602	i0	95.833	124.272251308901	192	6	100	2	1	191	205	15	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23736	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22322133	22322133	PRJNA674308_P_NODE_42118_length_166_cov_2.085470_g41883_i0	PRJNA674308	42118	166	2.08547	3.4618802	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	261	2.12e-65	NTclustered	gi\|225696213\|gb\|FJ805880.1\|	259957	g41883	i0	95.181	132.746987951807	166	7	100	1	1	166	3087	2923	Uncultured Chroococcidiopsis sp. clone A3_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22036	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24871045	24871045	PRJNA674308_P_NODE_480_length_1381_cov_14.805556_g395_i0	PRJNA674308	480	1381	14.805556	204.46472836	Stanieria cyanosphaera	102116	Bacteria	Bacteria	634	1.1e-176	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g395	i0	79.707	13.9869659666908	887	173	64	6	265	1146	885	1	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	19316	634	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera

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