RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1025141" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1025141 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
21839770 21839770 PRJNA1025141_P_NODE_9358_length_251_cov_1.039326_g9297_i0 PRJNA1025141 9358 251 1.039326 2.60870826 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 114 8.96e-31   NR ETO31022.1 46433 g9297 i0 71.6 3.66932270916335 74 21 88.4 0 28 249 21 94 ETO31022.1 heat shock protein 60 [Reticulomyxa filosa] diamond 921 114 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29151218 29151218 PRJNA1025141_P_NODE_5929_length_329_cov_1.203125_g5868_i0 PRJNA1025141 5929 329 1.203125 3.95828125 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.33e-6   NR ETO05878.1 46433 g5868 i0 30.7 3.72948328267477 101 52 92.1 2 18 320 28 110 ETO05878.1 ubiquitin activating enzyme 2 [Reticulomyxa filosa] diamond 1227 56.6 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29340393 29340393 PRJNA1025141_P_NODE_3009_length_472_cov_0.954887_g2948_i0 PRJNA1025141 3009 472 0.954887 4.50706664 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 205 2.48e-60   NR ETO05878.1 46433 g2948 i0 64.1 2.97457627118644 156 56 99.2 0 470 3 375 530 ETO05878.1 ubiquitin activating enzyme 2 [Reticulomyxa filosa] diamond 1404 205 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30319921 30319921 PRJNA1025141_P_NODE_7152_length_297_cov_1.008929_g7091_i0 PRJNA1025141 7152 297 1.008929 2.99651913 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 75.9 1.6e-13   NR ETO10415.1 46433 g7091 i0 48.7 9.58585858585859 78 40 78.8 0 59 292 83 160 ETO10415.1 inorganic pyrophosphatase [Reticulomyxa filosa] diamond 2847 75.9 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31330507 31330507 PRJNA1025141_P_NODE_7556_length_287_cov_1.079439_g7495_i0 PRJNA1025141 7556 287 1.079439 3.09798993 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 62.8 5.73e-9   NR ETO22870.1 46433 g7495 i0 40.4 0.930313588850174 89 51 90.9 2 275 15 318 406 ETO22870.1 peptidase C19 family ubiquitinyl hydrolase [Reticulomyxa filosa] diamond 267 62.8 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa

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