RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA547066 · 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
3062487 3062487 PRJNA547066_P_NODE_5163_length_169_cov_1.216418_g5069_i0 PRJNA547066 5163 169 1.216418 2.05574642 Demodex brevis 574145 Arthropoda Arthropoda 313 5.859999999999999e-81   NTclustered gi|360047411|gb|HQ718592.1| 574145 g5069 i0 100 9.02958579881657 169 0 100 0 1 169 5197 5029 Demodex brevis isolate Db2 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 1526 313 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex brevis
5615380 5615380 PRJNA547066_P_NODE_2565_length_293_cov_1.147287_g2471_i0 PRJNA547066 2565 293 1.147287 3.36155091 Timema douglasi 61478 Arthropoda Arthropoda 497 2.9e-136   NTclustered gi|1936766486|emb|OA594500.1| 61478 g2471 i0 97.27 1 293 8 100 0 1 293 1850 1558 1_Tdi_b3v08 blastn 293 497 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
5615391 5615391 PRJNA547066_P_NODE_4145_length_199_cov_1.219512_g4051_i0 PRJNA547066 4145 199 1.219512 2.42682888 Demodex brevis 574145 Arthropoda Arthropoda 357 3.2699999999999996e-94   NTclustered gi|719240701|gb|KM114225.1| 574145 g4051 i0 98.995 32.0854271356784 199 2 100 0 1 199 10461 10659 Demodex brevis mitochondrion, complete genome blastn 6385 357 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex brevis
8164399 8164399 PRJNA547066_P_NODE_3547_length_227_cov_1.041667_g3453_i0 PRJNA547066 3547 227 1.041667 2.36458409 Dermatophagoides farinae 6954 Arthropoda Arthropoda 420 4.81e-113   NTclustered gi|256985336|ref|NC_013184.1| 6954 g3453 i0 100 25.0352422907489 227 0 100 0 1 227 6554 6328 Dermatophagoides farinae mitochondrion, complete genome blastn 5683 420 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
9439920 9439920 PRJNA547066_P_NODE_2268_length_321_cov_2.069930_g2174_i0 PRJNA547066 2268 321 2.06993 6.6444753 Demodex brevis 574145 Arthropoda Arthropoda 444 4.2499999999999996e-120   NTclustered gi|1735120170|gb|MH540325.1| 574145 g2174 i0 99.588 36.3769470404984 243 1 76 0 1 243 243 1 Demodex brevis isolate D3-1 28S ribosomal RNA gene, partial sequence blastn 11677 444 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex brevis
10715705 10715705 PRJNA547066_P_NODE_409_length_748_cov_6.539972_g349_i0 PRJNA547066 409 748 6.539972 48.91899056 Demodex brevis 574145 Arthropoda Arthropoda 1349 0   NTclustered gi|719240701|gb|KM114225.1| 574145 g349 i0 99.198 34.9933155080214 748 6 100 0 1 748 11681 12428 Demodex brevis mitochondrion, complete genome blastn 26175 1349 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex brevis
23463863 23463863 PRJNA547066_P_NODE_979_length_502_cov_3.167024_g891_i0 PRJNA547066 979 502 3.167024 15.89846048 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.004   NTclustered gi|1965181363|emb|OE475415.1| 61474 g891 i0 90.909 0.0876494023904383 44 1 8 2 192 232 309 266 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
24737597 24737597 PRJNA547066_P_NODE_540_length_664_cov_2.912560_g469_i0 PRJNA547066 540 664 2.91256 19.3393984 Drosophila willistoni 7260 Arthropoda Arthropoda 69.4 6.57e-7   NTclustered gi|2203530715|ref|XM_023179400.2| 7260 g469 i0 100 3.71084337349398 37 0 6 0 591 627 3553 3589 PREDICTED: Drosophila willistoni histone acetyltransferase p300 (LOC6649171), mRNA blastn 2464 69.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila willistoni

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