RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA436017" and tax_phylum = "Evosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Evosea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA436017 · 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
1705439 1705439 PRJNA436017_P_NODE_11702_length_249_cov_1.613208_g11404_i0 PRJNA436017 11702 249 1.613208 4.01688792 Tychosporium acutostipes 668358 Evosea other_Eukaryota 193 1.27e-44   NTclustered gi|256550195|gb|FJ792703.1| 668358 g11404 i0 89.677 58.9357429718875 155 10 61 3 97 249 160 10 Tychosporium acutostipes strain KE11AL small subunit ribosomal RNA gene, partial sequence blastn 14675 193 1 Eukaryota Amoebozoa   Evosea Variosea Cavosteliida   Tychosporium Tychosporium acutostipes
1705677 1705677 PRJNA436017_P_NODE_24042_length_166_cov_1.813953_g23744_i0 PRJNA436017 24042 166 1.813953 3.01116198 Arcyria cinerea 137621 Evosea other_Eukaryota 302 1.2500000000000001e-77   NTclustered gi|2753773265|gb|PP982843.1| 137621 g23744 i0 99.398 97.3915662650602 166 1 100 0 1 166 338 503 Arcyria cinerea voucher TUF135974 small subunit ribosomal RNA gene, partial sequence blastn 16167 302 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Trichiida Trichiidae Arcyria Arcyria cinerea
1705903 1705903 PRJNA436017_P_NODE_8742_length_296_cov_1.613900_g8444_i0 PRJNA436017 8742 296 1.6139 4.777144 Tychosporium acutostipes 668358 Evosea other_Eukaryota 172 2.0199999999999998e-38   NTclustered gi|2467140639|dbj|LC720133.1| 668358 g8444 i0 90.152 16.0067567567568 132 13 45 0 4 135 926 795 Tychosporium acutostipes YIP-60 gene for 18S rRNA, partial sequence blastn 4738 172 1 Eukaryota Amoebozoa   Evosea Variosea Cavosteliida   Tychosporium Tychosporium acutostipes
11909442 11909442 PRJNA436017_P_NODE_14770_length_216_cov_2.033520_g14472_i0 PRJNA436017 14770 216 2.03352 4.3924032 Dictyostelium discoideum 44689 Evosea other_Eukaryota 250 6.3e-62   NTclustered gi|66813933|ref|XM_636054.1| 352472 g14472 i0 87.5 99.1388888888889 216 27 100 0 1 216 793 578 Dictyostelium discoideum AX4 hypothetical protein (act7) mRNA, complete cds blastn 21414 250 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium discoideum

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