RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA315314 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
13134637 13134637 PRJNA315314_S_NODE_28651_length_158_cov_1.596899_g28330_i0 PRJNA315314 28651 158 1.596899 2.52310042 Brachionus calyciflorus 104777 Rotifera other_Eukaryota 75.9 1.18e-14   NR CAF0892122.1 104777 g28330 i0 72.5 1.93670886075949 51 14 96.8 0 154 2 27 77 CAF0892122.1 unnamed protein product [Brachionus calyciflorus] diamond 306 75.9 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus calyciflorus
22057289 22057289 PRJNA315314_S_NODE_20298_length_183_cov_14.902597_g19977_i0 PRJNA315314 20298 183 14.902597 27.27175251 Adineta vaga 104782 Rotifera other_Eukaryota 101 8.84e-26   NR UJR22359.1 104782 g19977 i0 90.9 1.80327868852459 55 5 90.2 0 2 166 69 123 UJR22359.1 hypothetical protein I4U23_025421 [Adineta vaga] diamond 330 101 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
26838915 26838915 PRJNA315314_S_NODE_16561_length_202_cov_1.052023_g16240_i0 PRJNA315314 16561 202 1.052023 2.12508646 Eurotatoria 2816136 Rotifera other_Eukaryota 145 1.18e-38   NR CAF1631363.1 249248 g16240 i0 100 19.9009900990099 67 0 99.5 0 1 201 1237 1303 CAF1631363.1 unnamed protein product, partial [Adineta ricciae] diamond 4020 145 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
27376630 27376630 PRJNA315314_S_NODE_32103_length_151_cov_1.303279_g31782_i0 PRJNA315314 32103 151 1.303279 1.96795129 Eurotatoria 2816136 Rotifera other_Eukaryota 84.3 1.15e-18   NR AAX81535.1 249248 g31782 i0 91.8 4.86754966887417 49 4 97.4 0 3 149 78 126 AAX81535.1 ribosomal protein S7-like protein [Adineta ricciae] diamond 735 84.3 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
27453771 27453771 PRJNA315314_S_NODE_12083_length_234_cov_2.439024_g11762_i0 PRJNA315314 12083 234 2.439024 5.70731616 Didymodactylos carnosus 1234261 Rotifera other_Eukaryota 58.2 3.31e-8   NR CAF1129891.1 1234261 g11762 i0 46 1.44871794871795 63 33 79.5 1 3 188 106 168 CAF1129891.1 unnamed protein product, partial [Didymodactylos carnosus] diamond 339 58.2 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Didymodactylos Didymodactylos carnosus
28323420 28323420 PRJNA315314_S_NODE_24186_length_170_cov_1.957447_g23865_i0 PRJNA315314 24186 170 1.957447 3.3276599 Eurotatoria 2816136 Rotifera other_Eukaryota 99 2.01e-22   NR CAF1617361.1 249248 g23865 i0 98.2 7.78235294117647 55 1 97.1 0 169 5 112 166 CAF1617361.1 unnamed protein product [Adineta ricciae] diamond 1323 99 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
28323423 28323423 PRJNA315314_S_NODE_27466_length_161_cov_1.348485_g27145_i0 PRJNA315314 27466 161 1.348485 2.17106085 Rotaria 231623 Rotifera other_Eukaryota 75.1 4.57e-14   NR CAF1497961.1 392030 g27145 i0 62.3 7.90062111801242 53 20 98.8 0 1 159 117 169 CAF1497961.1 unnamed protein product [Rotaria magnacalcarata] diamond 1272 75.5 0.994701986754967 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria magnacalcarata
29113006 29113006 PRJNA315314_S_NODE_22308_length_176_cov_1.877551_g21987_i0 PRJNA315314 22308 176 1.877551 3.30448976 Rotaria 231623 Rotifera other_Eukaryota 108 1.08e-26   NR CAF1129048.1 2762511 g21987 i0 87.9 5.93181818181818 58 7 98.9 0 3 176 224 281 CAF1129048.1 unnamed protein product [Rotaria sp. Silwood1] diamond 1044 108 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sp. Silwood1
29758324 29758324 PRJNA315314_S_NODE_12271_length_232_cov_2.931034_g11950_i0 PRJNA315314 12271 232 2.931034 6.79999888 Rotaria sordida 392033 Rotifera other_Eukaryota 78.6 1.03e-15   NR CAF3696515.1 392033 g11950 i0 55.1 2.94827586206897 69 27 84.1 2 29 223 28 96 CAF3696515.1 unnamed protein product [Rotaria sordida] diamond 684 78.6 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sordida
29965561 29965561 PRJNA315314_S_NODE_21711_length_178_cov_2.570470_g21390_i0 PRJNA315314 21711 178 2.57047 4.5754366 Rotaria 231623 Rotifera other_Eukaryota 57.4 5.55e-8   NR CAF1442400.1 392030 g21390 i0 47.4 2.88202247191011 57 27 96.1 2 171 1 139 192 CAF1442400.1 unnamed protein product [Rotaria magnacalcarata] diamond 513 57.4 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria magnacalcarata
30565436 30565436 PRJNA315314_S_NODE_8673_length_275_cov_2.223577_g8352_i0 PRJNA315314 8673 275 2.223577 6.11483675 Eurotatoria 2816136 Rotifera other_Eukaryota 117 2.16e-28   NR CAF0972910.1 249248 g8352 i0 90.1 9.92727272727273 91 9 99.3 0 274 2 231 321 CAF0972910.1 unnamed protein product [Adineta ricciae] diamond 2730 117 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
30642929 30642929 PRJNA315314_S_NODE_9773_length_259_cov_3.730435_g9452_i0 PRJNA315314 9773 259 3.730435 9.66182665 Rotaria sp. Silwood1 2762511 Rotifera other_Eukaryota 60.5 6.95e-9   NR CAF5166224.1 2762511 g9452 i0 37.2 2.71042471042471 78 48 89.2 1 28 258 14 91 CAF5166224.1 unnamed protein product, partial [Rotaria sp. Silwood1] diamond 702 60.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sp. Silwood1
30895998 30895998 PRJNA315314_S_NODE_7094_length_303_cov_5.562044_g6773_i0 PRJNA315314 7094 303 5.562044 16.85299332 Rotaria sp. Silwood1 2762511 Rotifera other_Eukaryota 73.9 2.87e-13   NR CAF1615689.1 2762511 g6773 i0 42.4 2.73267326732673 92 51 90.1 2 303 31 120 210 CAF1615689.1 unnamed protein product [Rotaria sp. Silwood1] diamond 828 73.9 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sp. Silwood1
30927613 30927613 PRJNA315314_S_NODE_27454_length_161_cov_1.393939_g27133_i0 PRJNA315314 27454 161 1.393939 2.24424179 Rotaria sordida 392033 Rotifera other_Eukaryota 58.5 3.22e-8   NR CAF0802631.1 392033 g27133 i0 78.4 0.68944099378882 37 8 68.9 0 11 121 482 518 CAF0802631.1 unnamed protein product [Rotaria sordida] diamond 111 58.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sordida
31085422 31085422 PRJNA315314_S_NODE_18375_length_192_cov_4.687117_g18054_i0 PRJNA315314 18375 192 4.687117 8.99926464 Adineta ricciae 249248 Rotifera other_Eukaryota 57.4 1.01e-7   NR CAF0784306.1 249248 g18054 i0 46.8 0.96875 62 31 93.8 2 9 188 100 161 CAF0784306.1 unnamed protein product [Adineta ricciae] diamond 186 57.4 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
31654418 31654418 PRJNA315314_S_NODE_24597_length_169_cov_1.257143_g24276_i0 PRJNA315314 24597 169 1.257143 2.12457167 Adineta ricciae 249248 Rotifera other_Eukaryota 95.5 2.98e-21   NR CAF1162286.1 249248 g24276 i0 89.1 14.5207100591716 55 6 97.6 0 3 167 309 363 CAF1162286.1 unnamed protein product [Adineta ricciae] diamond 2454 95.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
31780958 31780958 PRJNA315314_S_NODE_24917_length_168_cov_1.604317_g24596_i0 PRJNA315314 24917 168 1.604317 2.69525256 Adineta ricciae 249248 Rotifera other_Eukaryota 62 2e-9   NR CAF1677623.1 249248 g24596 i0 83.3 1.67857142857143 42 7 75 0 3 128 304 345 CAF1677623.1 unnamed protein product [Adineta ricciae] diamond 282 62 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
31925100 31925100 PRJNA315314_S_NODE_20797_length_182_cov_1.202614_g20476_i0 PRJNA315314 20797 182 1.202614 2.18875748 Eurotatoria 2816136 Rotifera other_Eukaryota 92.4 1.21e-22   NR CAF1681633.1 249248 g20476 i0 95.8 3.95604395604396 48 2 79.1 0 3 146 53 100 CAF1681633.1 unnamed protein product, partial [Adineta ricciae] diamond 720 93.2 0.991416309012876 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
32002613 32002613 PRJNA315314_S_NODE_25938_length_165_cov_1.507353_g25617_i0 PRJNA315314 25938 165 1.507353 2.48713245 Adineta ricciae 249248 Rotifera other_Eukaryota 45.1 0.00188   NR CAF1187129.1 249248 g25617 i0 54.3 0.836363636363636 46 19 81.8 2 11 145 17 61 CAF1187129.1 unnamed protein product [Adineta ricciae] diamond 138 45.1 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
32413993 32413993 PRJNA315314_S_NODE_19179_length_188_cov_5.232704_g18858_i0 PRJNA315314 19179 188 5.232704 9.83748352 Adineta steineri 433720 Rotifera other_Eukaryota 42.7 0.00622   NR CAF1472279.1 433720 g18858 i0 85.7 0.335106382978723 21 3 33.5 0 125 187 90 110 CAF1472279.1 unnamed protein product [Adineta steineri] diamond 63 42.7 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta steineri
32572300 32572300 PRJNA315314_S_NODE_19639_length_186_cov_4.675159_g19318_i0 PRJNA315314 19639 186 4.675159 8.69579574 Rotaria sordida 392033 Rotifera other_Eukaryota 90.5 9.78e-21   NR CAF0733783.1 392033 g19318 i0 59.7 4 62 25 100 0 186 1 106 167 CAF0733783.1 unnamed protein product [Rotaria sordida] diamond 744 90.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sordida
32729557 32729557 PRJNA315314_S_NODE_17640_length_196_cov_2.604790_g17319_i0 PRJNA315314 17640 196 2.60479 5.1053884 Rotaria sp. Silwood2 2762512 Rotifera other_Eukaryota 94.7 2.5699999999999998e-23   NR CAF3440507.1 2762512 g17319 i0 72.1 0.933673469387755 61 17 93.4 0 191 9 8 68 CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] diamond 183 94.7 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sp. Silwood2

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