RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA407087" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA407087 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
5518729 5518729 PRJNA407087_S_NODE_485_length_1094_cov_37.500469_g295_i0 PRJNA407087 485 1094 37.500469 410.25513086 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 278 1.3099999999999995e-87   NR AAN28680.1 13286 g295 i0 48.9 3.5127970749543 348 143 87.5 13 1019 63 10 351 AAN28680.1 cathepsin L [Theromyzon tessulatum] diamond 3843 278 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Theromyzon Theromyzon tessulatum
20816585 20816585 PRJNA407087_S_NODE_2477_length_404_cov_13.250667_g2016_i0 PRJNA407087 2477 404 13.250667 53.53269468 Theromyzon tessulatum 13286 Annelida Annelida 137 1.96e-36   NR AAN28680.1 13286 g2016 i0 53.4 3.95049504950495 146 55 99.5 7 404 3 195 339 AAN28680.1 cathepsin L [Theromyzon tessulatum] diamond 1596 137 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Theromyzon Theromyzon tessulatum
26948803 26948803 PRJNA407087_S_NODE_3602_length_303_cov_4.496350_g3139_i0 PRJNA407087 3602 303 4.49635 13.6239405 Capitella teleta 283909 Annelida Annelida 96.7 2.4199999999999998e-23   NR ELU09549.1 283909 g3139 i0 53.4 0.722772277227723 73 34 72.3 0 220 2 12 84 ELU09549.1 hypothetical protein CAPTEDRAFT_136883 [Capitella teleta] diamond 219 96.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
28749208 28749208 PRJNA407087_S_NODE_4387_length_260_cov_2.948052_g3924_i0 PRJNA407087 4387 260 2.948052 7.6649352 Helobdella robusta 6412 Annelida Annelida 74.3 1.82e-13   NR XP_009009591.1 6412 g3924 i0 45.3 4.89230769230769 86 47 99.2 0 1 258 34 119 XP_009009591.1 hypothetical protein HELRODRAFT_63303 [Helobdella robusta] diamond 1272 74.3 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
29033634 29033634 PRJNA407087_S_NODE_7428_length_179_cov_1.860000_g6965_i0 PRJNA407087 7428 179 1.86 3.3294 Helobdella robusta 6412 Annelida Annelida 80.1 1.01e-16   NR XP_009021936.1 6412 g6965 i0 61.4 2.89944134078212 57 22 95.5 0 179 9 86 142 XP_009021936.1 hypothetical protein HELRODRAFT_185778 [Helobdella robusta] diamond 519 80.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
30913776 30913776 PRJNA407087_S_NODE_7914_length_172_cov_2.174825_g7451_i0 PRJNA407087 7914 172 2.174825 3.740699 Metazoa 33208 Annelida Annelida 53.1 2.29e-7   NR KAK2175563.1 27915 g7451 i0 46.4 6.80232558139535 56 30 97.7 0 3 170 10 65 KAK2175563.1 hypothetical protein NP493_726g01026 [Ridgeia piscesae] diamond 1170 53.1 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
32762099 32762099 PRJNA407087_S_NODE_5020_length_234_cov_1.990244_g4557_i0 PRJNA407087 5020 234 1.990244 4.65717096 Paralvinella palmiformis 53620 Annelida Annelida 43.5 0.0174   NR KAK2143477.1 53620 g4557 i0 41.4 1.69230769230769 70 38 89.7 2 3 212 332 398 KAK2143477.1 hypothetical protein LSH36_838g01002 [Paralvinella palmiformis] diamond 396 43.5 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis

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