RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1145997", tax_phylum = "Evosea" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 6 ✖

tax_phylum 1

  • Evosea · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1145997 · 6 ✖

analysis 1

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
5392336 5392336 PRJNA1145997_P_NODE_19105_length_736_cov_4.719457_g16603_i0 PRJNA1145997 19105 736 4.719457 34.73520352 Planoprotostelium fungivorum 1890364 Evosea other_Eukaryota 385 6.5099999999999984e-133   NR PRP82564.1 1890364 g16603 i0 85.2 0.855978260869565 210 31 85.6 0 697 68 45 254 PRP82564.1 S60 ribosomal protein L10 [Planoprotostelium fungivorum] diamond 630 385 1 Eukaryota Amoebozoa   Evosea Variosea Cavosteliida Cavosteliaceae Planoprotostelium Planoprotostelium fungivorum
26975631 26975631 PRJNA1145997_P_NODE_26482_length_471_cov_9.211055_g23866_i0 PRJNA1145997 26482 471 9.211055 43.38406905 Polysphondylium violaceum 133409 Evosea other_Eukaryota 77.8 7.96e-14   NR KAF2072750.1 133409 g23866 i0 38.3 0.732484076433121 115 70 73.2 1 37 381 156 269 KAF2072750.1 hypothetical protein CYY_005938 [Polysphondylium violaceum] diamond 345 77.8 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Polysphondylium Polysphondylium violaceum
28207394 28207394 PRJNA1145997_P_NODE_37326_length_286_cov_2.868545_g34707_i0 PRJNA1145997 37326 286 2.868545 8.2040387 Pelomyxa schiedti 1580589 Evosea other_Eukaryota 43.5 0.0135   NR KAH3764260.1 1580589 g34707 i0 39.6 1.36363636363636 53 32 55.6 0 112 270 43 95 KAH3764260.1 hypothetical protein Pelo_3878 [Pelomyxa schiedti] diamond 390 43.5 1 Eukaryota Amoebozoa   Evosea   Pelobiontida Pelomyxidae Pelomyxa Pelomyxa schiedti
28302260 28302260 PRJNA1145997_P_NODE_31666_length_354_cov_7.128114_g29047_i0 PRJNA1145997 31666 354 7.128114 25.23352356 Heterostelium album PN5 2086695 Evosea other_Eukaryota 44.3 0.0375   NR XP_020435909.1 670386 g29047 i0 57.1 0.296610169491525 35 15 29.7 0 128 232 131 165 XP_020435909.1 hypothetical protein PPL_02860 [Heterostelium album PN500] diamond 105 44.3 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Acytosteliales Acytosteliaceae Heterostelium Heterostelium album
29627933 29627933 PRJNA1145997_P_NODE_29670_length_391_cov_4.210692_g27052_i0 PRJNA1145997 29670 391 4.210692 16.46380572 Planoprotostelium fungivorum 1890364 Evosea other_Eukaryota 132 7.13e-34   NR PRP77394.1 1890364 g27052 i0 53.6 0.859335038363171 112 52 85.9 0 377 42 294 405 PRP77394.1 hypothetical protein PROFUN_14400 [Planoprotostelium fungivorum] diamond 336 132 1 Eukaryota Amoebozoa   Evosea Variosea Cavosteliida Cavosteliaceae Planoprotostelium Planoprotostelium fungivorum
31050327 31050327 PRJNA1145997_P_NODE_22775_length_595_cov_9.195402_g20170_i0 PRJNA1145997 22775 595 9.195402 54.7126419 Tieghemostelium lacteum 361077 Evosea other_Eukaryota 175 2.21e-50   NR KYR02370.1 361077 g20170 i0 61.9 0.700840336134454 139 50 69.6 2 523 110 162 298 KYR02370.1 AhpC/TSA family protein [Tieghemostelium lacteum] diamond 417 175 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Raperosteliaceae Tieghemostelium Tieghemostelium lacteum

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