RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA1174234" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1174234 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
1040957 1040957 PRJNA1174234_P_NODE_8581_length_471_cov_0.773869_g8385_i0 PRJNA1174234 8581 471 0.773869 3.64492299 Dimorphilus gyrociliatus 2664684 Annelida Annelida 205 5.41e-58   NR CAD5123301.1 2664684 g8385 i0 61.5 2.98089171974522 156 58 99.4 1 470 3 592 745 CAD5123301.1 DgyrCDS11658 [Dimorphilus gyrociliatus] diamond 1404 205 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Dinophilidae Dimorphilus Dimorphilus gyrociliatus
2867065 2867065 PRJNA1174234_P_NODE_9343_length_451_cov_1.248677_g9147_i0 PRJNA1174234 9343 451 1.248677 5.63153327 Opisthokonta 33154 Annelida Annelida 219 5.38e-70   NR ABW23174.1 6344 g9147 i0 73.2 41.5809312638581 149 40 99.1 0 3 449 15 163 ABW23174.1 ribosomal protein rpl19 [Arenicola marina] diamond 18753 219 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Arenicolidae Arenicola Arenicola marina
13069762 13069762 PRJNA1174234_P_NODE_33131_length_245_cov_0.895349_g32935_i0 PRJNA1174234 33131 245 0.895349 2.19360505 Paralvinella palmiformis 53620 Annelida Annelida 80.9 1.36e-16   NR KAK2142995.1 53620 g32935 i0 52.6 0.955102040816327 78 36 95.5 1 235 2 22 98 KAK2142995.1 hypothetical protein LSH36_888g00068 [Paralvinella palmiformis] diamond 234 80.9 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis
16893114 16893114 PRJNA1174234_P_NODE_10474_length_426_cov_1.441926_g10278_i0 PRJNA1174234 10474 426 1.441926 6.14260476 Metazoa 33208 Annelida Annelida 191 4.69e-58   NR CAH1799511.1 6347 g10278 i0 63.1 13.8943661971831 141 52 99.3 0 424 2 113 253 CAH1799511.1 unnamed protein product [Owenia fusiformis] diamond 5919 192 0.994791666666667 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
20717409 20717409 PRJNA1174234_P_NODE_1217_length_1063_cov_3.601010_g1098_i0 PRJNA1174234 1217 1063 3.60101 38.2787363 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 276 3.739999999999999e-87   NR AAN28680.1 13286 g1098 i0 48.6 3.61523988711195 348 144 90 13 997 41 10 351 AAN28680.1 cathepsin L [Theromyzon tessulatum] diamond 3843 278 0.992805755395683 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Theromyzon Theromyzon tessulatum
28051264 28051264 PRJNA1174234_P_NODE_26785_length_264_cov_1.209424_g26589_i0 PRJNA1174234 26785 264 1.209424 3.19287936 Paralvinella palmiformis 53620 Annelida Annelida 50.8 6.76e-5   NR KAK2145522.1 53620 g26589 i0 46 0.715909090909091 63 29 67 3 57 233 287 348 KAK2145522.1 hypothetical protein LSH36_676g00014 [Paralvinella palmiformis] diamond 189 50.8 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis
28228091 28228091 PRJNA1174234_P_NODE_16586_length_339_cov_1.154135_g16390_i0 PRJNA1174234 16586 339 1.154135 3.91251765 Metazoa 33208 Annelida Annelida 99 3.85e-23   NR CCD27771.1 6446 g16390 i0 53.1 1.95575221238938 113 45 99.1 2 339 4 63 168 CCD27771.1 ribosomal protein l13, partial [Sipunculus nudus] diamond 663 99.4 0.995975855130785 Eukaryota Opisthokonta Metazoa Annelida Sipuncula Golfingiida Sipunculidae Sipunculus Sipunculus nudus
28556619 28556619 PRJNA1174234_P_NODE_14407_length_363_cov_1.020690_g14211_i0 PRJNA1174234 14407 363 1.02069 3.7051047 Owenia fusiformis 6347 Annelida Annelida 90.9 2.06e-18   NR CAH1792746.1 6347 g14211 i0 48 0.809917355371901 98 50 81 1 296 3 1443 1539 CAH1792746.1 unnamed protein product [Owenia fusiformis] diamond 294 90.9 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
30009146 30009146 PRJNA1174234_P_NODE_21231_length_300_cov_1.013216_g21035_i0 PRJNA1174234 21231 300 1.013216 3.039648 Owenia fusiformis 6347 Annelida Annelida 107 5.6799999999999995e-25   NR CAH1794275.1 6347 g21035 i0 53.8 0.91 91 42 91 0 2 274 50 140 CAH1794275.1 unnamed protein product [Owenia fusiformis] diamond 273 107 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
30577468 30577468 PRJNA1174234_P_NODE_3733_length_686_cov_2.119086_g3548_i0 PRJNA1174234 3733 686 2.119086 14.53692996 Eisenia fetida 6396 Annelida Annelida 89.4 7.24e-18   NR AUS83917.1 6396 g3548 i0 36 0.813411078717201 186 104 78.7 6 23 562 1 177 AUS83917.1 glutathion S-transferase pi [Eisenia fetida] diamond 558 89.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Lumbricidae Eisenia Eisenia fetida
31177723 31177723 PRJNA1174234_P_NODE_28415_length_254_cov_1.917127_g28219_i0 PRJNA1174234 28415 254 1.917127 4.86950258 Owenia fusiformis 6347 Annelida Annelida 69.3 8.99e-13   NR CAH1789242.1 6347 g28219 i0 45.5 1.2992125984252 55 30 65 0 208 44 76 130 CAH1789242.1 unnamed protein product [Owenia fusiformis] diamond 330 69.3 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
32158736 32158736 PRJNA1174234_P_NODE_27458_length_260_cov_1.229947_g27262_i0 PRJNA1174234 27458 260 1.229947 3.1978622 Ridgeia piscesae 27915 Annelida Annelida 43.9 0.0173   NR KAK2158995.1 27915 g27262 i0 46.8 2.14615384615385 47 25 54.2 0 259 119 326 372 KAK2158995.1 hypothetical protein NP493_1748g00001 [Ridgeia piscesae] diamond 558 43.9 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
32304652 32304652 PRJNA1174234_P_NODE_7379_length_504_cov_2.670534_g7183_i0 PRJNA1174234 7379 504 2.670534 13.45949136 Metazoa 33208 Annelida Annelida 167 1.29e-48   NR WXB48350.1 6390 g7183 i0 64.3 3.53571428571429 112 39 66.1 1 107 439 111 222 WXB48350.1 destabilase-lysozyme 2 [Enchytraeus albidus] diamond 1782 167 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Enchytraeida Enchytraeidae Enchytraeus Enchytraeus albidus
32821796 32821796 PRJNA1174234_P_NODE_32980_length_245_cov_0.895349_g32784_i0 PRJNA1174234 32980 245 0.895349 2.19360505 Dimorphilus gyrociliatus 2664684 Annelida Annelida 53.5 6.2e-6   NR CAD5118963.1 2664684 g32784 i0 50 1.64081632653061 48 22 58.8 1 172 29 869 914 CAD5118963.1 DgyrCDS7634 [Dimorphilus gyrociliatus] diamond 402 53.5 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Dinophilidae Dimorphilus Dimorphilus gyrociliatus

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