RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1016321" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA1016321 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
12913199 12913199 PRJNA1016321_P_NODE_34751_length_304_cov_2.333333_g34520_i0 PRJNA1016321 34751 304 2.333333 7.09333232 Sus scrofa 9823 Chordata Chordata 157 3.2499999999999992e-43   NR XP_020938199.1 9823 g34520 i0 86.8 1.62828947368421 91 5 82.9 1 253 2 47 137 XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] diamond 495 157 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
19285746 19285746 PRJNA1016321_P_NODE_7556_length_740_cov_1.992504_g7355_i0 PRJNA1016321 7556 740 1.992504 14.7445296 Pediculus humanus corporis 121224 Arthropoda Arthropoda 375 4.9799999999999996e-129   NR XP_002426249.1 121224 g7355 i0 91.7 0.835135135135135 206 17 83.5 0 718 101 1 206 XP_002426249.1 40S ribosomal protein S6, putative [Pediculus humanus corporis] diamond 618 375 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
23112021 23112021 PRJNA1016321_P_NODE_42499_length_270_cov_1.192893_g42268_i0 PRJNA1016321 42499 270 1.192893 3.2208111 Ostreidae 6563 Mollusca Mollusca 79.7 4.3e-15   NR XP_062600034.1 36930 g42268 i0 71.7 2.57777777777778 46 13 51.1 0 270 133 368 413 XP_062600034.1 succinate-semialdehyde dehydrogenase, mitochondrial-like, partial [Saccostrea cuccullata] diamond 696 80.1 0.995006242197254 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata
26615398 26615398 PRJNA1016321_P_NODE_24361_length_377_cov_2.220395_g24130_i0 PRJNA1016321 24361 377 2.220395 8.37088915 Scleractinia 6125 Cnidaria other_Eukaryota 183 6.749999999999998e-56   NR ABN41777.1 46748 g24130 i0 64 4.97347480106101 125 45 99.5 0 376 2 16 140 ABN41777.1 green-to-red photoconvertible GFP-like protein [Catalaphyllia jardinei] diamond 1875 183 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Catalaphyllia Catalaphyllia jardinei
26908325 26908325 PRJNA1016321_P_NODE_51962_length_246_cov_0.890173_g51731_i0 PRJNA1016321 51962 246 0.890173 2.18982558 Aedes aegypti 7159 Arthropoda Arthropoda 82.4 4.31e-16   NR XP_021702187.1 7159 g51731 i0 55.6 0.878048780487805 72 31 86.6 1 31 243 894 965 XP_021702187.1 unconventional myosin-VIIa isoform X2 [Aedes aegypti] diamond 216 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
27098023 27098023 PRJNA1016321_P_NODE_31922_length_320_cov_1.481781_g31691_i0 PRJNA1016321 31922 320 1.481781 4.7416992 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 48.9 3.61e-5   NR 2GW4_A 196280 g31691 i0 81.5 0.253125 27 5 25.3 0 240 320 3 29 2GW4_A Chain A, Kaede [Trachyphyllia geoffroyi] diamond 81 48.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
27161007 27161007 PRJNA1016321_P_NODE_35922_length_298_cov_1.751111_g35691_i0 PRJNA1016321 35922 298 1.751111 5.21831078 Aphis gossypii 80765 Arthropoda Arthropoda 42.7 0.0388   NR CAH1737507.1 80765 g35691 i0 38.5 0.523489932885906 52 28 48.3 1 136 279 12 63 CAH1737507.1 unnamed protein product [Aphis gossypii] diamond 156 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
28014232 28014232 PRJNA1016321_P_NODE_37045_length_292_cov_3.954338_g36814_i0 PRJNA1016321 37045 292 3.954338 11.54666696 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 118 2.07e-31   NR 2GW4_B 196280 g36814 i0 67.4 0.914383561643836 89 29 91.4 0 1 267 73 161 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 267 118 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
28045572 28045572 PRJNA1016321_P_NODE_38665_length_285_cov_3.367925_g38434_i0 PRJNA1016321 38665 285 3.367925 9.59858625 Saccopteryx bilineata 59482 Chordata Chordata 68.2 7.32e-11   NR XP_066094014.1 59482 g38434 i0 62.9 0.736842105263158 70 26 73.7 0 73 282 488 557 XP_066094014.1 serine/threonine-protein kinase 4 isoform X1 [Saccopteryx bilineata] diamond 210 68.2 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Chiroptera Emballonuridae Saccopteryx Saccopteryx bilineata
28771772 28771772 PRJNA1016321_P_NODE_42587_length_269_cov_2.928571_g42356_i0 PRJNA1016321 42587 269 2.928571 7.87785599 Staurois parvus 386267 Chordata Chordata 49.7 1.29e-4   NR CAI9536211.1 386267 g42356 i0 54.2 0.535315985130111 48 15 45.7 3 49 171 178 225 CAI9536211.1 unnamed protein product [Staurois parvus] diamond 144 49.7 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
30066383 30066383 PRJNA1016321_P_NODE_57752_length_224_cov_4.344371_g57521_i0 PRJNA1016321 57752 224 4.344371 9.73139104 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 59.7 7.01e-10   NR 2GW4_A 196280 g57521 i0 66.7 0.683035714285714 51 17 68.3 0 153 1 3 53 2GW4_A Chain A, Kaede [Trachyphyllia geoffroyi] diamond 153 59.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
31172048 31172048 PRJNA1016321_P_NODE_42075_length_271_cov_2.787879_g41844_i0 PRJNA1016321 42075 271 2.787879 7.55515209 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 115 1.27e-30   NR 2GW4_B 196280 g41844 i0 75.3 0.896678966789668 81 20 89.7 0 7 249 47 127 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 243 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
32745522 32745522 PRJNA1016321_P_NODE_38700_length_285_cov_2.089623_g38469_i0 PRJNA1016321 38700 285 2.089623 5.95542555 Ixodes 6944 Arthropoda Arthropoda 56.2 1.11e-6   NR XP_040360213.1 6945 g38469 i0 38.6 7.90526315789474 88 47 92.6 1 285 22 305 385 XP_040360213.1 uncharacterized protein LOC120847811 [Ixodes scapularis] diamond 2253 56.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis

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