RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB12296 · 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
2570619 2570619 PRJEB12296_P_NODE_63_length_416_cov_13.635659_g55_i0 PRJEB12296 63 416 13.635659 56.72434144 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.011   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g55 i0 100 0.0697115384615385 29 0 7 0 281 309 1610 1638 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
8947712 8947712 PRJEB12296_P_NODE_428_length_208_cov_2.441341_g415_i0 PRJEB12296 428 208 2.441341 5.07798928 Timema californicum 61474 Arthropoda Arthropoda 58.4 3.92e-4   NTclustered gi|1965049124|emb|OE330953.1| 61474 g415 i0 100 2 31 0 15 0 28 58 241 271 2_Tcm_b3v08 blastn 416 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
22972707 22972707 PRJEB12296_P_NODE_79_length_382_cov_14.793201_g71_i0 PRJEB12296 79 382 14.793201 56.51002782 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g71 i0 100 0.0759162303664921 29 0 8 0 108 136 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
25500701 25500701 PRJEB12296_S_NODE_1857_length_301_cov_3184.736842_g1825_i0 PRJEB12296 1857 301 3184.736842 9586.05789442 Chydorus sphaericus 77745 Arthropoda Arthropoda 75 5.98e-9   NTclustered gi|2488168007|emb|OC981435.1| 77745 g1825 i0 100 15.21926910299 40 0 13 0 1 40 22 61 Chydorus sphaericus partial EOG090X0EPT gene for EOG090X0EPT blastn 4581 75 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Chydoridae Chydorus Chydorus sphaericus
25500789 25500789 PRJEB12296_S_NODE_481_length_458_cov_108.070922_g453_i0 PRJEB12296 481 458 108.070922 494.96482276 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.012   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g453 i0 100 0.0633187772925764 29 0 6 0 148 176 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
25636465 25636465 PRJEB12296_S_NODE_1154_length_350_cov_36.365079_g1122_i0 PRJEB12296 1154 350 36.365079 127.2777765 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.009   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g1122 i0 100 0.082857142857142893 29 0 8 0 148 176 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
25636571 25636571 PRJEB12296_S_NODE_3322_length_246_cov_14.696682_g3290_i0 PRJEB12296 3322 246 14.696682 36.15383772 Cydia splendana 1100963 Arthropoda Arthropoda 52.8 0.022   NTclustered gi|2695898591|ref|XM_063769561.1| 1100963 g3290 i0 100 0.113821138211382 28 0 11 0 87 114 1021 994 PREDICTED: Cydia splendana uncharacterized LOC134797339 (LOC134797339), partial mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia splendana
25772713 25772713 PRJEB12296_S_NODE_18171_length_151_cov_1.034483_g18139_i0 PRJEB12296 18171 151 1.034483 1.56206933 Chironomidae sp. Cy2 2827493 Arthropoda Arthropoda 252 1.13e-62   NTclustered gi|1896444345|gb|MT921245.1| 2766959 g18139 i0 96.689 103.112582781457 151 5 100 0 1 151 322 172 Chironomidae sp. Cy2020 sp1 voucher Chironomidae_Cy2020_sp1 small subunit ribosomal RNA gene, partial sequence blastn 15570 252 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae   Chironomidae sp. Cy2020 sp1
25772833 25772833 PRJEB12296_S_NODE_5643_length_203_cov_2.821429_g5611_i0 PRJEB12296 5643 203 2.821429 5.72750087 Zerynthia rumina 132710 Arthropoda Arthropoda 58.4 3.8e-4   NTclustered gi|2918382960|emb|OZ238066.1| 132710 g5611 i0 92.683 0.201970443349754 41 2 20 1 79 119 14560642 14560603 Zerynthia rumina genome assembly, chromosome: Z blastn 41 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Zerynthia Zerynthia rumina
25908800 25908800 PRJEB12296_S_NODE_10932_length_169_cov_5.231343_g10900_i0 PRJEB12296 10932 169 5.231343 8.84096967 Anopheles cruzii 68878 Arthropoda Arthropoda 65.8 1.81e-6   NTclustered gi|2428867201|ref|XM_053005325.1| 68878 g10900 i0 93.182 0.260355029585799 44 3 26 0 124 167 467 424 PREDICTED: Anopheles cruzii 40S ribosomal protein S16 (LOC128268276), mRNA blastn 44 65.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles cruzii
25908840 25908840 PRJEB12296_S_NODE_1500_length_325_cov_1.910345_g1468_i0 PRJEB12296 1500 325 1.910345 6.20862125 Timema genevievae 629358 Arthropoda Arthropoda 54.7 0.008   NTclustered gi|1963345359|emb|OE839378.1| 629358 g1468 i0 100 0.513846153846154 29 0 9 0 130 158 6940 6912 5_Tge_b3v08 blastn 167 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
25909078 25909078 PRJEB12296_S_NODE_9972_length_173_cov_2.594203_g9940_i0 PRJEB12296 9972 173 2.594203 4.48797119 Epheloscyta sancta 2591571 Arthropoda Arthropoda 58.4 3.12e-4   NTclustered gi|1694459297|gb|MH758064.1| 2591571 g9940 i0 100 10.3988439306358 31 0 18 0 143 173 578 608 Epheloscyta sancta isolate 68 28S ribosomal RNA gene, partial sequence blastn 1799 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphalaridae Epheloscyta Epheloscyta sancta
26044976 26044976 PRJEB12296_S_NODE_17685_length_152_cov_1.393162_g17653_i0 PRJEB12296 17685 152 1.393162 2.11760624 Drosophila innubila 198719 Arthropoda Arthropoda 52.8 0.012   NTclustered gi|1843871134|ref|XM_034619413.1| 198719 g17653 i0 100 0.184210526315789 28 0 18 0 117 144 416 389 PREDICTED: Drosophila innubila NADPH--cytochrome P450 reductase (LOC117782320), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila innubila
26045081 26045081 PRJEB12296_S_NODE_4797_length_214_cov_1312.703911_g4765_i0 PRJEB12296 4797 214 1312.703911 2809.18636954 Artemia franciscana 6661 Arthropoda Arthropoda 198 2.29e-46   NTclustered gi|2743067799|ref|XR_010617283.1| 6661 g4765 i0 99.099 42.2476635514019 111 0 51 1 50 159 154 44 PREDICTED: Artemia franciscana uncharacterized LOC136026412 (LOC136026412), ncRNA blastn 9041 198 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
26181052 26181052 PRJEB12296_S_NODE_10406_length_171_cov_8.500000_g10374_i0 PRJEB12296 10406 171 8.5 14.535 Porcellio scaber 64697 Arthropoda Arthropoda 156 1.06e-33   NTclustered gi|196122245|gb|EU914253.1| 64697 g10374 i0 100 0.491228070175439 84 0 49 0 88 171 4697 4614 Porcellio scaber 28S ribosomal RNA gene, partial sequence blastn 84 156 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Porcellionidae Porcellio Porcellio scaber
26287239 26287239 PRJEB12296_S_NODE_10710_length_170_cov_1.837037_g10678_i0 PRJEB12296 10710 170 1.837037 3.1229629 Calliphoridae 7371 Arthropoda Arthropoda 300 4.6e-77   NTclustered gi|426406492|ref|NC_019639.1| 7373 g10678 i0 100 95.7882352941176 162 0 95 0 9 170 12645 12806 Calliphora vicina mitochondrion, complete genome blastn 16284 300 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
26317007 26317007 PRJEB12296_S_NODE_623_length_421_cov_627.948187_g593_i0 PRJEB12296 623 421 627.948187 2643.66186727 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1965181363|emb|OE475415.1| 61474 g593 i0 90.909 0.104513064133017 44 1 10 2 64 104 309 266 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
26423206 26423206 PRJEB12296_S_NODE_8255_length_181_cov_3.904110_g8223_i0 PRJEB12296 8255 181 3.90411 7.0664391 Porcellionidae 96867 Arthropoda Arthropoda 302 1.3800000000000001e-77   NTclustered gi|12055106|emb|AJ287062.1| 64697 g8223 i0 99.398 89.3701657458564 166 1 92 0 1 166 1967 1802 Porcellio scaber 18S rRNA gene blastn 16176 302 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Porcellionidae Porcellio Porcellio scaber
26453250 26453250 PRJEB12296_S_NODE_4760_length_215_cov_3.472222_g4728_i0 PRJEB12296 4760 215 3.472222 7.4652773 Calliphora vicina 7373 Arthropoda Arthropoda 337 4.67e-88   NTclustered gi|572165567|gb|KF918984.1| 7373 g4728 i0 100 84.3488372093023 182 0 85 0 12 193 1533 1352 Calliphora vicina voucher NICC0014_11617949 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial blastn 18135 337 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina

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