RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA853203" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA853203 · 19 ✖

analysis 1

  • blastn · 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
4669758 4669758 PRJNA853203_P_NODE_1284_length_538_cov_1.774194_g1137_i0 PRJNA853203 1284 538 1.774194 9.54516372 Timema douglasi 61478 Arthropoda Arthropoda 894 0   NTclustered gi|1936766486|emb|OA594500.1| 61478 g1137 i0 97.18 0.988847583643123 532 9 99 2 1 532 1367 1892 1_Tdi_b3v08 blastn 532 894 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
4669778 4669778 PRJNA853203_P_NODE_15544_length_276_cov_1.280788_g15395_i0 PRJNA853203 15544 276 1.280788 3.53497488 Nylanderia fulva 613905 Arthropoda Arthropoda 52.8 0.025   NTclustered gi|1663685982|ref|XM_029303125.1| 613905 g15395 i0 100 0.101449275362319 28 0 10 0 209 236 461 488 PREDICTED: Nylanderia fulva ras-related protein Rab-5C (LOC114931154), transcript variant X1, mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Nylanderia Nylanderia fulva
4669985 4669985 PRJNA853203_P_NODE_41364_length_245_cov_0.906977_g41215_i0 PRJNA853203 41364 245 0.906977 2.22209365 Rhagoletis zephyria 28612 Arthropoda Arthropoda 58.4 4.75e-4   NTclustered gi|1048046004|ref|XM_017639019.1| 28612 g41215 i0 92.683 0.16734693877551 41 1 16 2 7 46 408 369 PREDICTED: Rhagoletis zephyria histone H1E-like (LOC108382644), mRNA blastn 41 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
5944790 5944790 PRJNA853203_P_NODE_7585_length_301_cov_1.250000_g7436_i0 PRJNA853203 7585 301 1.25 3.7625 Schwenckfeldina sp. MAB-2008 560270 Arthropoda Arthropoda 449 8.499999999999999e-122   NTclustered gi|202070884|gb|FJ040523.1| 560270 g7436 i0 95.699 93.1661129568106 279 12 93 0 22 300 1 279 Schwenckfeldina sp. MAB-2008 28S ribosomal RNA gene, partial sequence blastn 28043 449 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Schwenckfeldina Schwenckfeldina sp. MAB-2008
9769516 9769516 PRJNA853203_P_NODE_34388_length_249_cov_0.886364_g34239_i0 PRJNA853203 34388 249 0.886364 2.20704636 Musca domestica 7370 Arthropoda Arthropoda 117 7.88e-22   NTclustered gi|2568177617|ref|XM_011293505.3| 7370 g34239 i0 92.683 3.79919678714859 82 5 33 1 31 112 3866 3946 PREDICTED: Musca domestica uncharacterized LOC101888419 (LOC101888419), mRNA blastn 946 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca domestica
10163195 10163195 PRJNA853203_P_NODE_35988_length_248_cov_0.891429_g35839_i0 PRJNA853203 35988 248 0.891429 2.21074392 Diptera 7147 Arthropoda Arthropoda 459 1.13e-124   NTclustered gi|224016355|gb|FJ650541.1| 7375 g35839 i0 100 99.4516129032258 248 0 100 0 1 248 1037 790 Lucilia cuprina isolate FL_USA_AA06 28S ribosomal RNA gene, partial sequence blastn 24664 459 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
12320635 12320635 PRJNA853203_P_NODE_25110_length_255_cov_2.142857_g24961_i0 PRJNA853203 25110 255 2.142857 5.46428535 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1963356111|emb|OE839880.1| 629358 g24961 i0 100 0.333333333333333 29 0 11 0 59 87 215449 215421 5_Tge_b3v08 blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
12320727 12320727 PRJNA853203_P_NODE_38770_length_246_cov_1.942197_g38621_i0 PRJNA853203 38770 246 1.942197 4.77780462 Daphnia pulex 6669 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2192734159|ref|XM_046600325.1| 6669 g38621 i0 94.595 0.601626016260163 37 0 14 2 89 123 8498 8462 PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA blastn 148 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
17812170 17812170 PRJNA853203_P_NODE_36714_length_248_cov_0.891429_g36565_i0 PRJNA853203 36714 248 0.891429 2.21074392 root 1 Root_unresolved Root_unresolved 448 2.4499999999999996e-121   NTclustered gi|78190082|gb|AC168047.3| 7176 g36565 i0 99.194 14.5 248 2 100 0 1 248 32267 32020 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 3596 448 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
18692857 18692857 PRJNA853203_P_NODE_4435_length_346_cov_0.695971_g4286_i0 PRJNA853203 4435 346 0.695971 2.40805966 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.033   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g4286 i0 100 0.0809248554913295 28 0 8 0 7 34 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
18692925 18692925 PRJNA853203_P_NODE_9235_length_291_cov_1.247706_g9086_i0 PRJNA853203 9235 291 1.247706 3.63082446 Temnothorax curvispinosus 300111 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|1387169192|ref|XM_025019741.1| 300111 g9086 i0 94.444 0.123711340206186 36 2 12 0 256 291 3111 3076 PREDICTED: Temnothorax curvispinosus leucine-rich repeat and calponin homology domain-containing protein 1 (LOC112456928), transcript variant X2, mRNA blastn 36 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Temnothorax Temnothorax curvispinosus
19968105 19968105 PRJNA853203_P_NODE_4516_length_344_cov_1.494465_g4367_i0 PRJNA853203 4516 344 1.494465 5.1409596 Orthocladius sp. 3002598 Arthropoda Arthropoda 521 2.059999999999999e-143   NTclustered gi|2485418697|gb|OQ813472.1| 3002598 g4367 i0 93.895 102.904069767442 344 21 100 0 1 344 1357 1700 Orthocladius sp. isolate EAM591 small subunit ribosomal RNA gene, partial sequence blastn 35399 521 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Orthocladius Orthocladius sp.
21243678 21243678 PRJNA853203_P_NODE_5757_length_323_cov_1.248000_g5608_i0 PRJNA853203 5757 323 1.248 4.03104 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g5608 i0 100 0.0897832817337461 29 0 9 0 84 112 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
21636802 21636802 PRJNA853203_P_NODE_44177_length_244_cov_0.912281_g44028_i0 PRJNA853203 44177 244 0.912281 2.22596564 Timema 61471 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|1947810726|emb|OD565049.1| 61472 g44028 i0 94.286 0.401639344262295 35 1 14 1 127 161 204499 204466 4_Tbi_b3v08 blastn 98 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
22912273 22912273 PRJNA853203_P_NODE_17558_length_271_cov_1.737374_g17409_i0 PRJNA853203 17558 271 1.737374 4.70828354 Timema 61471 Arthropoda Arthropoda 58.4 5.34e-4   NTclustered gi|1965052417|emb|OE274148.1| 61474 g17409 i0 92.683 0.745387453874539 41 2 15 1 149 188 240 200 2_Tcm_b3v08 blastn 202 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
24186263 24186263 PRJNA853203_P_NODE_42139_length_245_cov_0.906977_g41990_i0 PRJNA853203 42139 245 0.906977 2.22209365 Lysiphlebus 55897 Arthropoda Arthropoda 453 5.1900000000000006e-123   NTclustered gi|5326667|emb|AJ009332.1| 75917 g41990 i0 100 99.9918367346939 245 0 100 0 1 245 949 705 Lysiphlebus fabarum partial 18S rRNA gene blastn 24498 453 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Lysiphlebus Lysiphlebus fabarum
25067611 25067611 PRJNA853203_P_NODE_37500_length_247_cov_0.896552_g37351_i0 PRJNA853203 37500 247 0.896552 2.21448344 Bradysia coprophila 38358 Arthropoda Arthropoda 211 3.48e-50   NTclustered gi|1928079258|ref|XM_037187342.1| 38358 g37351 i0 91.667 0.631578947368421 156 7 63 1 1 156 1516 1665 PREDICTED: Bradysia coprophila CDK5RAP3-like protein (LOC119079431), mRNA blastn 156 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
25067618 25067618 PRJNA853203_P_NODE_38700_length_246_cov_2.612717_g38551_i0 PRJNA853203 38700 246 2.612717 6.42728382 Timema shepardi 629360 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1937883691|emb|OC005375.1| 629360 g38551 i0 100 0.117886178861789 29 0 12 0 130 158 44400 44372 2_Tsi_b3v08 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema shepardi
25461376 25461376 PRJNA853203_P_NODE_40880_length_245_cov_1.587209_g40731_i0 PRJNA853203 40880 245 1.587209 3.88866205 Opisthokonta 33154 Arthropoda Arthropoda 86.1 2.18e-12   NTclustered gi|16215382|emb|AJ251734.2| 48714 g40731 i0 90.769 24.6285714285714 65 4 26 2 178 240 785 849 Thaumanura ruffoi partial 28S rRNA gene blastn 6034 86.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Poduromorpha Neanuridae Thaumanura Thaumanura ruffoi

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