RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA785164", tax_clade = "Opisthokonta" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 16 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 16 ✖

bioproject 1

  • PRJNA785164 · 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
4594339 4594339 PRJNA785164_P_NODE_34604_length_308_cov_2.468085_g34139_i0 PRJNA785164 34604 308 2.468085 7.6017018 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|2919539186|emb|OZ238349.1| 1002887 g34139 i0 100 0.0941558441558442 29 0 9 0 218 246 20155145 20155117 Glaucopsyche melanops genome assembly, chromosome: 8 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
4594460 4594460 PRJNA785164_P_NODE_39804_length_286_cov_0.868545_g39339_i0 PRJNA785164 39804 286 0.868545 2.4840387 Drosophila melanogaster 7227 Arthropoda Arthropoda 368 2.31e-97   NTclustered gi|56787662|gb|AC022351.3| 7227 g39339 i0 99.024 45.5629370629371 205 2 72 0 27 231 3103 2899 Drosophila melanogaster clone BACR29G15, complete sequence blastn 13031 368 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
5041911 5041911 PRJNA785164_P_NODE_64484_length_216_cov_5.069930_g64019_i0 PRJNA785164 64484 216 5.06993 10.9510488 Bombus 28641 Arthropoda Arthropoda 52.8 0.019   NTclustered gi|2832700248|ref|XR_011174825.1| 103934 g64019 i0 100 0.259259259259259 28 0 13 0 95 122 1433 1460 PREDICTED: Bombus flavifrons uncharacterized lncRNA (LOC138186175), ncRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus flavifrons
7144132 7144132 PRJNA785164_P_NODE_15046_length_517_cov_7.716216_g14581_i0 PRJNA785164 15046 517 7.716216 39.89283672 Polyergus mexicanus 615972 Arthropoda Arthropoda 54.7 0.014   NTclustered gi|2868444854|ref|XM_070292720.1| 615972 g14581 i0 100 0.0560928433268859 29 0 6 0 91 119 2814 2842 PREDICTED: Polyergus mexicanus sodium/calcium exchanger Calx (Calx), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Polyergus Polyergus mexicanus
8866623 8866623 PRJNA785164_P_NODE_37167_length_296_cov_1.381166_g36702_i0 PRJNA785164 37167 296 1.381166 4.08825136 Tephritidae 7211 Arthropoda Arthropoda 52.8 0.027   NTclustered gi|1913945052|ref|XM_036480072.1| 28610 g36702 i0 100 0.483108108108108 28 0 9 0 1 28 3375 3402 PREDICTED: Rhagoletis pomonella heparan-sulfate 6-O-sulfotransferase 1 (LOC118746241), mRNA blastn 143 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis pomonella
10970950 10970950 PRJNA785164_P_NODE_64609_length_211_cov_4.391304_g64144_i0 PRJNA785164 64609 211 4.391304 9.26565144 Satyrium ilicis 876074 Arthropoda Arthropoda 58.4 3.98e-4   NTclustered gi|2918386101|emb|OZ238115.1| 876074 g64144 i0 90.698 0.203791469194313 43 4 20 0 116 158 56559195 56559237 Satyrium ilicis genome assembly, chromosome: 6 blastn 43 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
17345006 17345006 PRJNA785164_P_NODE_60594_length_242_cov_1.207101_g60129_i0 PRJNA785164 60594 242 1.207101 2.92118442 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2024282833|ref|XM_040726472.1| 72036 g60129 i0 94.286 0.144628099173554 35 2 14 0 51 85 832 798 PREDICTED: Lepeophtheirus salmonis GATA zinc finger domain-containing protein 14-like (LOC121130796), mRNA blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
18617535 18617535 PRJNA785164_P_NODE_29695_length_336_cov_1.292776_g29230_i0 PRJNA785164 29695 336 1.292776 4.34372736 Trichogramma pretiosum 7493 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1321347915|ref|XM_023460776.1| 7493 g29230 i0 100 0.0863095238095238 29 0 9 0 35 63 380 408 PREDICTED: Trichogramma pretiosum serine protease easter-like (LOC111694077), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
18617945 18617945 PRJNA785164_P_NODE_46755_length_263_cov_1.484211_g46290_i0 PRJNA785164 46755 263 1.484211 3.90347493 Leiobunum subalpinum 3086104 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2920023896|emb|OZ239120.1| 3086104 g46290 i0 100 0.110266159695817 29 0 11 0 161 189 31171972 31172000 Leiobunum subalpinum genome assembly, chromosome: 3 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Opiliones Sclerosomatidae Leiobunum Leiobunum subalpinum
19892498 19892498 PRJNA785164_P_NODE_14736_length_524_cov_3.600887_g14272_i0 PRJNA785164 14736 524 3.600887 18.86864788 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|1965181363|emb|OE475415.1| 61474 g14272 i0 90.909 0.083969465648855 44 1 8 2 169 209 309 266 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
28095951 28095951 PRJNA785164_P_NODE_50965_length_251_cov_1.426966_g50500_i0 PRJNA785164 50965 251 1.426966 3.58168466 Trinorchestia longiramus 1923959 Arthropoda Arthropoda 51.6 3.08e-5   NR KAF2353244.1 1923959 g50500 i0 37.5 4.49402390438247 64 36 76.5 1 250 59 528 587 KAF2353244.1 Transposase type 1 [Trinorchestia longiramus] diamond 1128 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Talitridae Trinorchestia Trinorchestia longiramus
28926062 28926062 PRJNA785164_P_NODE_56768_length_246_cov_0.890173_g56303_i0 PRJNA785164 56768 246 0.890173 2.18982558 Miridae 30083 Arthropoda Arthropoda 152 1.09e-40   NR KAF6204472.1 248454 g56303 i0 76.5 1.97560975609756 81 19 98.8 0 245 3 1097 1177 KAF6204472.1 hypothetical protein GE061_002813 [Apolygus lucorum] diamond 486 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Apolygus Apolygus lucorum
28980210 28980210 PRJNA785164_P_NODE_58248_length_244_cov_1.497076_g57783_i0 PRJNA785164 58248 244 1.497076 3.65286544 Homalodisca vitripennis 197043 Arthropoda Arthropoda 41.6 0.044   NR KAG8265275.1 197043 g57783 i0 39.1 0.848360655737705 69 36 77.5 2 31 219 51 119 KAG8265275.1 hypothetical protein J6590_098403 [Homalodisca vitripennis] diamond 207 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
30653839 30653839 PRJNA785164_P_NODE_55993_length_246_cov_2.606936_g55528_i0 PRJNA785164 55993 246 2.606936 6.41306256 Eumeta japonica 151549 Arthropoda Arthropoda 41.2 0.034   NR GBP06203.1 151549 g55528 i0 40 0.609756097560976 50 25 54.9 2 163 29 23 72 GBP06203.1 hypothetical protein EVAR_3563_1 [Eumeta japonica] diamond 150 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Psychidae Eumeta Eumeta japonica
31159135 31159135 PRJNA785164_P_NODE_30635_length_330_cov_1.844358_g30170_i0 PRJNA785164 30635 330 1.844358 6.0863814 Lasioglossum lativentre 88531 Arthropoda Arthropoda 51.2 9.84e-5   NR ALO64872.1 88531 g30170 i0 37 0.736363636363636 81 51 73.6 0 3 245 168 248 ALO64872.1 cytochrome b [Lasioglossum lativentre] diamond 243 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Lasioglossum Lasioglossum lativentre
32866267 32866267 PRJNA785164_P_NODE_40340_length_284_cov_1.094787_g39875_i0 PRJNA785164 40340 284 1.094787 3.10919508 Folsomia candida 158441 Arthropoda Arthropoda 125 3.8699999999999997e-31   NR OXA59506.1 158441 g39875 i0 64.5 2.94718309859155 93 33 98.2 0 281 3 352 444 OXA59506.1 Carbonyl reductase [NADPH] 1 [Folsomia candida] diamond 837 125 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida

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