RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Bryozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bryozoa · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB64798 · 18 ✖

analysis 1

  • blastn · 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
993094 993094 PRJEB64798_P_NODE_181681_length_173_cov_15.500000_g179915_i0 PRJEB64798 181681 173 15.5 26.815 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 302 1.31e-77   NTclustered gi|359292663|gb|JN681030.1| 56620 g179915 i0 99.401 93.2543352601156 167 0 96 1 7 172 2221 2387 Plumatella emarginata 28S ribosomal RNA gene, partial sequence blastn 16133 302 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella emarginata
2268144 2268144 PRJEB64798_P_NODE_155422_length_185_cov_18.110294_g153656_i0 PRJEB64798 155422 185 18.110294 33.5040439 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 327 2.34e-85   NTclustered gi|359292663|gb|JN681030.1| 56620 g153656 i0 99.448 98.1027027027027 181 0 97 1 1 180 2109 1929 Plumatella emarginata 28S ribosomal RNA gene, partial sequence blastn 18149 327 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella emarginata
6096678 6096678 PRJEB64798_P_NODE_43525_length_298_cov_26.815261_g41760_i0 PRJEB64798 43525 298 26.815261 79.90947778 Thalamoporella 97293 Bryozoa other_Eukaryota 63.9 1.28e-5   NTclustered gi|2075442530|gb|MZ677793.1| 2865220 g41760 i0 87.273 0.761744966442953 55 7 18 0 3 57 3645 3699 Thalamoporella sp. BLEED1037 large subunit ribosomal RNA gene, partial sequence blastn 227 63.9 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Thalamoporellidae Thalamoporella Thalamoporella sp. BLEED1037
7370741 7370741 PRJEB64798_P_NODE_21866_length_424_cov_32.408000_g20127_i0 PRJEB64798 21866 424 32.408 137.40992 Thalamoporellidae 97292 Bryozoa other_Eukaryota 97.1 1.86e-15   NTclustered gi|2075442530|gb|MZ677793.1| 2865220 g20127 i0 77.457 27.7429245283019 173 31 41 4 249 420 3706 3541 Thalamoporella sp. BLEED1037 large subunit ribosomal RNA gene, partial sequence blastn 11763 97.1 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Thalamoporellidae Thalamoporella Thalamoporella sp. BLEED1037
9055179 9055179 PRJEB64798_P_NODE_20448_length_440_cov_17.473146_g18717_i0 PRJEB64798 20448 440 17.473146 76.8818424 Plumatella sp. ZHY-2005 365321 Bryozoa other_Eukaryota 318 3.7999999999999996e-82   NTclustered gi|90992874|gb|DQ333339.1| 365321 g18717 i0 81.796 54.5409090909091 401 53 90 18 38 433 1936 2321 Plumatella sp. ZHY-2005 28S ribosomal RNA gene, partial sequence blastn 23998 318 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella sp. ZHY-2005
9056014 9056014 PRJEB64798_P_NODE_33608_length_340_cov_5.945017_g31850_i0 PRJEB64798 33608 340 5.945017 20.2130578 Fredericella sultana 349672 Bryozoa other_Eukaryota 370 7.81e-98   NTclustered gi|359292662|gb|JN681029.1| 349672 g31850 i0 99.507 60.4941176470588 203 1 60 0 113 315 2721 2519 Fredericella sultana 28S ribosomal RNA gene, partial sequence blastn 20568 370 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Fredericellidae Fredericella Fredericella sultana
10330066 10330066 PRJEB64798_P_NODE_142369_length_192_cov_4.412587_g140603_i0 PRJEB64798 142369 192 4.412587 8.47216704 Plumatella sp. ZHY-2005 365321 Bryozoa other_Eukaryota 126 9.6e-25   NTclustered gi|90992874|gb|DQ333339.1| 365321 g140603 i0 79.474 0.989583333333333 190 30 96 9 3 187 579 394 Plumatella sp. ZHY-2005 28S ribosomal RNA gene, partial sequence blastn 190 126 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella sp. ZHY-2005
13746836 13746836 PRJEB64798_P_NODE_27331_length_376_cov_19.385321_g25576_i0 PRJEB64798 27331 376 19.385321 72.88880696 Plumatella 34519 Bryozoa other_Eukaryota 682 0   NTclustered gi|359292663|gb|JN681030.1| 56620 g25576 i0 99.467 26.9281914893617 375 2 99 0 2 376 808 434 Plumatella emarginata 28S ribosomal RNA gene, partial sequence blastn 10125 682 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella emarginata
15021589 15021589 PRJEB64798_P_NODE_71012_length_229_cov_7.305556_g69247_i0 PRJEB64798 71012 229 7.305556 16.72972324 Metazoa 33208 Bryozoa other_Eukaryota 102 2e-17   NTclustered gi|225542725|gb|FJ196125.1| 626267 g69247 i0 92 25.3362445414847 75 2 32 4 151 223 619 547 Diplosolen obelia 18S ribosomal RNA gene, partial sequence blastn 5802 102 1 Eukaryota Opisthokonta Metazoa Bryozoa Stenolaemata Cyclostomatida Diastoporidae Diplosolen Diplosolen obelia
15429236 15429236 PRJEB64798_P_NODE_13253_length_548_cov_121.899800_g11609_i0 PRJEB64798 13253 548 121.8998 668.010904 Steginoporella haddoni 2865435 Bryozoa other_Eukaryota 63.9 2.49e-5   NTclustered gi|2075442463|gb|MZ677754.1| 2865435 g11609 i0 95 2.98175182481752 40 2 7 0 159 198 3547 3586 Steginoporella haddoni voucher BLEED1763 large subunit ribosomal RNA gene, partial sequence blastn 1634 63.9 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Steginoporellidae Steginoporella Steginoporella haddoni
16295735 16295735 PRJEB64798_P_NODE_181913_length_173_cov_9.024194_g180147_i0 PRJEB64798 181913 173 9.024194 15.61185562 Plumatellidae 34518 Bryozoa other_Eukaryota 315 1.68e-81   NTclustered gi|478434497|gb|KC462029.1| 34520 g180147 i0 100 69.7861271676301 170 0 98 0 1 170 206 37 Plumatella repens isolate EW16 28S ribosomal RNA gene, partial sequence blastn 12073 315 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella repens
16296165 16296165 PRJEB64798_P_NODE_38233_length_319_cov_23.181481_g36473_i0 PRJEB64798 38233 319 23.181481 73.94892439 Thalamoporella 97293 Bryozoa other_Eukaryota 65.8 3.84e-6   NTclustered gi|2075442530|gb|MZ677793.1| 2865220 g36473 i0 91.667 0.54858934169279 48 2 14 2 167 212 3708 3661 Thalamoporella sp. BLEED1037 large subunit ribosomal RNA gene, partial sequence blastn 175 65.8 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Thalamoporellidae Thalamoporella Thalamoporella sp. BLEED1037
17570672 17570672 PRJEB64798_P_NODE_135374_length_195_cov_30.719178_g133608_i0 PRJEB64798 135374 195 30.719178 59.9023971 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 278 2.55e-70   NTclustered gi|359292491|gb|JN680929.1| 56620 g133608 i0 100 99.4769230769231 150 0 97 0 6 155 673 822 Plumatella emarginata 18S ribosomal RNA gene, partial sequence blastn 19398 278 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella emarginata
17979217 17979217 PRJEB64798_P_NODE_187615_length_171_cov_4.360656_g185849_i0 PRJEB64798 187615 171 4.360656 7.45672176 Cristatella mucedo 67896 Bryozoa other_Eukaryota 285 1.3e-72   NTclustered gi|359292660|gb|JN681027.1| 67896 g185849 i0 97.041 14.8187134502924 169 5 99 0 1 169 580 412 Cristatella mucedo 28S ribosomal RNA gene, partial sequence blastn 2534 285 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Cristatellidae Cristatella Cristatella mucedo
20527684 20527684 PRJEB64798_P_NODE_127117_length_199_cov_99.946667_g125351_i0 PRJEB64798 127117 199 99.946667 198.89386733 Watersipora subatra 2589382 Bryozoa other_Eukaryota 178 2.7299999999999998e-40   NTclustered gi|2795730917|ref|XR_010979524.1| 2589382 g125351 i0 83.838 119.48743718593 198 20 96 11 5 196 192 1 PREDICTED: Watersipora subatra U2 spliceosomal RNA (LOC137402908), ncRNA blastn 23778 178 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Watersiporidae Watersipora Watersipora subatra
20530080 20530080 PRJEB64798_P_NODE_52717_length_269_cov_8.918182_g50952_i0 PRJEB64798 52717 269 8.918182 23.98990958 Chaperiopsis aff. rubida RJO-2020 2780250 Bryozoa other_Eukaryota 75 5.26e-9   NTclustered gi|1919295448|gb|MW173720.1| 2780250 g50952 i0 95.652 1.82156133828996 46 2 17 0 143 188 3401 3356 Chaperiopsis aff. rubida RJO-2020 voucher BLEED1658 large subunit ribosomal RNA gene, partial sequence blastn 490 75 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Chaperiidae Chaperiopsis Chaperiopsis aff. rubida RJO-2020
23945576 23945576 PRJEB64798_P_NODE_207599_length_165_cov_4.741379_g205833_i0 PRJEB64798 207599 165 4.741379 7.82327535 Plumatellida 3279198 Bryozoa other_Eukaryota 294 2.08e-75   NTclustered gi|237872802|gb|FJ409576.1| 350071 g205833 i0 100 96.5393939393939 159 0 96 0 6 164 1499 1657 Pectinatella magnifica 28S ribosomal RNA gene, partial sequence blastn 15929 294 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Pectinatellidae Pectinatella Pectinatella magnifica
25219032 25219032 PRJEB64798_P_NODE_158100_length_184_cov_5.488889_g156334_i0 PRJEB64798 158100 184 5.488889 10.09955576 Plumatella 34519 Bryozoa other_Eukaryota 326 8.37e-85   NTclustered gi|359292663|gb|JN681030.1| 56620 g156334 i0 99.441 83.8967391304348 179 1 97 0 1 179 1678 1500 Plumatella emarginata 28S ribosomal RNA gene, partial sequence blastn 15437 326 1 Eukaryota Opisthokonta Metazoa Bryozoa Phylactolaemata   Plumatellidae Plumatella Plumatella emarginata

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