RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB73599 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
3546068 3546068 PRJEB73599_P_NODE_2543_length_462_cov_2.789838_g2271_i0 PRJEB73599 2543 462 2.789838 12.88905156 Metazoa 33208 Arthropoda Arthropoda 108 1.13e-26   NR XP_055694015.1 7200 g2271 i0 74.2 3.06493506493507 66 17 42.9 0 430 233 5 70 XP_055694015.1 60S ribosomal protein L27a-like [Lutzomyia longipalpis] diamond 1416 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
27413636 27413636 PRJEB73599_P_NODE_8743_length_176_cov_1.469388_g8456_i0 PRJEB73599 8743 176 1.469388 2.58612288 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 65.5 1.46e-11   NR CAL4060158.1 48144 g8456 i0 61.4 0.971590909090909 57 22 97.2 0 173 3 60 116 CAL4060158.1 unnamed protein product [Meganyctiphanes norvegica] diamond 171 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
28265692 28265692 PRJEB73599_P_NODE_7366_length_207_cov_6.359551_g7079_i0 PRJEB73599 7366 207 6.359551 13.16427057 Idotea baltica 82763 Arthropoda Arthropoda 49.3 5.81e-6   NR MCL4129530.1 82763 g7079 i0 65 0.579710144927536 40 10 52.2 1 109 2 9 48 MCL4129530.1 hypothetical protein [Idotea baltica] diamond 120 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32049998 32049998 PRJEB73599_P_NODE_8718_length_176_cov_2.312925_g8431_i0 PRJEB73599 8718 176 2.312925 4.070748 Chironomus 7150 Arthropoda Arthropoda 67.4 3.05e-11   NR XP_070493817.1 113505 g8431 i0 59.3 6.61363636363636 54 22 92 0 1 162 139 192 XP_070493817.1 fatty acid synthase-like [Chironomus tepperi] diamond 1164 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi

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