RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA564810 · 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
3105040 3105040 PRJNA564810_S_NODE_3923_length_275_cov_1.804762_g3901_i0 PRJNA564810 3923 275 1.804762 4.9630955 Ailoscolex lacteospumosus 1046305 Annelida Annelida 62.1 4.2e-5   NTclustered gi|2920003608|emb|OZ238872.1| 1046305 g3901 i0 90 3.84727272727273 50 2 17 3 42 89 11383496 11383448 Ailoscolex lacteospumosus genome assembly, chromosome: 13 blastn 1058 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
4381647 4381647 PRJNA564810_S_NODE_6204_length_234_cov_1.798817_g6182_i0 PRJNA564810 6204 234 1.798817 4.20923178 Hirudo verbana 311461 Annelida Annelida 58.4 4.5e-4   NTclustered gi|2918369620|emb|OZ237782.1| 311461 g6182 i0 97.059 0.700854700854701 34 1 15 0 123 156 14213685 14213718 Hirudo verbana genome assembly, chromosome: 4 blastn 164 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
8207117 8207117 PRJNA564810_S_NODE_2887_length_302_cov_1.721519_g2865_i0 PRJNA564810 2887 302 1.721519 5.19898738 Ailoscolex lacteospumosus 1046305 Annelida Annelida 56.5 0.002   NTclustered gi|2920003456|emb|OZ238864.1| 1046305 g2865 i0 100 0.19205298013245 30 0 10 0 256 285 25936575 25936546 Ailoscolex lacteospumosus genome assembly, chromosome: 5 blastn 58 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
20956272 20956272 PRJNA564810_S_NODE_3197_length_293_cov_0.894737_g3175_i0 PRJNA564810 3197 293 0.894737 2.62157941 Hirudo verbana 311461 Annelida Annelida 52.8 0.027   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g3175 i0 100 0.764505119453925 28 0 10 0 99 126 714367 714394 Hirudo verbana genome assembly, chromosome: 1 blastn 224 52.8 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);;