RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1145574" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1145574 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
288694 288694 PRJNA1145574_P_NODE_2961_length_475_cov_1.164179_g2777_i0 PRJNA1145574 2961 475 1.164179 5.52985025 Bacillus rossius 75184 Arthropoda Arthropoda 845 0   NTclustered gi|149207940|gb|EF450634.1| 93214 g2777 i0 98.737 99.7431578947368 475 6 100 0 1 475 98 572 Bacillus rossius redtenbacheri isolate rLU elongation factor 1-alpha (ef1-alpha) gene, partial cds blastn 47378 845 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
4115645 4115645 PRJNA1145574_P_NODE_10764_length_255_cov_3.247253_g10580_i0 PRJNA1145574 10764 255 3.247253 8.28049515 Timema bartmani 61472 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1946277497|emb|OD564950.1| 61472 g10580 i0 100 0.113725490196078 29 0 11 0 195 223 204957 204985 4_Tbi_b3v08 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
4115695 4115695 PRJNA1145574_P_NODE_13924_length_245_cov_0.906977_g13740_i0 PRJNA1145574 13924 245 0.906977 2.22209365 Pieris brassicae 7116 Arthropoda Arthropoda 128 3.57e-25   NTclustered gi|2172770947|ref|XM_045662154.1| 7116 g13740 i0 86.179 14.2897959183673 123 11 48 2 8 125 1278 1157 PREDICTED: Pieris brassicae Golgi SNAP receptor complex member 1 (LOC123710332), mRNA blastn 3501 128 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Pieris Pieris brassicae
6136120 6136120 PRJNA1145574_P_NODE_12845_length_248_cov_0.891429_g12661_i0 PRJNA1145574 12845 248 0.891429 2.21074392 Timema 61471 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1936979985|emb|OA569233.1| 61478 g12661 i0 100 0.225806451612903 28 0 11 0 118 145 32033 32060 1_Tdi_b3v08 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
6666518 6666518 PRJNA1145574_P_NODE_1166_length_766_cov_8.079365_g999_i0 PRJNA1145574 1166 766 8.079365 61.8879359 Timema cristinae 61476 Arthropoda Arthropoda 60.2 4.59e-4   NTclustered gi|1946912708|emb|OC317627.1| 61476 g999 i0 92.857 0.505221932114883 42 1 5 2 709 748 144084 144043 3_Tce_b3v08 blastn 387 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
9216769 9216769 PRJNA1145574_P_NODE_9368_length_280_cov_1.859903_g9184_i0 PRJNA1145574 9368 280 1.859903 5.2077284 Pseudoterpna coronillaria 1007376 Arthropoda Arthropoda 62.1 4.29e-5   NTclustered gi|2918369770|emb|OZ237837.1| 1007376 g9184 i0 86.441 0.210714285714286 59 4 20 4 202 257 5854565 5854508 Pseudoterpna coronillaria genome assembly, chromosome: 12 blastn 59 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Pseudoterpna Pseudoterpna coronillaria
10492286 10492286 PRJNA1145574_P_NODE_12629_length_248_cov_1.782857_g12445_i0 PRJNA1145574 12629 248 1.782857 4.42148536 Bombyx mori 7091 Arthropoda Arthropoda 459 1.13e-124   NTclustered gi|2919985595|emb|OZ208568.1| 7091 g12445 i0 100 10.5564516129032 248 0 100 0 1 248 10255674 10255427 Bombyx mori genome assembly, chromosome: 19 blastn 2618 459 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
10492344 10492344 PRJNA1145574_P_NODE_5709_length_356_cov_2.530035_g5525_i0 PRJNA1145574 5709 356 2.530035 9.0069246 Diuraphis noxia 143948 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|985399333|ref|XM_015511795.1| 143948 g5525 i0 100 3.88483146067416 30 0 8 0 83 112 868 839 PREDICTED: Diuraphis noxia protein grainyhead (LOC107164101), mRNA blastn 1383 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
14317565 14317565 PRJNA1145574_P_NODE_13252_length_247_cov_0.896552_g13068_i0 PRJNA1145574 13252 247 0.896552 2.21448344 Anabrus simplex 316456 Arthropoda Arthropoda 67.6 7.97e-7   NTclustered gi|2801275359|ref|XM_067152301.2| 316456 g13068 i0 97.436 12.0647773279352 39 1 16 0 161 199 2583 2545 PREDICTED: Anabrus simplex cell division cycle and apoptosis regulator protein 1 (LOC136878809), transcript variant X2, mRNA blastn 2980 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Tettigoniidae Anabrus Anabrus simplex
15591626 15591626 PRJNA1145574_P_NODE_9393_length_280_cov_1.265700_g9209_i0 PRJNA1145574 9393 280 1.2657 3.5439600000000002 Macrobrachium rosenbergii 79674 Arthropoda Arthropoda 512 9.85e-141   NTclustered gi|2782958066|ref|XM_067095634.1| 79674 g9209 i0 99.643 7.01428571428571 280 1 100 0 1 280 4138 4417 PREDICTED: Macrobrachium rosenbergii hemocyte protein-glutamine gamma-glutamyltransferase-like (LOC136833453), transcript variant X3, mRNA blastn 1964 512 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium rosenbergii
18140417 18140417 PRJNA1145574_P_NODE_655_length_1014_cov_5.202976_g521_i0 PRJNA1145574 655 1014 5.202976 52.75817664 Nasonia vitripennis 7425 Arthropoda Arthropoda 58.4 0.002   NTclustered gi|1815722811|ref|XM_032598121.1| 7425 g521 i0 97.059 0.0335305719921105 34 1 3 0 107 140 141 108 PREDICTED: Nasonia vitripennis mucin-6-like (LOC116416952), mRNA blastn 34 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
21965499 21965499 PRJNA1145574_P_NODE_5058_length_375_cov_1.798013_g4874_i0 PRJNA1145574 5058 375 1.798013 6.74254875 Charissa obscurata 204503 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|2919571106|emb|OZ238380.1| 204503 g4874 i0 100 0.0773333333333333 29 0 8 0 91 119 5255550 5255578 Charissa obscurata genome assembly, chromosome: 14 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
23985518 23985518 PRJNA1145574_P_NODE_10519_length_260_cov_1.251337_g10335_i0 PRJNA1145574 10519 260 1.251337 3.2534762 Phytoseiidae 34636 Arthropoda Arthropoda 453 5.5600000000000005e-123   NTclustered gi|2209908498|gb|ON025568.1| 756257 g10335 i0 98.077 57.7961538461538 260 5 100 0 1 260 812 1071 Typhlodromips montdorensis isolate 1_1 large subunit ribosomal RNA gene, partial sequence blastn 15027 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Typhlodromips Typhlodromips montdorensis

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