RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1112809 · 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
26774345 26774345 PRJNA1112809_P_NODE_171161_length_249_cov_0.869318_g167886_i0 PRJNA1112809 171161 249 0.869318 2.16460182 Arthropoda 6656 Arthropoda Arthropoda 115 1.44e-28   NR XP_012265730.2 37344 g167886 i0 66.3 5.75903614457831 80 27 96.4 0 240 1 66 145 XP_012265730.2 cysteine-rich with EGF-like domain protein 2 [Athalia rosae] diamond 1434 116 0.991379310344828 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Athaliidae Athalia Athalia rosae
26878379 26878379 PRJNA1112809_P_NODE_83861_length_371_cov_1.255034_g80586_i0 PRJNA1112809 83861 371 1.255034 4.65617614 Tribolium castaneum 7070 Arthropoda Arthropoda 44.3 0.0434   NR XP_008199173.3 7070 g80586 i0 34.2 0.921832884097035 114 64 84.1 5 330 19 437 549 XP_008199173.3 protein bride of sevenless [Tribolium castaneum] diamond 342 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
27130692 27130692 PRJNA1112809_P_NODE_163342_length_251_cov_1.730337_g160067_i0 PRJNA1112809 163342 251 1.730337 4.34314587 Prorops nasuta 863751 Arthropoda Arthropoda 107 1e-24   NR XP_066603290.1 863751 g160067 i0 72.3 0.99203187250996006 83 23 99.2 0 1 249 209 291 XP_066603290.1 BLOC-2 complex member HPS3 [Prorops nasuta] diamond 249 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Bethylidae Prorops Prorops nasuta
27185319 27185319 PRJNA1112809_P_NODE_127102_length_288_cov_1.074419_g123827_i0 PRJNA1112809 127102 288 1.074419 3.09432672 Opisthokonta 33154 Arthropoda Arthropoda 82 2.57e-17   NR XP_034253166.1 161013 g123827 i0 45.3 17.96875 95 51 99 1 288 4 28 121 XP_034253166.1 ubiquitin-40S ribosomal protein S27a [Thrips palmi] diamond 5175 82.4 0.995145631067961 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
27794556 27794556 PRJNA1112809_P_NODE_130964_length_283_cov_1.919048_g127689_i0 PRJNA1112809 130964 283 1.919048 5.43090584 Maniola hyperantus 2795564 Arthropoda Arthropoda 76.6 4.08e-14   NR XP_034826001.1 2795564 g127689 i0 47.8 2.66077738515901 92 33 97.5 1 4 279 44 120 XP_034826001.1 retinol dehydrogenase 12-like [Maniola hyperantus] diamond 753 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Maniola Maniola hyperantus
28394282 28394282 PRJNA1112809_P_NODE_195246_length_238_cov_2.412121_g191971_i0 PRJNA1112809 195246 238 2.412121 5.74084798 Oedothorax gibbosus 931172 Arthropoda Arthropoda 55.5 1.09e-6   NR KAG8181929.1 931172 g191971 i0 46.6 1.84033613445378 73 39 92 0 3 221 201 273 KAG8181929.1 hypothetical protein JTE90_000040 [Oedothorax gibbosus] diamond 438 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Linyphiidae Oedothorax Oedothorax gibbosus
28804539 28804539 PRJNA1112809_P_NODE_150388_length_263_cov_1.589474_g147113_i0 PRJNA1112809 150388 263 1.589474 4.18031662 Bemisia tabaci 7038 Arthropoda Arthropoda 72.8 4.97e-13   NR XP_018908210.1 7038 g147113 i0 57.1 2.39543726235741 70 30 79.8 0 210 1 9 78 XP_018908210.1 PREDICTED: 60S ribosomal protein L7a [Bemisia tabaci] diamond 630 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
28922106 28922106 PRJNA1112809_P_NODE_193548_length_241_cov_0.916667_g190273_i0 PRJNA1112809 193548 241 0.916667 2.20916747 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 100 2.41e-22   NR XP_049849216.1 7010 g190273 i0 55 2.96265560165975 80 34 99.6 2 240 1 646 723 XP_049849216.1 uncharacterized protein LOC126318245 [Schistocerca gregaria] diamond 714 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
29878443 29878443 PRJNA1112809_P_NODE_120431_length_296_cov_2.246637_g117156_i0 PRJNA1112809 120431 296 2.246637 6.65004552 Fragariocoptes setiger 1670756 Arthropoda Arthropoda 117 3.06e-28   NR KAG9509779.1 1670756 g117156 i0 59.6 1.05405405405405 104 23 86.1 2 288 34 229 332 KAG9509779.1 Mitogen-activated protein kinase kinase kinase 15, partial [Fragariocoptes setiger] diamond 312 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Fragariocoptes Fragariocoptes setiger
30162461 30162461 PRJNA1112809_P_NODE_194832_length_239_cov_2.512048_g191557_i0 PRJNA1112809 194832 239 2.512048 6.00379472 Vollenhovia emeryi 411798 Arthropoda Arthropoda 46.2 0.00213   NR XP_011859737.1 411798 g191557 i0 37.1 0.778242677824268 62 39 77.8 0 186 1 218 279 XP_011859737.1 PREDICTED: uncharacterized protein LOC105557175 [Vollenhovia emeryi] diamond 186 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Vollenhovia Vollenhovia emeryi
30280630 30280630 PRJNA1112809_P_NODE_127912_length_287_cov_1.238318_g124637_i0 PRJNA1112809 127912 287 1.238318 3.55397266 Malacostraca 6681 Arthropoda Arthropoda 123 2.4999999999999997e-32   NR CAL4060407.1 48144 g124637 i0 65.6 2.87456445993031 93 32 97.2 0 285 7 150 242 CAL4060407.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 825 124 0.991935483870968 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
30289423 30289423 PRJNA1112809_P_NODE_140712_length_273_cov_1.240000_g137437_i0 PRJNA1112809 140712 273 1.24 3.3852 Cinara cedri 506608 Arthropoda Arthropoda 72 2.62e-12   NR VVC27783.1 506608 g137437 i0 62.3 1.71428571428571 53 20 58.2 0 114 272 178 230 VVC27783.1 Hypothetical protein CINCED_3A025476 [Cinara cedri] diamond 468 72 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
31101559 31101559 PRJNA1112809_P_NODE_147395_length_266_cov_1.523316_g144120_i0 PRJNA1112809 147395 266 1.523316 4.05202056 Metazoa 33208 Arthropoda Arthropoda 89.7 2.39e-19   NR XP_055712420.1 29031 g144120 i0 64.5 42.5075187969925 76 20 85.7 2 230 3 22 90 XP_055712420.1 60S ribosomal protein L7a [Phlebotomus papatasi] diamond 11307 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
31141735 31141735 PRJNA1112809_P_NODE_136935_length_277_cov_1.147059_g133660_i0 PRJNA1112809 136935 277 1.147059 3.17735343 Fragariocoptes setiger 1670756 Arthropoda Arthropoda 83.6 2.55e-16   NR KAG9509995.1 1670756 g133660 i0 48.1 0.833935018050541 77 40 83.4 0 5 235 990 1066 KAG9509995.1 Nose resistant to fluoxetine protein 6 [Fragariocoptes setiger] diamond 231 83.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Fragariocoptes Fragariocoptes setiger
31173391 31173391 PRJNA1112809_P_NODE_145875_length_267_cov_2.773196_g142600_i0 PRJNA1112809 145875 267 2.773196 7.40443332 Polistes exclamans 27506 Arthropoda Arthropoda 45.8 7.74e-4   NR KAI4481302.1 27506 g142600 i0 61.7 0.528089887640449 47 14 51.7 2 25 162 57 100 KAI4481302.1 hypothetical protein M0804_009422 [Polistes exclamans] diamond 141 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Polistes Polistes exclamans
31204920 31204920 PRJNA1112809_P_NODE_201455_length_200_cov_4.496063_g198180_i0 PRJNA1112809 201455 200 4.496063 8.992126 Prorops nasuta 863751 Arthropoda Arthropoda 57.4 1.46e-7   NR XP_066593113.1 863751 g198180 i0 100 0.39 26 0 39 0 79 2 484 509 XP_066593113.1 tuberin [Prorops nasuta] diamond 78 57.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Bethylidae Prorops Prorops nasuta
32502628 32502628 PRJNA1112809_P_NODE_194199_length_241_cov_0.892857_g190924_i0 PRJNA1112809 194199 241 0.892857 2.15178537 Polistes dominula 743375 Arthropoda Arthropoda 94 9.22e-21   NR XP_015176414.1 743375 g190924 i0 85.9 0.970954356846473 78 11 97.1 0 3 236 104 181 XP_015176414.1 PREDICTED: zinc finger protein OZF-like [Polistes dominula] diamond 234 94 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Polistes Polistes dominula
32659860 32659860 PRJNA1112809_P_NODE_146960_length_266_cov_2.336788_g143685_i0 PRJNA1112809 146960 266 2.336788 6.21585608 Fragariocoptes setiger 1670756 Arthropoda Arthropoda 102 7.1e-23   NR KAG9510624.1 1670756 g143685 i0 59.6 1.00375939849624 89 34 99.2 2 2 265 1311 1398 KAG9510624.1 Delta-1-pyrroline-5-carboxylate dehydrogenase, mitochondrial, partial [Fragariocoptes setiger] diamond 267 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Fragariocoptes Fragariocoptes setiger
32745860 32745860 PRJNA1112809_P_NODE_62960_length_454_cov_2.272966_g59686_i0 PRJNA1112809 62960 454 2.272966 10.31926564 Opisthokonta 33154 Arthropoda Arthropoda 48.9 0.00213   NR XP_031780140.1 7425 g59686 i0 28.1 4.32819383259912 146 96 94.5 3 9 437 185 324 XP_031780140.1 putative ankyrin repeat protein RF_0381 [Nasonia vitripennis] diamond 1965 49.3 0.991886409736308 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis

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