RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA645397" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA645397 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
26860132 26860132 PRJNA645397_P_NODE_6121_length_210_cov_1.254658_g6048_i0 PRJNA645397 6121 210 1.254658 2.6347818 Araneus ventricosus 182803 Arthropoda Arthropoda 45.1 0.0037200000000000002   NR GBN61280.1 182803 g6048 i0 55 4.77142857142857 40 18 57.1 0 3 122 1149 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1002 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
26872432 26872432 PRJNA645397_P_NODE_9461_length_168_cov_0.873950_g9388_i0 PRJNA645397 9461 168 0.87395 1.468236 Hemiptera 7524 Arthropoda Arthropoda 67.8 2.03e-11   NR XP_050426277.1 133065 g9388 i0 78.4 3.33928571428571 37 8 66.1 0 168 58 528 564 XP_050426277.1 spondin-1-like [Adelges cooleyi] diamond 561 68.2 0.994134897360704 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Adelgidae Adelges Adelges cooleyi
29480950 29480950 PRJNA645397_P_NODE_430_length_659_cov_4.247541_g388_i0 PRJNA645397 430 659 4.247541 27.99129519 Cinara cedri 506608 Arthropoda Arthropoda 207 2.05e-60   NR VVC46497.1 506608 g388 i0 84.9 1.08801213960546 119 18 54.2 0 512 156 349 467 VVC46497.1 Reverse transcriptase domain, partial [Cinara cedri] diamond 717 207 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
29860111 29860111 PRJNA645397_P_NODE_1771_length_393_cov_1.616279_g1702_i0 PRJNA645397 1771 393 1.616279 6.35197647 Diuraphis noxia 143948 Arthropoda Arthropoda 95.9 5.32e-20   NR XP_015363153.1 143948 g1702 i0 71.4 0.854961832061069 56 16 42.7 0 390 223 463 518 XP_015363153.1 PREDICTED: uncharacterized protein LOC107161309 isoform X2 [Diuraphis noxia] diamond 336 95.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
30681388 30681388 PRJNA645397_P_NODE_4593_length_247_cov_1.540404_g4520_i0 PRJNA645397 4593 247 1.540404 3.80479788 Diuraphis noxia 143948 Arthropoda Arthropoda 75.5 1.13e-13   NR XP_015363153.1 143948 g4520 i0 75 1.60323886639676 44 11 53.4 0 134 3 410 453 XP_015363153.1 PREDICTED: uncharacterized protein LOC107161309 isoform X2 [Diuraphis noxia] diamond 396 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
30902833 30902833 PRJNA645397_P_NODE_774_length_541_cov_3.447154_g721_i0 PRJNA645397 774 541 3.447154 18.64910314 Daktulosphaira vitifoliae 58002 Arthropoda Arthropoda 78.6 3.05e-13   NR XP_050529254.1 58002 g721 i0 92.1 0.421441774491682 38 3 21.1 0 38 151 1387 1424 XP_050529254.1 CD109 antigen-like isoform X1 [Daktulosphaira vitifoliae] diamond 228 78.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
31914601 31914601 PRJNA645397_P_NODE_4317_length_256_cov_1.753623_g4244_i0 PRJNA645397 4317 256 1.753623 4.48927488 Onthophagus taurus 166361 Arthropoda Arthropoda 68.2 4.03e-11   NR XP_071050722.1 166361 g4244 i0 73.3 0.52734375 45 12 52.7 0 226 92 70 114 XP_071050722.1 uncharacterized protein [Onthophagus taurus] diamond 135 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Onthophagus Onthophagus taurus

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