RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA352850" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA352850 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_kingdom 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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
8049795 8049795 PRJNA352850_P_NODE_71107_length_266_cov_1.820276_g68274_i0 PRJNA352850 71107 266 1.820276 4.84193416 Craticula sp. RGastineau-2025a 3393937 SAR_Eukaryotes SAR_Eukaryotes 99 3.08e-16   NTclustered gi|2906190882|gb|PV031684.1| 3393937 g68274 i0 83.636 69.1390977443609 110 13 41 5 55 162 55120 55014 Craticula sp. RGastineau-2025a strain SZCZEY2171 mitochondrion, complete genome blastn 18391 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp. RGastineau-2025a
18247899 18247899 PRJNA352850_P_NODE_61255_length_295_cov_2.439024_g58422_i0 PRJNA352850 61255 295 2.439024 7.1951208 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 121 7.4e-23   NTclustered gi|1418586621|ref|NC_037987.1| 1458866 g58422 i0 78.191 4.45084745762712 188 41 64 0 19 206 5727 5914 Eunotia naegelii strain UTEX FD354 mitochondrion, complete genome blastn 1313 121 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
20796527 20796527 PRJNA352850_P_NODE_24677_length_559_cov_9.488235_g21861_i0 PRJNA352850 24677 559 9.488235 53.03923365 Entomoneis sp. 186043 SAR_Eukaryotes SAR_Eukaryotes 176 3.13e-39   NTclustered gi|1372147530|gb|MF997419.1| 186043 g21861 i0 74.444 14.6100178890877 450 95 79 18 66 508 21256 21692 Entomoneis sp. mitochondrion, complete genome blastn 8167 176 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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