RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1005695 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
1428300 1428300 PRJNA1005695_P_NODE_31702_length_265_cov_1.500000_g30850_i0 PRJNA1005695 31702 265 1.5 3.975 Pristina leidyi 150440 Annelida Annelida 468 2.03e-127   NTclustered gi|33330137|gb|AF534853.1| 150440 g30850 i0 98.491 92.5924528301887 265 4 100 0 1 265 808 544 Pristina leidyi isolate PRIlecbc cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial gene for mitochondrial product blastn 24537 468 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Tubificida Naididae Pristina Pristina leidyi
3980117 3980117 PRJNA1005695_P_NODE_9364_length_510_cov_1.151030_g8515_i0 PRJNA1005695 9364 510 1.15103 5.870253 Helobdella robusta 6412 Annelida Annelida 54.7 0.014   NTclustered gi|675879857|ref|XM_009027202.1| 6412 g8515 i0 96.97 0.0647058823529412 33 0 6 1 391 422 2089 2057 Helobdella robusta hypothetical protein partial mRNA blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
6531802 6531802 PRJNA1005695_P_NODE_39826_length_242_cov_1.846154_g38974_i0 PRJNA1005695 39826 242 1.846154 4.46769268 Hirudo verbana 311461 Annelida Annelida 52.8 0.022   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g38974 i0 100 0.115702479338843 28 0 12 0 28 55 5858307 5858280 Hirudo verbana genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
7806216 7806216 PRJNA1005695_P_NODE_4427_length_761_cov_1.690407_g3696_i0 PRJNA1005695 4427 761 1.690407 12.86399727 Ailoscolex lacteospumosus 1046305 Annelida Annelida 62.1 1.27e-4   NTclustered gi|2920003484|emb|OZ238865.1| 1046305 g3696 i0 89.583 0.0630749014454665 48 5 6 0 88 135 6881328 6881281 Ailoscolex lacteospumosus genome assembly, chromosome: 6 blastn 48 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
9929092 9929092 PRJNA1005695_P_NODE_25848_length_295_cov_1.351351_g24996_i0 PRJNA1005695 25848 295 1.351351 3.98648545 Pristina 150439 Annelida Annelida 545 1.03e-150   NTclustered gi|285029398|gb|GQ355416.1| 150440 g24996 i0 100 44.9559322033898 295 0 100 0 1 295 380 86 Pristina leidyi 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 13262 545 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Tubificida Naididae Pristina Pristina leidyi
12907329 12907329 PRJNA1005695_P_NODE_37591_length_247_cov_0.896552_g36739_i0 PRJNA1005695 37591 247 0.896552 2.21448344 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.022   NTclustered gi|2920003508|emb|OZ238866.1| 1046305 g36739 i0 96.875 0.129554655870445 32 0 13 1 206 237 16912113 16912083 Ailoscolex lacteospumosus genome assembly, chromosome: 7 blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
15456084 15456084 PRJNA1005695_P_NODE_18413_length_352_cov_2.236559_g17561_i0 PRJNA1005695 18413 352 2.236559 7.87268768 Dendrobaena pentheri 1302597 Annelida Annelida 63.9 1.54e-5   NTclustered gi|674656596|gb|KJ912407.1| 1302597 g17561 i0 72.414 1.42045454545455 261 51 71 19 99 347 660 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 500 63.9 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Lumbricidae Dendrobaena Dendrobaena pentheri
16303594 16303594 PRJNA1005695_P_NODE_21613_length_323_cov_38.012000_g20761_i0 PRJNA1005695 21613 323 38.012 122.77876 Haemadipsidae 27387 Annelida Annelida 222 2.18e-53   NTclustered gi|316927165|gb|HQ203119.1| 933824 g20761 i0 80.061 101.195046439628 326 44 100 12 1 323 1353 1046 Domanibdella palmyrae isolate APY 28S ribosomal RNA gene, partial sequence blastn 32686 222 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Haemadipsidae Domanibdella Domanibdella palmyrae

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