RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA807347" 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

  • PRJNA807347 · 3 ✖

analysis 1

  • blastn · 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
11010199 11010199 PRJNA807347_P_NODE_8789_length_280_cov_2.541063_g8686_i0 PRJNA807347 8789 280 2.541063 7.1149764 Chloroidium sp. KL-2023a 3031248 Plants Plants 512 9.85e-141   NTclustered gi|2450595352|gb|ON986219.1| 3031248 g8686 i0 99.643 115.471428571429 280 1 100 0 1 280 220834 221113 Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome blastn 32332 512 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Chloroidium Chloroidium sp. KL-2023a
21208550 21208550 PRJNA807347_P_NODE_11637_length_253_cov_1.238889_g11534_i0 PRJNA807347 11637 253 1.238889 3.13438917 Apatococcus lobatus 904363 Plants Plants 451 1.94e-122   NTclustered gi|554565730|gb|KF355931.1| 904363 g11534 i0 98.814 100.869565217391 253 3 100 0 1 253 345 93 Apatococcus lobatus 23S ribosomal RNA gene, partial sequence; chloroplast blastn 25520 451 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Apatococcus Apatococcus lobatus
23758936 23758936 PRJNA807347_P_NODE_3519_length_445_cov_1.161290_g3416_i0 PRJNA807347 3519 445 1.16129 5.1677405 Calidiella sp. FACHB-2405 2704677 Plants Plants 822 0   NTclustered gi|1802907774|gb|MT006195.1| 2704677 g3416 i0 100 99.8157303370786 445 0 100 0 1 445 2891 2447 Calidiella sp. FACHB-2405 small subunit ribosomal RNA gene, partial sequence blastn 44418 822 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Calidiella Calidiella sp. FACHB-2405

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