RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA438687", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 3 ✖

tax_kingdom 1

  • Metazoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA438687 · 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
6194265 6194265 PRJNA438687_S_NODE_6225_length_176_cov_1.375887_g6135_i0 PRJNA438687 6225 176 1.375887 2.42156112 Metazoa 33208 Annelida Annelida 58.4 3.19e-4   NTclustered gi|38154530|gb|AY364867.1| 152469 g6135 i0 100 0.704545454545455 31 0 18 0 146 176 2421 2391 Hrabeiella periglandulata 28S ribosomal RNA gene, partial sequence blastn 124 58.4 1 Eukaryota Opisthokonta Metazoa Annelida       Hrabeiella Hrabeiella periglandulata
22111978 22111978 PRJNA438687_S_NODE_5338_length_191_cov_3.480769_g5248_i0 PRJNA438687 5338 191 3.480769 6.64826879 Aeolosoma sp. THS-2006 397537 Annelida Annelida 326 8.77e-85   NTclustered gi|111559284|gb|DQ790019.1| 397537 g5248 i0 97.396 101.51832460733 192 3 100 2 1 191 2671 2861 Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence blastn 19390 326 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Aeolosomatidae Aeolosoma Aeolosoma sp. THS-2006
22112004 22112004 PRJNA438687_S_NODE_6798_length_167_cov_3.045455_g6708_i0 PRJNA438687 6798 167 3.045455 5.08590985 Pista wui 868041 Annelida Annelida 78.7 2.31e-10   NTclustered gi|304269431|gb|HM473257.1| 868041 g6708 i0 75.301 11.9341317365269 166 32 99 4 1 166 685 529 Pista wui voucher BIOUG<CAN>:BAMPOL0322 28S ribosomal RNA gene, partial sequence blastn 1993 78.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Terebellidae Pista Pista wui

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