RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA886442" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA886442 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
2137281 2137281 PRJNA886442_P_NODE_11702_length_250_cov_0.881356_g11538_i0 PRJNA886442 11702 250 0.881356 2.20339 Drosophila melanogaster 7227 Arthropoda Arthropoda 462 8.83e-126   NTclustered gi|14028971|gb|AC008209.5|AC008209 7227 g11538 i0 100 9.08 250 0 100 0 1 250 50188 49939 Drosophila melanogaster, chromosome 3R, region 96F-96F, BAC clone BACR06K17, complete sequence blastn 2270 462 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
2517090 2517090 PRJNA886442_P_NODE_9522_length_262_cov_1.238095_g9358_i0 PRJNA886442 9522 262 1.238095 3.2438089 root 1 Root_unresolved Root_unresolved 473 4.31e-129   NTclustered gi|78097481|gb|AC167665.2| 7176 g9358 i0 99.237 19.0725190839695 262 2 100 0 1 262 27468 27729 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940135D9, complete sequence blastn 4997 473 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
3412595 3412595 PRJNA886442_P_NODE_11403_length_251_cov_0.876404_g11239_i0 PRJNA886442 11403 251 0.876404 2.19977404 Nomia melanderi 2448451 Arthropoda Arthropoda 58.4 4.89e-4   NTclustered gi|1789182277|ref|XM_031973806.1| 2448451 g11239 i0 100 1.18725099601594 31 0 12 0 217 247 5512 5482 PREDICTED: Nomia melanderi E3 ubiquitin-protein ligase RBBP6 (LOC116425729), transcript variant X2, mRNA blastn 298 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Nomia Nomia melanderi
5965268 5965268 PRJNA886442_P_NODE_8905_length_270_cov_1.395939_g8741_i0 PRJNA886442 8905 270 1.395939 3.7690353 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|1963439494|emb|OE901623.1| 629358 g8741 i0 96.875 0.118518518518519 32 1 12 0 154 185 357 388 5_Tge_b3v08 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
7619543 7619543 PRJNA886442_P_NODE_8526_length_275_cov_2.227723_g8362_i0 PRJNA886442 8526 275 2.227723 6.12623825 Araneae 6893 Arthropoda Arthropoda 464 2.7399999999999998e-126   NTclustered gi|1148357621|gb|KY017144.1| 685669 g8362 i0 97.101 99.9890909090909 276 7 100 1 1 275 1028 1303 Haplinis diloris isolate ARAGH000070 28S ribosomal RNA gene, partial sequence blastn 27497 464 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Linyphiidae Haplinis Haplinis diloris
11065534 11065534 PRJNA886442_P_NODE_8969_length_269_cov_1.306122_g8805_i0 PRJNA886442 8969 269 1.306122 3.51346818 Macrobrachium nipponense 159736 Arthropoda Arthropoda 224 4.929999999999999e-54   NTclustered gi|2708562388|ref|XM_064231724.1| 159736 g8805 i0 81.919 17.271375464684 271 43 99 3 1 268 1223 956 PREDICTED: Macrobrachium nipponense ATP synthase subunit alpha, mitochondrial-like (LOC135202360), mRNA blastn 4646 224 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
11445243 11445243 PRJNA886442_P_NODE_12809_length_247_cov_0.896552_g12645_i0 PRJNA886442 12809 247 0.896552 2.21448344 root 1 Root_unresolved Root_unresolved 451 1.88e-122   NTclustered gi|78097481|gb|AC167665.2| 7176 g12645 i0 99.595 21.8178137651822 247 1 100 0 1 247 49460 49706 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940135D9, complete sequence blastn 5389 451 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
13615592 13615592 PRJNA886442_P_NODE_6631_length_304_cov_1.683983_g6467_i0 PRJNA886442 6631 304 1.683983 5.11930832 Trichogramma pretiosum 7493 Arthropoda Arthropoda 106 2.14e-18   NTclustered gi|1321345895|ref|XM_014368233.2| 7493 g6467 i0 81.818 2.53289473684211 132 19 42 5 152 280 436 307 PREDICTED: Trichogramma pretiosum cytochrome c-2 (LOC106650302), transcript variant X1, mRNA blastn 770 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma pretiosum
16164703 16164703 PRJNA886442_P_NODE_5253_length_333_cov_1.130769_g5089_i0 PRJNA886442 5253 333 1.130769 3.76546077 Agapeta hamana 1100904 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|2918369971|emb|OZ237863.1| 1100904 g5089 i0 94.286 0.105105105105105 35 2 11 0 95 129 16934804 16934838 Agapeta hamana genome assembly, chromosome: 4 blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
17440016 17440016 PRJNA886442_P_NODE_12134_length_249_cov_0.886364_g11970_i0 PRJNA886442 12134 249 0.886364 2.20704636 Drosophila melanogaster 7227 Arthropoda Arthropoda 460 3.16e-125   NTclustered gi|50872261|gb|AC092222.2| 7227 g11970 i0 100 15 249 0 100 0 1 249 86293 86045 Drosophila melanogaster clone BACR16I01, complete sequence blastn 3735 460 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
17440118 17440118 PRJNA886442_P_NODE_4674_length_347_cov_2.138686_g4510_i0 PRJNA886442 4674 347 2.138686 7.42124042 Euthrix potatoria 624169 Arthropoda Arthropoda 52.8 0.033   NTclustered gi|2918370001|emb|OZ237888.1| 624169 g4510 i0 100 0.0806916426512968 28 0 8 0 130 157 4844014 4844041 Euthrix potatoria genome assembly, chromosome: 16 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
19988446 19988446 PRJNA886442_P_NODE_10596_length_252_cov_2.659218_g10432_i0 PRJNA886442 10596 252 2.659218 6.70122936 Anarta stigmosa 1869462 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2918376566|emb|OZ237991.1| 1869462 g10432 i0 100 0.337301587301587 29 0 12 0 7 35 20686917 20686945 Anarta stigmosa genome assembly, chromosome: 15 blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Anarta Anarta stigmosa
19988540 19988540 PRJNA886442_P_NODE_2956_length_414_cov_1.372434_g2792_i0 PRJNA886442 2956 414 1.372434 5.68187676 Megalopta genalis 115081 Arthropoda Arthropoda 150 1.37e-31   NTclustered gi|1832193449|ref|XM_033474905.1| 115081 g2792 i0 91.667 11.9178743961353 108 9 26 0 1 108 331 438 PREDICTED: Megalopta genalis histone H3.3A (LOC117222886), transcript variant X3, mRNA blastn 4934 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Megalopta Megalopta genalis
19988576 19988576 PRJNA886442_P_NODE_5576_length_325_cov_1.238095_g5412_i0 PRJNA886442 5576 325 1.238095 4.02380875 Satyrium ilicis 876074 Arthropoda Arthropoda 58.4 6.56e-4   NTclustered gi|2918386101|emb|OZ238115.1| 876074 g5412 i0 90.698 0.132307692307692 43 4 13 0 84 126 56559195 56559237 Satyrium ilicis genome assembly, chromosome: 6 blastn 43 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Satyrium Satyrium ilicis
21263850 21263850 PRJNA886442_P_NODE_14637_length_243_cov_0.917647_g14473_i0 PRJNA886442 14637 243 0.917647 2.22988221 Timema bartmani 61472 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1946277497|emb|OD564950.1| 61472 g14473 i0 100 0.119341563786008 29 0 12 0 183 211 204957 204985 4_Tbi_b3v08 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani

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