RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA330616" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA330616 · 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
9317788 9317788 PRJNA330616_P_NODE_29168_length_164_cov_0.886957_g28759_i0 PRJNA330616 29168 164 0.886957 1.45460948 Adineta ricciae 249248 Rotifera other_Eukaryota 106 5.42e-25   NR CAF1403046.1 249248 g28759 i0 96.2 0.969512195121951 53 2 97 0 3 161 1600 1652 CAF1403046.1 unnamed protein product [Adineta ricciae] diamond 159 106 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
15692363 15692363 PRJNA330616_P_NODE_24153_length_172_cov_1.243902_g23744_i0 PRJNA330616 24153 172 1.243902 2.13951144 Adineta steineri 433720 Rotifera other_Eukaryota 73.6 8e-15   NR CAF3790859.1 433720 g23744 i0 89.3 0.976744186046512 56 6 97.7 0 170 3 4 59 CAF3790859.1 unnamed protein product [Adineta steineri] diamond 168 73.6 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta steineri
26726027 26726027 PRJNA330616_P_NODE_18801_length_194_cov_1.406897_g18392_i0 PRJNA330616 18801 194 1.406897 2.72938018 Adineta ricciae 249248 Rotifera other_Eukaryota 121 6.0299999999999986e-34   NR CAF1572320.1 249248 g18392 i0 93.7 1.94845360824742 63 4 97.4 0 193 5 24 86 CAF1572320.1 unnamed protein product [Adineta ricciae] diamond 378 121 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
26821613 26821613 PRJNA330616_P_NODE_32021_length_161_cov_0.910714_g31612_i0 PRJNA330616 32021 161 0.910714 1.46624954 Adineta vaga 104782 Rotifera other_Eukaryota 102 8.53e-24   NR UJR35326.1 104782 g31612 i0 88.7 0.987577639751553 53 6 98.8 0 1 159 58 110 UJR35326.1 hypothetical protein I4U23_028087 [Adineta vaga] diamond 159 102 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
29064232 29064232 PRJNA330616_P_NODE_25868_length_167_cov_0.864407_g25459_i0 PRJNA330616 25868 167 0.864407 1.44355969 Adineta ricciae 249248 Rotifera other_Eukaryota 98.6 5.3e-25   NR CAF0905598.1 249248 g25459 i0 86.7 1.07784431137725 60 3 98.8 1 167 3 50 109 CAF0905598.1 unnamed protein product [Adineta ricciae] diamond 180 98.6 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
29853564 29853564 PRJNA330616_P_NODE_31271_length_162_cov_0.902655_g30862_i0 PRJNA330616 31271 162 0.902655 1.4623011 Adineta ricciae 249248 Rotifera other_Eukaryota 107 9.58e-28   NR CAF0858604.1 249248 g30862 i0 94.4 1 54 3 100 0 162 1 129 182 CAF0858604.1 unnamed protein product [Adineta ricciae] diamond 162 107 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
30232576 30232576 PRJNA330616_P_NODE_28872_length_164_cov_0.886957_g28463_i0 PRJNA330616 28872 164 0.886957 1.45460948 Adineta ricciae 249248 Rotifera other_Eukaryota 102 1.53e-23   NR CAF1102793.1 249248 g28463 i0 92.5 0.969512195121951 53 4 97 0 163 5 219 271 CAF1102793.1 unnamed protein product [Adineta ricciae] diamond 159 102 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
30296221 30296221 PRJNA330616_P_NODE_27772_length_165_cov_0.879310_g27363_i0 PRJNA330616 27772 165 0.87931 1.4508615 Adineta vaga 104782 Rotifera other_Eukaryota 52 9.36e-7   NR UJR19227.1 104782 g27363 i0 41.8 1 55 31 98.2 1 163 2 4 58 UJR19227.1 hypothetical protein I4U23_022356 [Adineta vaga] diamond 165 52 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
30327873 30327873 PRJNA330616_P_NODE_28932_length_164_cov_0.886957_g28523_i0 PRJNA330616 28932 164 0.886957 1.45460948 Adineta ricciae 249248 Rotifera other_Eukaryota 110 5.17e-27   NR CAF1646830.1 249248 g28523 i0 100 1.97560975609756 54 0 98.8 0 163 2 200 253 CAF1646830.1 unnamed protein product [Adineta ricciae] diamond 324 110 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
31370443 31370443 PRJNA330616_P_NODE_28216_length_165_cov_0.879310_g27807_i0 PRJNA330616 28216 165 0.87931 1.4508615 Adineta ricciae 249248 Rotifera other_Eukaryota 94 2.73e-21   NR CAF1245671.1 249248 g27807 i0 96.3 0.981818181818182 54 2 98.2 0 2 163 245 298 CAF1245671.1 unnamed protein product, partial [Adineta ricciae] diamond 162 94 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
31465317 31465317 PRJNA330616_P_NODE_30056_length_163_cov_0.894737_g29647_i0 PRJNA330616 30056 163 0.894737 1.45842131 Adineta ricciae 249248 Rotifera other_Eukaryota 63.2 3.65e-10   NR CAF1386108.1 249248 g29647 i0 100 0.588957055214724 32 0 58.9 0 67 162 1 32 CAF1386108.1 unnamed protein product [Adineta ricciae] diamond 96 63.2 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
31735266 31735266 PRJNA330616_P_NODE_18057_length_198_cov_1.026846_g17648_i0 PRJNA330616 18057 198 1.026846 2.03315508 Rotaria 231623 Rotifera other_Eukaryota 42 0.0389   NR CAF0775847.1 392033 g17648 i0 42.2 2.90909090909091 64 26 80.3 2 27 185 652 715 CAF0775847.1 unnamed protein product [Rotaria sordida] diamond 576 42 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sordida
31893577 31893577 PRJNA330616_P_NODE_31037_length_162_cov_0.902655_g30628_i0 PRJNA330616 31037 162 0.902655 1.4623011 Eurotatoria 2816136 Rotifera other_Eukaryota 100 1.26e-24   NR CAF1213046.1 249248 g30628 i0 92.5 6.98148148148148 53 4 98.1 0 4 162 64 116 CAF1213046.1 unnamed protein product [Adineta ricciae] diamond 1131 100 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
32161238 32161238 PRJNA330616_P_NODE_29658_length_163_cov_1.333333_g29249_i0 PRJNA330616 29658 163 1.333333 2.17333279 Adineta ricciae 249248 Rotifera other_Eukaryota 84.3 2.98e-18   NR CAF0807537.1 249248 g29249 i0 79.2 0.975460122699387 53 11 97.5 0 1 159 35 87 CAF0807537.1 unnamed protein product [Adineta ricciae] diamond 159 84.3 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
32526742 32526742 PRJNA330616_P_NODE_9899_length_263_cov_2.892523_g9490_i0 PRJNA330616 9899 263 2.892523 7.60733549 Metazoa 33208 Rotifera other_Eukaryota 155 6.68e-47   NR RNA36257.1 10195 g9490 i0 80.5 44.6577946768061 87 17 99.2 0 261 1 43 129 RNA36257.1 40S ribosomal S15Aa [Brachionus plicatilis] diamond 11745 155 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus plicatilis
32747006 32747006 PRJNA330616_P_NODE_32180_length_161_cov_0.910714_g31771_i0 PRJNA330616 32180 161 0.910714 1.46624954 Eurotatoria 2816136 Rotifera other_Eukaryota 53.9 1.1e-6   NR CAF2047328.1 392030 g31771 i0 96 4.19254658385093 25 1 46.6 0 161 87 231 255 CAF2047328.1 unnamed protein product [Rotaria magnacalcarata] diamond 675 54.3 0.992633517495396 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria magnacalcarata
32809950 32809950 PRJNA330616_P_NODE_31760_length_161_cov_1.580357_g31351_i0 PRJNA330616 31760 161 1.580357 2.54437477 Eurotatoria 2816136 Rotifera other_Eukaryota 114 4.97e-29   NR CAF1668492.1 249248 g31351 i0 96.2 4.93788819875776 53 2 98.8 0 161 3 169 221 CAF1668492.1 unnamed protein product, partial [Adineta ricciae] diamond 795 115 0.991304347826087 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae

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