RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA602115" and tax_clade = "Amoebozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Amoebozoa · 3 ✖

bioproject 1

  • PRJNA602115 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
7520745 7520745 PRJNA602115_P_NODE_1366_length_506_cov_5.734831_g1341_i0 PRJNA602115 1366 506 5.734831 29.01824486 Vannellidae 95227 Discosea other_Eukaryota 806 0   NTclustered gi|399764204|gb|JQ271715.1| 1217115 g1341 i0 95.481 101.122529644269 509 16 100 6 1 506 1687 1183 Ripella sp. GP2 18S ribosomal RNA gene, partial sequence blastn 51168 808 0.997524752475248 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella sp. GP2
14604584 14604584 PRJNA602115_P_NODE_2772_length_363_cov_1.172185_g2747_i0 PRJNA602115 2772 363 1.172185 4.25503155 Badhamia sp. FYZ-2019a 2592590 Evosea other_Eukaryota 353 8.429999999999997e-93   NTclustered gi|1818990597|gb|MN128540.1| 2592590 g2747 i0 84.254 98.5123966942149 362 57 99 0 1 362 627 266 Badhamia sp. FYZ-2019a voucher SM2015091702 elongation factor 1-alpha (ef1alpha) gene, partial cds blastn 35760 353 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Physariida Physaraceae Badhamia Badhamia sp. FYZ-2019a
23528067 23528067 PRJNA602115_P_NODE_159_length_1439_cov_16.998549_g148_i0 PRJNA602115 159 1439 16.998549 244.60912011 Ripella sp. 805 1217113 Discosea other_Eukaryota 1628 0   NTclustered gi|399764202|gb|JQ271713.1| 1217113 g148 i0 94.502 74.1341209173037 1055 44 73 10 387 1438 1 1044 Ripella sp. 805 18S ribosomal RNA gene, partial sequence blastn 106679 1628 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella sp. 805

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