RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA287283" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA287283 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
15674928 15674928 PRJNA287283_P_NODE_9953_length_177_cov_0.903226_g9729_i0 PRJNA287283 9953 177 0.903226 1.59871002 Artemia franciscana 6661 Arthropoda Arthropoda 117 9.45e-33   NR KAK2720046.1 6661 g9729 i0 98.3 1.96610169491525 58 1 98.3 0 176 3 22 79 KAK2720046.1 hypothetical protein QYM36_004080 [Artemia franciscana] diamond 348 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27358795 27358795 PRJNA287283_P_NODE_4703_length_283_cov_1.195652_g4479_i0 PRJNA287283 4703 283 1.195652 3.38369516 Limulus polyphemus 6850 Arthropoda Arthropoda 85.1 7.89e-17   NR XP_022240776.1 6850 g4479 i0 54.1 4.40989399293286 61 28 64.7 0 261 79 131 191 XP_022240776.1 papilin-like, partial [Limulus polyphemus] diamond 1248 85.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
27800827 27800827 PRJNA287283_P_NODE_9144_length_180_cov_0.881890_g8920_i0 PRJNA287283 9144 180 0.88189 1.587402 Artemia franciscana 6661 Arthropoda Arthropoda 115 5.26e-28   NR KAK2715200.1 6661 g8920 i0 94.9 1.96666666666667 59 3 98.3 0 3 179 509 567 KAK2715200.1 hypothetical protein QYM36_010000, partial [Artemia franciscana] diamond 354 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27863735 27863735 PRJNA287283_P_NODE_6325_length_227_cov_1.287356_g6101_i0 PRJNA287283 6325 227 1.287356 2.9222981200000002 Artemia franciscana 6661 Arthropoda Arthropoda 100 6.259999999999999e-23   NR CAG4635437.1 6661 g6101 i0 82.1 0.885462555066079 67 12 88.5 0 202 2 18 84 CAG4635437.1 EOG090X05EE [Artemia franciscana] diamond 201 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27895303 27895303 PRJNA287283_P_NODE_9225_length_180_cov_0.881890_g9001_i0 PRJNA287283 9225 180 0.88189 1.587402 Artemia franciscana 6661 Arthropoda Arthropoda 72 7.48e-13   NR KAK2715654.1 6661 g9001 i0 78.7 0.783333333333333 47 10 78.3 0 40 180 232 278 KAK2715654.1 hypothetical protein QYM36_010283 [Artemia franciscana] diamond 141 72 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28116334 28116334 PRJNA287283_P_NODE_9165_length_180_cov_0.881890_g8941_i0 PRJNA287283 9165 180 0.88189 1.587402 Portunus trituberculatus 210409 Arthropoda Arthropoda 41.2 0.0107   NR MPC86861.1 210409 g8941 i0 85.7 0.35 21 3 35 0 101 39 32 52 MPC86861.1 hypothetical protein [Portunus trituberculatus] diamond 63 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
28639461 28639461 PRJNA287283_P_NODE_7047_length_208_cov_1.083871_g6823_i0 PRJNA287283 7047 208 1.083871 2.25445168 Opisthokonta 33154 Arthropoda Arthropoda 46.6 0.00105   NR XP_043276914.1 32260 g6823 i0 41.3 5.65384615384615 63 35 88 1 25 207 185 247 XP_043276914.1 far upstream element-binding protein 3 isoform X3 [Venturia canescens] diamond 1176 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Ichneumonidae Venturia Venturia canescens
28969020 28969020 PRJNA287283_P_NODE_2748_length_393_cov_2.108824_g2524_i0 PRJNA287283 2748 393 2.108824 8.28767832 Artemia franciscana 6661 Arthropoda Arthropoda 164 3.4199999999999996e-48   NR KAK2724467.1 6661 g2524 i0 69 0.984732824427481 129 24 98.5 1 7 393 1 113 KAK2724467.1 hypothetical protein QYM36_001091 [Artemia franciscana] diamond 387 164 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29127051 29127051 PRJNA287283_P_NODE_8629_length_182_cov_1.302326_g8405_i0 PRJNA287283 8629 182 1.302326 2.37023332 Artemia franciscana 6661 Arthropoda Arthropoda 115 3.4e-28   NR KAK2703289.1 6661 g8405 i0 95 0.989010989010989 60 3 98.9 0 2 181 209 268 KAK2703289.1 hypothetical protein QYM36_018206 [Artemia franciscana] diamond 180 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29523341 29523341 PRJNA287283_P_NODE_6390_length_225_cov_1.627907_g6166_i0 PRJNA287283 6390 225 1.627907 3.66279075 Insecta 50557 Arthropoda Arthropoda 157 3.77e-47   NR XP_031353020.1 7054 g6166 i0 90.5 133.2 74 7 98.7 0 3 224 38 111 XP_031353020.1 SUMO-conjugating enzyme UBC9-B [Photinus pyralis] diamond 29970 158 0.993670886075949 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis
29568765 29568765 PRJNA287283_P_NODE_6710_length_216_cov_1.030675_g6486_i0 PRJNA287283 6710 216 1.030675 2.226258 Tigriopus californicus 6832 Arthropoda Arthropoda 45.8 0.00205   NR XP_059097862.1 6832 g6486 i0 67.9 0.777777777777778 28 9 38.9 0 18 101 43 70 XP_059097862.1 phosphatidate cytidylyltransferase, mitochondrial-like isoform X2 [Tigriopus californicus] diamond 168 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
30168743 30168743 PRJNA287283_P_NODE_10112_length_176_cov_0.910569_g9888_i0 PRJNA287283 10112 176 0.910569 1.60260144 Drosophila willistoni 7260 Arthropoda Arthropoda 42.7 0.0151   NR AAO01105.1 7260 g9888 i0 47.5 1.38068181818182 40 18 63.1 1 122 12 198 237 AAO01105.1 CG12134-PA [Drosophila willistoni] diamond 243 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila willistoni
30232103 30232103 PRJNA287283_P_NODE_9472_length_179_cov_0.888889_g9248_i0 PRJNA287283 9472 179 0.888889 1.59111131 Artemia franciscana 6661 Arthropoda Arthropoda 57.8 1.07e-8   NR XP_065575302.1 6661 g9248 i0 58 0.837988826815642 50 21 83.8 0 160 11 80 129 XP_065575302.1 uncharacterized protein LOC136036884 [Artemia franciscana] diamond 150 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30264036 30264036 PRJNA287283_P_NODE_9932_length_177_cov_0.903226_g9708_i0 PRJNA287283 9932 177 0.903226 1.59871002 Artemia franciscana 6661 Arthropoda Arthropoda 92 6.76e-20   NR KAK2707178.1 6661 g9708 i0 84.7 1 59 9 100 0 177 1 29 87 KAK2707178.1 hypothetical protein QYM36_015008, partial [Artemia franciscana] diamond 177 92 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30660512 30660512 PRJNA287283_P_NODE_10233_length_176_cov_0.910569_g10009_i0 PRJNA287283 10233 176 0.910569 1.60260144 Metazoa 33208 Arthropoda Arthropoda 118 8.22e-30   NR XP_037795964.1 6687 g10009 i0 96.6 141.306818181818 58 2 98.9 0 2 175 353 410 XP_037795964.1 splicing factor 3A subunit 2-like [Penaeus monodon] diamond 24870 119 0.991596638655462 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
31147987 31147987 PRJNA287283_P_NODE_9695_length_178_cov_0.896000_g9471_i0 PRJNA287283 9695 178 0.896 1.59488 Artemia franciscana 6661 Arthropoda Arthropoda 90.9 4.9e-21   NR KAK2713169.1 6661 g9471 i0 81.8 0.926966292134832 55 10 92.7 0 12 176 1 55 KAK2713169.1 hypothetical protein QYM36_011757 [Artemia franciscana] diamond 165 90.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31211121 31211121 PRJNA287283_P_NODE_7315_length_202_cov_1.040268_g7091_i0 PRJNA287283 7315 202 1.040268 2.10134136 Molorchus minor 1323400 Arthropoda Arthropoda 117 1.02e-31   NR KAJ8972197.1 1323400 g7091 i0 100 1.63366336633663 55 0 81.7 0 165 1 104 158 KAJ8972197.1 hypothetical protein NQ317_011585, partial [Molorchus minor] diamond 330 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Molorchus Molorchus minor
31907435 31907435 PRJNA287283_P_NODE_6477_length_222_cov_2.591716_g6253_i0 PRJNA287283 6477 222 2.591716 5.75360952 Artemia franciscana 6661 Arthropoda Arthropoda 121 4.359999999999999e-32   NR XP_065578452.1 6661 g6253 i0 90.5 1 74 7 100 0 222 1 35 108 XP_065578452.1 uncharacterized protein LOC136038901 [Artemia franciscana] diamond 222 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
32792083 32792083 PRJNA287283_P_NODE_5680_length_245_cov_2.041667_g5456_i0 PRJNA287283 5680 245 2.041667 5.00208415 Artemia franciscana 6661 Arthropoda Arthropoda 100 5.24e-24   NR KAK2724467.1 6661 g5456 i0 86.4 0.991836734693878 81 11 99.2 0 1 243 126 206 KAK2724467.1 hypothetical protein QYM36_001091 [Artemia franciscana] diamond 243 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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