RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB50765" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB50765 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
991329 991329 PRJEB50765_P_NODE_2001_length_204_cov_1.371257_g1977_i0 PRJEB50765 2001 204 1.371257 2.79736428 Culex 7174 Arthropoda Arthropoda 62.1 2.96e-5   NTclustered gi|1949592807|ref|XM_038254214.1| 7176 g1977 i0 100 13.2549019607843 33 0 16 0 19 51 353 321 Culex quinquefasciatus ATP synthase subunit beta, mitochondrial (LOC6038107), mRNA blastn 2704 62.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Culex Culex quinquefasciatus
1393963 1393963 PRJEB50765_P_NODE_3182_length_154_cov_1.136752_g3158_i0 PRJEB50765 3182 154 1.136752 1.75059808 Aedes aegypti 7159 Arthropoda Arthropoda 193 7.14e-45   NTclustered gi|1218254935|ref|XM_001655975.2| 7159 g3158 i0 89.542 97.5064935064935 153 14 99 2 2 153 1353 1504 PREDICTED: Aedes aegypti tubulin beta-1 chain (LOC5576244), mRNA blastn 15016 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
5221954 5221954 PRJEB50765_P_NODE_1125_length_298_cov_2.490421_g1101_i0 PRJEB50765 1125 298 2.490421 7.42145458 Chironomus tepperi 113505 Arthropoda Arthropoda 209 1.55e-49   NTclustered gi|2874233255|ref|XM_070651430.1| 113505 g1101 i0 84.404 26.0167785234899 218 29 72 4 51 266 147 361 PREDICTED: Chironomus tepperi tubulin alpha-1 chain (LOC139099036), mRNA blastn 7753 209 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
5221970 5221970 PRJEB50765_P_NODE_3265_length_152_cov_0.991304_g3241_i0 PRJEB50765 3265 152 0.991304 1.50678208 Drosophila melanogaster 7227 Arthropoda Arthropoda 52.8 0.012   NTclustered gi|15451502|gb|AC008326.9| 7227 g3241 i0 100 0.368421052631579 28 0 18 0 70 97 57099 57126 Drosophila melanogaster, chromosome 2L, region 27C-27C, BAC clone BACR39J17, complete sequence blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
6497798 6497798 PRJEB50765_P_NODE_2926_length_161_cov_3.120968_g2902_i0 PRJEB50765 2926 161 3.120968 5.02475848 Docodesmus trinidadensis 245715 Arthropoda Arthropoda 86.1 1.32e-12   NTclustered gi|34597163|gb|AY310255.1| 245715 g2902 i0 89.552 1.37267080745342 67 7 42 0 85 151 213 279 Docodesmus trinidadensis voucher Dotr elongation factor 2 mRNA, partial cds blastn 221 86.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Diplopoda Polydesmida Pyrgodesmidae Docodesmus Docodesmus trinidadensis
11597876 11597876 PRJEB50765_P_NODE_290_length_618_cov_2.383821_g272_i0 PRJEB50765 290 618 2.383821 14.73201378 Papilio polytes 76194 Arthropoda Arthropoda 977 0   NTclustered gi|389615034|dbj|AK405121.1| 76194 g272 i0 99.259 24.1326860841424 540 4 87 0 79 618 1 540 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 14914 977 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
12873055 12873055 PRJEB50765_P_NODE_2811_length_165_cov_1.789062_g2787_i0 PRJEB50765 2811 165 1.789062 2.9519523 Bradysia coprophila 38358 Arthropoda Arthropoda 193 7.79e-45   NTclustered gi|1928081288|ref|XM_037188404.1| 38358 g2787 i0 89.474 99.6909090909091 152 16 92 0 4 155 861 1012 PREDICTED: Bradysia coprophila ATP synthase subunit beta, mitochondrial (LOC119080178), mRNA blastn 16449 193 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
23071566 23071566 PRJEB50765_P_NODE_2459_length_180_cov_1.083916_g2435_i0 PRJEB50765 2459 180 1.083916 1.9510488 Amurrhyparia leopardinula 1875010 Arthropoda Arthropoda 67.6 5.45e-7   NTclustered gi|1051347853|gb|KX050456.1| 1875010 g2435 i0 86.885 0.338888888888889 61 7 34 1 19 79 278 337 Amurrhyparia leopardinula voucher KN00881 cytosolic malate dehydrogenase (MDH) gene, partial cds blastn 61 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Erebidae Amurrhyparia Amurrhyparia leopardinula

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