RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1129273" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1129273 · 6 ✖

analysis 1

  • diamond · 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
16860469 16860469 PRJNA1129273_P_NODE_8414_length_253_cov_1.277778_g8134_i0 PRJNA1129273 8414 253 1.277778 3.23277834 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 95.9 1.17e-21   NR CAF0890961.1 249248 g8134 i0 56.5 10.0909090909091 85 36 99.6 1 1 252 158 242 CAF0890961.1 unnamed protein product [Adineta ricciae] diamond 2553 95.9 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
27828457 27828457 PRJNA1129273_P_NODE_3444_length_395_cov_2.776398_g3164_i0 PRJNA1129273 3444 395 2.776398 10.9667721 Adineta steineri 433720 Rotifera other_Eukaryota 43.5 0.0436   NR CAF1540500.1 433720 g3164 i0 46.2 0.29620253164557 39 21 29.6 0 252 136 95 133 CAF1540500.1 unnamed protein product [Adineta steineri] diamond 117 43.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta steineri
27859873 27859873 PRJNA1129273_P_NODE_9445_length_247_cov_0.896552_g9165_i0 PRJNA1129273 9445 247 0.896552 2.21448344 Adineta vaga 104782 Rotifera other_Eukaryota 42.7 0.0216   NR UJR28176.1 104782 g9165 i0 41.3 1.12955465587045 46 27 55.9 0 2 139 70 115 UJR28176.1 hypothetical protein I4U23_009429 [Adineta vaga] diamond 279 42.7 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
28207134 28207134 PRJNA1129273_P_NODE_506_length_1246_cov_7.598465_g354_i0 PRJNA1129273 506 1246 7.598465 94.6768739 Rotaria sordida 392033 Rotifera other_Eukaryota 73.2 3.38e-10   NR CAF0983950.1 392033 g354 i0 25.8 0.953451043338684 198 139 47.7 3 625 32 143 332 CAF0983950.1 unnamed protein product [Rotaria sordida] diamond 1188 73.2 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sordida
28428429 28428429 PRJNA1129273_P_NODE_10986_length_231_cov_4.398734_g10706_i0 PRJNA1129273 10986 231 4.398734 10.16107554 Adineta ricciae 249248 Rotifera other_Eukaryota 64.3 1.01e-10   NR CAF0745393.1 249248 g10706 i0 40.8 2.57142857142857 71 42 92.2 0 9 221 17 87 CAF0745393.1 unnamed protein product [Adineta ricciae] diamond 594 64.3 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
30007318 30007318 PRJNA1129273_P_NODE_9891_length_245_cov_0.901163_g9611_i0 PRJNA1129273 9891 245 0.901163 2.20784935 Rotaria sp. Silwood1 2762511 Rotifera other_Eukaryota 54.3 3.12e-6   NR CAF3851092.1 2762511 g9611 i0 41.7 1.51836734693878 60 35 73.5 0 66 245 334 393 CAF3851092.1 unnamed protein product [Rotaria sp. Silwood1] diamond 372 54.3 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sp. Silwood1

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