RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA951810", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 20 ✖

tax_kingdom 1

  • Metazoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA951810 · 20 ✖

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
8590147 8590147 PRJNA951810_P_NODE_29987_length_366_cov_2.153584_g29645_i0 PRJNA951810 29987 366 2.153584 7.88211744 Halichondria panicea 6063 Porifera other_Eukaryota 114 3.18e-29   NR XP_064402577.1 6063 g29645 i0 59.1 2.79508196721311 115 45 93.4 2 23 364 18 131 XP_064402577.1 uncharacterized protein LOC135348325 [Halichondria panicea] diamond 1023 114 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
17513621 17513621 PRJNA951810_P_NODE_111614_length_285_cov_10.627358_g111270_i0 PRJNA951810 111614 285 10.627358 30.2879703 Metazoa 33208 Porifera other_Eukaryota 166 7.66e-49   NR CAI7992851.1 519541 g111270 i0 77.9 17 95 21 100 0 1 285 61 155 CAI7992851.1 T-complex protein 1 subunit epsilon [Geodia barretti] diamond 4845 167 0.994011976047904 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
26779054 26779054 PRJNA951810_P_NODE_174141_length_238_cov_6.624242_g173796_i0 PRJNA951810 174141 238 6.624242 15.76569596 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 93.6 4.26e-20   NR XP_065197853.1 27933 g173796 i0 58.2 22.6134453781513 79 31 97.1 1 236 6 228 306 XP_065197853.1 endoplasmic reticulum mannosyl-oligosaccharide 1,2-alpha-mannosidase-like [Sycon ciliatum] diamond 5382 93.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
26905670 26905670 PRJNA951810_P_NODE_42861_length_310_cov_8.751055_g42518_i0 PRJNA951810 42861 310 8.751055 27.1282705 root 1 Root_unresolved Root_unresolved 44.3 0.0246   NR XP_065890264.1 196820 g42518 i0 51.1 1.72258064516129 45 21 42.6 1 144 13 435 479 XP_065890264.1 leucine-rich repeat serine/threonine-protein kinase 2-like [Dysidea avara] diamond 534 44.7 0.991051454138702 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
26993814 26993814 PRJNA951810_P_NODE_27102_length_386_cov_5.536741_g26760_i0 PRJNA951810 27102 386 5.536741 21.37182026 Corticium candelabrum 121492 Porifera other_Eukaryota 67 3.73e-10   NR XP_062499402.1 121492 g26760 i0 48.5 1.59326424870466 66 32 51.3 1 9 206 119 182 XP_062499402.1 mitochondrial substrate carrier family protein G-like [Corticium candelabrum] diamond 615 67 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
27784079 27784079 PRJNA951810_P_NODE_195784_length_202_cov_4.875969_g195439_i0 PRJNA951810 195784 202 4.875969 9.84945738 Amphimedon queenslandica 400682 Porifera other_Eukaryota 82.8 7.01e-17   NR XP_003384811.1 400682 g195439 i0 67.8 1.76732673267327 59 19 87.6 0 194 18 220 278 XP_003384811.1 PREDICTED: 60S acidic ribosomal protein P0-like [Amphimedon queenslandica] diamond 357 82.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
27853415 27853415 PRJNA951810_P_NODE_186544_length_223_cov_5.853333_g186199_i0 PRJNA951810 186544 223 5.853333 13.05293259 root 1 Root_unresolved Root_unresolved 84.3 6.49e-17   NR KAI6656849.1 111878 g186199 i0 68.3 12.0941704035874 60 19 80.7 0 222 43 339 398 KAI6656849.1 P protein-like [Oopsacas minuta] diamond 2697 84.3 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
28225540 28225540 PRJNA951810_P_NODE_104306_length_290_cov_4.764977_g103962_i0 PRJNA951810 104306 290 4.764977 13.8184333 Sycon ciliatum 27933 Porifera other_Eukaryota 58.5 1.84e-7   NR XP_065181207.1 27933 g103962 i0 40.7 0.889655172413793 86 49 86.9 2 2 253 200 285 XP_065181207.1 TRAF2 and NCK-interacting protein kinase-like [Sycon ciliatum] diamond 258 58.5 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29110052 29110052 PRJNA951810_P_NODE_180048_length_232_cov_3.207547_g179703_i0 PRJNA951810 180048 232 3.207547 7.44150904 Geodia barretti 519541 Porifera other_Eukaryota 56.6 4.1e-7   NR CAI8050751.1 519541 g179703 i0 40.3 1.86206896551724 72 41 90.5 1 22 231 17 88 CAI8050751.1 Serine/threonine-protein kinase PINK1, mitochondrial [Geodia barretti] diamond 432 56.6 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29330927 29330927 PRJNA951810_P_NODE_188149_length_220_cov_4.278912_g187804_i0 PRJNA951810 188149 220 4.278912 9.4136064 Geodia barretti 519541 Porifera other_Eukaryota 59.7 1.63e-8   NR CAI8040394.1 519541 g187804 i0 53.3 1.67727272727273 60 28 81.8 0 3 182 181 240 CAI8040394.1 40S ribosomal protein S3-B [Geodia barretti] diamond 369 59.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29551871 29551871 PRJNA951810_P_NODE_94150_length_296_cov_2.923767_g93806_i0 PRJNA951810 94150 296 2.923767 8.65435032 Halichondria panicea 6063 Porifera other_Eukaryota 80.5 3.85e-15   NR XP_064382755.1 6063 g93806 i0 56.3 1.96621621621622 64 28 64.9 0 105 296 801 864 XP_064382755.1 lysosomal alpha-glucosidase-like [Halichondria panicea] diamond 582 80.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30032312 30032312 PRJNA951810_P_NODE_95351_length_295_cov_4.765766_g95007_i0 PRJNA951810 95351 295 4.765766 14.0590097 root 1 Root_unresolved Root_unresolved 51.2 5.92e-5   NR XP_065916461.1 196820 g95007 i0 53.7 2.31864406779661 41 19 41.7 0 290 168 103 143 XP_065916461.1 monoglyceride lipase-like [Dysidea avara] diamond 684 51.6 0.992248062015504 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30247078 30247078 PRJNA951810_P_NODE_180152_length_232_cov_2.591195_g179807_i0 PRJNA951810 180152 232 2.591195 6.0115724 Sycon ciliatum 27933 Porifera other_Eukaryota 45.1 0.00508   NR XP_065181207.1 27933 g179807 i0 45 0.775862068965517 60 30 76.3 2 2 178 201 258 XP_065181207.1 TRAF2 and NCK-interacting protein kinase-like [Sycon ciliatum] diamond 180 45.1 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30973670 30973670 PRJNA951810_P_NODE_169314_length_243_cov_1.447059_g168969_i0 PRJNA951810 169314 243 1.447059 3.51635337 Dysidea avara 196820 Porifera other_Eukaryota 63.5 1.45e-9   NR XP_065902146.1 196820 g168969 i0 62.7 1.22222222222222 51 19 63 0 181 29 286 336 XP_065902146.1 quinone oxidoreductase-like [Dysidea avara] diamond 297 63.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31106294 31106294 PRJNA951810_P_NODE_168055_length_244_cov_1.432749_g167710_i0 PRJNA951810 168055 244 1.432749 3.49590756 root 1 Root_unresolved Root_unresolved 55.5 1.21e-6   NR XP_064393088.1 6063 g167710 i0 69.7 6.4672131147541 33 10 40.6 0 244 146 32 64 XP_064393088.1 dnaJ homolog subfamily A member 2-like [Halichondria panicea] diamond 1578 55.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31637408 31637408 PRJNA951810_P_NODE_169236_length_243_cov_1.752941_g168891_i0 PRJNA951810 169236 243 1.752941 4.25964663 Oscarella lobularis 121494 Porifera other_Eukaryota 65.9 2.59e-10   NR XP_065842163.1 121494 g168891 i0 42.3 3.69135802469136 78 35 84 1 205 2 207 284 XP_065842163.1 LON peptidase N-terminal domain and RING finger protein 3-like isoform X2 [Oscarella lobularis] diamond 897 65.9 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
31922183 31922183 PRJNA951810_P_NODE_166817_length_245_cov_0.895349_g166472_i0 PRJNA951810 166817 245 0.895349 2.19360505 Amphimedon queenslandica 400682 Porifera other_Eukaryota 47.8 6.64e-4   NR XP_019848995.1 400682 g166472 i0 56.1 0.502040816326531 41 18 50.2 0 123 245 813 853 XP_019848995.1 PREDICTED: structural maintenance of chromosomes protein 4-like [Amphimedon queenslandica] diamond 123 47.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
32238846 32238846 PRJNA951810_P_NODE_112658_length_285_cov_2.462264_g112314_i0 PRJNA951810 112658 285 2.462264 7.0174524 Dysidea avara 196820 Porifera other_Eukaryota 63.5 2.97e-9   NR XP_065909000.1 196820 g112314 i0 54.7 4.68421052631579 53 23 55.8 1 1 159 336 387 XP_065909000.1 E3 ubiquitin-protein ligase TRIM71-like [Dysidea avara] diamond 1335 63.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32302250 32302250 PRJNA951810_P_NODE_161199_length_249_cov_2.386364_g160854_i0 PRJNA951810 161199 249 2.386364 5.94204636 Dysidea avara 196820 Porifera other_Eukaryota 58.5 1.08e-7   NR XP_065889942.1 196820 g160854 i0 47.4 0.91566265060241 76 39 91.6 1 14 241 616 690 XP_065889942.1 E3 ubiquitin-protein ligase HECTD3-like [Dysidea avara] diamond 228 58.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32844913 32844913 PRJNA951810_P_NODE_174740_length_238_cov_2.418182_g174395_i0 PRJNA951810 174740 238 2.418182 5.75527316 Opisthokonta 33154 Porifera other_Eukaryota 68.9 2.01e-11   NR XP_064403991.1 6063 g174395 i0 50 3.13865546218487 64 31 80.7 1 17 208 170 232 XP_064403991.1 uncharacterized protein LOC135349391 [Halichondria panicea] diamond 747 69.3 0.994227994227994 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea

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