RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA640350" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA640350 · 16 ✖

analysis 1

  • blastn · 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
610564 610564 PRJNA640350_P_NODE_5321_length_409_cov_2.292105_g5165_i0 PRJNA640350 5321 409 2.292105 9.37470945 Artemia franciscana 6661 Arthropoda Arthropoda 248 4.67e-61   NTclustered gi|2743038046|ref|XM_065715268.1| 6661 g5165 i0 97.26 94.3496332518337 146 4 66 0 264 409 5599 5744 PREDICTED: Artemia franciscana probable Bax inhibitor 1 (LOC136034119), partial mRNA blastn 38589 248 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
2431043 2431043 PRJNA640350_P_NODE_39782_length_152_cov_2.162602_g39621_i0 PRJNA640350 39782 152 2.162602 3.28715504 root 1 Root_unresolved Root_unresolved 281 1.46e-71   NTclustered gi|78190082|gb|AC168047.3| 7176 g39621 i0 100 65.5065789473684 152 0 100 0 1 152 34822 34671 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 9957 281 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
3161412 3161412 PRJNA640350_P_NODE_33443_length_164_cov_1.362963_g33282_i0 PRJNA640350 33443 164 1.362963 2.23525932 Culex quinquefasciatus 7176 Arthropoda Arthropoda 287 3.45e-73   NTclustered gi|78190082|gb|AC168047.3| 7176 g33282 i0 98.171 12 164 3 100 0 1 164 64877 64714 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 1968 287 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
3161423 3161423 PRJNA640350_P_NODE_34983_length_160_cov_5.557252_g34822_i0 PRJNA640350 34983 160 5.557252 8.8916032 Charissa obscurata 204503 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2919604802|emb|OZ238384.1| 204503 g34822 i0 96.875 0.2 32 1 20 0 30 61 19659605 19659574 Charissa obscurata genome assembly, chromosome: 18 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Charissa Charissa obscurata
4984082 4984082 PRJNA640350_P_NODE_8724_length_357_cov_2.365854_g8564_i0 PRJNA640350 8724 357 2.365854 8.44609878 Araneae 6893 Arthropoda Arthropoda 93.5 1.99e-14   NTclustered gi|939468642|gb|KT894371.1| 1738616 g8564 i0 88.312 20.2128851540616 77 9 22 0 277 353 13 89 Lasaeola tristis isolate JIE24 histone subunit 3 (H3) gene, partial cds blastn 7216 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Lasaeola Lasaeola tristis
8263826 8263826 PRJNA640350_P_NODE_7627_length_368_cov_1.764012_g7467_i0 PRJNA640350 7627 368 1.764012 6.49156416 Aphis gossypii 80765 Arthropoda Arthropoda 130 1.57e-25   NTclustered gi|28629117|gb|AF487716.1| 80765 g7467 i0 95.181 11.5869565217391 83 3 42 1 4 86 316 397 Aphis gossypii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 4264 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis gossypii
9538898 9538898 PRJNA640350_P_NODE_18688_length_238_cov_2.674641_g18527_i0 PRJNA640350 18688 238 2.674641 6.36564558 Bombyx mori 7091 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|185050622|dbj|AP009035.1| 7091 g18527 i0 100 0.470588235294118 28 0 12 0 4 31 55628 55655 Bombyx mori genomic DNA, chromosome 18, BAC clone:535J11, complete sequence blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
10084047 10084047 PRJNA640350_P_NODE_13428_length_333_cov_1.927632_g13267_i0 PRJNA640350 13428 333 1.927632 6.41901456 Diptera 7147 Arthropoda Arthropoda 206 2.2799999999999998e-48   NTclustered gi|1729047405|ref|XR_003996079.1| 7225 g13267 i0 99.123 34.2252252252252 114 1 34 0 203 316 2002 1889 PREDICTED: Scaptodrosophila lebanonensis large subunit ribosomal RNA (LOC115630241), rRNA blastn 11397 206 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Scaptodrosophila Scaptodrosophila lebanonensis
10814800 10814800 PRJNA640350_P_NODE_6629_length_383_cov_1.228814_g6469_i0 PRJNA640350 6629 383 1.228814 4.70635762 Panulirus ornatus 150431 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|2919532469|ref|XM_071662675.1| 150431 g6469 i0 96.875 1.33681462140992 32 1 8 0 349 380 6343 6374 PREDICTED: Panulirus ornatus plasma membrane calcium-transporting ATPase 3 (PMCA), transcript variant X3, mRNA blastn 512 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palinuridae Panulirus Panulirus ornatus
11359029 11359029 PRJNA640350_P_NODE_18769_length_237_cov_2.754808_g18608_i0 PRJNA640350 18769 237 2.754808 6.52889496 root 1 Root_unresolved Root_unresolved 326 1.14e-84   NTclustered gi|78190082|gb|AC168047.3| 7176 g18608 i0 94.762 104.949367088608 210 9 89 2 1 210 27677 27884 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 24873 326 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
12089954 12089954 PRJNA640350_P_NODE_38490_length_154_cov_2.504000_g38329_i0 PRJNA640350 38490 154 2.504 3.85616 Artemia franciscana 6661 Arthropoda Arthropoda 250 4.18e-62   NTclustered gi|2743078632|ref|XM_065708588.1| 6661 g38329 i0 96.104 43 154 5 100 1 1 154 861 709 PREDICTED: Artemia franciscana uncharacterized LOC136029994 (LOC136029994), mRNA blastn 6622 250 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
14639452 14639452 PRJNA640350_P_NODE_4592_length_431_cov_1.500000_g4438_i0 PRJNA640350 4592 431 1.5 6.465 Aphis citricidus 223852 Arthropoda Arthropoda 278 6.3e-70   NTclustered gi|29028559|gb|AY216697.1| 223852 g4438 i0 94.944 16.0881670533643 178 8 55 1 4 180 1022 1199 Toxoptera citricida 18S ribosomal RNA gene, complete sequence blastn 6934 278 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis citricidus
15184227 15184227 PRJNA640350_P_NODE_34092_length_162_cov_3.045113_g33931_i0 PRJNA640350 34092 162 3.045113 4.93308306 Metazoa 33208 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2081108234|ref|XM_043034813.1| 27405 g33931 i0 100 0.358024691358025 29 0 18 0 7 35 41 69 PREDICTED: Penaeus japonicus uveal autoantigen with coiled-coil domains and ankyrin repeats-like (LOC122265468), mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus japonicus
17733579 17733579 PRJNA640350_P_NODE_29774_length_173_cov_1.861111_g29613_i0 PRJNA640350 29774 173 1.861111 3.21972203 root 1 Root_unresolved Root_unresolved 320 3.61e-83   NTclustered gi|78190082|gb|AC168047.3| 7176 g29613 i0 100 85.878612716763 173 0 100 0 1 173 88747 88575 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence blastn 14857 320 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
19737314 19737314 PRJNA640350_P_NODE_3896_length_457_cov_2.077103_g3745_i0 PRJNA640350 3896 457 2.077103 9.49236071 Timema cristinae 61476 Arthropoda Arthropoda 63.9 2.05e-5   NTclustered gi|1946880863|emb|OC317005.1| 61476 g3745 i0 100 0.135667396061269 34 0 7 0 81 114 3185 3152 3_Tce_b3v08 blastn 62 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
23562947 23562947 PRJNA640350_P_NODE_11099_length_343_cov_0.863057_g10938_i0 PRJNA640350 11099 343 0.863057 2.96028551 Micronychus sp. UPOL MT0029 1959925 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1148300271|gb|KU496207.1| 1959925 g10938 i0 100 0.0845481049562682 29 0 8 0 46 74 989 1017 Micronychus sp. UPOL MT0029 NADH dehydrogenase subunit 5 (ND5) gene, partial cds; tRNA-Phe and tRNA-Glu genes, complete sequence; and tRNA-Ser gene, partial sequence; mitochondrial blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lycidae Micronychus Micronychus sp. UPOL MT0029

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