RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB30004" 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

  • PRJEB30004 · 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
14079973 14079973 PRJEB30004_P_NODE_629432_length_161_cov_1.344262_g613805_i0 PRJEB30004 629432 161 1.344262 2.16426182 Myodes glareolus 447135 Chordata Chordata 68.6 9.41e-12   NR KAK7809252.1 447135 g613805 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
26938187 26938187 PRJEB30004_P_NODE_288842_length_290_cov_1.282869_g273215_i0 PRJEB30004 288842 290 1.282869 3.7203201 Peromyscus californicus insignis 564181 Chordata Chordata 56.2 1.17e-6   NR XP_052569554.1 564181 g273215 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
27121258 27121258 PRJEB30004_P_NODE_565642_length_174_cov_2.000000_g550015_i0 PRJEB30004 565642 174 2 3.48 Mammalia 40674 Chordata Chordata 52.8 4.24e-6   NR VTJ69415.1 9995 g550015 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
27127678 27127678 PRJEB30004_P_NODE_125702_length_531_cov_9.024390_g110284_i0 PRJEB30004 125702 531 9.02439 47.9195109 Leucoraja erinaceus 7782 Chordata Chordata 45.8 0.0439   NR XP_055512319.1 7782 g110284 i0 47.9 0.271186440677966 48 23 26 1 388 525 149 196 XP_055512319.1 uncharacterized protein LOC129709775 [Leucoraja erinaceus] diamond 144 45.8 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Rajiformes Rajidae Leucoraja Leucoraja erinaceus
27381118 27381118 PRJEB30004_P_NODE_389463_length_232_cov_0.891192_g373836_i0 PRJEB30004 389463 232 0.891192 2.06756544 Engystomops pustulosus 76066 Chordata Chordata 70.5 5.01e-14   NR KAG8588135.1 76066 g373836 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
27381127 27381127 PRJEB30004_P_NODE_525043_length_184_cov_2.600000_g509416_i0 PRJEB30004 525043 184 2.6 4.784 Arvicola amphibius 1047088 Chordata Chordata 42 0.0324   NR XP_041910257.1 1047088 g509416 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
28044011 28044011 PRJEB30004_P_NODE_422025_length_218_cov_1.374302_g406398_i0 PRJEB30004 422025 218 1.374302 2.99597836 Neotoma lepida 56216 Chordata Chordata 63.2 1.64e-9   NR OBS58039.1 56216 g406398 i0 77.8 0.495412844036697 36 8 49.5 0 148 41 18 53 OBS58039.1 hypothetical protein A6R68_10835 [Neotoma lepida] diamond 108 63.2 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Cricetidae Neotoma Neotoma lepida
28454665 28454665 PRJEB30004_P_NODE_424846_length_217_cov_1.264045_g409219_i0 PRJEB30004 424846 217 1.264045 2.74297765 Cricetulus griseus 10029 Chordata Chordata 42.7 0.0245   NR XP_035304105.1 10029 g409219 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
28574197 28574197 PRJEB30004_P_NODE_640327_length_159_cov_1.075000_g624700_i0 PRJEB30004 640327 159 1.075 1.70925 Chordata 7711 Chordata Chordata 47 3.29e-4   NR CAM2113386.1 8467 g624700 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
29432952 29432952 PRJEB30004_P_NODE_306950_length_277_cov_1.722689_g291323_i0 PRJEB30004 306950 277 1.722689 4.77184853 Cricetulus griseus 10029 Chordata Chordata 41.2 0.0283   NR ERE88245.1 10029 g291323 i0 42.4 0.63898916967509 59 29 58.5 2 54 215 6 64 ERE88245.1 hypothetical protein H671_1g3204 [Cricetulus griseus] diamond 177 41.2 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Cricetidae Cricetulus Cricetulus griseus
29970058 29970058 PRJEB30004_P_NODE_328131_length_264_cov_1.022222_g312504_i0 PRJEB30004 328131 264 1.022222 2.69866608 Staurois parvus 386267 Chordata Chordata 55.1 3.16e-7   NR CAI9548327.1 386267 g312504 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
30318196 30318196 PRJEB30004_P_NODE_470232_length_200_cov_3.055901_g454605_i0 PRJEB30004 470232 200 3.055901 6.111802 Mus musculus 10090 Chordata Chordata 43.1 0.0041   NR EDL11837.1 10090 g454605 i0 69.6 0.345 23 7 34.5 0 132 200 49 71 EDL11837.1 mCG1035771, isoform CRA_b [Mus musculus] diamond 69 43.1 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
30444143 30444143 PRJEB30004_P_NODE_210893_length_364_cov_2.461538_g195267_i0 PRJEB30004 210893 364 2.461538 8.95999832 Apodemus speciosus 105296 Chordata Chordata 53.5 2.2e-5   NR GAB1285821.1 105296 g195267 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
30532210 30532210 PRJEB30004_P_NODE_437653_length_212_cov_1.421965_g422026_i0 PRJEB30004 437653 212 1.421965 3.0145658 Artiodactyla 91561 Chordata Chordata 54.3 2.04e-6   NR XP_057401233.1 9767 g422026 i0 44.6 3.60849056603774 56 31 79.2 0 3 170 129 184 XP_057401233.1 60S ribosomal export protein NMD3 isoform X3 [Balaenoptera acutorostrata] diamond 765 54.3 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Balaenopteridae Balaenoptera Balaenoptera acutorostrata
30854719 30854719 PRJEB30004_P_NODE_414814_length_221_cov_1.115385_g399187_i0 PRJEB30004 414814 221 1.115385 2.46500085 Rattus norvegicus 10116 Chordata Chordata 57.8 1.42e-7   NR AAQ91064.1 10116 g399187 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
31644993 31644993 PRJEB30004_P_NODE_656437_length_156_cov_1.051282_g640810_i0 PRJEB30004 656437 156 1.051282 1.63999992 Peromyscus californicus insignis 564181 Chordata Chordata 43.5 0.00628   NR XP_052599680.1 564181 g640810 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
31676630 31676630 PRJEB30004_P_NODE_330617_length_262_cov_1.887892_g314990_i0 PRJEB30004 330617 262 1.887892 4.94627704 Erpetoichthys calabaricus 27687 Chordata Chordata 108 2.46e-26   NR XP_051791274.1 27687 g314990 i0 76 8.54198473282443 75 17 84.7 1 39 260 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

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