RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA1241156" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1241156 · 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
26661749 26661749 PRJNA1241156_S_NODE_29461_length_332_cov_4.276817_g29001_i0 PRJNA1241156 29461 332 4.276817 14.19903244 Penaeus vannamei 6689 Arthropoda Arthropoda 43.9 0.0401   NR ROT79753.1 6689 g29001 i0 43.4 0.75 83 45 73.2 1 296 54 480 562 ROT79753.1 hypothetical protein C7M84_001529 [Penaeus vannamei] diamond 249 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
26756879 26756879 PRJNA1241156_S_NODE_61101_length_251_cov_3.855769_g60641_i0 PRJNA1241156 61101 251 3.855769 9.67798019 Diaphorina citri 121845 Arthropoda Arthropoda 48.9 2.61e-4   NR KAI5706979.1 121845 g60641 i0 82.1 1.00398406374502 28 5 33.5 0 167 250 150 177 KAI5706979.1 hypothetical protein M8J75_013076 [Diaphorina citri] diamond 252 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
27263309 27263309 PRJNA1241156_S_NODE_69223_length_232_cov_2.015873_g68763_i0 PRJNA1241156 69223 232 2.015873 4.67682536 Trichonephila clavipes 2585209 Arthropoda Arthropoda 42 0.0348   NR GFV10021.1 2585209 g68763 i0 51.3 0.504310344827586 39 18 50.4 1 102 218 93 130 GFV10021.1 zinc finger BED domain-containing protein 5 [Trichonephila clavipes] diamond 117 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
27831627 27831627 PRJNA1241156_S_NODE_48244_length_280_cov_4.987342_g47784_i0 PRJNA1241156 48244 280 4.987342 13.9645576 Nephila pilipes 299642 Arthropoda Arthropoda 41.6 0.0204   NR GFT52669.1 299642 g47784 i0 50 0.364285714285714 34 17 36.4 0 127 228 36 69 GFT52669.1 hypothetical protein NPIL_313811 [Nephila pilipes] diamond 102 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes
29157972 29157972 PRJNA1241156_S_NODE_7589_length_451_cov_2.595588_g7135_i0 PRJNA1241156 7589 451 2.595588 11.70610188 Ixodes persulcatus 34615 Arthropoda Arthropoda 50.8 4.45e-4   NR KAG0434031.1 34615 g7135 i0 36.5 2.05543237250554 52 32 34.6 1 270 115 196 246 KAG0434031.1 hypothetical protein HPB47_019399 [Ixodes persulcatus] diamond 927 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes persulcatus
29505002 29505002 PRJNA1241156_S_NODE_18150_length_373_cov_4.827273_g17690_i0 PRJNA1241156 18150 373 4.827273 18.00572829 Trichonephila clavipes 2585209 Arthropoda Arthropoda 44.3 0.0381   NR GFX44677.1 2585209 g17690 i0 33.8 0.522788203753351 65 43 52.3 0 207 13 163 227 GFX44677.1 uncharacterized protein TNCV_4441821 [Trichonephila clavipes] diamond 195 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
29599568 29599568 PRJNA1241156_S_NODE_22070_length_357_cov_5.668790_g21610_i0 PRJNA1241156 22070 357 5.66879 20.2375803 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 45.4 0.0156   NR XP_066946104.1 79674 g21610 i0 32.1 2.65546218487395 84 21 40.3 1 228 85 744 827 XP_066946104.1 uncharacterized protein [Macrobrachium rosenbergii] diamond 948 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
29599569 29599569 PRJNA1241156_S_NODE_36710_length_311_cov_4.354478_g36250_i0 PRJNA1241156 36710 311 4.354478 13.54242658 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 96.3 2.4e-21   NR XP_066958655.1 79674 g36250 i0 59.1 0.84887459807074 88 36 84.9 0 47 310 193 280 XP_066958655.1 general transcription factor II-I repeat domain-containing protein 2A-like [Macrobrachium rosenbergii] diamond 264 96.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
30028630 30028630 PRJNA1241156_S_NODE_12291_length_405_cov_18.765193_g11831_i0 PRJNA1241156 12291 405 18.765193 75.99903165 root 1 Root_unresolved Root_unresolved 53.1 5.31e-5   NR GBN61280.1 182803 g11831 i0 50.9 3.61481481481481 53 26 39.3 0 124 282 1136 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1464 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
30073436 30073436 PRJNA1241156_S_NODE_72572_length_216_cov_5.156069_g72112_i0 PRJNA1241156 72572 216 5.156069 11.13710904 Nasonia vitripennis 7425 Arthropoda Arthropoda 42.4 0.0361   NR XP_001603434.1 7425 g72112 i0 32.7 0.680555555555556 49 33 68.1 0 7 153 60 108 XP_001603434.1 L-lactate dehydrogenase-like [Nasonia vitripennis] diamond 147 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
30105087 30105087 PRJNA1241156_S_NODE_31032_length_327_cov_5.119718_g30572_i0 PRJNA1241156 31032 327 5.119718 16.74147786 Trinorchestia longiramus 1923959 Arthropoda Arthropoda 79 1.86e-14   NR KAF2347932.1 1923959 g30572 i0 81.4 0.81651376146789 43 8 39.4 0 227 99 163 205 KAF2347932.1 hypothetical protein FHG87_021314 [Trinorchestia longiramus] diamond 267 79 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Talitridae Trinorchestia Trinorchestia longiramus
30547502 30547502 PRJNA1241156_S_NODE_65833_length_242_cov_1.075377_g65373_i0 PRJNA1241156 65833 242 1.075377 2.60241234 Diatraea saccharalis 40085 Arthropoda Arthropoda 45.1 0.00546   NR CAG9795359.1 40085 g65373 i0 59.4 0.396694214876033 32 13 39.7 0 2 97 289 320 CAG9795359.1 unnamed protein product [Diatraea saccharalis] diamond 96 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Diatraea Diatraea saccharalis
31685307 31685307 PRJNA1241156_S_NODE_70757_length_227_cov_2.554348_g70297_i0 PRJNA1241156 70757 227 2.554348 5.79836996 Leptosia nina 320188 Arthropoda Arthropoda 78.2 9.59e-15   NR CAK1544121.1 320188 g70297 i0 68.5 4.28193832599119 54 17 71.4 0 216 55 55 108 CAK1544121.1 unnamed protein product [Leptosia nina] diamond 972 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Leptosia Leptosia nina
32791514 32791514 PRJNA1241156_S_NODE_62800_length_248_cov_1.170732_g62340_i0 PRJNA1241156 62800 248 1.170732 2.90341536 Dermacentor albipictus 60249 Arthropoda Arthropoda 62.8 2.63e-9   NR XP_070387400.1 60249 g62340 i0 53.3 1.06451612903226 45 21 54.4 0 90 224 56 100 XP_070387400.1 uncharacterized protein [Dermacentor albipictus] diamond 264 62.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor albipictus

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