RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA798905" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA798905 · 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
26746108 26746108 PRJNA798905_S_NODE_40161_length_240_cov_2.485030_g39712_i0 PRJNA798905 40161 240 2.48503 5.964072 Muntiacus 9885 Chordata Chordata 79 6.44e-15   NR KAB0373699.1 9886 g39712 i0 52.6 16.575 78 33 92.5 1 222 1 53 130 KAB0373699.1 hypothetical protein FD755_013955 [Muntiacus reevesi] diamond 3978 79 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Cervidae Muntiacus Muntiacus reevesi
27749217 27749217 PRJNA798905_S_NODE_3244_length_743_cov_613.671642_g2826_i0 PRJNA798905 3244 743 613.671642 4559.58030006 Bactrocera tryoni 59916 Arthropoda Arthropoda 62.4 2.23e-7   NR XP_039967484.1 59916 g2826 i0 65.9 0.177658142664872 44 15 17.8 0 372 503 1 44 XP_039967484.1 DNA ligase-like, partial [Bactrocera tryoni] diamond 132 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera tryoni
27969928 27969928 PRJNA798905_S_NODE_19705_length_334_cov_5.708812_g19256_i0 PRJNA798905 19705 334 5.708812 19.06743208 Hymenochirus boettgeri 247094 Chordata Chordata 43.5 0.0465   NR KAG8440169.1 247094 g19256 i0 36.3 0.718562874251497 80 42 66.5 2 88 309 152 228 KAG8440169.1 hypothetical protein GDO86_006102 [Hymenochirus boettgeri] diamond 240 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Pipidae Hymenochirus Hymenochirus boettgeri
28096261 28096261 PRJNA798905_S_NODE_30465_length_274_cov_1.532338_g30016_i0 PRJNA798905 30465 274 1.532338 4.19860612 Lagenorhynchus albirostris 27610 Chordata Chordata 47.8 5.36e-4   NR XP_059984459.1 27610 g30016 i0 87.5 0.525547445255474 24 3 26.3 0 200 271 149 172 XP_059984459.1 ubiquitin-conjugating enzyme E2 W isoform X2 [Lagenorhynchus albirostris] diamond 144 47.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Delphinidae Lagenorhynchus Lagenorhynchus albirostris
28569820 28569820 PRJNA798905_S_NODE_9647_length_442_cov_4.476965_g9198_i0 PRJNA798905 9647 442 4.476965 19.7881853 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 108 1.5600000000000002e-26   NR AAX25032.2 6182 g9198 i0 91.1 0.380090497737557 56 5 38 0 286 119 113 168 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 168 108 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29327564 29327564 PRJNA798905_S_NODE_33429_length_260_cov_3.128342_g32980_i0 PRJNA798905 33429 260 3.128342 8.1336892 Ovis ammon polii x Ovis aries 2918886 Chordata Chordata 70.1 2.08e-12   NR KAI4577098.1 2918886 g32980 i0 94.1 0.773076923076923 34 2 39.2 0 102 1 85 118 KAI4577098.1 hypothetical protein MJT46_002933 [Ovis ammon polii x Ovis aries] diamond 201 70.1 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Ovis Ovis ammon polii x Ovis aries
29579966 29579966 PRJNA798905_S_NODE_24010_length_307_cov_2.752137_g23561_i0 PRJNA798905 24010 307 2.752137 8.44906059 Phyllostomus discolor 89673 Chordata Chordata 60.5 1.05e-8   NR KAF6088414.1 89673 g23561 i0 51.7 1.14332247557003 60 28 58.6 1 76 255 67 125 KAF6088414.1 hypothetical protein HJG60_008239 [Phyllostomus discolor] diamond 351 60.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Chiroptera Phyllostomidae Phyllostomus Phyllostomus discolor
30117034 30117034 PRJNA798905_S_NODE_40912_length_236_cov_2.993865_g40463_i0 PRJNA798905 40912 236 2.993865 7.0655214 Trichonephila clavata 2740835 Arthropoda Arthropoda 45.1 0.00443   NR GFQ94560.1 2740835 g40463 i0 46.3 0.686440677966102 54 26 66.1 2 60 215 153 205 GFQ94560.1 helitron_like_N domain-containing protein [Trichonephila clavata] diamond 162 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavata
30591039 30591039 PRJNA798905_S_NODE_27033_length_291_cov_1.059633_g26584_i0 PRJNA798905 27033 291 1.059633 3.08353203 Muntiacus muntjak 9888 Chordata Chordata 62.8 5.83e-9   NR KAB0351662.1 9888 g26584 i0 55.2 2.96907216494845 67 29 68 1 6 203 381 447 KAB0351662.1 hypothetical protein FD754_016519 [Muntiacus muntjak] diamond 864 62.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Cervidae Muntiacus Muntiacus muntjak
30789661 30789661 PRJNA798905_S_NODE_27414_length_289_cov_1.425926_g26965_i0 PRJNA798905 27414 289 1.425926 4.12092614 root 1 Root_unresolved Root_unresolved 200 2.18e-59   NR XP_030110853.2 10090 g26965 i0 97.9 15.7785467128028 95 2 98.6 0 287 3 154 248 XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] diamond 4560 200 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
31349673 31349673 PRJNA798905_S_NODE_30376_length_274_cov_3.024876_g29927_i0 PRJNA798905 30376 274 3.024876 8.28816024 Balaenoptera physalus 9770 Chordata Chordata 68.6 8.67e-12   NR KAB0406035.1 9770 g29927 i0 78 0.996350364963504 91 18 97.4 1 268 2 1 91 KAB0406035.1 hypothetical protein E2I00_012731, partial [Balaenoptera physalus] diamond 273 68.6 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Balaenopteridae Balaenoptera Balaenoptera physalus
31444425 31444425 PRJNA798905_S_NODE_32816_length_263_cov_1.621053_g32367_i0 PRJNA798905 32816 263 1.621053 4.26336939 Mesoplodon densirostris 48708 Chordata Chordata 65.9 3.26e-10   NR XP_059952282.1 48708 g32367 i0 50.7 1.55133079847909 73 31 77.6 2 43 246 304 376 XP_059952282.1 LOW QUALITY PROTEIN: pyroglutamylated RF-amide peptide receptor [Mesoplodon densirostris] diamond 408 65.9 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Ziphiidae Mesoplodon Mesoplodon densirostris
31453616 31453616 PRJNA798905_S_NODE_21656_length_321_cov_7.322581_g21207_i0 PRJNA798905 21656 321 7.322581 23.50548501 Aves 8782 Chordata Chordata 93.2 1.52e-19   NR NXG10333.1 419690 g21207 i0 87.8 3.85981308411215 49 6 45.8 0 223 77 448 496 NXG10333.1 C43BP protein [Sakesphorus luctuosus] diamond 1239 93.2 1 Eukaryota Opisthokonta Metazoa Chordata Aves Passeriformes Thamnophilidae Sakesphorus Sakesphorus luctuosus
31602724 31602724 PRJNA798905_S_NODE_26856_length_291_cov_18.766055_g26407_i0 PRJNA798905 26856 291 18.766055 54.60922005 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 79.3 1.7e-16   NR AAW27122.1 6182 g26407 i0 83.7 0.505154639175258 49 5 47.4 1 257 120 1 49 AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] diamond 147 79.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32740858 32740858 PRJNA798905_S_NODE_13060_length_393_cov_10.028125_g12611_i0 PRJNA798905 13060 393 10.028125 39.41053125 Ranitomeya imitator 111125 Chordata Chordata 45.4 0.02   NR CAJ0965772.1 111125 g12611 i0 46 0.480916030534351 63 30 45 1 217 41 320 382 CAJ0965772.1 unnamed protein product [Ranitomeya imitator] diamond 189 45.4 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Dendrobatidae Ranitomeya Ranitomeya imitator
32803602 32803602 PRJNA798905_S_NODE_42040_length_230_cov_3.757962_g41591_i0 PRJNA798905 42040 230 3.757962 8.6433126 Mirounga angustirostris 9716 Chordata Chordata 43.5 0.0169   NR XP_064428521.1 9716 g41591 i0 46 0.652173913043478 50 27 65.2 0 161 12 571 620 XP_064428521.1 WD repeat-containing and planar cell polarity effector protein fritz homolog isoform X17 [Mirounga angustirostris] diamond 150 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Phocidae Mirounga Mirounga angustirostris

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