RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJEB2333" 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

  • PRJEB2333 · 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
24248691 24248691 PRJEB2333_P_NODE_2200_length_778_cov_2.327935_g1457_i0 PRJEB2333 2200 778 2.327935 18.1113343 Metazoa 33208 Bryozoa other_Eukaryota 374 3.13e-126   NR KAF6037269.1 10212 g1457 i0 72.1 28.0681233933162 262 70 99.9 2 1 777 142 403 KAF6037269.1 SLC25A31 [Bugula neritina] diamond 21837 376 0.99468085106383 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
28858301 28858301 PRJEB2333_P_NODE_2668_length_516_cov_1.396660_g1898_i0 PRJEB2333 2668 516 1.39666 7.2067656 Opisthokonta 33154 Arthropoda Arthropoda 69.3 9.03e-12   NR XP_037084519.1 41117 g1898 i0 36.2 3.01162790697674 127 67 73.3 2 496 119 1 114 XP_037084519.1 60S ribosomal protein L34-like [Pollicipes pollicipes] diamond 1554 69.7 0.994261119081779 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
29016599 29016599 PRJEB2333_P_NODE_2928_length_457_cov_1.321429_g2156_i0 PRJEB2333 2928 457 1.321429 6.03893053 Arachnida 6854 Arthropoda Arthropoda 212 2.54e-66   NR KAF7495963.1 52283 g2156 i0 66.9 25.9299781181619 151 50 99.1 0 5 457 84 234 KAF7495963.1 40S ribosomal protein S2 [Sarcoptes scabiei] diamond 11850 213 0.995305164319249 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei
30343219 30343219 PRJEB2333_P_NODE_3512_length_273_cov_1.567797_g2735_i0 PRJEB2333 3512 273 1.567797 4.28008581 Opisthokonta 33154 Arthropoda Arthropoda 106 1.42e-26   NR XP_013790258.1 6850 g2735 i0 62.7 18.6043956043956 83 31 91.2 0 3 251 75 157 XP_013790258.1 60S ribosomal protein L17-like [Limulus polyphemus] diamond 5079 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
30854607 30854607 PRJEB2333_P_NODE_4174_length_176_cov_1.122302_g3397_i0 PRJEB2333 4174 176 1.122302 1.97525152 Adineta steineri 433720 Rotifera other_Eukaryota 90.5 2.2e-19   NR CAF0763090.1 433720 g3397 i0 78.9 11.6590909090909 57 12 97.2 0 175 5 242 298 CAF0763090.1 unnamed protein product [Adineta steineri] diamond 2052 90.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta steineri
31834624 31834624 PRJEB2333_P_NODE_4397_length_165_cov_2.437500_g3620_i0 PRJEB2333 4397 165 2.4375 4.021875 Cichlidogyrus casuarinus 1844966 Platyhelminthes Platyhelminthes 51.6 2.98e-6   NR KAL3311567.1 1844966 g3620 i0 60.5 0.781818181818182 43 17 78.2 0 160 32 108 150 KAL3311567.1 60S ribosomal protein L35 [Cichlidogyrus casuarinus] diamond 129 51.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Dactylogyridea Ancyrocephalidae Cichlidogyrus Cichlidogyrus casuarinus
32049784 32049784 PRJEB2333_P_NODE_2638_length_527_cov_1.008163_g1868_i0 PRJEB2333 2638 527 1.008163 5.31301901 Insecta 50557 Arthropoda Arthropoda 68.2 3.12e-10   NR XP_044753161.1 41139 g1868 i0 53.8 1.65085388994307 65 29 37 1 37 231 158 221 XP_044753161.1 60S ribosomal protein L10 [Coccinella septempunctata] diamond 870 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata

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