RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1227535 · 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
2322279 2322279 PRJNA1227535_P_NODE_24802_length_249_cov_1.500000_g24678_i0 PRJNA1227535 24802 249 1.5 3.735 Trebouxia 13786 Plants Plants 460 3.16e-125   NTclustered gi|189909382|gb|EU725860.1| 13787 g24678 i0 100 125.843373493976 249 0 100 0 1 249 854 1102 Trebouxia asymmetrica strain SAG 48.88 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast blastn 31335 460 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia asymmetrica
9263450 9263450 PRJNA1227535_P_NODE_2828_length_413_cov_1.702941_g2705_i0 PRJNA1227535 2828 413 1.702941 7.03314633 uncultured Trebouxia photobiont 285713 Plants Plants 601 3.14e-167   NTclustered gi|1273623725|gb|KY033354.1| 285713 g2705 i0 93.187 99.5544794188862 411 24 99 4 1 408 6807 6398 Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 41116 601 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia uncultured Trebouxia photobiont
24561670 24561670 PRJNA1227535_P_NODE_3840_length_366_cov_2.296928_g3717_i0 PRJNA1227535 3840 366 2.296928 8.40675648 Hormotilopsis gelatinosa 56008 Plants Plants 291 6.759999999999999e-74   NTclustered gi|586587046|gb|KC817003.1| 56008 g3717 i0 86.567 80.6530054644809 268 30 73 5 1 266 1206 1469 Hormotilopsis gelatinosa strain UTEX B104 28S ribosomal RNA gene, partial sequence blastn 29519 291 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chaetopeltidales Chaetopeltidaceae Hormotilopsis Hormotilopsis gelatinosa

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