RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA473824" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA473824 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
1720873 1720873 PRJNA473824_P_NODE_101282_length_173_cov_2.742647_g100644_i0 PRJNA473824 101282 173 2.742647 4.74477931 Ceratitis capitata 7213 Arthropoda Arthropoda 74.7 7.7e-14   NR CAD7015489.1 7213 g100644 i0 69.5 1.02312138728324 59 16 98.8 1 1 171 622 680 CAD7015489.1 unnamed protein product [Ceratitis capitata] diamond 177 74.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
27139044 27139044 PRJNA473824_P_NODE_170262_length_150_cov_3.203540_g169624_i0 PRJNA473824 170262 150 3.20354 4.80531 Aedes albopictus 7160 Arthropoda Arthropoda 38.9 0.0466   NR KXJ78923.1 7160 g169624 i0 68.2 0.44 22 7 44 0 68 3 2 23 KXJ78923.1 hypothetical protein RP20_CCG002939 [Aedes albopictus] diamond 66 38.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
27613460 27613460 PRJNA473824_P_NODE_142544_length_151_cov_4.894737_g141906_i0 PRJNA473824 142544 151 4.894737 7.39105287 Bradysia coprophila 38358 Arthropoda Arthropoda 49.7 3.64e-5   NR XP_037026722.1 38358 g141906 i0 87.5 0.47682119205298 24 3 47.7 0 74 3 444 467 XP_037026722.1 uncharacterized protein LOC119067714 [Bradysia coprophila] diamond 72 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
27960616 27960616 PRJNA473824_P_NODE_15865_length_299_cov_3.412214_g15227_i0 PRJNA473824 15865 299 3.412214 10.20251986 Contarinia nasturtii 265458 Arthropoda Arthropoda 45.4 0.00701   NR XP_031634449.1 265458 g15227 i0 36.8 1.13377926421405 57 33 54.2 1 234 73 181 237 XP_031634449.1 von Willebrand factor-like [Contarinia nasturtii] diamond 339 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
29223768 29223768 PRJNA473824_P_NODE_157169_length_151_cov_3.157895_g156531_i0 PRJNA473824 157169 151 3.157895 4.76842145 Ceratitis capitata 7213 Arthropoda Arthropoda 92.4 2.25e-20   NR CAD7015492.1 7213 g156531 i0 62 3.15894039735099 79 0 97.4 1 3 149 132 210 CAD7015492.1 unnamed protein product [Ceratitis capitata] diamond 477 92.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
29286640 29286640 PRJNA473824_P_NODE_80129_length_173_cov_3.382353_g79491_i0 PRJNA473824 80129 173 3.382353 5.85147069 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 50.1 3.81e-5   NR XP_015903335.1 114398 g79491 i0 96 0.433526011560694 25 1 43.4 0 172 98 403 427 XP_015903335.1 paired amphipathic helix protein Sin3a [Parasteatoda tepidariorum] diamond 75 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
29475925 29475925 PRJNA473824_P_NODE_92210_length_173_cov_2.985294_g91572_i0 PRJNA473824 92210 173 2.985294 5.16455862 Diachasma alloeum 454923 Arthropoda Arthropoda 42.4 0.0203   NR XP_015124738.1 454923 g91572 i0 76 0.867052023121387 25 6 43.4 0 1 75 478 502 XP_015124738.1 uncharacterized protein LOC107046602 [Diachasma alloeum] diamond 150 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Diachasma Diachasma alloeum
29791780 29791780 PRJNA473824_P_NODE_50531_length_174_cov_4.554745_g49893_i0 PRJNA473824 50531 174 4.554745 7.9252563 Halotydeus destructor 2874060 Arthropoda Arthropoda 47.4 3.58e-4   NR KAI1278482.1 2874060 g49893 i0 72 0.431034482758621 25 7 43.1 0 75 1 1364 1388 KAI1278482.1 DNA polymerase alpha catalytic subunit [Halotydeus destructor] diamond 75 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
30013160 30013160 PRJNA473824_P_NODE_162871_length_150_cov_6.088496_g162233_i0 PRJNA473824 162871 150 6.088496 9.132744 Tetranychus urticae 32264 Arthropoda Arthropoda 54.7 6.19e-7   NR XP_015794960.1 32264 g162233 i0 52 4.18 50 14 80 1 124 5 499 548 XP_015794960.1 sodium-dependent phosphate transport protein 2B-like [Tetranychus urticae] diamond 627 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
30234199 30234199 PRJNA473824_P_NODE_157012_length_151_cov_3.166667_g156374_i0 PRJNA473824 157012 151 3.166667 4.78166717 Araneus ventricosus 182803 Arthropoda Arthropoda 48.5 9.63e-5   NR GBN91128.1 182803 g156374 i0 53.5 1.70860927152318 43 18 81.5 1 5 127 173 215 GBN91128.1 hypothetical protein AVEN_181476-1 [Araneus ventricosus] diamond 258 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
31150004 31150004 PRJNA473824_P_NODE_125055_length_164_cov_4.543307_g124417_i0 PRJNA473824 125055 164 4.543307 7.45102348 Mythimna loreyi 667449 Arthropoda Arthropoda 41.2 0.0457   NR KAJ8723365.1 667449 g124417 i0 55.6 0.658536585365854 36 16 65.9 0 31 138 907 942 KAJ8723365.1 hypothetical protein PYW08_003277 [Mythimna loreyi] diamond 108 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Mythimna Mythimna loreyi
31261464 31261464 PRJNA473824_P_NODE_164595_length_150_cov_4.796460_g163957_i0 PRJNA473824 164595 150 4.79646 7.19469 Insecta 50557 Arthropoda Arthropoda 44.7 0.00216   NR KAJ3637953.1 7067 g163957 i0 52.1 4.86 48 21 92 1 142 5 220 267 KAJ3637953.1 hypothetical protein MTP99_001371 [Tenebrio molitor] diamond 729 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
32131244 32131244 PRJNA473824_P_NODE_83498_length_173_cov_3.264706_g82860_i0 PRJNA473824 83498 173 3.264706 5.64794138 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 73.2 2.69e-13   NR XP_042898543.1 114398 g82860 i0 75.4 0.988439306358382 57 3 98.8 2 3 173 1413 1458 XP_042898543.1 uncharacterized protein [Parasteatoda tepidariorum] diamond 171 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
32162787 32162787 PRJNA473824_P_NODE_103738_length_173_cov_2.698529_g103100_i0 PRJNA473824 103738 173 2.698529 4.66845517 Schistocerca gregaria 7010 Arthropoda Arthropoda 48.5 1.23e-4   NR XP_049830636.1 7010 g103100 i0 95.7 0.398843930635838 23 1 39.9 0 100 168 168 190 XP_049830636.1 uncharacterized protein LOC126272099 [Schistocerca gregaria] diamond 69 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
32731511 32731511 PRJNA473824_P_NODE_85680_length_173_cov_3.198529_g85042_i0 PRJNA473824 85680 173 3.198529 5.53345517 Condylostylus longicornis 2530218 Arthropoda Arthropoda 60.5 8.02e-9   NR XP_055371001.1 2530218 g85042 i0 61.1 1.8728323699422 54 15 93.6 2 10 171 421 468 XP_055371001.1 5'-3' exonuclease PLD3-like isoform X1 [Condylostylus longicornis] diamond 324 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
32762843 32762843 PRJNA473824_P_NODE_168640_length_150_cov_3.451327_g168002_i0 PRJNA473824 168640 150 3.451327 5.1769905 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 55.5 3.31e-7   NR XP_015923921.1 114398 g168002 i0 89.3 2.04 28 3 56 0 65 148 366 393 XP_015923921.1 SAFB-like transcription modulator [Parasteatoda tepidariorum] diamond 306 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum

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