RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA986547" 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 · 4 ✖

bioproject 1

  • PRJNA986547 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
12453435 12453435 PRJNA986547_P_NODE_4870_length_280_cov_18.768116_g4788_i0 PRJNA986547 4870 280 18.768116 52.5507248 Pleurastrosarcina brevispinosa 163096 Plants Plants 220 6.68e-53   NTclustered gi|698349064|gb|KM462875.1| 163096 g4788 i0 96.947 0.467857142857143 131 4 47 0 1 131 14344 14474 Chlorosarcina brevispinosa culture-collection UTEX:1176 chloroplast, partial genome blastn 131 220 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae     Pleurastrosarcina Pleurastrosarcina brevispinosa
16277068 16277068 PRJNA986547_P_NODE_2513_length_311_cov_3.533613_g2431_i0 PRJNA986547 2513 311 3.533613 10.98953643 Chlamydomonas reinhardtii 3055 Plants Plants 54.7 0.008   NTclustered gi|2082255134|ref|XM_043066014.1| 3055 g2431 i0 100 0.0932475884244373 29 0 9 0 261 289 101 129 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g401108v5), mRNA blastn 29 54.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
21376238 21376238 PRJNA986547_P_NODE_11977_length_241_cov_1.833333_g11895_i0 PRJNA986547 11977 241 1.833333 4.41833253 Pleurastrum terricola 34116 Plants Plants 440 3.959999999999999e-119   NTclustered gi|153805558|ref|NC_009681.1| 34116 g11895 i0 99.585 100.701244813278 241 1 100 0 1 241 2485 2725 Leptosira terrestris chloroplast, complete genome blastn 24269 440 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Pleurastraceae Pleurastrum Pleurastrum terricola
23926806 23926806 PRJNA986547_P_NODE_8199_length_253_cov_1.411111_g8117_i0 PRJNA986547 8199 253 1.411111 3.57011083 Volvox carteri 3067 Plants Plants 108 4.83e-19   NTclustered gi|302840791|ref|XM_002951896.1| 3068 g8117 i0 82.4 7.27667984189723 125 20 49 2 124 247 451 328 Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl19), mRNA blastn 1841 108 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Volvox Volvox carteri

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