RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA397736" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA397736 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
4907909 4907909 PRJNA397736_S_NODE_184_length_676_cov_32.989181_g167_i0 PRJNA397736 184 676 32.989181 223.00686356 root 1 Root_unresolved Root_unresolved 58.4 0.001   NTclustered gi|2304139023|ref|XM_050623139.1| 85661 g167 i0 100 1.78994082840237 31 0 5 0 468 498 160 190 PREDICTED: Bombus huntii uncharacterized LOC126868013 (LOC126868013), transcript variant X1, mRNA blastn 1210 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus huntii
8065467 8065467 PRJNA397736_S_NODE_287_length_556_cov_17.252372_g214_i2 PRJNA397736 287 556 17.252372 95.92318832 Demodex environmental sample 1856688 Arthropoda Arthropoda 752 0   NTclustered gi|1040064834|gb|KU363928.1| 1856688 g214 i2 91.47 98.089928057554 551 42 99 4 8 556 1 548 Demodex environmental sample clone K-7-14-37 28S ribosomal RNA gene, partial sequence blastn 54538 752 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex environmental sample
10616031 10616031 PRJNA397736_S_NODE_1009_length_286_cov_3.747082_g973_i0 PRJNA397736 1009 286 3.747082 10.71665452 Blattella germanica 6973 Arthropoda Arthropoda 527 3.5999999999999986e-145   NTclustered gi|357966808|gb|JF499929.1| 6973 g973 i0 100 96.1398601398601 285 0 99 0 2 286 841 557 Blattella germanica isolate GRI-D22-2a small subunit ribosomal RNA gene, partial sequence blastn 27496 527 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
13165892 13165892 PRJNA397736_S_NODE_851_length_311_cov_5.645390_g815_i0 PRJNA397736 851 311 5.64539 17.5571629 Pseudoterpna coronillaria 1007376 Arthropoda Arthropoda 60.2 1.74e-4   NTclustered gi|2918369770|emb|OZ237837.1| 1007376 g815 i0 89.583 0.154340836012862 48 3 15 2 261 308 5854513 5854558 Pseudoterpna coronillaria genome assembly, chromosome: 12 blastn 48 60.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Geometridae Pseudoterpna Pseudoterpna coronillaria
19537996 19537996 PRJNA397736_S_NODE_236_length_620_cov_19.473773_g214_i0 PRJNA397736 236 620 19.473773 120.7373926 Demodex environmental sample 1856688 Arthropoda Arthropoda 942 0   NTclustered gi|1040064834|gb|KU363928.1| 1856688 g214 i0 95.159 97.6290322580645 599 26 96 3 17 613 598 1 Demodex environmental sample clone K-7-14-37 28S ribosomal RNA gene, partial sequence blastn 60530 942 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex environmental sample
19537998 19537998 PRJNA397736_S_NODE_816_length_318_cov_4.148789_g780_i0 PRJNA397736 816 318 4.148789 13.19314902 Platynothrus peltifer 128015 Arthropoda Arthropoda 52.8 0.03   NTclustered gi|2579718317|gb|CP133306.1| 128015 g780 i0 100 0.0880503144654088 28 0 9 0 3 30 19738402 19738375 Platynothrus peltifer isolate 155_3 chromosome 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Camisiidae Platynothrus Platynothrus peltifer

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