RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA724039 · 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
9639655 9639655 PRJNA724039_S_NODE_228_length_2304_cov_6.770181_g189_i0 PRJNA724039 228 2304 6.770181 155.98497024 Timema californicum 61474 Arthropoda Arthropoda 868 8.58e-305   NR CAD7567708.1 61474 g189 i0 60.2 1.88151041666667 724 259 93.2 7 157 2304 1 703 CAD7567708.1 unnamed protein product, partial [Timema californicum] diamond 4335 868 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
16013768 16013768 PRJNA724039_S_NODE_6473_length_267_cov_5.834783_g6266_i0 PRJNA724039 6473 267 5.834783 15.57887061 root 1 Root_unresolved Root_unresolved 152 1.4599999999999996e-40   NR CAG4636794.1 302197 g6266 i0 90.9 2.9438202247191 88 8 98.9 0 3 266 658 745 CAG4636794.1 EOG090X01G2 [Ceriodaphnia reticulata] diamond 786 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Ceriodaphnia Ceriodaphnia reticulata
27536595 27536595 PRJNA724039_S_NODE_11363_length_191_cov_2.305195_g11156_i0 PRJNA724039 11363 191 2.305195 4.40292245 root 1 Root_unresolved Root_unresolved 116 2.46e-28   NR CAG4636794.1 302197 g11156 i0 93.7 5.93717277486911 63 4 99 0 2 190 927 989 CAG4636794.1 EOG090X01G2 [Ceriodaphnia reticulata] diamond 1134 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Ceriodaphnia Ceriodaphnia reticulata
27621031 27621031 PRJNA724039_S_NODE_16184_length_158_cov_2.876033_g15977_i0 PRJNA724039 16184 158 2.876033 4.54413214 Tetranychus truncatus 93132 Arthropoda Arthropoda 42.7 0.00393   NR AYV89077.1 93132 g15977 i0 55.9 0.645569620253165 34 15 64.6 0 156 55 78 111 AYV89077.1 ribosomal protein S25, partial [Tetranychus truncatus] diamond 102 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus truncatus
28230911 28230911 PRJNA724039_S_NODE_17326_length_153_cov_2.810345_g17119_i0 PRJNA724039 17326 153 2.810345 4.29982785 Arthropoda 6656 Arthropoda Arthropoda 89 4.07e-20   NR QWX93892.1 707891 g17119 i0 75.5 59.3137254901961 49 12 96.1 0 148 2 168 216 QWX93892.1 cytochrome oxidase subunit II, partial [Lepidocyrtus violaceus] diamond 9075 89.7 0.992196209587514 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Entomobryidae Lepidocyrtus Lepidocyrtus violaceus
28568064 28568064 PRJNA724039_S_NODE_9747_length_209_cov_1.511628_g9540_i0 PRJNA724039 9747 209 1.511628 3.15930252 Artemia franciscana 6661 Arthropoda Arthropoda 95.9 1.8199999999999994e-23   NR XP_065571790.1 6661 g9540 i0 69.5 0.84688995215311 59 18 84.7 0 209 33 72 130 XP_065571790.1 small ribosomal subunit protein eS12-like [Artemia franciscana] diamond 177 95.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28799275 28799275 PRJNA724039_S_NODE_10147_length_204_cov_2.041916_g9940_i0 PRJNA724039 10147 204 2.041916 4.16550864 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 90.9 2.97e-22   NR XHB13796.1 34648 g9940 i0 74.2 6.29411764705882 62 14 88.2 1 202 23 9 70 XHB13796.1 putative venom peptide 511 [Mesobuthus eupeus] diamond 1284 91.7 0.991275899672846 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Mesobuthus Mesobuthus eupeus
29641309 29641309 PRJNA724039_S_NODE_15070_length_164_cov_3.157480_g14863_i0 PRJNA724039 15070 164 3.15748 5.1782672 Nicrophorus vespilloides 110193 Arthropoda Arthropoda 46.2 7.66e-4   NR XP_017786420.1 110193 g14863 i0 46.8 0.859756097560976 47 23 86 1 159 19 58 102 XP_017786420.1 PREDICTED: E3 ubiquitin-protein ligase Su(dx) [Nicrophorus vespilloides] diamond 141 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Silphidae Nicrophorus Nicrophorus vespilloides
30188866 30188866 PRJNA724039_S_NODE_16272_length_158_cov_1.388430_g16065_i0 PRJNA724039 16272 158 1.38843 2.1937194 Lampyridae 7049 Arthropoda Arthropoda 53.5 7.42e-7   NR XP_031333277.1 7054 g16065 i0 52.1 8.73417721518987 48 23 91.1 0 146 3 40 87 XP_031333277.1 60S ribosomal protein L18a [Photinus pyralis] diamond 1380 53.9 0.992578849721707 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis
30400240 30400240 PRJNA724039_S_NODE_17233_length_154_cov_0.991453_g17026_i0 PRJNA724039 17233 154 0.991453 1.52683762 Notodromas monacha 399045 Arthropoda Arthropoda 75.5 9.84e-15   NR CAD7277138.1 399045 g17026 i0 76.7 7.46103896103896 43 10 83.8 0 149 21 174 216 CAD7277138.1 unnamed protein product [Notodromas monacha] diamond 1149 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
31917165 31917165 PRJNA724039_S_NODE_9457_length_212_cov_2.291429_g9250_i0 PRJNA724039 9457 212 2.291429 4.85782948 Halotydeus destructor 2874060 Arthropoda Arthropoda 48.5 2.29e-4   NR KAI1292274.1 2874060 g9250 i0 51.1 0.665094339622642 47 23 66.5 0 158 18 895 941 KAI1292274.1 Next to BRCA1 protein [Halotydeus destructor] diamond 141 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
32328819 32328819 PRJNA724039_S_NODE_13839_length_172_cov_1.496296_g13632_i0 PRJNA724039 13839 172 1.496296 2.57362912 Triatoma brasiliensis 65344 Arthropoda Arthropoda 63.9 2.54e-11   NR ABJ96355.1 65344 g13632 i0 60 0.959302325581395 55 22 95.9 0 167 3 25 79 ABJ96355.1 60S acidic ribosomal protein P2 [Triatoma brasiliensis] diamond 165 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Reduviidae Triatoma Triatoma brasiliensis

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