RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA551951" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA551951 · 7 ✖

analysis 1

  • diamond · 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
27867778 27867778 PRJNA551951_S_NODE_10305_length_231_cov_2.005102_g10187_i0 PRJNA551951 10305 231 2.005102 4.63178562 Rotaria sp. Silwood1 2762511 Rotifera other_Eukaryota 119 2.11e-32   NR CAF5151067.1 2762511 g10187 i0 82.6 2.68831168831169 69 12 89.6 0 231 25 67 135 CAF5151067.1 unnamed protein product, partial [Rotaria sp. Silwood1] diamond 621 119 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria sp. Silwood1
28183412 28183412 PRJNA551951_S_NODE_13726_length_183_cov_1.317568_g13608_i0 PRJNA551951 13726 183 1.317568 2.41114944 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 45.8 8.18e-4   NR PAA59187.1 282301 g13608 i0 85.7 0.688524590163934 21 3 34.4 0 183 121 133 153 PAA59187.1 hypothetical protein BOX15_Mlig001782g2, partial [Macrostomum lignano] diamond 126 45.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
30299837 30299837 PRJNA551951_S_NODE_4072_length_449_cov_40.342995_g3957_i0 PRJNA551951 4072 449 40.342995 181.14004755 Acanthosepion pharaonis 158019 Mollusca Mollusca 45.1 0.0369   NR CAE1295632.1 158019 g3957 i0 42.6 0.674832962138085 101 50 65.5 4 3 296 16 111 CAE1295632.1 unnamed protein product [Acanthosepion pharaonis] diamond 303 45.1 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Sepiida Sepiidae Acanthosepion Acanthosepion pharaonis
31089273 31089273 PRJNA551951_S_NODE_3955_length_458_cov_3.661939_g3840_i0 PRJNA551951 3955 458 3.661939 16.77168062 Necator americanus 51031 Nematoda Nematoda 219 1.25e-64   NR ETN79898.1 51031 g3840 i0 73.7 0.995633187772926 152 40 99.6 0 456 1 244 395 ETN79898.1 hypothetical protein NECAME_18058, partial [Necator americanus] diamond 456 219 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Ancylostomatidae Necator Necator americanus
32101349 32101349 PRJNA551951_S_NODE_3798_length_469_cov_32.502304_g3684_i0 PRJNA551951 3798 469 32.502304 152.43580576 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 94.7 6.14e-22   NR XP_015922803.1 114398 g3684 i0 45.9 0.71002132196162 111 53 70.4 4 404 75 1 105 XP_015922803.1 uncharacterized protein [Parasteatoda tepidariorum] diamond 333 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
32354774 32354774 PRJNA551951_S_NODE_13759_length_182_cov_2.585034_g13641_i0 PRJNA551951 13759 182 2.585034 4.70476188 Scyliorhinus canicula 7830 Chordata Chordata 42.7 0.0125   NR XP_038659988.1 7830 g13641 i0 50 0.758241758241758 46 22 74.2 1 9 143 82 127 XP_038659988.1 glutaredoxin-like protein C5orf63 homolog isoform X2 [Scyliorhinus canicula] diamond 138 42.7 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Carcharhiniformes Scyliorhinidae Scyliorhinus Scyliorhinus canicula
32670303 32670303 PRJNA551951_S_NODE_7880_length_285_cov_10.668000_g7762_i0 PRJNA551951 7880 285 10.668 30.4038 Rotaria magnacalcarata 392030 Rotifera other_Eukaryota 70.9 7.03e-13   NR CAF4675100.1 392030 g7762 i0 88.6 1.47368421052632 35 4 36.8 0 260 156 133 167 CAF4675100.1 unnamed protein product, partial [Rotaria magnacalcarata] diamond 420 70.9 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Rotaria Rotaria magnacalcarata

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