RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA812001" and tax_phylum = "Hemichordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Hemichordata · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA812001 · 3 ✖

analysis 1

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
3361941 3361941 PRJNA812001_P_NODE_89643_length_249_cov_0.875000_g89397_i0 PRJNA812001 89643 249 0.875 2.17875 Ptychodera flava 63121 Hemichordata other_Eukaryota 158 4.639999999999999e-34   NTclustered gi|2875667982|ref|XM_070718680.1| 63121 g89397 i0 79.399 9.9718875502008 233 40 92 8 4 232 414 186 PREDICTED: Ptychodera flava peptide methionine sulfoxide reductase-like (LOC139147553), mRNA blastn 2483 158 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Ptychoderidae Ptychodera Ptychodera flava
16113586 16113586 PRJNA812001_P_NODE_97213_length_248_cov_0.880000_g96967_i0 PRJNA812001 97213 248 0.88 2.1824 Saccoglossus kowalevskii 10224 Hemichordata other_Eukaryota 303 5.61e-78   NTclustered gi|296317308|ref|NM_001184814.1| 10224 g96967 i0 90.129 95.1129032258064 233 23 94 0 1 233 705 473 Saccoglossus kowalevskii tubulin beta chain-like (LOC100366486), mRNA blastn 23588 303 1 Eukaryota Opisthokonta Metazoa Hemichordata Enteropneusta   Harrimaniidae Saccoglossus Saccoglossus kowalevskii
22487732 22487732 PRJNA812001_P_NODE_68278_length_264_cov_1.277487_g68032_i0 PRJNA812001 68278 264 1.277487 3.37256568 Ptychodera flava 63121 Hemichordata other_Eukaryota 206 1.75e-48   NTclustered gi|2875672642|ref|XM_070721020.1| 63121 g68032 i0 80.682 1.28787878787879 264 51 100 0 1 264 545 282 PREDICTED: Ptychodera flava ubiquitin-ribosomal protein eS31 fusion protein (LOC139149316), mRNA blastn 340 206 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);;