RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJEB15333" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB15333 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
27096298 27096298 PRJEB15333_P_NODE_2242_length_408_cov_7.164345_g2160_i0 PRJEB15333 2242 408 7.164345 29.2305276 Staurois parvus 386267 Chordata Chordata 57 2.31e-7   NR CAI9533415.1 386267 g2160 i0 40 3.64705882352941 110 47 66.9 4 288 16 1 110 CAI9533415.1 unnamed protein product [Staurois parvus] diamond 1488 57 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
27538803 27538803 PRJEB15333_P_NODE_11484_length_201_cov_1.171053_g11400_i0 PRJEB15333 11484 201 1.171053 2.35381653 Engystomops pustulosus 76066 Chordata Chordata 50.1 3.76e-6   NR KAG8588135.1 76066 g11400 i0 60.5 0.567164179104478 38 15 56.7 0 187 74 32 69 KAG8588135.1 hypothetical protein GDO81_005883 [Engystomops pustulosus] diamond 114 50.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
27696922 27696922 PRJEB15333_P_NODE_15824_length_174_cov_0.992000_g15740_i0 PRJEB15333 15824 174 0.992 1.72608 Merops nubicus 57421 Chordata Chordata 40 0.0118   NR KFQ19212.1 57421 g15740 i0 52.9 0.586206896551724 34 16 58.6 0 9 110 2 35 KFQ19212.1 Zinc finger protein 135, partial [Merops nubicus] diamond 102 40 1 Eukaryota Opisthokonta Metazoa Chordata Aves Coraciiformes Meropidae Merops Merops nubicus
27917466 27917466 PRJEB15333_P_NODE_12285_length_195_cov_0.931507_g12201_i0 PRJEB15333 12285 195 0.931507 1.81643865 Staurois parvus 386267 Chordata Chordata 42.7 0.00166   NR CAI9601297.1 386267 g12201 i0 50 1.15384615384615 40 20 61.5 0 128 9 7 46 CAI9601297.1 unnamed protein product [Staurois parvus] diamond 225 43.1 0.990719257540603 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
28707060 28707060 PRJEB15333_P_NODE_18587_length_166_cov_0.888889_g18503_i0 PRJEB15333 18587 166 0.888889 1.47555574 Staurois parvus 386267 Chordata Chordata 44.3 4.66e-4   NR CAI9540006.1 386267 g18503 i0 60.6 0.596385542168675 33 13 59.6 0 113 15 4 36 CAI9540006.1 unnamed protein product, partial [Staurois parvus] diamond 99 44.3 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
28959768 28959768 PRJEB15333_P_NODE_4788_length_296_cov_1.587045_g4704_i0 PRJEB15333 4788 296 1.587045 4.6976532 Petaurus breviceps papuanus 3040969 Chordata Chordata 43.5 0.0368   NR XP_068953296.1 3040969 g4704 i0 65.4 2.91891891891892 26 9 26.4 0 295 218 220 245 XP_068953296.1 zinc finger protein ZFP2-like [Petaurus breviceps papuanus] diamond 864 43.9 0.990888382687927 Eukaryota Opisthokonta Metazoa Chordata Mammalia Diprotodontia Petauridae Petaurus Petaurus breviceps
28991423 28991423 PRJEB15333_P_NODE_19108_length_165_cov_0.896552_g19024_i0 PRJEB15333 19108 165 0.896552 1.4793108 Engystomops pustulosus 76066 Chordata Chordata 50.1 2.28e-6   NR KAG8584541.1 76066 g19024 i0 57.1 1.52727272727273 42 18 76.4 0 135 10 8 49 KAG8584541.1 hypothetical protein GDO81_004655 [Engystomops pustulosus] diamond 252 50.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
29205933 29205933 PRJEB15333_P_NODE_13829_length_185_cov_1.419118_g13745_i0 PRJEB15333 13829 185 1.419118 2.6253683 Chordata 7711 Chordata Chordata 48.9 1.1e-4   NR XP_044768277.1 29088 g13745 i0 49 11.4 49 25 79.5 0 17 163 266 314 XP_044768277.1 zinc finger protein 775, partial [Neomonachus schauinslandi] diamond 2109 48.9 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Phocidae Neomonachus Neomonachus schauinslandi
29527944 29527944 PRJEB15333_P_NODE_18110_length_167_cov_0.881356_g18026_i0 PRJEB15333 18110 167 0.881356 1.47186452 Engystomops pustulosus 76066 Chordata Chordata 50.8 1.86e-5   NR KAG8571490.1 76066 g18026 i0 57.1 2.26347305389222 42 18 75.4 0 34 159 1010 1051 KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] diamond 378 50.8 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
29717041 29717041 PRJEB15333_P_NODE_14910_length_179_cov_0.900000_g14826_i0 PRJEB15333 14910 179 0.9 1.611 Heterodontus francisci 7792 Chordata Chordata 41.6 0.0406   NR XP_067870855.1 7792 g14826 i0 69.6 0.385474860335196 23 7 38.5 0 1 69 6 28 XP_067870855.1 zinc finger protein 271-like [Heterodontus francisci] diamond 69 41.6 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Heterodontiformes Heterodontidae Heterodontus Heterodontus francisci
29900510 29900510 PRJEB15333_P_NODE_20571_length_162_cov_0.920354_g20487_i0 PRJEB15333 20571 162 0.920354 1.49097348 Chordata 7711 Chordata Chordata 42 0.0211   NR XP_031538010.1 30538 g20487 i0 60.7 20.7407407407407 28 11 51.9 0 15 98 1 28 XP_031538010.1 zinc finger protein 835-like, partial [Vicugna pacos] diamond 3360 42.4 0.990566037735849 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Camelidae Vicugna Vicugna pacos
29938482 29938482 PRJEB15333_P_NODE_18991_length_165_cov_0.896552_g18907_i0 PRJEB15333 18991 165 0.896552 1.4793108 Bufotes viridis 30338 Chordata Chordata 51.6 9.33e-6   NR CAK8647423.1 30338 g18907 i0 45.7 0.836363636363636 46 25 83.6 0 12 149 92 137 CAK8647423.1 Zinc finger protein 300, partial [Bufotes viridis] diamond 138 51.6 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Bufonidae Bufotes Bufotes viridis
30248140 30248140 PRJEB15333_P_NODE_17872_length_167_cov_1.050847_g17788_i0 PRJEB15333 17872 167 1.050847 1.75491449 Metazoa 33208 Chordata Chordata 47 4.02e-5   NR NXP47799.1 54369 g17788 i0 60.6 1.29341317365269 33 13 59.3 0 7 105 6 38 NXP47799.1 ZN629 protein [Heliornis fulica] diamond 216 47.4 0.991561181434599 Eukaryota Opisthokonta Metazoa Chordata Aves Gruiformes Heliornithidae Heliornis Heliornis fulica
30665058 30665058 PRJEB15333_P_NODE_17093_length_169_cov_0.866667_g17009_i0 PRJEB15333 17093 169 0.866667 1.46466723 Calypte anna 9244 Chordata Chordata 42.7 0.00115   NR KFO94887.1 9244 g17009 i0 51.3 5.92899408284024 39 19 69.2 0 169 53 2 40 KFO94887.1 Zinc finger protein 768, partial [Calypte anna] diamond 1002 42.7 1 Eukaryota Opisthokonta Metazoa Chordata Aves Apodiformes Trochilidae Calypte Calypte anna
30690141 30690141 PRJEB15333_P_NODE_17453_length_168_cov_0.873950_g17369_i0 PRJEB15333 17453 168 0.87395 1.468236 Chordata 7711 Chordata Chordata 41.2 0.0434   NR XP_031538010.1 30538 g17369 i0 65.4 2.32142857142857 26 9 46.4 0 154 77 1 26 XP_031538010.1 zinc finger protein 835-like, partial [Vicugna pacos] diamond 390 41.2 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Camelidae Vicugna Vicugna pacos
30886215 30886215 PRJEB15333_P_NODE_19134_length_165_cov_0.896552_g19050_i0 PRJEB15333 19134 165 0.896552 1.4793108 Engystomops pustulosus 76066 Chordata Chordata 51.2 1.15e-6   NR KAG8536220.1 76066 g19050 i0 67.7 0.563636363636364 31 10 56.4 0 73 165 36 66 KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus] diamond 93 51.2 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
31107273 31107273 PRJEB15333_P_NODE_20795_length_162_cov_0.920354_g20711_i0 PRJEB15333 20795 162 0.920354 1.49097348 Staurois parvus 386267 Chordata Chordata 52.8 4.38e-7   NR CAI9618505.1 386267 g20711 i0 47.5 1.48148148148148 40 21 74.1 0 162 43 12 51 CAI9618505.1 unnamed protein product, partial [Staurois parvus] diamond 240 52.8 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
31518604 31518604 PRJEB15333_P_NODE_17536_length_168_cov_0.873950_g17452_i0 PRJEB15333 17536 168 0.87395 1.468236 Engystomops pustulosus 76066 Chordata Chordata 43.9 8.71e-4   NR KAG8536220.1 76066 g17452 i0 47.2 1.28571428571429 36 19 64.3 0 56 163 36 71 KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus] diamond 216 43.9 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
32246430 32246430 PRJEB15333_P_NODE_11638_length_200_cov_0.668874_g11554_i0 PRJEB15333 11638 200 0.668874 1.337748 Heptranchias perlo 212740 Chordata Chordata 42.7 0.0209   NR XP_067834290.1 212740 g11554 i0 73.1 0.39 26 7 39 0 3 80 15 40 XP_067834290.1 zinc finger protein 135-like [Heptranchias perlo] diamond 78 42.7 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Hexanchiformes Hexanchidae Heptranchias Heptranchias perlo

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