RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA738523" and tax_phylum = "Evosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Evosea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA738523 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_kingdom 0

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
28000286 28000286 PRJNA738523_P_NODE_9125_length_263_cov_1.621053_g9054_i0 PRJNA738523 9125 263 1.621053 4.26336939 Cavenderia fasciculata 261658 Evosea other_Eukaryota 112 2.07e-26   NR XP_004354613.1 261658 g9054 i0 76.4 3.18250950570342 72 17 82.1 0 218 3 601 672 XP_004354613.1 3-oxoacid CoA-transferase [Cavenderia fasciculata] diamond 837 112 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Acytosteliales Cavenderiaceae Cavenderia Cavenderia fasciculata
28757744 28757744 PRJNA738523_P_NODE_10367_length_251_cov_2.792135_g10296_i0 PRJNA738523 10367 251 2.792135 7.00825885 Pelomyxa schiedti 1580589 Evosea other_Eukaryota 53.1 8.86e-6   NR KAH3767700.1 1580589 g10296 i0 37.3 0.99203187250996006 83 48 96.8 2 251 9 667 747 KAH3767700.1 gelation factor [Pelomyxa schiedti] diamond 249 53.1 1 Eukaryota Amoebozoa   Evosea   Pelobiontida Pelomyxidae Pelomyxa Pelomyxa schiedti
28820654 28820654 PRJNA738523_P_NODE_11508_length_249_cov_1.664773_g11437_i0 PRJNA738523 11508 249 1.664773 4.14528477 Dictyostelium purpureum 5786 Evosea other_Eukaryota 68.9 2.3e-11   NR XP_003283666.1 5786 g11437 i0 39.7 0.939759036144578 78 44 94 1 14 247 407 481 XP_003283666.1 uncharacterized protein DICPUDRAFT_147400 [Dictyostelium purpureum] diamond 234 68.9 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium purpureum
32392053 32392053 PRJNA738523_P_NODE_9119_length_263_cov_1.621053_g9048_i0 PRJNA738523 9119 263 1.621053 4.26336939 Pelomyxa schiedti 1580589 Evosea other_Eukaryota 79 6.1e-15   NR KAH3757648.1 1580589 g9048 i0 48.8 0.958174904942966 84 42 94.7 1 259 11 223 306 KAH3757648.1 structural constituent of cytoskeleton [Pelomyxa schiedti] diamond 252 79 1 Eukaryota Amoebozoa   Evosea   Pelobiontida Pelomyxidae Pelomyxa Pelomyxa schiedti

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