RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA407087" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA407087 · 18 ✖

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
26758811 26758811 PRJNA407087_S_NODE_1441_length_574_cov_52.638532_g1029_i0 PRJNA407087 1441 574 52.638532 302.14517368 Geodia barretti 519541 Porifera other_Eukaryota 140 1.91e-38   NR CAI8030757.1 519541 g1029 i0 51.3 0.815331010452962 156 61 77.9 6 1 447 28 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 468 140 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
26854195 26854195 PRJNA407087_S_NODE_881_length_783_cov_110.176393_g567_i1 PRJNA407087 881 783 110.176393 862.68115719 Geodia barretti 519541 Porifera other_Eukaryota 148 1.22e-40   NR CAI8030757.1 519541 g567 i1 51.8 0.636015325670498 166 65 60.9 6 293 769 18 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 498 148 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
26885806 26885806 PRJNA407087_S_NODE_1321_length_608_cov_52.671848_g928_i0 PRJNA407087 1321 608 52.671848 320.24483584 Geodia barretti 519541 Porifera other_Eukaryota 143 2.44e-39   NR CAI8030757.1 519541 g928 i0 49.4 1.59375 166 69 78.5 6 116 592 18 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 969 143 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
27154951 27154951 PRJNA407087_S_NODE_5482_length_218_cov_4.857143_g5019_i0 PRJNA407087 5482 218 4.857143 10.58857174 Demospongiae 6042 Porifera other_Eukaryota 109 5.65e-28   NR AFJ64431.1 178514 g5019 i0 71.8 3.89449541284404 71 20 97.7 0 2 214 57 127 AFJ64431.1 aldolase, partial [Amphimedon compressa] diamond 849 109 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon compressa
28023091 28023091 PRJNA407087_S_NODE_1425_length_580_cov_61.733212_g1018_i0 PRJNA407087 1425 580 61.733212 358.0526296 Geodia barretti 519541 Porifera other_Eukaryota 140 2.04e-38   NR CAI8030757.1 519541 g1018 i0 51.3 0.806896551724138 156 61 77.1 6 1 447 28 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 468 140 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
28039757 28039757 PRJNA407087_S_NODE_625_length_952_cov_5.510293_g391_i0 PRJNA407087 625 952 5.510293 52.45798936 Metazoa 33208 Porifera other_Eukaryota 390 8.209999999999996e-130   NR XP_064394482.1 6063 g391 i0 60.6 50.9558823529412 310 122 97.7 0 951 22 198 507 XP_064394482.1 methylmalonate-semialdehyde/malonate-semialdehyde dehydrogenase [acylating], mitochondrial-like [Halichondria panicea] diamond 48510 393 0.99236641221374 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28654510 28654510 PRJNA407087_S_NODE_6347_length_198_cov_3.136095_g5884_i0 PRJNA407087 6347 198 3.136095 6.2094681 Geodia barretti 519541 Porifera other_Eukaryota 70.9 1.73e-12   NR CAI8006611.1 519541 g5884 i0 53.1 0.96969696969697 64 29 97 1 197 6 73 135 CAI8006611.1 Serine dehydratase-like [Geodia barretti] diamond 192 70.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
28671285 28671285 PRJNA407087_S_NODE_8507_length_164_cov_3.548148_g8044_i0 PRJNA407087 8507 164 3.548148 5.81896272 Opisthokonta 33154 Porifera other_Eukaryota 63.9 3.66e-10   NR XP_064392077.1 6063 g8044 i0 60.4 5.72560975609756 53 19 97 2 5 163 124 174 XP_064392077.1 serine dehydratase-like [Halichondria panicea] diamond 939 64.3 0.993779160186625 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28749202 28749202 PRJNA407087_S_NODE_1327_length_606_cov_85.357019_g934_i0 PRJNA407087 1327 606 85.357019 517.26353514 Geodia barretti 519541 Porifera other_Eukaryota 148 2.58e-41   NR CAI8030757.1 519541 g934 i0 51.8 0.821782178217822 166 65 78.7 6 116 592 18 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 498 148 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29159856 29159856 PRJNA407087_S_NODE_4929_length_237_cov_2.692308_g4466_i0 PRJNA407087 4929 237 2.692308 6.38076996 Sycon ciliatum 27933 Porifera other_Eukaryota 58.2 6.13e-8   NR XP_065179218.1 27933 g4466 i0 43.7 0.89873417721519 71 35 89.9 1 2 214 154 219 XP_065179218.1 glutathione S-transferase Mu 1-like [Sycon ciliatum] diamond 213 58.2 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30486236 30486236 PRJNA407087_S_NODE_2753_length_376_cov_4.605187_g2291_i0 PRJNA407087 2753 376 4.605187 17.31550312 Halichondria panicea 6063 Porifera other_Eukaryota 146 4.9399999999999986e-40   NR XP_064392077.1 6063 g2291 i0 55.2 0.997340425531915 125 54 99.7 2 1 375 187 309 XP_064392077.1 serine dehydratase-like [Halichondria panicea] diamond 375 146 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30707285 30707285 PRJNA407087_S_NODE_6854_length_188_cov_6.031447_g6391_i0 PRJNA407087 6854 188 6.031447 11.33912036 Corticium candelabrum 121492 Porifera other_Eukaryota 47 5.76e-4   NR XP_062516935.1 121492 g6391 i0 44 1.61170212765957 50 26 76.6 1 146 3 628 677 XP_062516935.1 leishmanolysin-like peptidase [Corticium candelabrum] diamond 303 47 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31180960 31180960 PRJNA407087_S_NODE_5235_length_226_cov_2.005076_g4772_i0 PRJNA407087 5235 226 2.005076 4.53147176 Halichondria panicea 6063 Porifera other_Eukaryota 84 7.82e-17   NR XP_064395289.1 6063 g4772 i0 55.4 5.41592920353982 65 28 85 1 28 219 28 92 XP_064395289.1 serine carboxypeptidase S10 family member 1-like [Halichondria panicea] diamond 1224 84 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31276070 31276070 PRJNA407087_S_NODE_875_length_785_cov_85.078042_g567_i0 PRJNA407087 875 785 85.078042 667.8626297 Geodia barretti 519541 Porifera other_Eukaryota 143 1.1199999999999999e-38   NR CAI8030757.1 519541 g567 i0 49.4 1.2343949044586 166 69 60.8 6 493 17 18 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 969 143 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
31466116 31466116 PRJNA407087_S_NODE_9976_length_151_cov_1.500000_g9513_i0 PRJNA407087 9976 151 1.5 2.265 Oscarella lobularis 121494 Porifera other_Eukaryota 59.3 1.52e-8   NR XP_065844633.1 121494 g9513 i0 55.1 0.973509933774834 49 22 97.4 0 1 147 445 493 XP_065844633.1 26S proteasome non-ATPase regulatory subunit 2-like [Oscarella lobularis] diamond 147 59.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
31561004 31561004 PRJNA407087_S_NODE_2016_length_463_cov_108.175115_g1564_i0 PRJNA407087 2016 463 108.175115 500.85078245 Geodia barretti 519541 Porifera other_Eukaryota 145 3.93e-41   NR CAI8030757.1 519541 g1564 i0 53.8 1.01079913606911 156 57 96.5 6 463 17 28 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 468 145 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
31876938 31876938 PRJNA407087_S_NODE_2717_length_379_cov_82.745714_g2255_i0 PRJNA407087 2717 379 82.745714 313.60625606 Geodia barretti 519541 Porifera other_Eukaryota 85.1 8.91e-18   NR CAI8030757.1 519541 g2255 i0 54.8 0.66490765171504 84 32 64.9 2 379 134 96 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 252 85.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
32415137 32415137 PRJNA407087_S_NODE_2779_length_373_cov_68.703488_g2317_i0 PRJNA407087 2779 373 68.703488 256.26401024 Geodia barretti 519541 Porifera other_Eukaryota 85.1 8.32e-18   NR CAI8030757.1 519541 g2317 i0 54.8 0.675603217158177 84 32 66 2 373 128 96 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 252 85.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti

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