RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA951810" 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

  • PRJNA951810 · 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
27594462 27594462 PRJNA951810_P_NODE_117264_length_282_cov_2.028708_g116920_i0 PRJNA951810 117264 282 2.028708 5.72095656 Ridgeia piscesae 27915 Annelida Annelida 50.4 1.11e-4   NR KAK2194222.1 27915 g116920 i0 52.1 2.29787234042553 48 23 51.1 0 3 146 424 471 KAK2194222.1 hypothetical protein NP493_1g02003 [Ridgeia piscesae] diamond 648 50.4 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
27752423 27752423 PRJNA951810_P_NODE_151884_length_256_cov_5.693989_g151539_i0 PRJNA951810 151884 256 5.693989 14.57661184 Lamellibrachia satsuma 104711 Annelida Annelida 72.8 1.16e-12   NR KAI0240140.1 104711 g151539 i0 49.3 2.61328125 71 33 79.7 1 207 4 562 632 KAI0240140.1 E3 ubiquitin-protein ligase TRIM56 [Lamellibrachia satsuma] diamond 669 72.8 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
28295415 28295415 PRJNA951810_P_NODE_78206_length_299_cov_4.938053_g77862_i0 PRJNA951810 78206 299 4.938053 14.76477847 Opisthokonta 33154 Annelida Annelida 45.1 0.00523   NR XP_009024478.1 6412 g77862 i0 48.7 2.79933110367893 39 20 39.1 0 277 161 15 53 XP_009024478.1 hypothetical protein HELRODRAFT_85566, partial [Helobdella robusta] diamond 837 45.4 0.993392070484582 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
28510062 28510062 PRJNA951810_P_NODE_179187_length_233_cov_3.168750_g178842_i0 PRJNA951810 179187 233 3.16875 7.3831875 Capitella teleta 283909 Annelida Annelida 50.1 8.61e-5   NR ELT99505.1 283909 g178842 i0 57.1 1.3519313304721 35 15 45.1 0 1 105 233 267 ELT99505.1 hypothetical protein CAPTEDRAFT_108416 [Capitella teleta] diamond 315 50.1 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
28794056 28794056 PRJNA951810_P_NODE_193687_length_207_cov_6.104478_g193342_i0 PRJNA951810 193687 207 6.104478 12.63626946 Owenia fusiformis 6347 Annelida Annelida 61.6 5.18e-9   NR CAH1777903.1 6347 g193342 i0 62.2 1.07246376811594 37 14 53.6 0 91 201 257 293 CAH1777903.1 unnamed protein product [Owenia fusiformis] diamond 222 61.6 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
30436687 30436687 PRJNA951810_P_NODE_159833_length_250_cov_2.711864_g159488_i0 PRJNA951810 159833 250 2.711864 6.77966 Lamellibrachia satsuma 104711 Annelida Annelida 87.4 7.82e-18   NR KAI0229746.1 104711 g159488 i0 60.3 3.48 73 28 86.4 1 26 241 372 444 KAI0229746.1 Xanthine dehydrogenase/oxidase [Lamellibrachia satsuma] diamond 870 87.4 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
30980209 30980209 PRJNA951810_P_NODE_143414_length_263_cov_3.047368_g143069_i0 PRJNA951810 143414 263 3.047368 8.01457784 Metazoa 33208 Annelida Annelida 50.4 9.04e-5   NR KAK2193066.1 27915 g143069 i0 46.7 1.0722433460076 45 20 51.3 1 150 16 70 110 KAK2193066.1 hypothetical protein NP493_17g02086 [Ridgeia piscesae] diamond 282 50.4 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae

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