RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA416866" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA416866 · 10 ✖

analysis 1

  • diamond · 10 ✖
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
14448546 14448546 PRJNA416866_P_NODE_532_length_1005_cov_2.890890_g427_i0 PRJNA416866 532 1005 2.89089 29.0534445 Halichondria panicea 6063 Porifera other_Eukaryota 376 6.52e-127   NR XP_064388847.1 6063 g427 i0 57.6 0.985074626865672 330 131 97.6 4 1005 25 9 332 XP_064388847.1 procathepsin L-like [Halichondria panicea] diamond 990 376 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
18271295 18271295 PRJNA416866_P_NODE_5375_length_282_cov_1.737557_g5231_i0 PRJNA416866 5375 282 1.737557 4.89991074 Opisthokonta 33154 Porifera other_Eukaryota 134 4.34e-38   NR XP_065830937.1 121494 g5231 i0 72.4 4.59574468085106 87 24 92.6 0 263 3 1 87 XP_065830937.1 small ribosomal subunit protein eS24-like [Oscarella lobularis] diamond 1296 135 0.992592592592593 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
27517984 27517984 PRJNA416866_P_NODE_4563_length_308_cov_1.295547_g4419_i0 PRJNA416866 4563 308 1.295547 3.99028476 Oopsacas minuta 111878 Porifera other_Eukaryota 141 2.37e-39   NR KAI6660403.1 111878 g4419 i0 71.7 2.9025974025974 99 28 96.4 0 298 2 61 159 KAI6660403.1 hypothetical protein LOD99_13989 [Oopsacas minuta] diamond 894 141 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
27581032 27581032 PRJNA416866_P_NODE_3964_length_332_cov_1.719557_g3821_i0 PRJNA416866 3964 332 1.719557 5.70892924 Halichondria panicea 6063 Porifera other_Eukaryota 141 3.1499999999999997e-37   NR XP_064385714.1 6063 g3821 i0 65.1 3.92168674698795 109 38 98.5 0 3 329 295 403 XP_064385714.1 lipoamide acyltransferase component of branched-chain alpha-keto acid dehydrogenase complex, mitochondrial-like isoform X2 [Halichondria panicea] diamond 1302 141 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
27928443 27928443 PRJNA416866_P_NODE_6845_length_248_cov_1.368984_g6701_i0 PRJNA416866 6845 248 1.368984 3.39508032 Sycon ciliatum 27933 Porifera other_Eukaryota 44.3 0.00973   NR XP_065177742.1 27933 g6701 i0 36.5 0.895161290322581 74 46 89.5 1 243 22 163 235 XP_065177742.1 protein phosphatase 1 regulatory inhibitor subunit 16B-like [Sycon ciliatum] diamond 222 44.3 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28450404 28450404 PRJNA416866_P_NODE_8886_length_216_cov_0.961290_g8742_i0 PRJNA416866 8886 216 0.96129 2.0763864 root 1 Root_unresolved Root_unresolved 111 1.02e-26   NR XP_065826812.1 121494 g8742 i0 74.6 12.8888888888889 71 18 98.6 0 4 216 122 192 XP_065826812.1 adenylosuccinate lyase-like [Oscarella lobularis] diamond 2784 112 0.991071428571429 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28576476 28576476 PRJNA416866_P_NODE_10587_length_205_cov_0.888889_g10443_i0 PRJNA416866 10587 205 0.888889 1.82222245 root 1 Root_unresolved Root_unresolved 87 8.11e-19   NR KAI6656485.1 111878 g10443 i0 56.7 2.89756097560976 67 29 98 0 203 3 72 138 KAI6656485.1 DNA ligase III [Oopsacas minuta] diamond 594 87.8 0.990888382687927 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
29191495 29191495 PRJNA416866_P_NODE_8269_length_224_cov_2.036810_g8125_i0 PRJNA416866 8269 224 2.03681 4.5624544 Oopsacas minuta 111878 Porifera other_Eukaryota 77 1.73e-14   NR KAI6654657.1 111878 g8125 i0 47.2 0.964285714285714 72 38 96.4 0 5 220 217 288 KAI6654657.1 Beta-1,3-glucan-binding protein-like [Oopsacas minuta] diamond 216 77 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
31529474 31529474 PRJNA416866_P_NODE_5716_length_273_cov_3.018868_g5572_i0 PRJNA416866 5716 273 3.018868 8.24150964 Corticium candelabrum 121492 Porifera other_Eukaryota 92 1.32e-20   NR XP_062519832.1 121492 g5572 i0 48.1 0.89010989010989 81 42 89 0 269 27 2 82 XP_062519832.1 LIM and SH3 domain protein 1-like [Corticium candelabrum] diamond 243 92 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
32415281 32415281 PRJNA416866_P_NODE_4939_length_295_cov_1.358974_g4795_i0 PRJNA416866 4939 295 1.358974 4.0089733 Amphimedon queenslandica 400682 Porifera other_Eukaryota 67.4 1.36e-10   NR XP_003388741.1 400682 g4795 i0 38.8 0.864406779661017 85 49 85.4 3 252 1 140 222 XP_003388741.1 PREDICTED: putative ascorbate peroxidase [Amphimedon queenslandica] diamond 255 67.4 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);;