RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA683902 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
12654796 12654796 PRJNA683902_S_NODE_22990_length_215_cov_1.898876_g22546_i0 PRJNA683902 22990 215 1.898876 4.0825834 root 1 Root_unresolved Root_unresolved 107 8.970000000000001e-27   NR XP_046909420.1 6954 g22546 i0 70.4 26.7488372093023 71 21 99.1 0 213 1 116 186 XP_046909420.1 40S ribosomal protein S2-like [Dermatophagoides farinae] diamond 5751 108 0.990740740740741 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
15967910 15967910 PRJNA683902_S_NODE_15713_length_294_cov_1.431907_g15269_i0 PRJNA683902 15713 294 1.431907 4.20980658 root 1 Root_unresolved Root_unresolved 168 6.54e-46   NR CAG4636794.1 302197 g15269 i0 88.8 3 98 11 100 0 1 294 654 751 CAG4636794.1 EOG090X01G2 [Ceriodaphnia reticulata] diamond 882 168 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Ceriodaphnia Ceriodaphnia reticulata
22342550 22342550 PRJNA683902_S_NODE_22798_length_216_cov_2.597765_g22354_i0 PRJNA683902 22798 216 2.597765 5.6111724 Prorops nasuta 863751 Arthropoda Arthropoda 80.1 3.74e-17   NR XP_066596327.1 863751 g22354 i0 54.8 3.04166666666667 73 31 98.6 1 2 214 41 113 XP_066596327.1 large ribosomal subunit protein eL22-like [Prorops nasuta] diamond 657 80.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Bethylidae Prorops Prorops nasuta
24127204 24127204 PRJNA683902_S_NODE_16999_length_273_cov_6.546610_g16555_i0 PRJNA683902 16999 273 6.54661 17.8722453 Artemia franciscana 6661 Arthropoda Arthropoda 193 4.43e-62   NR KAK2708227.1 6661 g16555 i0 97.8 2.96703296703297 90 2 98.9 0 3 272 4 93 KAK2708227.1 hypothetical protein QYM36_013979 [Artemia franciscana] diamond 810 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
26650439 26650439 PRJNA683902_S_NODE_29721_length_179_cov_3.239437_g29277_i0 PRJNA683902 29721 179 3.239437 5.79859223 root 1 Root_unresolved Root_unresolved 114 9.79e-28   NR CAG4636794.1 302197 g29277 i0 93.2 4.89385474860335 59 4 98.9 0 178 2 1009 1067 CAG4636794.1 EOG090X01G2 [Ceriodaphnia reticulata] diamond 876 115 0.991304347826087 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Ceriodaphnia Ceriodaphnia reticulata
27587804 27587804 PRJNA683902_S_NODE_24244_length_207_cov_2.752941_g23800_i0 PRJNA683902 24244 207 2.752941 5.69858787 Ceriodaphnia reticulata 302197 Arthropoda Arthropoda 135 3.97e-35   NR CAG4636794.1 302197 g23800 i0 94.1 1.97101449275362 68 4 98.6 0 206 3 189 256 CAG4636794.1 EOG090X01G2 [Ceriodaphnia reticulata] diamond 408 135 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Ceriodaphnia Ceriodaphnia reticulata
29619619 29619619 PRJNA683902_S_NODE_28830_length_183_cov_2.246575_g28386_i0 PRJNA683902 28830 183 2.246575 4.11123225 root 1 Root_unresolved Root_unresolved 43.5 0.00837   NR XP_014238573.1 7493 g28386 i0 58.6 4.11475409836066 29 12 47.5 0 5 91 231 259 XP_014238573.1 40S ribosomal protein S4 [Trichogramma pretiosum] diamond 753 43.9 0.990888382687927 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
29651196 29651196 PRJNA683902_S_NODE_34690_length_163_cov_1.238095_g34246_i0 PRJNA683902 34690 163 1.238095 2.01809485 Pyroglyphidae 6952 Arthropoda Arthropoda 91.7 7.94e-21   NR XP_046914540.1 6954 g34246 i0 78.8 34.4539877300613 52 11 95.7 0 6 161 1 52 XP_046914540.1 40S ribosomal protein S4-like [Dermatophagoides farinae] diamond 5616 91.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
30524501 30524501 PRJNA683902_S_NODE_38733_length_153_cov_1.008621_g38289_i0 PRJNA683902 38733 153 1.008621 1.54319013 Idotea baltica 82763 Arthropoda Arthropoda 70.5 1.56e-12   NR MCL4123734.1 82763 g38289 i0 70.6 3.94117647058824 51 14 98 1 152 3 153 203 MCL4123734.1 hypothetical protein [Idotea baltica] diamond 603 70.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
30619228 30619228 PRJNA683902_S_NODE_29873_length_179_cov_1.373239_g29429_i0 PRJNA683902 29873 179 1.373239 2.45809781 Idotea baltica 82763 Arthropoda Arthropoda 101 7.16e-25   NR MCL4121308.1 82763 g29429 i0 69.5 2.96648044692737 59 18 98.9 0 1 177 19 77 MCL4121308.1 hypothetical protein [Idotea baltica] diamond 531 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31136127 31136127 PRJNA683902_S_NODE_33675_length_166_cov_1.209302_g33231_i0 PRJNA683902 33675 166 1.209302 2.00744132 Opisthokonta 33154 Arthropoda Arthropoda 44.3 0.00382   NR XP_022664933.1 109461 g33231 i0 38.8 1.75301204819277 49 30 88.6 0 17 163 321 369 XP_022664933.1 protein disulfide-isomerase A3-like [Varroa destructor] diamond 291 44.7 0.991051454138702 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Varroidae Varroa Varroa destructor
31282807 31282807 PRJNA683902_S_NODE_27975_length_187_cov_1.880000_g27531_i0 PRJNA683902 27975 187 1.88 3.5156 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 70.1 6.86e-13   NR ADD38186.1 72036 g27531 i0 50 0.93048128342246 58 29 93 0 187 14 79 136 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 174 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis

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