RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA532380" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA532380 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
1117334 1117334 PRJNA532380_P_NODE_17941_length_212_cov_18.754601_g17616_i0 PRJNA532380 17941 212 18.754601 39.75975412 Helobdella robusta 6412 Annelida Annelida 97.8 5.14e-25   NR XP_009015833.1 6412 g17616 i0 83.3 2.32075471698113 54 9 76.4 0 42 203 1 54 XP_009015833.1 hypothetical protein HELRODRAFT_64261 [Helobdella robusta] diamond 492 97.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
11983047 11983047 PRJNA532380_P_NODE_8550_length_323_cov_1.386861_g8225_i0 PRJNA532380 8550 323 1.386861 4.47956103 Capitella teleta 283909 Annelida Annelida 126 3.5e-31   NR ELU12941.1 283909 g8225 i0 60.7 2.87925696594427 107 36 99.4 2 3 323 1197 1297 ELU12941.1 hypothetical protein CAPTEDRAFT_198744 [Capitella teleta] diamond 930 126 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
27123960 27123960 PRJNA532380_P_NODE_30122_length_166_cov_0.888889_g29797_i0 PRJNA532380 30122 166 0.888889 1.47555574 Metazoa 33208 Annelida Annelida 44.3 0.00381   NR KAK2186147.1 27915 g29797 i0 48.7 2.02409638554217 39 15 61.4 1 2 103 434 472 KAK2186147.1 hypothetical protein NP493_212g03021 [Ridgeia piscesae] diamond 336 44.7 0.991051454138702 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
27140454 27140454 PRJNA532380_P_NODE_14522_length_237_cov_2.515957_g14197_i0 PRJNA532380 14522 237 2.5159570000000002 5.96281809 Dimorphilus gyrociliatus 2664684 Annelida Annelida 64.3 8.18e-10   NR CAD5121438.1 2664684 g14197 i0 39.5 0.962025316455696 76 42 91.1 1 216 1 123 198 CAD5121438.1 DgyrCDS9949 [Dimorphilus gyrociliatus] diamond 228 64.3 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Dinophilidae Dimorphilus Dimorphilus gyrociliatus
28151634 28151634 PRJNA532380_P_NODE_22925_length_187_cov_1.652174_g22600_i0 PRJNA532380 22925 187 1.652174 3.08956538 Owenia fusiformis 6347 Annelida Annelida 82.4 1.77e-18   NR CAH1792323.1 6347 g22600 i0 78.4 1.63636363636364 51 11 81.8 0 34 186 1 51 CAH1792323.1 unnamed protein product [Owenia fusiformis] diamond 306 82.4 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
28277546 28277546 PRJNA532380_P_NODE_33446_length_162_cov_0.920354_g33121_i0 PRJNA532380 33446 162 0.920354 1.49097348 Lamellibrachia satsuma 104711 Annelida Annelida 82 1.72e-16   NR KAI0219131.1 104711 g33121 i0 63 2 54 19 98.1 1 2 160 473 526 KAI0219131.1 Kelch-like protein 26 [Lamellibrachia satsuma] diamond 324 82 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
28562030 28562030 PRJNA532380_P_NODE_14887_length_234_cov_1.405405_g14562_i0 PRJNA532380 14887 234 1.405405 3.2886477 Lamellibrachia satsuma 104711 Annelida Annelida 108 1.05e-26   NR KAI0219335.1 104711 g14562 i0 61.8 2.93589743589744 76 29 97.4 0 228 1 92 167 KAI0219335.1 Calcyphosin-like protein [Lamellibrachia satsuma] diamond 687 108 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
28576938 28576938 PRJNA532380_P_NODE_7487_length_349_cov_1.040000_g7162_i0 PRJNA532380 7487 349 1.04 3.6296 Metazoa 33208 Annelida Annelida 144 2.2199999999999998e-39   NR XP_009031044.1 6412 g7162 i0 66.4 7.81375358166189 110 36 94.6 1 16 345 100 208 XP_009031044.1 hypothetical protein HELRODRAFT_186207 [Helobdella robusta] diamond 2727 144 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
29287971 29287971 PRJNA532380_P_NODE_28489_length_168_cov_0.873950_g28164_i0 PRJNA532380 28489 168 0.87395 1.468236 Lamellibrachia satsuma 104711 Annelida Annelida 116 1.2e-28   NR KAI0231565.1 104711 g28164 i0 90.9 1.96428571428571 55 5 98.2 0 167 3 171 225 KAI0231565.1 DET1-like protein [Lamellibrachia satsuma] diamond 330 116 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
29445761 29445761 PRJNA532380_P_NODE_2150_length_723_cov_4.983680_g1884_i0 PRJNA532380 2150 723 4.98368 36.0320064 Helobdella robusta 6412 Annelida Annelida 151 3.0299999999999996e-42   NR XP_009028970.1 6412 g1884 i0 43.6 2.07883817427386 165 92 68.5 1 66 560 1 164 XP_009028970.1 hypothetical protein HELRODRAFT_108067, partial [Helobdella robusta] diamond 1503 151 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
29445766 29445766 PRJNA532380_P_NODE_24590_length_180_cov_1.190840_g24265_i0 PRJNA532380 24590 180 1.19084 2.143512 Dimorphilus gyrociliatus 2664684 Annelida Annelida 110 1.2e-26   NR CAD5118452.1 2664684 g24265 i0 89.7 0.966666666666667 58 6 96.7 0 7 180 231 288 CAD5118452.1 DgyrCDS7159 [Dimorphilus gyrociliatus] diamond 174 110 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Dinophilidae Dimorphilus Dimorphilus gyrociliatus
29635027 29635027 PRJNA532380_P_NODE_11090_length_276_cov_2.911894_g10765_i0 PRJNA532380 11090 276 2.911894 8.03682744 Lamellibrachia satsuma 104711 Annelida Annelida 70.1 1.28e-12   NR KAI0221400.1 104711 g10765 i0 40.2 1.75 82 46 89.1 1 254 9 1 79 KAI0221400.1 TCTP domain-containing protein [Lamellibrachia satsuma] diamond 483 70.1 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
31025555 31025555 PRJNA532380_P_NODE_27935_length_168_cov_1.747899_g27610_i0 PRJNA532380 27935 168 1.747899 2.93647032 Paralvinella palmiformis 53620 Annelida Annelida 74.7 3.57e-15   NR KAK2143758.1 53620 g27610 i0 63.6 0.982142857142857 55 18 96.4 2 6 167 70 123 KAK2143758.1 hypothetical protein LSH36_815g03000 [Paralvinella palmiformis] diamond 165 74.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis
31531490 31531490 PRJNA532380_P_NODE_29516_length_167_cov_0.881356_g29191_i0 PRJNA532380 29516 167 0.881356 1.47186452 Owenia fusiformis 6347 Annelida Annelida 55.8 3.13e-7   NR CAH1792581.1 6347 g29191 i0 67.6 3.26946107784431 37 12 66.5 0 113 3 386 422 CAH1792581.1 unnamed protein product [Owenia fusiformis] diamond 546 55.8 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
32259276 32259276 PRJNA532380_P_NODE_28538_length_168_cov_0.873950_g28213_i0 PRJNA532380 28538 168 0.87395 1.468236 Owenia fusiformis 6347 Annelida Annelida 51.6 9.92e-6   NR CAH1787995.1 6347 g28213 i0 42.6 0.964285714285714 54 29 92.9 1 3 158 807 860 CAH1787995.1 unnamed protein product [Owenia fusiformis] diamond 162 51.6 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis

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