RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA605033 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26953306 26953306 PRJNA605033_P_NODE_128942_length_218_cov_1.945355_g127373_i0 PRJNA605033 128942 218 1.945355 4.2408739 Styela clava 7725 Chordata Chordata 42.4 0.0367   NR XP_039263800.1 7725 g127373 i0 59.4 0.440366972477064 32 13 44 0 99 4 465 496 XP_039263800.1 solute carrier family 2, facilitated glucose transporter member 5-like [Styela clava] diamond 96 42.4 1 Eukaryota Opisthokonta Metazoa Chordata Ascidiacea Stolidobranchia Styelidae Styela Styela clava
27333115 27333115 PRJNA605033_P_NODE_213503_length_161_cov_0.912698_g211934_i0 PRJNA605033 213503 161 0.912698 1.46944378 Panthera onca 9690 Chordata Chordata 53.5 1.89e-6   NR XP_060490466.1 9690 g211934 i0 59.5 0.782608695652174 42 17 78.3 0 9 134 17 58 XP_060490466.1 UDP-glucuronosyltransferase 3A2-like isoform X1 [Panthera onca] diamond 126 53.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Felidae Panthera Panthera onca
28027720 28027720 PRJNA605033_P_NODE_81425_length_222_cov_2.454545_g79856_i0 PRJNA605033 81425 222 2.454545 5.4490899 Alectoris rufa 9079 Chordata Chordata 46.6 0.00122   NR CAK6567267.1 9079 g79856 i0 46.8 1.67567567567568 62 9 83.8 1 2 187 310 347 CAK6567267.1 unnamed protein product [Alectoris rufa] diamond 372 46.6 1 Eukaryota Opisthokonta Metazoa Chordata Aves Galliformes Phasianidae Alectoris Alectoris rufa
28185245 28185245 PRJNA605033_P_NODE_238346_length_152_cov_8.299145_g236777_i0 PRJNA605033 238346 152 8.299145 12.6147004 Balaenoptera musculus 9771 Chordata Chordata 42.4 0.0144   NR XP_036714249.1 9771 g236777 i0 88.5 0.513157894736842 26 3 51.3 0 80 3 47 72 XP_036714249.1 uncharacterized protein LOC118898228 [Balaenoptera musculus] diamond 78 42.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Balaenopteridae Balaenoptera Balaenoptera musculus
28216788 28216788 PRJNA605033_P_NODE_116606_length_222_cov_1.673797_g115037_i0 PRJNA605033 116606 222 1.673797 3.71582934 Loxodonta africana 9785 Chordata Chordata 50.4 5.39e-5   NR XP_064138050.1 9785 g115037 i0 40.5 1 74 35 98.6 2 221 3 765 830 XP_064138050.1 protein zyg-11 homolog B isoform X1 [Loxodonta africana] diamond 222 50.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Proboscidea Elephantidae Loxodonta Loxodonta africana
28248405 28248405 PRJNA605033_P_NODE_125286_length_221_cov_1.284946_g123717_i0 PRJNA605033 125286 221 1.284946 2.83973066 Sus scrofa 9823 Chordata Chordata 48.5 2.6e-4   NR XP_020937328.1 9823 g123717 i0 54.4 1.73755656108597 57 21 77.4 2 214 44 614 665 XP_020937328.1 collagen alpha-2(I) chain-like [Sus scrofa] diamond 384 48.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
28596080 28596080 PRJNA605033_P_NODE_152947_length_192_cov_1.019108_g151378_i0 PRJNA605033 152947 192 1.019108 1.95668736 Crocuta crocuta 9678 Chordata Chordata 55.5 1.2e-7   NR KAF0874559.1 9678 g151378 i0 55.2 0.90625 58 25 89.1 1 191 21 15 72 KAF0874559.1 LORF2 protein, partial [Crocuta crocuta] diamond 174 55.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Hyaenidae Crocuta Crocuta crocuta
29069739 29069739 PRJNA605033_P_NODE_84028_length_222_cov_2.358289_g82459_i0 PRJNA605033 84028 222 2.358289 5.2354015800000004 Ovis ammon polii x Ovis aries 2918886 Chordata Chordata 45.1 0.0044   NR KAI4569641.1 2918886 g82459 i0 84 0.337837837837838 25 4 33.8 0 2 76 158 182 KAI4569641.1 hypothetical protein MJT46_006935 [Ovis ammon polii x Ovis aries] diamond 75 45.1 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Ovis Ovis ammon polii x Ovis aries
29953735 29953735 PRJNA605033_P_NODE_228411_length_156_cov_0.991736_g226842_i0 PRJNA605033 228411 156 0.991736 1.54710816 Sus scrofa 9823 Chordata Chordata 43.9 0.00444   NR XP_020937328.1 9823 g226842 i0 57.9 0.730769230769231 38 16 73.1 0 155 42 19 56 XP_020937328.1 collagen alpha-2(I) chain-like [Sus scrofa] diamond 114 43.9 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
29998602 29998602 PRJNA605033_P_NODE_247731_length_150_cov_2.313043_g246162_i0 PRJNA605033 247731 150 2.313043 3.4695645 Mammalia 40674 Chordata Chordata 55.8 2.43e-7   NR XP_069906595.1 9986 g246162 i0 65.2 19.44 46 12 90 2 11 145 587 629 XP_069906595.1 LOW QUALITY PROTEIN: LINE-1 retrotransposable element ORF2 protein [Oryctolagus cuniculus] diamond 2916 55.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Lagomorpha Leporidae Oryctolagus Oryctolagus cuniculus
30048297 30048297 PRJNA605033_P_NODE_28591_length_283_cov_1.366935_g27025_i0 PRJNA605033 28591 283 1.366935 3.86842605 Phacochoerus africanus 41426 Chordata Chordata 51.6 2.96e-5   NR XP_047622059.1 41426 g27025 i0 48.6 0.784452296819788 74 30 70 1 80 277 2 75 XP_047622059.1 spidroin-1-like [Phacochoerus africanus] diamond 222 51.6 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Phacochoerus Phacochoerus africanus
30333285 30333285 PRJNA605033_P_NODE_155232_length_190_cov_1.548387_g153663_i0 PRJNA605033 155232 190 1.548387 2.9419353 Echinops telfairi 9371 Chordata Chordata 42 0.0339   NR XP_004713071.1 9371 g153663 i0 43.5 0.726315789473684 46 26 72.6 0 188 51 143 188 XP_004713071.1 major facilitator superfamily domain-containing protein 6-like [Echinops telfairi] diamond 138 42 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia   Tenrecidae Echinops Echinops telfairi
30806825 30806825 PRJNA605033_P_NODE_85774_length_222_cov_2.299465_g84205_i0 PRJNA605033 85774 222 2.299465 5.1048123 Mycteria americana 33587 Chordata Chordata 58.5 7.51e-8   NR KAK4806217.1 33587 g84205 i0 39.5 5.81081081081081 86 36 94.6 1 212 3 584 669 KAK4806217.1 hypothetical protein QYF61_001140 [Mycteria americana] diamond 1290 58.5 1 Eukaryota Opisthokonta Metazoa Chordata Aves Ciconiiformes Ciconiidae Mycteria Mycteria americana
31515628 31515628 PRJNA605033_P_NODE_193556_length_168_cov_3.421053_g191987_i0 PRJNA605033 193556 168 3.421053 5.74736904 Carnivora 33554 Chordata Chordata 41.2 0.0479   NR BAA25253.1 9615 g191987 i0 68.2 0.821428571428571 22 7 39.3 0 67 2 34 55 BAA25253.1 unnamed protein product [Canis lupus familiaris] diamond 138 41.2 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Canidae Canis Canis lupus
32116539 32116539 PRJNA605033_P_NODE_70398_length_222_cov_3.090909_g68829_i0 PRJNA605033 70398 222 3.090909 6.86181798 Aves 8782 Chordata Chordata 43.5 0.0154   NR GAB0185865.1 30415 g68829 i0 72 2.36486486486486 25 7 33.8 0 75 1 100 124 GAB0185865.1 triadin [Grus japonensis] diamond 525 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Aves Gruiformes Gruidae Grus Grus japonensis
32829779 32829779 PRJNA605033_P_NODE_89320_length_222_cov_2.203209_g87751_i0 PRJNA605033 89320 222 2.203209 4.89112398 Crocuta crocuta 9678 Chordata Chordata 45.8 0.00229   NR KAF0885212.1 9678 g87751 i0 79.2 3.24324324324324 24 5 32.4 0 218 147 132 155 KAF0885212.1 LORF2 protein, partial [Crocuta crocuta] diamond 720 45.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Hyaenidae Crocuta Crocuta crocuta
32861151 32861151 PRJNA605033_P_NODE_73400_length_222_cov_2.850267_g71831_i0 PRJNA605033 73400 222 2.850267 6.32759274 Ursus arctos 9644 Chordata Chordata 46.6 0.00128   NR XP_057161243.1 9644 g71831 i0 91.7 0.324324324324324 24 2 32.4 0 151 222 403 426 XP_057161243.1 kelch-like protein 17 isoform X1 [Ursus arctos] diamond 72 46.6 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Ursidae Ursus Ursus arctos

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