RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA757618" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA757618 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
4561151 4561151 PRJNA757618_P_NODE_43124_length_244_cov_0.912281_g42072_i0 PRJNA757618 43124 244 0.912281 2.22596564 Orchesella dallaii 48710 Arthropoda Arthropoda 81.3 1.01e-15   NR CAL8071148.1 48710 g42072 i0 47.4 6.92213114754098 78 41 95.9 0 239 6 145 222 CAL8071148.1 unnamed protein product [Orchesella dallaii] diamond 1689 81.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
26714245 26714245 PRJNA757618_P_NODE_47281_length_242_cov_0.923077_g46229_i0 PRJNA757618 47281 242 0.923077 2.23384634 Trombidiformes 83136 Arthropoda Arthropoda 50.1 2.38e-5   NR XP_015785135.1 32264 g46229 i0 64.9 0.929752066115702 37 13 45.9 0 10 120 96 132 XP_015785135.1 ragulator complex protein LAMTOR3 [Tetranychus urticae] diamond 225 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
27694879 27694879 PRJNA757618_P_NODE_31464_length_250_cov_0.881356_g30412_i0 PRJNA757618 31464 250 0.881356 2.20339 Arthropoda 6656 Arthropoda Arthropoda 44.7 0.00807   NR ARS01459.1 6661 g30412 i0 86.4 1.632 22 3 26.4 0 66 1 8 29 ARS01459.1 dsRNA binding protein 1 [Artemia franciscana] diamond 408 45.1 0.991130820399113 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28063589 28063589 PRJNA757618_P_NODE_30045_length_251_cov_0.870787_g28993_i0 PRJNA757618 30045 251 0.870787 2.18567537 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 132 1.08e-33   NR KAH9404896.1 59818 g28993 i0 79.3 0.9800796812749 82 17 98 0 250 5 607 688 KAH9404896.1 hypothetical protein TYRP_000729 [Tyrophagus putrescentiae] diamond 246 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
28474198 28474198 PRJNA757618_P_NODE_36766_length_247_cov_0.896552_g35714_i0 PRJNA757618 36766 247 0.896552 2.21448344 Halotydeus destructor 2874060 Arthropoda Arthropoda 55.1 1.23e-6   NR KAI1302366.1 2874060 g35714 i0 52.8 0.437246963562753 36 17 43.7 0 247 140 209 244 KAI1302366.1 Ribonuclease 2 [Halotydeus destructor] diamond 108 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
28726724 28726724 PRJNA757618_P_NODE_12467_length_324_cov_1.231076_g11415_i0 PRJNA757618 12467 324 1.231076 3.98868624 Sitophilus oryzae 7048 Arthropoda Arthropoda 89 1.3e-18   NR XP_030761880.1 7048 g11415 i0 35.3 0.944444444444444 102 66 94.4 0 308 3 132 233 XP_030761880.1 tRNA methyltransferase 10 homolog A-like [Sitophilus oryzae] diamond 306 89 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Sitophilus Sitophilus oryzae
29515880 29515880 PRJNA757618_P_NODE_22370_length_267_cov_1.577320_g21318_i0 PRJNA757618 22370 267 1.57732 4.2114444 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 93.2 2.15e-20   NR KAH9391432.1 59818 g21318 i0 98.6 0.797752808988764 71 1 79.8 0 55 267 100 170 KAH9391432.1 Caveolin-1 [Tyrophagus putrescentiae] diamond 213 93.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
29999749 29999749 PRJNA757618_P_NODE_39251_length_246_cov_0.901734_g38199_i0 PRJNA757618 39251 246 0.901734 2.21826564 Sarcoptiformes 83137 Arthropoda Arthropoda 76.6 4.38e-14   NR XP_046909145.1 6954 g38199 i0 49.3 4.48780487804878 73 37 89 0 224 6 612 684 XP_046909145.1 uncharacterized protein LOC124490652 [Dermatophagoides farinae] diamond 1104 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
30316053 30316053 PRJNA757618_P_NODE_43072_length_244_cov_0.912281_g42020_i0 PRJNA757618 43072 244 0.912281 2.22596564 Arthropoda 6656 Arthropoda Arthropoda 61.2 1.01e-8   NR XP_046658813.1 197043 g42020 i0 71.4 3.55327868852459 35 10 43 0 2 106 220 254 XP_046658813.1 phosphatidylinositol 4-kinase type 2-beta [Homalodisca vitripennis] diamond 867 61.6 0.993506493506494 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
30716338 30716338 PRJNA757618_P_NODE_31914_length_250_cov_0.875706_g30862_i0 PRJNA757618 31914 250 0.875706 2.189265 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 149 1.53e-41   NR KAH9409359.1 59818 g30862 i0 100 0.9 75 0 90 0 3 227 321 395 KAH9409359.1 hypothetical protein TYRP_010362 [Tyrophagus putrescentiae] diamond 225 149 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
32076091 32076091 PRJNA757618_P_NODE_31698_length_250_cov_0.881356_g30646_i0 PRJNA757618 31698 250 0.881356 2.20339 Lasius platythorax 488582 Arthropoda Arthropoda 108 4.16e-26   NR CAL1678200.1 488582 g30646 i0 83.6 0.66 55 9 66 0 1 165 228 282 CAL1678200.1 unnamed protein product [Lasius platythorax] diamond 165 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius platythorax

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