RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1248424" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1248424 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
6730136 6730136 PRJNA1248424_P_NODE_29306_length_528_cov_1.292308_g23275_i0 PRJNA1248424 29306 528 1.292308 6.82338624 Hirudo verbana 311461 Annelida Annelida 58.4 0.001   NTclustered gi|2918369643|emb|OZ237784.1| 311461 g23275 i0 94.595 0.125 37 2 7 0 178 214 10598735 10598771 Hirudo verbana genome assembly, chromosome: 6 blastn 66 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
6730485 6730485 PRJNA1248424_P_NODE_45286_length_335_cov_1.187023_g39222_i0 PRJNA1248424 45286 335 1.187023 3.97652705 Hirudo verbana 311461 Annelida Annelida 52.8 0.032   NTclustered gi|2918369702|emb|OZ237787.1| 311461 g39222 i0 92.308 0.116417910447761 39 0 11 2 65 102 7036270 7036234 Hirudo verbana genome assembly, chromosome: 9 blastn 39 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
16929870 16929870 PRJNA1248424_P_NODE_41514_length_361_cov_1.326389_g35452_i0 PRJNA1248424 41514 361 1.326389 4.78826429 Hirudo verbana 311461 Annelida Annelida 62.1 5.69e-5   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g35452 i0 100 5.23268698060942 33 0 9 0 261 293 1426663 1426631 Hirudo verbana genome assembly, chromosome: 3 blastn 1889 62.1 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
16930015 16930015 PRJNA1248424_P_NODE_49494_length_312_cov_1.874477_g43426_i0 PRJNA1248424 49494 312 1.874477 5.84836824 Hirudo verbana 311461 Annelida Annelida 54.7 0.008   NTclustered gi|2918369702|emb|OZ237787.1| 311461 g43426 i0 100 0.362179487179487 29 0 9 0 177 205 9718187 9718159 Hirudo verbana genome assembly, chromosome: 9 blastn 113 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
20753863 20753863 PRJNA1248424_P_NODE_27457_length_575_cov_1.171315_g21459_i0 PRJNA1248424 27457 575 1.171315 6.73506125 Ailoscolex lacteospumosus 1046305 Annelida Annelida 60.2 3.39e-4   NTclustered gi|2920003257|emb|OZ238860.1| 1046305 g21459 i0 93.023 1.1304347826087 43 0 8 2 95 137 18517691 18517730 Ailoscolex lacteospumosus genome assembly, chromosome: 1 blastn 650 60.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
23304935 23304935 PRJNA1248424_P_NODE_40359_length_370_cov_1.861953_g34298_i0 PRJNA1248424 40359 370 1.861953 6.8892261 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.01   NTclustered gi|2920003371|emb|OZ238862.1| 1046305 g34298 i0 96.875 0.0864864864864865 32 1 9 0 135 166 34030472 34030503 Ailoscolex lacteospumosus genome assembly, chromosome: 3 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
23305556 23305556 PRJNA1248424_P_NODE_71299_length_249_cov_0.875000_g65230_i0 PRJNA1248424 71299 249 0.875 2.17875 Ailoscolex lacteospumosus 1046305 Annelida Annelida 58.4 4.84e-4   NTclustered gi|2920003257|emb|OZ238860.1| 1046305 g65230 i0 97.059 0.253012048192771 34 1 14 0 193 226 35867349 35867316 Ailoscolex lacteospumosus genome assembly, chromosome: 1 blastn 63 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus

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