RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1123309 · 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
4105551 4105551 PRJNA1123309_P_NODE_51564_length_250_cov_3.412429_g51184_i0 PRJNA1123309 51564 250 3.412429 8.5310725 Helobdella robusta 6412 Annelida Annelida 56.5 0.002   NTclustered gi|675849589|ref|XM_009012107.1| 6412 g51184 i0 100 0.12 30 0 12 0 179 208 28 57 Helobdella robusta hypothetical protein partial mRNA blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
13782251 13782251 PRJNA1123309_P_NODE_27271_length_310_cov_1.308017_g26891_i0 PRJNA1123309 27271 310 1.308017 4.0548527 root 1 Root_unresolved Root_unresolved 54.7 0.008   NTclustered gi|2920003623|emb|OZ238873.1| 1046305 g26891 i0 100 0.27741935483871 29 0 9 0 25 53 17185339 17185311 Ailoscolex lacteospumosus genome assembly, chromosome: 14 blastn 86 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
16855767 16855767 PRJNA1123309_P_NODE_5854_length_607_cov_1.586142_g5502_i0 PRJNA1123309 5854 607 1.586142 9.62788194 Hirudo verbana 311461 Annelida Annelida 56.5 0.005   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g5502 i0 100 0.0494233937397035 30 0 5 0 327 356 457494 457465 Hirudo verbana genome assembly, chromosome: 13 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
23230669 23230669 PRJNA1123309_P_NODE_40479_length_269_cov_1.852041_g40099_i0 PRJNA1123309 40479 269 1.852041 4.98199029 Hirudo verbana 311461 Annelida Annelida 58.4 5.3e-4   NTclustered gi|2918369720|emb|OZ237792.1| 311461 g40099 i0 94.595 1.57992565055762 37 2 14 0 5 41 7753599 7753563 Hirudo verbana genome assembly, chromosome: 14 blastn 425 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);;