RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA1067443 · 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
8666700 8666700 PRJNA1067443_P_NODE_2347_length_448_cov_12.000000_g2329_i0 PRJNA1067443 2347 448 12 53.76 Hymenoptera sp. BOLD:ACB2397 1667987 Arthropoda Arthropoda 178 5.2199999999999996e-54   NR AKQ92961.1 1667987 g2329 i0 81.7 1.39285714285714 104 19 69.6 0 418 107 37 140 AKQ92961.1 cytochrome oxidase subunit 1, partial [Hymenoptera sp. BOLD:ACB2397] diamond 624 178 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera     Hymenoptera sp. BOLD:ACB2397
20582568 20582568 PRJNA1067443_P_NODE_1697_length_494_cov_10.836105_g1679_i0 PRJNA1067443 1697 494 10.836105 53.5303587 Schistocerca gregaria 7010 Arthropoda Arthropoda 150 4.41e-39   NR XP_049849072.1 7010 g1679 i0 53.5 1.77935222672065 144 63 85 2 1 420 486 629 XP_049849072.1 heat shock 70 kDa protein-like [Schistocerca gregaria] diamond 879 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
27446748 27446748 PRJNA1067443_P_NODE_16623_length_251_cov_0.865169_g16605_i0 PRJNA1067443 16623 251 0.865169 2.17157419 Adineta steineri 433720 Rotifera other_Eukaryota 63.2 1.24e-10   NR CAF4129484.1 433720 g16605 i0 41.3 0.956175298804781 80 47 95.6 0 244 5 19 98 CAF4129484.1 unnamed protein product [Adineta steineri] diamond 240 63.2 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta steineri
28290472 28290472 PRJNA1067443_P_NODE_18026_length_248_cov_1.594286_g18008_i0 PRJNA1067443 18026 248 1.594286 3.95382928 root 1 Root_unresolved Root_unresolved 43.9 0.0159   NR XP_061445943.1 261503 g18008 i0 42.9 1.33064516129032 63 35 76.2 1 223 35 37 98 XP_061445943.1 serine/threonine-protein kinase WNK4 [Rhineura floridana] diamond 330 43.9 1 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Rhineuridae Rhineura Rhineura floridana
29909474 29909474 PRJNA1067443_P_NODE_2411_length_444_cov_19.083558_g2393_i0 PRJNA1067443 2411 444 19.083558 84.73099752 Schistocerca gregaria 7010 Arthropoda Arthropoda 73.2 7.89e-12   NR XP_049849872.1 7010 g2393 i0 47.8 0.466216216216216 69 36 46.6 0 94 300 615 683 XP_049849872.1 apoptosis-inducing factor 1, mitochondrial-like [Schistocerca gregaria] diamond 207 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
30035765 30035765 PRJNA1067443_P_NODE_4511_length_368_cov_13.061017_g4493_i0 PRJNA1067443 4511 368 13.061017 48.06454256 Schistocerca gregaria 7010 Arthropoda Arthropoda 50.4 2.83e-4   NR XP_049851163.1 7010 g4493 i0 38.8 0.692934782608696 85 46 67.7 3 2 250 383 463 XP_049851163.1 oxysterol-binding protein 8-like [Schistocerca gregaria] diamond 255 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
30320596 30320596 PRJNA1067443_P_NODE_5832_length_338_cov_6.800000_g5814_i0 PRJNA1067443 5832 338 6.8 22.984 Schistocerca gregaria 7010 Arthropoda Arthropoda 65.9 8.59e-10   NR XP_049850183.1 7010 g5814 i0 57.9 0.505917159763314 57 24 50.6 0 172 2 166 222 XP_049850183.1 uncharacterized protein LOC126321793 [Schistocerca gregaria] diamond 171 65.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
30352201 30352201 PRJNA1067443_P_NODE_32_length_1611_cov_25.263329_g28_i0 PRJNA1067443 32 1611 25.263329 406.99223019 Periplaneta americana 6978 Arthropoda Arthropoda 60.8 1.02e-5   NR XP_069698449.1 6978 g28 i0 50.9 0.199255121042831 53 26 9.9 0 7 165 160 212 XP_069698449.1 BTB/POZ domain-containing protein 6-B [Periplaneta americana] diamond 321 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
30383651 30383651 PRJNA1067443_P_NODE_15573_length_254_cov_2.016575_g15555_i0 PRJNA1067443 15573 254 2.016575 5.1221005 Tribolium castaneum 7070 Arthropoda Arthropoda 71.2 2.14e-14   NR EFA13580.1 7070 g15555 i0 100 0.401574803149606 34 0 40.2 0 206 105 19 52 EFA13580.1 hypothetical protein TcasGA2_TC001599 [Tribolium castaneum] diamond 102 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
30667599 30667599 PRJNA1067443_P_NODE_4033_length_380_cov_6.739414_g4015_i0 PRJNA1067443 4033 380 6.739414 25.6097732 Schistocerca gregaria 7010 Arthropoda Arthropoda 93.2 3.89e-19   NR XP_049849622.1 7010 g4015 i0 41.2 0.805263157894737 102 59 79.7 1 1 303 922 1023 XP_049849622.1 phosphatidylinositol 4-kinase-like [Schistocerca gregaria] diamond 306 93.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
31299569 31299569 PRJNA1067443_P_NODE_17355_length_249_cov_1.750000_g17337_i0 PRJNA1067443 17355 249 1.75 4.3575 Halotydeus destructor 2874060 Arthropoda Arthropoda 145 2.18e-38   NR KAI1278379.1 2874060 g17337 i0 77.1 1.98795180722892 83 19 100 0 1 249 188 270 KAI1278379.1 Histone deacetylase 6 [Halotydeus destructor] diamond 495 145 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
32248971 32248971 PRJNA1067443_P_NODE_418_length_724_cov_31.049155_g403_i0 PRJNA1067443 418 724 31.049155 224.7958822 Nesidiocoris tenuis 355587 Arthropoda Arthropoda 93.6 7.12e-18   NR BES96277.1 355587 g403 i0 40 0.662983425414365 160 26 66.3 1 109 588 118 207 BES96277.1 solute carrier family 2, facilitated glucose transporter member [Nesidiocoris tenuis] diamond 480 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Nesidiocoris Nesidiocoris tenuis
32627853 32627853 PRJNA1067443_P_NODE_15300_length_255_cov_5.472527_g15282_i0 PRJNA1067443 15300 255 5.472527 13.95494385 Bos mutus 72004 Chordata Chordata 52.4 1.18e-5   NR XP_070226243.1 72004 g15282 i0 50.9 1.22352941176471 57 23 61.2 1 100 255 15 71 XP_070226243.1 LINE-1 type transposase domain-containing protein 1 [Bos mutus] diamond 312 52.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bos Bos mutus
32627859 32627859 PRJNA1067443_P_NODE_24460_length_197_cov_4.266129_g24442_i0 PRJNA1067443 24460 197 4.266129 8.40427413 Tribolium castaneum 7070 Arthropoda Arthropoda 63.2 1.62e-11   NR EFA13580.1 7070 g24442 i0 75.6 0.685279187817259 45 11 68.5 0 20 154 8 52 EFA13580.1 hypothetical protein TcasGA2_TC001599 [Tribolium castaneum] diamond 135 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum

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