RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA813520" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA813520 · 15 ✖
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
815044 815044 PRJNA813520_S_NODE_1741_length_274_cov_113.453061_g1694_i0 PRJNA813520 1741 274 113.453061 310.86138714 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|1044897043|gb|KT223635.1| 354439 g1694 i0 100 0.102189781021898 28 0 10 0 212 239 58 31 Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
7193269 7193269 PRJNA813520_S_NODE_4566_length_170_cov_6.730496_g4519_i0 PRJNA813520 4566 170 6.730496 11.4418432 Timema tahoe 61484 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1946537262|emb|OE128069.1| 61484 g4519 i0 100 0.170588235294118 29 0 17 0 57 85 88 60 4_Tte_b3v08 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
8878507 8878507 PRJNA813520_S_NODE_5087_length_161_cov_2.469697_g5040_i0 PRJNA813520 5087 161 2.469697 3.97621217 Timema 61471 Arthropoda Arthropoda 52.8 0.013   NTclustered gi|1936955213|emb|OA567898.1| 61478 g5040 i0 100 0.521739130434783 28 0 17 0 41 68 49402 49375 1_Tdi_b3v08 blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
9743087 9743087 PRJNA813520_S_NODE_1168_length_327_cov_82.080537_g1121_i0 PRJNA813520 1168 327 82.080537 268.40335599 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 52.8 0.031   NTclustered gi|1044897043|gb|KT223635.1| 354439 g1121 i0 100 0.0856269113149847 28 0 9 0 36 63 31 58 Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
9743090 9743090 PRJNA813520_S_NODE_1468_length_297_cov_21.190299_g1421_i0 PRJNA813520 1468 297 21.190299 62.93518803 Scylla paramamosain 85552 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1184387702|emb|LT835105.1| 85552 g1421 i0 100 0.205387205387205 29 0 10 0 4 32 6 34 Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) blastn 61 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
9743096 9743096 PRJNA813520_S_NODE_2288_length_240_cov_115.573460_g2241_i0 PRJNA813520 2288 240 115.57346 277.376304 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1044897043|gb|KT223635.1| 354439 g2241 i0 100 0.120833333333333 29 0 12 0 177 205 59 31 Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
11018843 11018843 PRJNA813520_S_NODE_2969_length_212_cov_165.393443_g2922_i0 PRJNA813520 2969 212 165.393443 350.63409916 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.019   NTclustered gi|1965352140|emb|OE839425.1| 629358 g2922 i0 100 0.132075471698113 28 0 13 0 70 97 12476 12449 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
12294272 12294272 PRJNA813520_S_NODE_150_length_807_cov_46.645244_g127_i0 PRJNA813520 150 807 46.645244 376.42711908 root 1 Root_unresolved Root_unresolved 334 3.4499999999999987e-107   NR ODN03678.1 48709 g127 i0 68.2 166.617100371747 242 73 88.8 3 91 807 6 246 ODN03678.1 Heat shock 70 kDa protein [Orchesella cincta] diamond 134460 337 0.991097922848665 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
17393416 17393416 PRJNA813520_S_NODE_3174_length_206_cov_2.135593_g3127_i0 PRJNA813520 3174 206 2.135593 4.39932158 Platynothrus peltifer 128015 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|2579718317|gb|CP133306.1| 128015 g3127 i0 100 0.135922330097087 28 0 14 0 114 141 19738402 19738375 Platynothrus peltifer isolate 155_3 chromosome 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Camisiidae Platynothrus Platynothrus peltifer
17393426 17393426 PRJNA813520_S_NODE_4814_length_166_cov_1.897810_g4767_i0 PRJNA813520 4814 166 1.89781 3.1503646 Timema genevievae 629358 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|1964536497|emb|OE845740.1| 629358 g4767 i0 100 0.530120481927711 30 0 18 0 100 129 7201 7230 5_Tge_b3v08 blastn 88 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
17393434 17393434 PRJNA813520_S_NODE_554_length_449_cov_34.838095_g507_i0 PRJNA813520 554 449 34.838095 156.42304655 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.043   NTclustered gi|1965352161|emb|OE839429.1| 629358 g507 i0 100 0.0623608017817372 28 0 6 0 341 368 207360 207387 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
21217177 21217177 PRJNA813520_S_NODE_717_length_403_cov_70.743316_g670_i0 PRJNA813520 717 403 70.743316 285.09556348 Rhynchophorus ferrugineus 354439 Arthropoda Arthropoda 52.8 0.039   NTclustered gi|1044897043|gb|KT223635.1| 354439 g670 i0 100 0.0694789081885856 28 0 7 0 341 368 58 31 Rhynchophorus ferrugineus isolate RPWSSHCyp60 cathepsin L mRNA, partial cds blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
21627388 21627388 PRJNA813520_S_NODE_857_length_372_cov_22.967930_g810_i0 PRJNA813520 857 372 22.96793 85.4406996 Metazoa 33208 Arthropoda Arthropoda 52.8 0.035   NTclustered gi|2864125441|ref|XM_070121053.1| 6689 g810 i0 100 1.13172043010753 28 0 8 0 345 372 286 259 PREDICTED: Penaeus vannamei nucleolar protein 6 Mat89Ba (Mat89Ba), mRNA blastn 421 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
22491839 22491839 PRJNA813520_S_NODE_2838_length_217_cov_3.042553_g2791_i0 PRJNA813520 2838 217 3.042553 6.60234001 Bombus monticola 103936 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|2919524519|emb|OZ238329.1| 103936 g2791 i0 100 0.133640552995392 29 0 13 0 1 29 2951200 2951172 Bombus monticola genome assembly, chromosome: 7 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus monticola
28010886 28010886 PRJNA813520_S_NODE_105_length_956_cov_18.204962_g85_i0 PRJNA813520 105 956 18.204962 174.03943672 Diptera 7147 Arthropoda Arthropoda 137 2.2e-35   NR XP_037894365.1 7396 g85 i0 48.6 9.87866108786611 140 66 43.9 1 188 607 49 182 XP_037894365.1 ADP-ribose glycohydrolase OARD1 isoform X1 [Glossina fuscipes] diamond 9444 138 0.992753623188406 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina fuscipes

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