RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA229468" and tax_phylum = "Discosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Discosea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA229468 · 4 ✖

analysis 1

  • blastn · 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
9295359 9295359 PRJNA229468_S_NODE_248_length_316_cov_1.681648_g235_i0 PRJNA229468 248 316 1.681648 5.31400768 Ripella sp. 1973050 Discosea other_Eukaryota 477 4.119999999999998e-130   NTclustered gi|2666517889|gb|PP259000.1| 1973050 g235 i0 96.552 88.2088607594937 290 6 91 4 1 289 994 708 Ripella sp. strain CHIESE83/2 small subunit ribosomal RNA gene, partial sequence blastn 27874 477 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella sp.
13809991 13809991 PRJNA229468_S_NODE_1111_length_165_cov_2.965517_g1098_i0 PRJNA229468 1111 165 2.965517 4.89310305 Ripella 1217112 Discosea other_Eukaryota 263 5.86e-66   NTclustered gi|1269228383|gb|MF683508.1| 2047821 g1098 i0 99.315 84.3878787878788 146 0 88 1 20 165 209 353 Ripella platypodia clone 26.10.47 18S ribosomal RNA gene, partial sequence blastn 13924 263 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella platypodia
15670096 15670096 PRJNA229468_S_NODE_953_length_173_cov_2.733871_g940_i0 PRJNA229468 953 173 2.733871 4.72959683 Ripella sp. GP2 1217115 Discosea other_Eukaryota 303 3.63e-78   NTclustered gi|399764204|gb|JQ271715.1| 1217115 g940 i0 98.266 97.4624277456647 173 3 100 0 1 173 188 16 Ripella sp. GP2 18S ribosomal RNA gene, partial sequence blastn 16861 303 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella sp. GP2
24008528 24008528 PRJNA229468_S_NODE_779_length_187_cov_2.615942_g766_i0 PRJNA229468 779 187 2.615942 4.89181154 Vannella 95228 Discosea other_Eukaryota 318 1.43e-82   NTclustered gi|399764213|gb|JQ271724.1| 1215628 g766 i0 97.326 81.4010695187166 187 5 100 0 1 187 163 349 Vannella sp. ACN1 18S ribosomal RNA gene, partial sequence blastn 15222 318 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Vannella Vannella sp. ACN1

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