RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA719595" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA719595 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
24936015 24936015 PRJNA719595_P_NODE_6820_length_252_cov_0.871508_g6785_i0 PRJNA719595 6820 252 0.871508 2.19620016 Diptera 7147 Arthropoda Arthropoda 126 3.99e-32   NR XP_004518446.1 7213 g6785 i0 74.4 47.3571428571429 78 20 92.9 0 238 5 159 236 XP_004518446.1 vacuolar protein sorting-associated protein 26B-like [Ceratitis capitata] diamond 11934 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
24936064 24936064 PRJNA719595_P_NODE_8860_length_244_cov_0.912281_g8825_i0 PRJNA719595 8860 244 0.912281 2.22596564 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 122 3.1599999999999997e-32   NR KAK0051780.1 112525 g8825 i0 77.5 31.5 80 18 98.4 0 5 244 162 241 KAK0051780.1 40S ribosomal protein S2 [Biomphalaria pfeifferi] diamond 7686 123 0.991869918699187 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria pfeifferi
26650760 26650760 PRJNA719595_P_NODE_9101_length_243_cov_0.917647_g9066_i0 PRJNA719595 9101 243 0.917647 2.22988221 Trombidiformes 83136 Arthropoda Arthropoda 107 6.77e-26   NR RWS23265.1 299467 g9066 i0 58.8 6.91358024691358 80 33 98.8 0 3 242 67 146 RWS23265.1 peptide chain release factor 1-like: mitochondrial isoform X2 [Leptotrombidium deliense] diamond 1680 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
26798812 26798812 PRJNA719595_P_NODE_8341_length_246_cov_0.901734_g8306_i0 PRJNA719595 8341 246 0.901734 2.21826564 Aphelenchoides fujianensis 1052528 Nematoda Nematoda 52 2.16e-5   NR KAI6219037.1 1052528 g8306 i0 34.1 1 82 52 100 2 1 246 323 402 KAI6219037.1 Plus3 domain-containing protein [Aphelenchoides fujianensis] diamond 246 52 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Aphelenchoididae Aphelenchoides Aphelenchoides fujianensis
27020402 27020402 PRJNA719595_P_NODE_4762_length_292_cov_1.068493_g4727_i0 PRJNA719595 4762 292 1.068493 3.11999956 Ranitomeya imitator 111125 Chordata Chordata 70.1 1.45e-11   NR CAJ0964204.1 111125 g4727 i0 73 1.15068493150685 37 10 38 0 150 40 15 51 CAJ0964204.1 unnamed protein product [Ranitomeya imitator] diamond 336 70.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Dendrobatidae Ranitomeya Ranitomeya imitator
28346895 28346895 PRJNA719595_P_NODE_8126_length_247_cov_0.896552_g8091_i0 PRJNA719595 8126 247 0.896552 2.21448344 Ylistrum balloti 509963 Mollusca Mollusca 42.4 0.0333   NR XP_060069831.1 509963 g8091 i0 51.3 0.473684210526316 39 19 47.4 0 203 87 56 94 XP_060069831.1 neo-calmodulin-like [Ylistrum balloti] diamond 117 42.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Ylistrum Ylistrum balloti
28473323 28473323 PRJNA719595_P_NODE_6186_length_257_cov_1.597826_g6151_i0 PRJNA719595 6186 257 1.597826 4.10641282 Spodoptera frugiperda 7108 Arthropoda Arthropoda 43.1 0.0124   NR KAF9791410.1 7108 g6151 i0 62.2 1.93774319066148 37 11 39.7 1 115 14 52 88 KAF9791410.1 hypothetical protein SFRURICE_015995 [Spodoptera frugiperda] diamond 498 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
28957533 28957533 PRJNA719595_P_NODE_8708_length_245_cov_0.906977_g8673_i0 PRJNA719595 8708 245 0.906977 2.22209365 Metazoa 33208 Arthropoda Arthropoda 102 4.789999999999999e-23   NR KAL3217357.1 6941 g8673 i0 67.6 6.12244897959184 71 23 86.9 0 225 13 128 198 KAL3217357.1 hypothetical protein MRX96_032478 [Rhipicephalus microplus] diamond 1500 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
29367856 29367856 PRJNA719595_P_NODE_6029_length_260_cov_1.657754_g5994_i0 PRJNA719595 6029 260 1.657754 4.3101604 Insecta 50557 Arthropoda Arthropoda 113 2.26e-29   NR CAK9830547.1 597843 g5994 i0 72.3 1.92692307692308 83 22 95.8 1 8 256 1 82 CAK9830547.1 60S ribosomal protein L17 [Anthophora retusa] diamond 501 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora retusa
29462175 29462175 PRJNA719595_P_NODE_7910_length_248_cov_0.891429_g7875_i0 PRJNA719595 7910 248 0.891429 2.21074392 Calliphoridae 7371 Arthropoda Arthropoda 58.9 7.84e-8   NR XP_065369578.1 7373 g7875 i0 48 2.41935483870968 50 26 60.5 0 150 1 159 208 XP_065369578.1 protein 5NUC isoform X1 [Calliphora vicina] diamond 600 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
30620667 30620667 PRJNA719595_P_NODE_7273_length_250_cov_0.881356_g7238_i0 PRJNA719595 7273 250 0.881356 2.20339 Fragariocoptes setiger 1670756 Arthropoda Arthropoda 64.7 1.03e-10   NR KAG9510839.1 1670756 g7238 i0 76.5 0.408 34 8 40.8 0 242 141 129 162 KAG9510839.1 Coiled-coil-helix-coiled-coil-helix domain-containing protein 2, partial [Fragariocoptes setiger] diamond 102 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Fragariocoptes Fragariocoptes setiger
30999980 30999980 PRJNA719595_P_NODE_8454_length_246_cov_0.901734_g8419_i0 PRJNA719595 8454 246 0.901734 2.21826564 Bombyx mori 7091 Arthropoda Arthropoda 45.1 0.00566   NR XP_004926831.3 7091 g8419 i0 75 0.292682926829268 24 6 29.3 0 148 77 105 128 XP_004926831.3 putative uncharacterized transposon-derived protein F52C9.6 [Bombyx mori] diamond 72 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
31769195 31769195 PRJNA719595_P_NODE_6837_length_252_cov_0.871508_g6802_i0 PRJNA719595 6837 252 0.871508 2.19620016 root 1 Root_unresolved Root_unresolved 49.3 2.08e-4   NR XP_022100316.1 133434 g6802 i0 35.8 3.20238095238095 81 32 95.2 2 8 247 723 784 XP_022100316.1 uncharacterized protein LOC110984425 [Acanthaster planci] diamond 807 49.7 0.991951710261569 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
32360223 32360223 PRJNA719595_P_NODE_8619_length_245_cov_0.906977_g8584_i0 PRJNA719595 8619 245 0.906977 2.22209365 Caenorhabditis brenneri 135651 Nematoda Nematoda 64.3 2.7e-10   NR EGT34389.1 135651 g8584 i0 51.9 4.44489795918367 54 26 66.1 0 1 162 122 175 EGT34389.1 hypothetical protein CAEBREN_23279 [Caenorhabditis brenneri] diamond 1089 64.3 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis brenneri

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