RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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

  • PRJNA1035005 · 7 ✖

analysis 1

  • blastn · 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
1443454 1443454 PRJNA1035005_P_NODE_2462_length_726_cov_5.583461_g2083_i0 PRJNA1035005 2462 726 5.583461 40.535926859999996 Aeolosoma sp. GG-2011 1071604 Annelida Annelida 359 3.82e-94   NTclustered gi|342220097|gb|HQ691208.1| 1071604 g2083 i0 81.21 26.1225895316804 463 72 62 10 125 576 472 14 Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 18965 359 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Aeolosomatidae Aeolosoma Aeolosoma sp. GG-2011
4836004 4836004 PRJNA1035005_P_NODE_7604_length_398_cov_1.467692_g7202_i0 PRJNA1035005 7604 398 1.467692 5.84141416 Opisthokonta 33154 Annelida Annelida 56.5 0.003   NTclustered gi|2918369697|emb|OZ237786.1| 311461 g7202 i0 100 0.296482412060302 30 0 8 0 239 268 11023387 11023416 Hirudo verbana genome assembly, chromosome: 8 blastn 118 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
15471854 15471854 PRJNA1035005_P_NODE_6173_length_431_cov_1.743017_g5771_i0 PRJNA1035005 6173 431 1.743017 7.51240327 Dendrobaena pentheri 1302597 Annelida Annelida 75 8.88e-9   NTclustered gi|674656596|gb|KJ912407.1| 1302597 g5771 i0 72.492 2.20417633410673 309 58 69 26 63 358 703 409 Dendrobaena pentheri isolate MPL406 12S ribosomal RNA gene, partial sequence; tRNA-Val gene, complete sequence; and 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 950 75 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Lumbricidae Dendrobaena Dendrobaena pentheri
20569811 20569811 PRJNA1035005_P_NODE_13617_length_332_cov_1.660232_g13211_i0 PRJNA1035005 13617 332 1.660232 5.51197024 Ailoscolex lacteospumosus 1046305 Annelida Annelida 56.5 0.002   NTclustered gi|2920003484|emb|OZ238865.1| 1046305 g13211 i0 100 0.0903614457831325 30 0 9 0 170 199 20004805 20004834 Ailoscolex lacteospumosus genome assembly, chromosome: 6 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
20569964 20569964 PRJNA1035005_P_NODE_3557_length_574_cov_1.554890_g3164_i0 PRJNA1035005 3557 574 1.55489 8.9250686 Pristina longiseta 188231 Annelida Annelida 891 0   NTclustered gi|2169792353|gb|OM001222.1| 188231 g3164 i0 97.154 82.4756097560976 527 15 92 0 7 533 1 527 Pristina longiseta voucher CW649 large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 47341 891 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Tubificida Naididae Pristina Pristina longiseta
21845560 21845560 PRJNA1035005_P_NODE_14898_length_324_cov_1.243028_g14492_i0 PRJNA1035005 14898 324 1.243028 4.02741072 Hirudo verbana 311461 Annelida Annelida 58.4 6.54e-4   NTclustered gi|2918369706|emb|OZ237788.1| 311461 g14492 i0 97.143 1.3179012345679 35 0 10 1 122 155 5029325 5029359 Hirudo verbana genome assembly, chromosome: 10 blastn 427 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
24394762 24394762 PRJNA1035005_P_NODE_19020_length_304_cov_1.965368_g18614_i0 PRJNA1035005 19020 304 1.965368 5.97471872 Hirudo verbana 311461 Annelida Annelida 75 6.05e-9   NTclustered gi|2918369693|emb|OZ237785.1| 311461 g18614 i0 89.655 137.644736842105 58 6 19 0 92 149 3955963 3955906 Hirudo verbana genome assembly, chromosome: 7 blastn 41844 75 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana

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