RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA898105" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA898105 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
23826013 23826013 PRJNA898105_P_NODE_6839_length_248_cov_0.880000_g6639_i0 PRJNA898105 6839 248 0.88 2.1824 Chironomidae 7149 Arthropoda Arthropoda 120 5.37e-33   NR KAG5676080.1 319348 g6639 i0 96.7 1.45161290322581 60 2 72.6 0 246 67 82 141 KAG5676080.1 hypothetical protein PVAND_005934 [Polypedilum vanderplanki] diamond 360 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
27095002 27095002 PRJNA898105_P_NODE_5102_length_270_cov_1.563452_g4902_i0 PRJNA898105 5102 270 1.563452 4.2213204 Formicidae 36668 Arthropoda Arthropoda 100 1.58e-22   NR XP_012063672.1 12957 g4902 i0 57.1 8.06666666666667 91 37 98.9 1 3 269 328 418 XP_012063672.1 PREDICTED: probable ATP-dependent RNA helicase DDX17, partial [Atta cephalotes] diamond 2178 101 0.99009900990099 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Atta Atta cephalotes
30213550 30213550 PRJNA898105_P_NODE_6392_length_250_cov_0.870056_g6192_i0 PRJNA898105 6392 250 0.870056 2.17514 Armadillidium vulgare 13347 Arthropoda Arthropoda 73.9 1.41e-14   NR RXG50746.1 13347 g6192 i0 37.5 2.592 72 43 84 1 37 246 8 79 RXG50746.1 hypothetical protein Avbf_04233 [Armadillidium vulgare] diamond 648 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium vulgare

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