RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA781427" and tax_phylum = "Hemichordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Hemichordata · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA781427 · 6 ✖

analysis 1

  • diamond · 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
5863794 5863794 PRJNA781427_P_NODE_30645_length_419_cov_5.575145_g29764_i0 PRJNA781427 30645 419 5.575145 23.35985755 Ptychodera flava 63121 Hemichordata other_Eukaryota 190 1.42e-59   NR XP_070578318.1 63121 g29764 i0 71.9 6.68019093078759 114 32 81.6 0 49 390 15 128 XP_070578318.1 DNA-directed RNA polymerase II subunit RPB9-like [Ptychodera flava] diamond 2799 190 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
26809813 26809813 PRJNA781427_P_NODE_23061_length_498_cov_1.752941_g22182_i0 PRJNA781427 23061 498 1.752941 8.72964618 Metazoa 33208 Hemichordata other_Eukaryota 56.2 3.77e-6   NR XP_070554237.1 63121 g22182 i0 28.4 4.42771084337349 134 93 78.9 2 29 421 13 146 XP_070554237.1 high mobility group protein B2-like [Ptychodera flava] diamond 2205 56.2 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
29516541 29516541 PRJNA781427_P_NODE_37250_length_375_cov_3.480132_g36368_i0 PRJNA781427 37250 375 3.480132 13.050495 Saccoglossus kowalevskii 10224 Hemichordata other_Eukaryota 137 1.11e-36   NR XP_002735314.2 10224 g36368 i0 56.8 2.824 118 51 94.4 0 21 374 9 126 XP_002735314.2 PREDICTED: aldehyde dehydrogenase, mitochondrial-like [Saccoglossus kowalevskii] diamond 1059 137 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
30780238 30780238 PRJNA781427_P_NODE_29814_length_426_cov_2.235127_g28933_i0 PRJNA781427 29814 426 2.235127 9.52164102 Ptychodera flava 63121 Hemichordata other_Eukaryota 100 1.98e-24   NR XP_070559810.1 63121 g28933 i0 60.2 0.725352112676056 103 39 72.5 2 321 13 3 103 XP_070559810.1 small ribosomal subunit protein mS33-like [Ptychodera flava] diamond 309 100 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
30821224 30821224 PRJNA781427_P_NODE_24954_length_475_cov_1.256219_g24075_i0 PRJNA781427 24954 475 1.256219 5.96704025 Opisthokonta 33154 Hemichordata other_Eukaryota 111 1.14e-25   NR XP_070576820.1 63121 g24075 i0 52.7 4.84421052631579 110 52 69.5 0 104 433 194 303 XP_070576820.1 probable cardiolipin synthase (CMP-forming) [Ptychodera flava] diamond 2301 111 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
32054337 32054337 PRJNA781427_P_NODE_73038_length_253_cov_1.527778_g72154_i0 PRJNA781427 73038 253 1.527778 3.86527834 Metazoa 33208 Hemichordata other_Eukaryota 79.3 2.39e-16   NR XP_070570200.1 63121 g72154 i0 44.7 9.07114624505929 85 45 98.4 1 3 251 70 154 XP_070570200.1 uncharacterized protein [Ptychodera flava] diamond 2295 79.3 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava

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