RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA396510" 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

  • PRJNA396510 · 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
411889 411889 PRJNA396510_P_NODE_15961_length_162_cov_0.902655_g15892_i0 PRJNA396510 15961 162 0.902655 1.4623011 Artemia franciscana 6661 Arthropoda Arthropoda 283 4.39e-72   NTclustered gi|2743057488|ref|XM_065728831.1| 6661 g15892 i0 98.148 3.12345679012346 162 3 100 0 1 162 32 193 PREDICTED: Artemia franciscana protein bric-a-brac 1-like (LOC136043868), transcript variant X2, mRNA blastn 506 283 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
1079184 1079184 PRJNA396510_P_NODE_8121_length_209_cov_1.106250_g8052_i0 PRJNA396510 8121 209 1.10625 2.3120625 Artemia 6660 Arthropoda Arthropoda 387 4.42e-103   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g8052 i0 100 100.947368421053 209 0 100 0 1 209 1394 1186 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 21098 387 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
7457069 7457069 PRJNA396510_P_NODE_3326_length_307_cov_4.406977_g3257_i0 PRJNA396510 3326 307 4.406977 13.52941939 Artemia 6660 Arthropoda Arthropoda 568 2.3e-157   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g3257 i0 100 24.671009771987 307 0 100 0 1 307 449 755 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 7574 568 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
7457070 7457070 PRJNA396510_P_NODE_4246_length_275_cov_1.743363_g4177_i0 PRJNA396510 4246 275 1.743363 4.79424825 Artemia 6660 Arthropoda Arthropoda 508 1.2499999999999999e-139   NTclustered gi|27461892|gb|AY137143.1| 6661 g4177 i0 100 6.38181818181818 275 0 100 0 1 275 586 312 Artemia franciscana 28S ribosomal RNA gene, partial sequence blastn 1755 508 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
9340073 9340073 PRJNA396510_P_NODE_6008_length_238_cov_0.962963_g5939_i0 PRJNA396510 6008 238 0.962963 2.29185194 Aedes albopictus 7160 Arthropoda Arthropoda 52.8 0.021   NTclustered gi|2669916502|ref|XM_062857525.1| 7160 g5939 i0 100 0.588235294117647 28 0 12 0 200 227 1870 1897 PREDICTED: Aedes albopictus uncharacterized LOC134290391 (LOC134290391), mRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
10615838 10615838 PRJNA396510_P_NODE_9169_length_198_cov_1.369128_g9100_i0 PRJNA396510 9169 198 1.369128 2.71087344 Artemia franciscana 6661 Arthropoda Arthropoda 126 9.97e-25   NTclustered gi|2743049377|ref|XM_065720999.1| 6661 g9100 i0 91.398 0.939393939393939 93 7 47 1 106 198 3717 3626 PREDICTED: Artemia franciscana lachesin-like (LOC136038049), transcript variant X2, mRNA blastn 186 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
11890738 11890738 PRJNA396510_P_NODE_2570_length_342_cov_6.648464_g2501_i0 PRJNA396510 2570 342 6.648464 22.73774688 Artemia franciscana 6661 Arthropoda Arthropoda 630 3.259999999999999e-176   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g2501 i0 100 2.31286549707602 341 0 99 0 2 342 3693 3353 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 791 630 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
11890755 11890755 PRJNA396510_P_NODE_9950_length_191_cov_0.901408_g9881_i0 PRJNA396510 9950 191 0.901408 1.72168928 Glaucopsyche melanops 1002887 Arthropoda Arthropoda 52.8 0.016   NTclustered gi|2919550840|emb|OZ238361.1| 1002887 g9881 i0 100 0.146596858638743 28 0 15 0 77 104 14100601 14100628 Glaucopsyche melanops genome assembly, chromosome: 20 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lycaenidae Glaucopsyche Glaucopsyche melanops
12557832 12557832 PRJNA396510_P_NODE_10830_length_183_cov_1.873134_g10761_i0 PRJNA396510 10830 183 1.873134 3.42783522 root 1 Root_unresolved Root_unresolved 339 1.07e-88   NTclustered gi|83281396|gb|AC167967.6| 7176 g10761 i0 100 163 183 0 100 0 1 183 138 320 Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940144D9, complete sequence blastn 29829 339 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
19537794 19537794 PRJNA396510_P_NODE_13856_length_166_cov_0.871795_g13787_i0 PRJNA396510 13856 166 0.871795 1.4471797 Galerucella sp. EMHAU-15070821 2480061 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1494235853|gb|KY039110.1| 2480061 g13787 i0 100 0.174698795180723 29 0 17 0 131 159 5533 5561 Galerucella sp. EMHAU-15070821 mitochondrion, partial genome blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Galerucella Galerucella sp. EMHAU-15070821
20205341 20205341 PRJNA396510_P_NODE_8516_length_204_cov_3.948387_g8447_i0 PRJNA396510 8516 204 3.948387 8.05470948 Artemia 6660 Arthropoda Arthropoda 377 2.59e-100   NTclustered gi|2743080997|ref|XR_010618360.1| 6661 g8447 i0 100 77.5 204 0 100 0 1 204 1479 1682 PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA blastn 15810 377 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
22088441 22088441 PRJNA396510_P_NODE_8578_length_204_cov_1.154839_g8509_i0 PRJNA396510 8578 204 1.154839 2.35587156 Artemia franciscana 6661 Arthropoda Arthropoda 298 2.07e-76   NTclustered gi|2743025003|ref|XR_010621486.1| 6661 g8509 i0 93.5 17.9950980392157 200 13 99 0 3 202 755 556 PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA blastn 3671 298 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
22088446 22088446 PRJNA396510_P_NODE_958_length_523_cov_2.232068_g890_i0 PRJNA396510 958 523 2.232068 11.67371564 Achaea janata 378752 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|1236175841|gb|MF425655.1| 378752 g890 i0 97.059 0.0650095602294455 34 0 7 1 160 193 2931 2963 Achaea janata aminopeptidase N (APN6) mRNA, complete cds blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Erebidae Achaea Achaea janata
24638317 24638317 PRJNA396510_P_NODE_8080_length_209_cov_1.912500_g8011_i0 PRJNA396510 8080 209 1.9125 3.997125 Agapeta hamana 1100904 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|2918369793|emb|OZ237860.1| 1100904 g8011 i0 100 0.287081339712919 30 0 14 0 135 164 9630697 9630668 Agapeta hamana genome assembly, chromosome: 1 blastn 60 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Agapeta Agapeta hamana
25305317 25305317 PRJNA396510_P_NODE_16800_length_156_cov_4.289720_g16731_i0 PRJNA396510 16800 156 4.28972 6.6919632 Artemia 6660 Arthropoda Arthropoda 289 9e-74   NTclustered gi|25251406|emb|AJ238061.1| 6661 g16731 i0 100 99.9935897435897 156 0 100 0 1 156 732 887 Artemia franciscana 18S rRNA gene blastn 15599 289 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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