RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA390533", tax_clade = "Opisthokonta" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 4 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 4 ✖

bioproject 1

  • PRJNA390533 · 4 ✖

analysis 1

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
8062848 8062848 PRJNA390533_P_NODE_15307_length_473_cov_6.714286_g14307_i0 PRJNA390533 15307 473 6.714286 31.75857278 Hirudo verbana 311461 Annelida Annelida 52.8 0.046   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g14307 i0 96.774 0.06553911205074 31 1 7 0 394 424 7998187 7998217 Hirudo verbana genome assembly, chromosome: 12 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
18261212 18261212 PRJNA390533_P_NODE_21735_length_358_cov_6.884013_g20711_i0 PRJNA390533 21735 358 6.884013 24.64476654 Hirudo verbana 311461 Annelida Annelida 65.8 4.35e-6   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g20711 i0 97.368 0.189944134078212 38 1 11 0 101 138 8666240 8666277 Hirudo verbana genome assembly, chromosome: 12 blastn 68 65.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
22086169 22086169 PRJNA390533_P_NODE_31618_length_235_cov_17.479592_g30591_i0 PRJNA390533 31618 235 17.479592 41.0770412 Lumbricus terrestris 6398 Annelida Annelida 351 1.85e-92   NTclustered gi|5835191|ref|NC_001673.1| 6398 g30591 i0 97.115 10.5191489361702 208 6 89 0 22 229 1333 1540 Lumbricus terrestris mitochondrion, complete genome blastn 2472 351 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Lumbricidae Lumbricus Lumbricus terrestris
22755091 22755091 PRJNA390533_P_NODE_35218_length_207_cov_1.392857_g34191_i0 PRJNA390533 35218 207 1.392857 2.88321399 Clitellata 42113 Annelida Annelida 52.8 0.018   NTclustered gi|675856747|ref|XM_009015686.1| 6412 g34191 i0 100 0.434782608695652 28 0 14 0 48 75 167 140 Helobdella robusta hypothetical protein partial mRNA blastn 90 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta

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