RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB3181 · 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
1330324 1330324 PRJEB3181_S_NODE_10602_length_196_cov_2.018634_g10309_i0 PRJEB3181 10602 196 2.018634 3.95652264 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.005   NTclustered gi|2920003545|emb|OZ238868.1| 1046305 g10309 i0 96.875 0.163265306122449 32 1 16 0 58 89 534659 534690 Ailoscolex lacteospumosus genome assembly, chromosome: 9 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
8983037 8983037 PRJEB3181_P_NODE_17428_length_199_cov_2.059524_g17164_i0 PRJEB3181 17428 199 2.059524 4.09845276 Ailoscolex lacteospumosus 1046305 Annelida Annelida 102 1.69e-17   NTclustered gi|2920003257|emb|OZ238860.1| 1046305 g17164 i0 87.5 2.22613065326633 88 11 44 0 105 192 43170591 43170678 Ailoscolex lacteospumosus genome assembly, chromosome: 1 blastn 443 102 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
10258706 10258706 PRJEB3181_P_NODE_24509_length_163_cov_1.469697_g24244_i0 PRJEB3181 24509 163 1.469697 2.39560611 Hirudo verbana 311461 Annelida Annelida 54.7 0.004   NTclustered gi|2918369614|emb|OZ237780.1| 311461 g24244 i0 96.97 0.202453987730061 33 0 20 1 42 73 273679 273647 Hirudo verbana genome assembly, chromosome: 2 blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
12809695 12809695 PRJEB3181_S_NODE_6971_length_236_cov_2.985075_g6678_i0 PRJEB3181 6971 236 2.985075 7.044777 Platynereis dumerilii 6359 Annelida Annelida 106 1.6e-18   NTclustered gi|83307676|emb|CT033650.1| 6359 g6678 i0 80 33.1949152542373 145 27 61 2 83 226 778 635 Platynereis dumerilii EST IB0AAA16CH07EM1 blastn 7834 106 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Phyllodocida Nereididae Platynereis Platynereis dumerilii

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