RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA316313" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 3 ✖

bioproject 1

  • PRJNA316313 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
28513016 28513016 PRJNA316313_P_NODE_147167_length_187_cov_4.826667_g145781_i0 PRJNA316313 147167 187 4.826667 9.02586729 Eukaryota 2759 Plants Plants 51.2 1.77e-5   NR CAD7696102.1 121088 g145781 i0 95.8 47.3582887700535 24 1 38.5 0 114 185 882 905 CAD7696102.1 unnamed protein product [Ostreobium quekettii] diamond 8856 51.6 0.992248062015504 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Ostreobiaceae Ostreobium Ostreobium quekettii
28685329 28685329 PRJNA316313_P_NODE_335407_length_186_cov_2.449664_g334021_i0 PRJNA316313 335407 186 2.449664 4.55637504 Apatococcus lobatus 904363 Plants Plants 45.1 0.00274   NR KAK9816287.1 904363 g334021 i0 80 0.403225806451613 25 5 40.3 0 75 1 254 278 KAK9816287.1 hypothetical protein WJX74_006374 [Apatococcus lobatus] diamond 75 45.1 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Apatococcus Apatococcus lobatus
28765559 28765559 PRJNA316313_S_NODE_1407_length_188_cov_2.033113_g1404_i0 PRJNA316313 1407 188 2.033113 3.82225244 Eukaryota 2759 Plants Plants 99 2.72e-22   NR KAG2497954.1 47281 g1404 i0 73.3 5.77659574468085 60 16 95.7 0 180 1 418 477 KAG2497954.1 hypothetical protein HYH03_004216 [Edaphochlamys debaryana] diamond 1086 99.4 0.995975855130785 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales   Edaphochlamys Edaphochlamys debaryana

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