RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA811237" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA811237 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
808834 808834 PRJNA811237_S_NODE_9941_length_243_cov_3.015464_g9701_i0 PRJNA811237 9941 243 3.015464 7.32757752 Hirudo verbana 311461 Annelida Annelida 54.7 0.006   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g9701 i0 96.875 0.259259259259259 32 1 13 0 10 41 5421141 5421110 Hirudo verbana genome assembly, chromosome: 3 blastn 63 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
2084477 2084477 PRJNA811237_S_NODE_18022_length_197_cov_1.033784_g17782_i0 PRJNA811237 18022 197 1.033784 2.03655448 Hirudo verbana 311461 Annelida Annelida 56.5 0.001   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g17782 i0 100 0.152284263959391 30 0 15 0 8 37 1936438 1936467 Hirudo verbana genome assembly, chromosome: 13 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
5051626 5051626 PRJNA811237_S_NODE_5944_length_301_cov_3.031746_g5704_i0 PRJNA811237 5944 301 3.031746 9.12555546 Metazoa 33208 Annelida Annelida 58.4 6.02e-4   NTclustered gi|675889717|ref|XM_009032113.1| 6412 g5704 i0 100 1.75415282392027 31 0 10 0 1 31 307 277 Helobdella robusta hypothetical protein partial mRNA blastn 528 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
18660204 18660204 PRJNA811237_S_NODE_16375_length_204_cov_0.987097_g16135_i0 PRJNA811237 16375 204 0.987097 2.01367788 Arenicola marina 6344 Annelida Annelida 122 1.34e-23   NTclustered gi|2108986978|gb|MZ593393.1| 6344 g16135 i0 80.892 3.41666666666667 157 28 76 2 41 196 363 518 Arenicola marina 26S proteasome regulatory subunit 4 (PSMC1) mRNA, complete cds blastn 697 122 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Arenicolidae Arenicola Arenicola marina
21210985 21210985 PRJNA811237_S_NODE_2097_length_497_cov_2.888393_g1858_i0 PRJNA811237 2097 497 2.888393 14.35531321 Hirudo verbana 311461 Annelida Annelida 58.4 0.001   NTclustered gi|2918369614|emb|OZ237780.1| 311461 g1858 i0 100 1.92957746478873 31 0 6 0 467 497 7580224 7580254 Hirudo verbana genome assembly, chromosome: 2 blastn 959 58.4 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);;