RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1263632" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1263632 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
4190880 4190880 PRJNA1263632_P_NODE_6724_length_249_cov_1.744318_g6706_i0 PRJNA1263632 6724 249 1.744318 4.34335182 Diachasmimorpha longicaudata 58733 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2706563758|ref|XM_064133614.1| 58733 g6706 i0 97.059 0.136546184738956 34 0 14 1 88 121 1174 1206 PREDICTED: Diachasmimorpha longicaudata uncharacterized LOC135168959 (LOC135168959), mRNA blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Diachasmimorpha Diachasmimorpha longicaudata
6741592 6741592 PRJNA1263632_P_NODE_8446_length_241_cov_0.916667_g8428_i0 PRJNA1263632 8446 241 0.916667 2.20916747 Daphnia carinata 120202 Arthropoda Arthropoda 174 4.4399999999999997e-39   NTclustered gi|2577075302|ref|XM_057525616.2| 120202 g8428 i0 80.702 11.1203319502075 228 41 94 3 14 239 847 621 PREDICTED: Daphnia carinata ATP synthase subunit alpha, mitochondrial-like (LOC130704142), mRNA blastn 2680 174 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia carinata
8017030 8017030 PRJNA1263632_P_NODE_2347_length_397_cov_0.891975_g2329_i0 PRJNA1263632 2347 397 0.891975 3.54114075 Glossina fuscipes 7396 Arthropoda Arthropoda 54.7 0.011   NTclustered gi|1939362760|ref|XM_038023609.1| 7396 g2329 i0 96.875 0.0806045340050378 32 1 8 0 193 224 2252 2221 PREDICTED: Glossina fuscipes alpha-protein kinase 1 (LOC119631426), mRNA blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina fuscipes
8017172 8017172 PRJNA1263632_P_NODE_7127_length_247_cov_1.206897_g7109_i0 PRJNA1263632 7127 247 1.206897 2.98103559 Hydrometra stagnorum 446445 Arthropoda Arthropoda 250 7.38e-62   NTclustered gi|1131051030|gb|KX821841.1| 446445 g7109 i0 85.385 39.8421052631579 260 17 100 16 1 247 1310 1059 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 9841 250 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
10567732 10567732 PRJNA1263632_P_NODE_1509_length_486_cov_2.476998_g1491_i0 PRJNA1263632 1509 486 2.476998 12.03821028 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g1491 i0 100 2.84567901234568 30 0 6 0 203 232 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
10567853 10567853 PRJNA1263632_P_NODE_589_length_744_cov_1.847988_g572_i0 PRJNA1263632 589 744 1.847988 13.74903072 Papilio polytes 76194 Arthropoda Arthropoda 1349 0   NTclustered gi|389615034|dbj|AK405121.1| 76194 g572 i0 99.593 22.6572580645161 738 3 99 0 1 738 738 1 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 16857 1349 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
15081621 15081621 PRJNA1263632_P_NODE_4172_length_304_cov_1.419913_g4154_i0 PRJNA1263632 4172 304 1.419913 4.31653552 Opisthokonta 33154 Arthropoda Arthropoda 99 3.59e-16   NTclustered gi|17979676|gb|AF291874.1| 6943 g4154 i0 82.5 39.3618421052632 120 14 39 6 35 152 7163 7049 Amblyomma americanum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 11966 100 0.99 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Amblyomma Amblyomma americanum
15666624 15666624 PRJNA1263632_P_NODE_4773_length_288_cov_1.293023_g4755_i0 PRJNA1263632 4773 288 1.293023 3.72390624 Pachyrhinus yasumatsui 2071596 Arthropoda Arthropoda 303 6.66e-78   NTclustered gi|2284955655|gb|OK105108.1| 2071596 g4755 i0 88.98 86.8541666666667 245 27 85 0 13 257 1 245 Pachyrhinus yasumatsui elongation factor 1-alpha mRNA, complete cds blastn 25014 303 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Pachyrhinus Pachyrhinus yasumatsui
20765391 20765391 PRJNA1263632_P_NODE_8437_length_241_cov_0.916667_g8419_i0 PRJNA1263632 8437 241 0.916667 2.20916747 Teleopsis dalmanni 139649 Arthropoda Arthropoda 213 9.4e-51   NTclustered gi|1941875015|ref|XM_038091273.1| 139649 g8419 i0 83.333 51.6763485477178 234 35 96 3 9 240 881 650 PREDICTED: Teleopsis dalmanni V-type proton ATPase subunit B (LOC119679098), mRNA blastn 12454 213 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Diopsidae Teleopsis Teleopsis dalmanni
24006003 24006003 PRJNA1263632_P_NODE_2719_length_370_cov_1.346801_g2701_i0 PRJNA1263632 2719 370 1.346801 4.9831637 Diptera 7147 Arthropoda Arthropoda 235 3.25e-57   NTclustered gi|2568208206|ref|XM_005176726.4| 7370 g2701 i0 78.32 94.4216216216216 369 76 99 3 1 367 1251 1617 PREDICTED: Musca domestica ATP synthase subunit beta, mitochondrial (LOC101901126), transcript variant X1, mRNA blastn 34936 235 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca domestica

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