RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1002570" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1002570 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
26876482 26876482 PRJNA1002570_P_NODE_30841_length_265_cov_1.604167_g30646_i0 PRJNA1002570 30841 265 1.604167 4.25104255 Ceratosolen solmsi marchali 326594 Arthropoda Arthropoda 47.8 7.81e-4   NR XP_011505423.1 326594 g30646 i0 35.2 2.70566037735849 88 52 94 1 12 260 85 172 XP_011505423.1 PREDICTED: leucine-rich repeat-containing protein 15-like [Ceratosolen solmsi marchali] diamond 717 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Agaonidae Ceratosolen Ceratosolen solmsi
26876492 26876492 PRJNA1002570_P_NODE_36841_length_250_cov_0.870056_g36646_i0 PRJNA1002570 36841 250 0.870056 2.17514 Chironomus riparius 315576 Arthropoda Arthropoda 45.4 0.00363   NR CAH1718848.1 315576 g36646 i0 52.5 0.792 40 19 48 0 129 248 27 66 CAH1718848.1 unnamed protein product [Chironomus riparius] diamond 198 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
27192293 27192293 PRJNA1002570_P_NODE_22482_length_285_cov_1.452830_g22287_i0 PRJNA1002570 22482 285 1.45283 4.1405655 Contarinia nasturtii 265458 Arthropoda Arthropoda 58.2 2.29e-7   NR XP_031636743.1 265458 g22287 i0 35 3.89473684210526 100 56 95.8 1 3 275 325 424 XP_031636743.1 toll-like receptor Tollo [Contarinia nasturtii] diamond 1110 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
27445572 27445572 PRJNA1002570_P_NODE_8583_length_390_cov_2.634069_g8388_i0 PRJNA1002570 8583 390 2.634069 10.2728691 Haemaphysalis longicornis 44386 Arthropoda Arthropoda 47.4 0.00199   NR KAH9382982.1 44386 g8388 i0 40.3 1.33076923076923 77 42 59.2 1 100 330 15 87 KAH9382982.1 hypothetical protein HPB48_023619 [Haemaphysalis longicornis] diamond 519 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Haemaphysalis Haemaphysalis longicornis
27508554 27508554 PRJNA1002570_P_NODE_23563_length_283_cov_1.147619_g23368_i0 PRJNA1002570 23563 283 1.147619 3.24776177 Rhynocoris fuscipes 488301 Arthropoda Arthropoda 60.8 2.07e-8   NR KAK9512800.1 488301 g23368 i0 48.3 0.614840989399293 58 27 61.5 1 176 3 167 221 KAK9512800.1 hypothetical protein O3M35_001134 [Rhynocoris fuscipes] diamond 174 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Reduviidae Rhynocoris Rhynocoris fuscipes
28202801 28202801 PRJNA1002570_P_NODE_35446_length_252_cov_1.513966_g35251_i0 PRJNA1002570 35446 252 1.513966 3.81519432 Araneus ventricosus 182803 Arthropoda Arthropoda 130 2.03e-36   NR GBM80471.1 182803 g35251 i0 85.1 0.880952380952381 74 11 88.1 0 222 1 39 112 GBM80471.1 hypothetical protein AVEN_57307-1 [Araneus ventricosus] diamond 222 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
28582087 28582087 PRJNA1002570_P_NODE_37787_length_249_cov_0.875000_g37592_i0 PRJNA1002570 37787 249 0.875 2.17875 Araneus ventricosus 182803 Arthropoda Arthropoda 97.4 1.05e-21   NR GBM55150.1 182803 g37592 i0 92.6 0.650602409638554 54 4 65.1 0 1 162 344 397 GBM55150.1 hypothetical protein AVEN_225936-1 [Araneus ventricosus] diamond 162 97.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
28606068 28606068 PRJNA1002570_P_NODE_21907_length_286_cov_2.075117_g21712_i0 PRJNA1002570 21907 286 2.075117 5.93483462 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 43.5 0.0311   NR AKN91185.1 95602 g21712 i0 45.5 1.23776223776224 55 24 56.6 3 1 162 6 55 AKN91185.1 serine protease-like protein [Eriocheir sinensis] diamond 354 43.9 0.990888382687927 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
28645164 28645164 PRJNA1002570_P_NODE_20187_length_290_cov_1.322581_g19992_i0 PRJNA1002570 20187 290 1.322581 3.8354849 Trinorchestia longiramus 1923959 Arthropoda Arthropoda 62.8 6.12e-9   NR KAF2365248.1 1923959 g19992 i0 70.3 0.76551724137931 37 11 38.3 0 288 178 1951 1987 KAF2365248.1 Proteasome activator Blm10 mid region [Trinorchestia longiramus] diamond 222 62.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Talitridae Trinorchestia Trinorchestia longiramus
29087236 29087236 PRJNA1002570_P_NODE_26548_length_276_cov_1.394089_g26353_i0 PRJNA1002570 26548 276 1.394089 3.84768564 Portunus trituberculatus 210409 Arthropoda Arthropoda 43.1 0.0198   NR MPC58194.1 210409 g26353 i0 37.5 1.04347826086957 96 47 94.6 4 273 13 24 115 MPC58194.1 hypothetical protein [Portunus trituberculatus] diamond 288 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
29497539 29497539 PRJNA1002570_P_NODE_38670_length_248_cov_0.880000_g38475_i0 PRJNA1002570 38670 248 0.88 2.1824 Orchesella cincta 48709 Arthropoda Arthropoda 68.9 2.41e-11   NR ODM97119.1 48709 g38475 i0 64.8 0.858870967741935 71 15 75 3 62 247 831 900 ODM97119.1 Pecanex-like protein 1 [Orchesella cincta] diamond 213 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
30192318 30192318 PRJNA1002570_P_NODE_37992_length_249_cov_0.869318_g37797_i0 PRJNA1002570 37992 249 0.869318 2.16460182 Laodelphax striatellus 195883 Arthropoda Arthropoda 52 1.24e-6   NR RZF33313.1 195883 g37797 i0 51.1 0.566265060240964 47 21 56.6 1 27 167 14 58 RZF33313.1 hypothetical protein LSTR_LSTR007658 [Laodelphax striatellus] diamond 141 52 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Laodelphax Laodelphax striatellus
30761233 30761233 PRJNA1002570_P_NODE_43194_length_242_cov_0.911243_g42999_i0 PRJNA1002570 43194 242 0.911243 2.20520806 Cordylochernes scorpioides 51811 Arthropoda Arthropoda 95.1 1.34e-20   NR UYV72335.1 51811 g42999 i0 71.1 99.8925619834711 76 22 94.2 0 1 228 146 221 UYV72335.1 HSPA8 [Cordylochernes scorpioides] diamond 24174 95.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Pseudoscorpiones Chernetidae Cordylochernes Cordylochernes scorpioides
31266779 31266779 PRJNA1002570_P_NODE_41135_length_245_cov_0.895349_g40940_i0 PRJNA1002570 41135 245 0.895349 2.19360505 Argiope bruennichi 94029 Arthropoda Arthropoda 116 3.7e-28   NR XP_055934990.1 94029 g40940 i0 73.6 2.64489795918367 72 19 88.2 0 30 245 3 74 XP_055934990.1 uncharacterized protein LOC129964266 [Argiope bruennichi] diamond 648 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
32184163 32184163 PRJNA1002570_P_NODE_22518_length_285_cov_1.424528_g22323_i0 PRJNA1002570 22518 285 1.424528 4.0599048 Daphnia pulicaria 35523 Arthropoda Arthropoda 62 1.08e-8   NR XP_046634518.1 35523 g22323 i0 57.4 0.978947368421053 47 18 47.4 1 7 141 964 1010 XP_046634518.1 uncharacterized protein LOC124313751 [Daphnia pulicaria] diamond 279 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulicaria

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