RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1145276" 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

  • PRJNA1145276 · 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
27765721 27765721 PRJNA1145276_P_NODE_2564_length_604_cov_4.642185_g2508_i0 PRJNA1145276 2564 604 4.642185 28.0387974 Cinara cedri 506608 Arthropoda Arthropoda 62.4 2.44e-8   NR VVC42816.1 506608 g2508 i0 46.2 0.322847682119205 65 35 32.3 0 241 47 99 163 VVC42816.1 Hypothetical protein CINCED_3A015187 [Cinara cedri] diamond 195 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
27891685 27891685 PRJNA1145276_P_NODE_18785_length_243_cov_0.905882_g18728_i0 PRJNA1145276 18785 243 0.905882 2.20129326 Thrips palmi 161013 Arthropoda Arthropoda 131 2.76e-33   NR XP_034238899.1 161013 g18728 i0 85.3 0.925925925925926 75 11 92.6 0 3 227 653 727 XP_034238899.1 uncharacterized protein LOC117643876 isoform X2 [Thrips palmi] diamond 225 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Thrips Thrips palmi
28775811 28775811 PRJNA1145276_P_NODE_2247_length_643_cov_5.180702_g2191_i0 PRJNA1145276 2247 643 5.180702 33.31191386 Cinara cedri 506608 Arthropoda Arthropoda 83.6 4.94e-16   NR VVC42815.1 506608 g2191 i0 48.8 0.59253499222395 127 65 59.3 0 75 455 15 141 VVC42815.1 Hypothetical protein CINCED_3A007329 [Cinara cedri] diamond 381 83.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri

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