RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA596870 · 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
1844238 1844238 PRJNA596870_P_NODE_38762_length_242_cov_0.911243_g38629_i0 PRJNA596870 38762 242 0.911243 2.20520806 Hirudo verbana 311461 Annelida Annelida 52.8 0.022   NTclustered gi|2918369706|emb|OZ237788.1| 311461 g38629 i0 100 0.115702479338843 28 0 12 0 72 99 1192199 1192226 Hirudo verbana genome assembly, chromosome: 10 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
5672248 5672248 PRJNA596870_P_NODE_30565_length_250_cov_0.870056_g30432_i0 PRJNA596870 30565 250 0.870056 2.17514 Hirudo verbana 311461 Annelida Annelida 65.8 2.91e-6   NTclustered gi|2918369643|emb|OZ237784.1| 311461 g30432 i0 90.385 20.284 52 1 21 3 137 187 12469245 12469293 Hirudo verbana genome assembly, chromosome: 6 blastn 5071 65.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
11343823 11343823 PRJNA596870_P_NODE_18649_length_308_cov_1.463830_g18516_i0 PRJNA596870 18649 308 1.46383 4.5085964 Metazoa 33208 Annelida Annelida 228 4.449999999999999e-55   NTclustered gi|675884945|ref|XM_009029727.1| 6412 g18516 i0 82.09 167.438311688312 268 46 87 2 42 308 697 963 Helobdella robusta hypothetical protein partial mRNA blastn 51571 228 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
12047625 12047625 PRJNA596870_P_NODE_31790_length_249_cov_0.875000_g31657_i0 PRJNA596870 31790 249 0.875 2.17875 Hirudo verbana 311461 Annelida Annelida 56.5 0.002   NTclustered gi|2918369620|emb|OZ237782.1| 311461 g31657 i0 100 0.120481927710843 30 0 12 0 218 247 12405256 12405227 Hirudo verbana genome assembly, chromosome: 4 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
22245799 22245799 PRJNA596870_P_NODE_4838_length_548_cov_2.227368_g4706_i0 PRJNA596870 4838 548 2.227368 12.20597664 Hirudo verbana 311461 Annelida Annelida 56.5 0.004   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g4706 i0 100 0.0547445255474453 30 0 5 0 362 391 8590847 8590818 Hirudo verbana genome assembly, chromosome: 11 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
23520693 23520693 PRJNA596870_P_NODE_2319_length_758_cov_3.654015_g2199_i0 PRJNA596870 2319 758 3.654015 27.6974337 Helobdella robusta 6412 Annelida Annelida 603 1.6699999999999999e-167   NTclustered gi|675877099|ref|XM_009025862.1| 6412 g2199 i0 82.438 89.7295514511873 689 121 91 0 69 757 85 773 Helobdella robusta hypothetical protein mRNA blastn 68015 603 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
23521000 23521000 PRJNA596870_P_NODE_38759_length_242_cov_0.911243_g38626_i0 PRJNA596870 38759 242 0.911243 2.20520806 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.022   NTclustered gi|2920003651|emb|OZ238876.1| 1046305 g38626 i0 96.774 0.243801652892562 31 1 13 0 61 91 9497129 9497099 Ailoscolex lacteospumosus genome assembly, chromosome: 17 blastn 59 52.8 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);;