RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB49404 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
3941179 3941179 PRJEB49404_P_NODE_591204_length_161_cov_1.344262_g577403_i0 PRJEB49404 591204 161 1.344262 2.16426182 Myodes glareolus 447135 Chordata Chordata 68.6 9.41e-12   NR KAK7809252.1 447135 g577403 i0 66 11.832298136646 53 17 98.8 1 160 2 247 298 KAK7809252.1 hypothetical protein U0070_025661 [Myodes glareolus] diamond 1905 68.6 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Cricetidae Myodes Myodes glareolus
26773652 26773652 PRJEB49404_P_NODE_529641_length_174_cov_2.000000_g515840_i0 PRJEB49404 529641 174 2 3.48 Mammalia 40674 Chordata Chordata 52.8 4.24e-6   NR VTJ69415.1 9995 g515840 i0 61.9 2.13793103448276 42 16 72.4 0 155 30 1099 1140 VTJ69415.1 Hypothetical predicted protein [Marmota monax] diamond 372 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Sciuridae Marmota Marmota monax
26812049 26812049 PRJEB49404_P_NODE_489961_length_184_cov_2.600000_g476160_i0 PRJEB49404 489961 184 2.6 4.784 Arvicola amphibius 1047088 Chordata Chordata 42 0.0324   NR XP_041910257.1 1047088 g476160 i0 41.1 0.91304347826087 56 22 91.3 1 1 168 96 140 XP_041910257.1 pinin-like [Arvicola amphibius] diamond 168 42 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Cricetidae Arvicola Arvicola amphibius
26970091 26970091 PRJEB49404_P_NODE_302842_length_262_cov_1.645740_g289041_i0 PRJEB49404 302842 262 1.64574 4.3118388 Erpetoichthys calabaricus 27687 Chordata Chordata 108 2.46e-26   NR XP_051791274.1 27687 g289041 i0 76 8.54198473282443 75 17 84.7 1 224 3 115 189 XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] diamond 2238 108 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Erpetoichthys Erpetoichthys calabaricus
27475911 27475911 PRJEB49404_P_NODE_358823_length_232_cov_0.891192_g345022_i0 PRJEB49404 358823 232 0.891192 2.06756544 Engystomops pustulosus 76066 Chordata Chordata 70.5 5.01e-14   NR KAG8588135.1 76066 g345022 i0 59.1 0.853448275862069 66 26 85.3 1 228 31 5 69 KAG8588135.1 hypothetical protein GDO81_005883 [Engystomops pustulosus] diamond 198 70.5 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
28044239 28044239 PRJEB49404_P_NODE_383265_length_221_cov_1.115385_g369464_i0 PRJEB49404 383265 221 1.115385 2.46500085 Rattus norvegicus 10116 Chordata Chordata 57.8 1.42e-7   NR AAQ91064.1 10116 g369464 i0 52.6 4.43891402714932 57 27 77.4 0 3 173 225 281 AAQ91064.1 LRRGT00108 [Rattus norvegicus] diamond 981 57.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Rattus Rattus norvegicus
28454916 28454916 PRJEB49404_P_NODE_392906_length_217_cov_1.151685_g379105_i0 PRJEB49404 392906 217 1.151685 2.49915645 Cricetulus griseus 10029 Chordata Chordata 42.7 0.0245   NR XP_035304105.1 10029 g379105 i0 44.4 0.622119815668203 45 21 56.7 2 144 22 2 46 XP_035304105.1 sperm-associated antigen 7 isoform X2 [Cricetulus griseus] diamond 135 42.7 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Cricetidae Cricetulus Cricetulus griseus
28801826 28801826 PRJEB49404_P_NODE_541868_length_171_cov_2.583333_g528067_i0 PRJEB49404 541868 171 2.583333 4.41749943 Bufotes viridis 30338 Chordata Chordata 44.7 0.00301   NR CAK8629749.1 30338 g528067 i0 62.1 1.28070175438596 29 11 50.9 0 79 165 335 363 CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] diamond 219 44.7 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Bufonidae Bufotes Bufotes viridis
28921478 28921478 PRJEB49404_P_NODE_602848_length_159_cov_1.075000_g589047_i0 PRJEB49404 602848 159 1.075 1.70925 Chordata 7711 Chordata Chordata 47 3.29e-4   NR CAM2113386.1 8467 g589047 i0 82.1 81.8867924528302 28 5 52.8 0 85 2 115 142 CAM2113386.1 unnamed protein product [Caretta caretta] diamond 13020 47.4 0.991561181434599 Eukaryota Opisthokonta Metazoa Chordata   Testudines Cheloniidae Caretta Caretta caretta
29023403 29023403 PRJEB49404_P_NODE_197648_length_355_cov_1.962025_g183849_i0 PRJEB49404 197648 355 1.962025 6.96518875 Staurois parvus 386267 Chordata Chordata 53.5 2.62e-6   NR CAI9557087.1 386267 g183849 i0 63.9 0.608450704225352 36 11 28.7 1 150 251 24 59 CAI9557087.1 unnamed protein product, partial [Staurois parvus] diamond 216 53.5 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
29275498 29275498 PRJEB49404_P_NODE_477729_length_188_cov_1.375839_g463928_i0 PRJEB49404 477729 188 1.375839 2.58657732 Neotoma lepida 56216 Chordata Chordata 62.8 1.49e-9   NR OBS58039.1 56216 g463928 i0 77.8 0.574468085106383 36 8 57.4 0 41 148 18 53 OBS58039.1 hypothetical protein A6R68_10835 [Neotoma lepida] diamond 108 62.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Cricetidae Neotoma Neotoma lepida
29900582 29900582 PRJEB49404_P_NODE_394151_length_216_cov_1.853107_g380350_i0 PRJEB49404 394151 216 1.853107 4.00271112 Mammalia 40674 Chordata Chordata 60.1 1.99e-8   NR XP_064138050.1 9785 g380350 i0 67.6 5.84722222222222 37 12 51.4 0 113 3 491 527 XP_064138050.1 protein zyg-11 homolog B isoform X1 [Loxodonta africana] diamond 1263 60.1 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Proboscidea Elephantidae Loxodonta Loxodonta africana
30159647 30159647 PRJEB49404_P_NODE_263172_length_290_cov_1.282869_g249371_i0 PRJEB49404 263172 290 1.282869 3.7203201 Peromyscus californicus insignis 564181 Chordata Chordata 56.2 1.17e-6   NR XP_052569554.1 564181 g249371 i0 62 1.55172413793103 50 13 51.7 1 25 174 81 124 XP_052569554.1 TBC1 domain family member 12 isoform X2 [Peromyscus californicus insignis] diamond 450 56.2 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Cricetidae Peromyscus Peromyscus californicus
30223028 30223028 PRJEB49404_P_NODE_113552_length_525_cov_8.187243_g99911_i0 PRJEB49404 113552 525 8.187243 42.98302575 Leucoraja erinaceus 7782 Chordata Chordata 49.7 0.00206   NR XP_055512319.1 7782 g99911 i0 50 0.274285714285714 48 22 26.3 1 388 525 149 196 XP_055512319.1 uncharacterized protein LOC129709775 [Leucoraja erinaceus] diamond 144 49.7 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Rajiformes Rajidae Leucoraja Leucoraja erinaceus
31170714 31170714 PRJEB49404_P_NODE_190575_length_364_cov_2.209231_g176776_i0 PRJEB49404 190575 364 2.209231 8.04160084 Apodemus speciosus 105296 Chordata Chordata 53.5 2.2e-5   NR GAB1285821.1 105296 g176776 i0 79.3 0.239010989010989 29 6 23.9 0 169 255 206 234 GAB1285821.1 BRO1 domain-containing protein BROX [Apodemus speciosus] diamond 87 53.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Apodemus Apodemus speciosus
32436613 32436613 PRJEB49404_P_NODE_300219_length_264_cov_1.022222_g286418_i0 PRJEB49404 300219 264 1.022222 2.69866608 Staurois parvus 386267 Chordata Chordata 55.1 3.16e-7   NR CAI9548327.1 386267 g286418 i0 57.4 2.39772727272727 54 18 55.7 1 70 216 47 100 CAI9548327.1 unnamed protein product [Staurois parvus] diamond 633 55.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
32688710 32688710 PRJEB49404_P_NODE_619720_length_156_cov_1.051282_g605919_i0 PRJEB49404 619720 156 1.051282 1.63999992 Peromyscus californicus insignis 564181 Chordata Chordata 43.5 0.00628   NR XP_052599680.1 564181 g605919 i0 54.3 0.673076923076923 35 16 67.3 0 10 114 370 404 XP_052599680.1 arylsulfatase K isoform X3 [Peromyscus californicus insignis] diamond 105 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Cricetidae Peromyscus Peromyscus californicus
32814764 32814764 PRJEB49404_P_NODE_608980_length_158_cov_0.966387_g595179_i0 PRJEB49404 608980 158 0.966387 1.52689146 Engystomops pustulosus 76066 Chordata Chordata 59.7 1.21e-8   NR KAG8571490.1 76066 g595179 i0 58.5 3.01898734177215 53 21 98.7 1 1 156 980 1032 KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] diamond 477 59.7 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus

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