RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1000943 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1419903 1419903 PRJNA1000943_P_NODE_6702_length_314_cov_1.456432_g6564_i0 PRJNA1000943 6702 314 1.456432 4.57319648 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.008   NTclustered gi|2920003636|emb|OZ238874.1| 1046305 g6564 i0 100 0.0923566878980892 29 0 9 0 84 112 18635826 18635798 Ailoscolex lacteospumosus genome assembly, chromosome: 15 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
3971374 3971374 PRJNA1000943_P_NODE_11824_length_251_cov_0.876404_g11686_i0 PRJNA1000943 11824 251 0.876404 2.19977404 Ailoscolex lacteospumosus 1046305 Annelida Annelida 60.2 1.36e-4   NTclustered gi|2920003484|emb|OZ238865.1| 1046305 g11686 i0 97.222 0.143426294820717 36 0 14 1 97 131 4215131 4215166 Ailoscolex lacteospumosus genome assembly, chromosome: 6 blastn 36 60.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
7797694 7797694 PRJNA1000943_P_NODE_7467_length_301_cov_1.105263_g7329_i0 PRJNA1000943 7467 301 1.105263 3.32684163 Hirudo verbana 311461 Annelida Annelida 60.2 1.67e-4   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g7329 i0 90.909 1.77740863787375 44 4 15 0 61 104 2512574 2512617 Hirudo verbana genome assembly, chromosome: 13 blastn 535 60.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
15027100 15027100 PRJNA1000943_P_NODE_3692_length_405_cov_5.746988_g3555_i0 PRJNA1000943 3692 405 5.746988 23.2753014 Metazoa 33208 Annelida Annelida 279 1.64e-70   NTclustered gi|675872871|ref|XM_009023748.1| 6412 g3555 i0 81.928 40.0691358024691 332 58 82 2 4 334 97 427 Helobdella robusta hypothetical protein partial mRNA blastn 16228 279 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
20125772 20125772 PRJNA1000943_P_NODE_14576_length_244_cov_0.912281_g14438_i0 PRJNA1000943 14576 244 0.912281 2.22596564 Metazoa 33208 Annelida Annelida 52.8 0.022   NTclustered gi|2918369702|emb|OZ237787.1| 311461 g14438 i0 100 0.459016393442623 28 0 11 0 159 186 10844166 10844193 Hirudo verbana genome assembly, chromosome: 9 blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
24370978 24370978 PRJNA1000943_P_NODE_12540_length_249_cov_0.886364_g12402_i0 PRJNA1000943 12540 249 0.886364 2.20704636 Hirudo verbana 311461 Annelida Annelida 63.9 1.04e-5   NTclustered gi|2918369706|emb|OZ237788.1| 311461 g12402 i0 97.297 2.55020080321285 37 1 15 0 193 229 10039708 10039744 Hirudo verbana genome assembly, chromosome: 10 blastn 635 63.9 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);;