RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA738523" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA738523 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
9647965 9647965 PRJNA738523_P_NODE_15468_length_242_cov_0.911243_g15397_i0 PRJNA738523 15468 242 0.911243 2.20520806 Hirudo verbana 311461 Annelida Annelida 62.1 3.62e-5   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g15397 i0 89.796 1.74380165289256 49 4 20 1 25 73 8828144 8828191 Hirudo verbana genome assembly, chromosome: 13 blastn 422 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
12198941 12198941 PRJNA738523_P_NODE_5350_length_311_cov_0.966387_g5279_i0 PRJNA738523 5350 311 0.966387 3.00546357 Hirudo verbana 311461 Annelida Annelida 69.4 2.89e-7   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g5279 i0 87.302 12.8810289389068 63 4 19 3 6 64 426261 426199 Hirudo verbana genome assembly, chromosome: 12 blastn 4006 69.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
13473366 13473366 PRJNA738523_P_NODE_14211_length_244_cov_1.801170_g14140_i0 PRJNA738523 14211 244 1.80117 4.3948548 Hirudo verbana 311461 Annelida Annelida 167 7.529999999999998e-37   NTclustered gi|2918369702|emb|OZ237787.1| 311461 g14140 i0 91.129 20.3401639344262 124 10 52 1 3 126 5167086 5167208 Hirudo verbana genome assembly, chromosome: 9 blastn 4963 167 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
13473386 13473386 PRJNA738523_P_NODE_2531_length_412_cov_2.253687_g2460_i0 PRJNA738523 2531 412 2.253687 9.28519044 Helobdella robusta 6412 Annelida Annelida 313 1.64e-80   NTclustered gi|675872871|ref|XM_009023748.1| 6412 g2460 i0 80.693 43.2936893203884 404 76 98 2 5 407 427 25 Helobdella robusta hypothetical protein partial mRNA blastn 17837 313 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
14748467 14748467 PRJNA738523_P_NODE_15732_length_242_cov_0.911243_g15661_i0 PRJNA738523 15732 242 0.911243 2.20520806 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.022   NTclustered gi|2920003323|emb|OZ238861.1| 1046305 g15661 i0 100 0.115702479338843 28 0 12 0 94 121 33627857 33627830 Ailoscolex lacteospumosus genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
24945978 24945978 PRJNA738523_P_NODE_14260_length_244_cov_1.444444_g14189_i0 PRJNA738523 14260 244 1.444444 3.52444336 Ailoscolex lacteospumosus 1046305 Annelida Annelida 69.4 2.19e-7   NTclustered gi|2920003323|emb|OZ238861.1| 1046305 g14189 i0 95.349 14.2622950819672 43 2 18 0 1 43 3194798 3194840 Ailoscolex lacteospumosus genome assembly, chromosome: 2 blastn 3480 69.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus

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