RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1082072" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1082072 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
4019755 4019755 PRJNA1082072_P_NODE_884_length_356_cov_1.088339_g877_i0 PRJNA1082072 884 356 1.088339 3.87448684 Metazoa 33208 Porifera other_Eukaryota 169 3.25e-46   NR XP_065194361.1 27933 g877 i0 70.3 10.9044943820225 118 35 99.4 0 354 1 512 629 XP_065194361.1 major vault protein-like [Sycon ciliatum] diamond 3882 169 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
5295978 5295978 PRJNA1082072_P_NODE_385_length_491_cov_1.830144_g378_i0 PRJNA1082072 385 491 1.830144 8.98600704 Halichondria panicea 6063 Porifera other_Eukaryota 143 3.29e-36   NR XP_064391610.1 6063 g378 i0 69.3 0.995926680244399 163 50 99.6 0 489 1 645 807 XP_064391610.1 major vault protein-like [Halichondria panicea] diamond 489 143 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
20594223 20594223 PRJNA1082072_P_NODE_2257_length_249_cov_0.875000_g2250_i0 PRJNA1082072 2257 249 0.875 2.17875 Opisthokonta 33154 Porifera other_Eukaryota 80.9 1.03e-16   NR XP_064402576.1 6063 g2250 i0 52.4 63.1807228915663 82 36 95.2 1 241 5 42 123 XP_064402576.1 calmodulin-beta [Halichondria panicea] diamond 15732 81.6 0.991421568627451 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
21419206 21419206 PRJNA1082072_P_NODE_497_length_440_cov_1.130790_g490_i0 PRJNA1082072 497 440 1.13079 4.975476 Suberites domuncula 55567 Porifera other_Eukaryota 206 9.780000000000001e-64   NR Q4KTI3.1 55567 g490 i0 71.2 5.95909090909091 146 38 99.5 1 438 1 3 144 Q4KTI3.1 RecName: Full=Large ribosomal subunit protein uL18; AltName: Full=60S ribosomal protein L5 [Suberites domuncula] diamond 2622 206 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
26963864 26963864 PRJNA1082072_P_NODE_2122_length_251_cov_0.865169_g2115_i0 PRJNA1082072 2122 251 0.865169 2.17157419 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 130 1.02e-33   NR XP_064398741.1 6063 g2115 i0 68.3 29.402390438247 82 26 98 0 5 250 372 453 XP_064398741.1 serine--tRNA ligase, cytoplasmic-like [Halichondria panicea] diamond 7380 130 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
27004086 27004086 PRJNA1082072_P_NODE_1082_length_332_cov_1.154440_g1075_i0 PRJNA1082072 1082 332 1.15444 3.8327408 Geodia barretti 519541 Porifera other_Eukaryota 99 3.129999999999999e-23   NR CAI8029397.1 519541 g1075 i0 52.5 1.9066265060241 101 40 87.7 3 6 296 99 195 CAI8029397.1 hypothetical protein GBAR_LOCUS16700 [Geodia barretti] diamond 633 99 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
27478289 27478289 PRJNA1082072_P_NODE_2703_length_244_cov_0.900585_g2696_i0 PRJNA1082072 2703 244 0.900585 2.1974274 Amphimedon queenslandica 400682 Porifera other_Eukaryota 50.1 1e-4   NR XP_019855616.1 400682 g2696 i0 32 1.26639344262295 103 35 83.6 3 38 241 272 374 XP_019855616.1 PREDICTED: pyridoxal-dependent decarboxylase domain-containing protein 1-like [Amphimedon queenslandica] diamond 309 50.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
27848477 27848477 PRJNA1082072_P_NODE_1184_length_318_cov_1.661224_g1177_i0 PRJNA1082072 1184 318 1.661224 5.28269232 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 67 2.04e-10   NR CAH04631.1 55567 g1177 i0 42 2.33962264150943 69 40 65.1 0 230 24 27 95 CAH04631.1 cathepsin H [Suberites domuncula] diamond 744 67 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
28457229 28457229 PRJNA1082072_P_NODE_86_length_973_cov_2.528889_g82_i0 PRJNA1082072 86 973 2.528889 24.60608997 Geodia barretti 519541 Porifera other_Eukaryota 135 8.409999999999998e-35   NR CAI8030757.1 519541 g82 i0 50.3 0.490236382322713 159 64 46.9 6 463 8 25 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 477 135 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
28867523 28867523 PRJNA1082072_P_NODE_1908_length_262_cov_1.132275_g1901_i0 PRJNA1082072 1908 262 1.132275 2.9665605 Geodia barretti 519541 Porifera other_Eukaryota 132 1.77e-36   NR CAI8032315.1 519541 g1901 i0 77 0.99618320610687 87 20 99.6 0 2 262 5 91 CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] diamond 261 132 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
28962507 28962507 PRJNA1082072_P_NODE_2648_length_245_cov_0.895349_g2641_i0 PRJNA1082072 2648 245 0.895349 2.19360505 Oscarella lobularis 121494 Porifera other_Eukaryota 76.6 4.26e-14   NR XP_065842109.1 121494 g2641 i0 45.7 0.857142857142857 70 38 85.7 0 213 4 60 129 XP_065842109.1 uncharacterized protein [Oscarella lobularis] diamond 210 76.6 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29901089 29901089 PRJNA1082072_P_NODE_791_length_371_cov_2.483221_g784_i0 PRJNA1082072 791 371 2.483221 9.21274991 root 1 Root_unresolved Root_unresolved 92.4 4.45e-19   NR XP_064387462.1 6063 g784 i0 50 2.37735849056604 102 44 82.5 3 64 369 35 129 XP_064387462.1 uncharacterized protein LOC135335819 [Halichondria panicea] diamond 882 92.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30406829 30406829 PRJNA1082072_P_NODE_1213_length_314_cov_1.597510_g1206_i0 PRJNA1082072 1213 314 1.59751 5.0161814 Opisthokonta 33154 Porifera other_Eukaryota 92 4.45e-20   NR KAI6660403.1 111878 g1206 i0 54.1 2.8375796178344 98 45 93.6 0 21 314 27 124 KAI6660403.1 hypothetical protein LOD99_13989 [Oopsacas minuta] diamond 891 92.4 0.995670995670996 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
30848821 30848821 PRJNA1082072_P_NODE_2414_length_247_cov_1.327586_g2407_i0 PRJNA1082072 2414 247 1.327586 3.27913742 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 147 8.58e-44   NR XP_062508220.1 121492 g2407 i0 82.9 11.9514170040486 82 14 99.6 0 246 1 41 122 XP_062508220.1 small ribosomal subunit protein uS8 [Corticium candelabrum] diamond 2952 147 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31805871 31805871 PRJNA1082072_P_NODE_837_length_364_cov_1.158076_g830_i0 PRJNA1082072 837 364 1.158076 4.21539664 Geodia barretti 519541 Porifera other_Eukaryota 72.4 5.85e-13   NR CAI8030757.1 519541 g830 i0 50 0.741758241758242 90 33 70.1 4 257 3 72 154 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 270 72.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
32628070 32628070 PRJNA1082072_P_NODE_1540_length_284_cov_1.094787_g1533_i0 PRJNA1082072 1540 284 1.094787 3.10919508 Sycon ciliatum 27933 Porifera other_Eukaryota 109 1.9699999999999999e-28   NR CCQ18628.1 27933 g1533 i0 55.2 3.51760563380282 87 39 91.9 0 283 23 50 136 CCQ18628.1 40S ribosomal protein S2 [Sycon ciliatum] diamond 999 109 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum

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