RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJEB2333" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB2333 · 19 ✖
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
22860 22860 PRJEB2333_P_NODE_2361_length_669_cov_2.767405_g1604_i0 PRJEB2333 2361 669 2.767405 18.51393945 Atypus heterothecus 1649349 Arthropoda Arthropoda 100 2.35e-16   NTclustered gi|818931526|gb|KP229783.1| 1649349 g1604 i0 81.538 11.3139013452915 130 17 19 7 199 322 6 134 Atypus heterothecus voucher XUXI-2012-004 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 7569 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Atypidae Atypus Atypus heterothecus
22866 22866 PRJEB2333_P_NODE_4901_length_150_cov_1.380531_g4124_i0 PRJEB2333 4901 150 1.380531 2.0707965 Tydeidae sp. 2945581 Arthropoda Arthropoda 250 4.04e-62   NTclustered gi|2240866578|gb|ON555693.1| 2945581 g4124 i0 96.689 54.5333333333333 151 3 100 2 1 150 268 417 Tydeidae sp. isolate FP100 large subunit ribosomal RNA gene, partial sequence blastn 8180 250 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tydeidae   Tydeidae sp.
2261427 2261427 PRJEB2333_P_NODE_2522_length_579_cov_3.488930_g1755_i0 PRJEB2333 2522 579 3.48893 20.2009047 Lorryia 708297 Arthropoda Arthropoda 359 3.01e-94   NTclustered gi|2240866606|gb|ON555721.1| 2945569 g1755 i0 89.384 20.7720207253886 292 22 70 8 292 579 1682 1396 Lorryia aff. praefata isolate FP236 small subunit ribosomal RNA gene, partial sequence blastn 12027 359 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tydeidae Lorryia Lorryia aff. praefata
7675149 7675149 PRJEB2333_P_NODE_4347_length_167_cov_1.784615_g3570_i0 PRJEB2333 4347 167 1.784615 2.98030705 Eiconaxius agassizi 2734661 Arthropoda Arthropoda 52.8 0.014   NTclustered gi|1839355201|gb|MN237769.1| 2734661 g3570 i0 100 0.167664670658683 28 0 17 0 3 30 390 363 Eiconaxius agassizi isolate 357EcAgssi large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Axiidae Eiconaxius Eiconaxius agassizi
11189491 11189491 PRJEB2333_P_NODE_2989_length_446_cov_5.936430_g2215_i0 PRJEB2333 2989 446 5.93643 26.4764778 Coleoptera 7041 Arthropoda Arthropoda 220 1.12e-52   NTclustered gi|2715164233|ref|XR_010336169.1| 7070 g2215 i0 97.656 42.7847533632287 128 3 29 0 257 384 3708 3581 PREDICTED: Tribolium castaneum large subunit ribosomal RNA (LOC135267796), rRNA blastn 19082 220 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
11500901 11500901 PRJEB2333_P_NODE_3030_length_441_cov_3.643564_g2255_i0 PRJEB2333 3030 441 3.643564 16.06811724 Meligethes sp. MJM-2013 1663392 Arthropoda Arthropoda 344 6.279999999999999e-90   NTclustered gi|872322676|gb|KC966631.1| 1663392 g2255 i0 100 54.7256235827664 186 0 79 0 1 186 582 397 Meligethes sp. MJM-2013 voucher BYU CO380 28S ribosomal RNA gene, partial sequence blastn 24134 344 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Meligethes Meligethes sp. MJM-2013
12776455 12776455 PRJEB2333_P_NODE_2711_length_502_cov_1.576344_g1941_i0 PRJEB2333 2711 502 1.576344 7.91324688 Tydeidae sp. 2945581 Arthropoda Arthropoda 279 2.07e-70   NTclustered gi|2240866578|gb|ON555693.1| 2945581 g1941 i0 96.45 17.8585657370518 169 5 69 1 1 169 1085 918 Tydeidae sp. isolate FP100 large subunit ribosomal RNA gene, partial sequence blastn 8965 279 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tydeidae   Tydeidae sp.
14050991 14050991 PRJEB2333_P_NODE_4392_length_166_cov_1.162791_g3615_i0 PRJEB2333 4392 166 1.162791 1.93023306 Dalotia coriaria 877792 Arthropoda Arthropoda 167 4.76e-37   NTclustered gi|2732256169|ref|XM_065306284.1| 877792 g3615 i0 95.238 64.5963855421687 105 5 63 0 60 164 1303 1199 PREDICTED: Atheta coriaria actin, muscle (LOC135794841), mRNA blastn 10723 167 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Dalotia Dalotia coriaria
16599681 16599681 PRJEB2333_P_NODE_2234_length_762_cov_2.012414_g1490_i0 PRJEB2333 2234 762 2.012414 15.33459468 Tydeidae sp. 2945581 Arthropoda Arthropoda 239 5.47e-58   NTclustered gi|2240866578|gb|ON555693.1| 2945581 g1490 i0 93.333 18.9146981627297 165 5 52 3 305 467 1509 1669 Tydeidae sp. isolate FP100 large subunit ribosomal RNA gene, partial sequence blastn 14413 239 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tydeidae   Tydeidae sp.
16599685 16599685 PRJEB2333_P_NODE_2994_length_446_cov_1.227384_g2220_i0 PRJEB2333 2994 446 1.227384 5.47413264 Helicoverpa assulta 52344 Arthropoda Arthropoda 52.8 0.043   NTclustered gi|2636206755|emb|OY979781.1| 52344 g2220 i0 100 0.228699551569507 28 0 6 0 353 380 8315215 8315242 Helicoverpa assulta genome assembly, chromosome: 7 blastn 102 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Helicoverpa Helicoverpa assulta
16599686 16599686 PRJEB2333_P_NODE_3034_length_441_cov_0.537129_g2259_i0 PRJEB2333 3034 441 0.537129 2.36873889 Hydrometra stagnorum 446445 Arthropoda Arthropoda 141 8.85e-29   NTclustered gi|1131051030|gb|KX821841.1| 446445 g2259 i0 90.741 0.351473922902494 108 7 35 3 1 107 1085 1190 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 155 141 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
17874472 17874472 PRJEB2333_P_NODE_2975_length_450_cov_1.392252_g2202_i0 PRJEB2333 2975 450 1.392252 6.265134 Aethina tumida 116153 Arthropoda Arthropoda 272 3.07e-68   NTclustered gi|2284713038|ref|XR_007547965.1| 116153 g2202 i0 96.914 85.2111111111111 162 5 59 0 289 450 2424 2263 PREDICTED: Aethina tumida large subunit ribosomal RNA (LOC126265483), rRNA blastn 38345 272 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Aethina Aethina tumida
18837983 18837983 PRJEB2333_P_NODE_4495_length_162_cov_1.280000_g3718_i0 PRJEB2333 4495 162 1.28 2.0736 Coleoptera 7041 Arthropoda Arthropoda 300 4.36e-77   NTclustered gi|37223283|gb|AY310660.1| 186067 g3718 i0 100 100 162 0 100 0 1 162 2190 2029 Cucujus clavipes 28S ribosomal RNA gene, partial sequence blastn 16200 300 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cucujidae Cucujus Cucujus clavipes
20423574 20423574 PRJEB2333_P_NODE_2677_length_513_cov_2.834034_g1907_i0 PRJEB2333 2677 513 2.834034 14.53859442 Lorryia sp. 2945573 Arthropoda Arthropoda 244 7.72e-60   NTclustered gi|2240866603|gb|ON555718.1| 2945573 g1907 i0 96 18.8421052631579 150 6 74 0 364 513 281 132 Lorryia sp. isolate FP301 large subunit ribosomal RNA gene, partial sequence blastn 9666 244 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tydeidae Lorryia Lorryia sp.
21699595 21699595 PRJEB2333_P_NODE_4858_length_151_cov_1.614035_g4081_i0 PRJEB2333 4858 151 1.614035 2.43719285 Harmonia axyridis 115357 Arthropoda Arthropoda 130 5.53e-26   NTclustered gi|2170063887|ref|XM_045621439.1| 115357 g4081 i0 83.824 24.5827814569536 136 22 90 0 6 141 1108 1243 PREDICTED: Harmonia axyridis actin-5C (LOC123682682), transcript variant X1, mRNA blastn 3712 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Harmonia Harmonia axyridis
28858301 28858301 PRJEB2333_P_NODE_2668_length_516_cov_1.396660_g1898_i0 PRJEB2333 2668 516 1.39666 7.2067656 Opisthokonta 33154 Arthropoda Arthropoda 69.3 9.03e-12   NR XP_037084519.1 41117 g1898 i0 36.2 3.01162790697674 127 67 73.3 2 496 119 1 114 XP_037084519.1 60S ribosomal protein L34-like [Pollicipes pollicipes] diamond 1554 69.7 0.994261119081779 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
29016599 29016599 PRJEB2333_P_NODE_2928_length_457_cov_1.321429_g2156_i0 PRJEB2333 2928 457 1.321429 6.03893053 Arachnida 6854 Arthropoda Arthropoda 212 2.54e-66   NR KAF7495963.1 52283 g2156 i0 66.9 25.9299781181619 151 50 99.1 0 5 457 84 234 KAF7495963.1 40S ribosomal protein S2 [Sarcoptes scabiei] diamond 11850 213 0.995305164319249 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei
30343219 30343219 PRJEB2333_P_NODE_3512_length_273_cov_1.567797_g2735_i0 PRJEB2333 3512 273 1.567797 4.28008581 Opisthokonta 33154 Arthropoda Arthropoda 106 1.42e-26   NR XP_013790258.1 6850 g2735 i0 62.7 18.6043956043956 83 31 91.2 0 3 251 75 157 XP_013790258.1 60S ribosomal protein L17-like [Limulus polyphemus] diamond 5079 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
32049784 32049784 PRJEB2333_P_NODE_2638_length_527_cov_1.008163_g1868_i0 PRJEB2333 2638 527 1.008163 5.31301901 Insecta 50557 Arthropoda Arthropoda 68.2 3.12e-10   NR XP_044753161.1 41139 g1868 i0 53.8 1.65085388994307 65 29 37 1 37 231 158 221 XP_044753161.1 60S ribosomal protein L10 [Coccinella septempunctata] diamond 870 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata

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