RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA695140 · 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
676101 676101 PRJNA695140_S_NODE_2641_length_321_cov_34.919014_g2460_i0 PRJNA695140 2641 321 34.919014 112.09003494 Palaemon carinicauda 392227 Arthropoda Arthropoda 52.8 0.03   NTclustered gi|2804931725|ref|XM_068378853.1| 392227 g2460 i0 100 0.0872274143302181 28 0 9 0 7 34 306 279 PREDICTED: Palaemon carinicauda DAB adaptor protein (Dab), transcript variant X6, mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
9604531 9604531 PRJNA695140_S_NODE_11128_length_161_cov_1.419355_g10947_i0 PRJNA695140 11128 161 1.419355 2.28516155 Speleorchestes sp. AD1084 2051767 Arthropoda Arthropoda 93.5 7.88e-15   NTclustered gi|1282187773|gb|KY921978.1| 2051767 g10947 i0 83.495 8.86335403726708 103 14 62 3 62 161 2568 2466 Speleorchestes sp. AD1084 voucher UMMZ BMOC 07-0615-007 AD1084 28S ribosomal RNA gene, partial sequence blastn 1427 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Speleorchestes Speleorchestes sp. AD1084
11385052 11385052 PRJNA695140_S_NODE_1369_length_456_cov_12.608592_g1190_i0 PRJNA695140 1369 456 12.608592 57.49517952 root 1 Root_unresolved Root_unresolved 58.4 0.001   NTclustered gi|2304139023|ref|XM_050623139.1| 85661 g1190 i0 100 3.54385964912281 31 0 7 0 12 42 190 160 PREDICTED: Bombus huntii uncharacterized LOC126868013 (LOC126868013), transcript variant X1, mRNA blastn 1616 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus huntii
12155287 12155287 PRJNA695140_S_NODE_6430_length_207_cov_4.523529_g6249_i0 PRJNA695140 6430 207 4.523529 9.36370503 Timema genevievae 629358 Arthropoda Arthropoda 52.8 0.018   NTclustered gi|1963352837|emb|OE839734.1| 629358 g6249 i0 100 0.135265700483092 28 0 14 0 97 124 121538 121565 5_Tge_b3v08 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
19033376 19033376 PRJNA695140_S_NODE_9875_length_169_cov_3.181818_g9694_i0 PRJNA695140 9875 169 3.181818 5.37727242 Metazoa 33208 Arthropoda Arthropoda 63.9 6.52e-6   NTclustered gi|2064673160|ref|XR_006077150.1| 6945 g9694 i0 93.182 4.22485207100592 44 1 25 2 25 67 1967 2009 PREDICTED: Ixodes scapularis large subunit ribosomal RNA (LOC120848971), rRNA blastn 714 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
20307923 20307923 PRJNA695140_S_NODE_1816_length_391_cov_30.186441_g1635_i0 PRJNA695140 1816 391 30.186441 118.02898431 Timema 61471 Arthropoda Arthropoda 54.7 0.01   NTclustered gi|1947819235|emb|OD566261.1| 61472 g1635 i0 100 0.148337595907928 29 0 7 0 3 31 111505 111477 4_Tbi_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani

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