RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1249042" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1249042 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
26725042 26725042 PRJNA1249042_S_NODE_94261_length_166_cov_1.024390_g94047_i0 PRJNA1249042 94261 166 1.02439 1.7004874 Ridgeia piscesae 27915 Annelida Annelida 50.8 1.84e-5   NR KAK2182532.1 27915 g94047 i0 72.2 1.95180722891566 36 10 65.1 0 108 1 70 105 KAK2182532.1 hypothetical protein NP493_350g01030 [Ridgeia piscesae] diamond 324 50.8 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
29428236 29428236 PRJNA1249042_S_NODE_98689_length_162_cov_2.369748_g98475_i0 PRJNA1249042 98689 162 2.369748 3.83899176 Metazoa 33208 Annelida Annelida 75.5 2.44e-14   NR XP_009012368.1 6412 g98475 i0 100 97.3333333333333 36 0 66.7 0 110 3 183 218 XP_009012368.1 hypothetical protein HELRODRAFT_185332 [Helobdella robusta] diamond 15768 75.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
30042016 30042016 PRJNA1249042_S_NODE_42131_length_221_cov_1.325843_g41917_i0 PRJNA1249042 42131 221 1.325843 2.93011303 Lamellibrachia satsuma 104711 Annelida Annelida 95.9 5.46e-21   NR KAI0233503.1 104711 g41917 i0 66.7 1.81900452488688 69 23 93.7 0 213 7 68 136 KAI0233503.1 Craniofacial development protein 2 [Lamellibrachia satsuma] diamond 402 95.9 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
32318599 32318599 PRJNA1249042_S_NODE_27779_length_246_cov_1.389163_g27565_i0 PRJNA1249042 27779 246 1.389163 3.41734098 Ridgeia piscesae 27915 Annelida Annelida 54.7 2.43e-6   NR KAK2163843.1 27915 g27565 i0 42.4 2.85365853658537 59 34 72 0 195 19 418 476 KAK2163843.1 hypothetical protein NP493_1444g02021 [Ridgeia piscesae] diamond 702 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
32791587 32791587 PRJNA1249042_S_NODE_105240_length_157_cov_4.122807_g105026_i0 PRJNA1249042 105240 157 4.122807 6.47280699 Lamellibrachia satsuma 104711 Annelida Annelida 41.2 0.0417   NR KAI0209977.1 104711 g105026 i0 72.7 2.10191082802548 22 6 42 0 26 91 120 141 KAI0209977.1 hypothetical protein LSAT2_005314 [Lamellibrachia satsuma] diamond 330 41.6 0.990384615384615 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma

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