RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA290839" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA290839 · 11 ✖

analysis 1

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
4200038 4200038 PRJNA290839_P_NODE_364_length_442_cov_1.043360_g343_i0 PRJNA290839 364 442 1.04336 4.6116512 Halichondria panicea 6063 Porifera other_Eukaryota 199 1.11e-60   NR XP_064395651.1 6063 g343 i0 67.3 3.99095022624434 147 44 99.8 1 441 1 88 230 XP_064395651.1 large ribosomal subunit protein uL18 [Halichondria panicea] diamond 1764 199 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
9300979 9300979 PRJNA290839_P_NODE_488_length_368_cov_1.562712_g467_i0 PRJNA290839 488 368 1.562712 5.75078016 Geodia barretti 519541 Porifera other_Eukaryota 189 2.65e-58   NR CAI8032315.1 519541 g467 i0 76.2 0.994565217391304 122 29 99.5 0 3 368 2 123 CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] diamond 366 189 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
10576829 10576829 PRJNA290839_P_NODE_1269_length_248_cov_0.891429_g1248_i0 PRJNA290839 1269 248 0.891429 2.21074392 Corticium candelabrum 121492 Porifera other_Eukaryota 147 8.58e-44   NR XP_062508220.1 121492 g1248 i0 84.1 6.94354838709677 82 13 99.2 0 2 247 41 122 XP_062508220.1 small ribosomal subunit protein uS8 [Corticium candelabrum] diamond 1722 147 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
16950297 16950297 PRJNA290839_P_NODE_394_length_412_cov_1.230088_g373_i0 PRJNA290839 394 412 1.230088 5.06796256 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 203 2.03e-64   NR XP_064384635.1 6063 g373 i0 78.9 56.5194174757282 133 28 96.8 0 399 1 1 133 XP_064384635.1 large ribosomal subunit protein uL11-like [Halichondria panicea] diamond 23286 205 0.990243902439024 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
27168794 27168794 PRJNA290839_P_NODE_1002_length_254_cov_1.287293_g981_i0 PRJNA290839 1002 254 1.287293 3.26972422 Oopsacas minuta 111878 Porifera other_Eukaryota 93.2 7.21e-20   NR KAI6652214.1 111878 g981 i0 58.5 14.2322834645669 65 27 76.8 0 196 2 24 88 KAI6652214.1 Casein kinase I isoform epsilon [Oopsacas minuta] diamond 3615 93.2 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
27706376 27706376 PRJNA290839_P_NODE_684_length_309_cov_1.317797_g663_i0 PRJNA290839 684 309 1.317797 4.07199273 Oscarella lobularis 121494 Porifera other_Eukaryota 52.8 1.78e-5   NR XP_065837205.1 121494 g663 i0 42.4 0.640776699029126 66 37 64.1 1 72 269 38 102 XP_065837205.1 uncharacterized protein [Oscarella lobularis] diamond 198 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28527141 28527141 PRJNA290839_P_NODE_1127_length_251_cov_0.870787_g1106_i0 PRJNA290839 1127 251 0.870787 2.18567537 Amphimedon queenslandica 400682 Porifera other_Eukaryota 68.9 2.45e-11   NR XP_019848677.1 400682 g1106 i0 51.7 0.693227091633466 58 27 68.1 1 173 3 98 155 XP_019848677.1 PREDICTED: probable alpha-glucosidase Os06g0675700 [Amphimedon queenslandica] diamond 174 68.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
30091609 30091609 PRJNA290839_P_NODE_1432_length_246_cov_0.872832_g1411_i0 PRJNA290839 1432 246 0.872832 2.14716672 Demospongiae 6042 Porifera other_Eukaryota 62 5.41e-9   NR Q4KTE2.1 55567 g1411 i0 46.5 2.47560975609756 86 37 96.3 2 1 237 171 254 Q4KTE2.1 RecName: Full=Small ribosomal subunit protein uS2; AltName: Full=40S ribosomal protein SA [Suberites domuncula] diamond 609 62 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
31229029 31229029 PRJNA290839_P_NODE_1535_length_243_cov_1.476471_g1514_i0 PRJNA290839 1535 243 1.476471 3.58782453 root 1 Root_unresolved Root_unresolved 44.7 0.00678   NR XP_064390747.1 6063 g1514 i0 54.3 10.3703703703704 35 16 43.2 0 201 97 49 83 XP_064390747.1 small ribosomal subunit protein eS6-like [Halichondria panicea] diamond 2520 44.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31496497 31496497 PRJNA290839_P_NODE_1236_length_249_cov_0.880682_g1215_i0 PRJNA290839 1236 249 0.880682 2.19289818 Sycon ciliatum 27933 Porifera other_Eukaryota 73.6 5.81e-13   NR XP_065176847.1 27933 g1215 i0 58.5 0.987951807228916 82 34 98.8 0 246 1 704 785 XP_065176847.1 major vault protein-like [Sycon ciliatum] diamond 246 73.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32178445 32178445 PRJNA290839_P_NODE_1038_length_252_cov_1.307263_g1017_i0 PRJNA290839 1038 252 1.307263 3.29430276 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 92 2.2700000000000004e-21   NR XP_003388638.1 400682 g1017 i0 69 4.32142857142857 71 18 83.3 2 252 43 45 112 XP_003388638.1 PREDICTED: 40S ribosomal protein S10-like [Amphimedon queenslandica] diamond 1089 92 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica

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