RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA508758" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA508758 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
484741 484741 PRJNA508758_P_NODE_61681_length_274_cov_1.532338_g60633_i0 PRJNA508758 61681 274 1.532338 4.19860612 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.007   NTclustered gi|2920003593|emb|OZ238871.1| 1046305 g60633 i0 100 0.105839416058394 29 0 11 0 234 262 7484976 7484948 Ailoscolex lacteospumosus genome assembly, chromosome: 12 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
1759835 1759835 PRJNA508758_P_NODE_47942_length_305_cov_1.887931_g46894_i0 PRJNA508758 47942 305 1.887931 5.75818955 Hirudo verbana 311461 Annelida Annelida 65.8 3.65e-6   NTclustered gi|2918369697|emb|OZ237786.1| 311461 g46894 i0 91.667 3.02950819672131 48 3 15 1 1 47 10448676 10448629 Hirudo verbana genome assembly, chromosome: 8 blastn 924 65.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
9412695 9412695 PRJNA508758_P_NODE_36308_length_342_cov_1.498141_g35260_i0 PRJNA508758 36308 342 1.498141 5.12364222 Hirudo verbana 311461 Annelida Annelida 52.8 0.032   NTclustered gi|2918369706|emb|OZ237788.1| 311461 g35260 i0 100 0.0818713450292398 28 0 8 0 230 257 1192226 1192199 Hirudo verbana genome assembly, chromosome: 10 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
24710407 24710407 PRJNA508758_P_NODE_21700_length_431_cov_1.754190_g20653_i0 PRJNA508758 21700 431 1.75419 7.5605589 Helobdella robusta 6412 Annelida Annelida 62.1 6.91e-5   NTclustered gi|675876331|ref|XM_009025478.1| 6412 g20653 i0 94.872 0.846867749419954 39 2 10 0 323 361 870 908 Helobdella robusta hypothetical protein partial mRNA blastn 365 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta

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