RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA515078 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
3662184 3662184 PRJNA515078_P_NODE_11463_length_264_cov_1.546256_g11230_i0 PRJNA515078 11463 264 1.546256 4.08211584 Opisthokonta 33154 Plants Plants 63.9 1.11e-5   NTclustered gi|255085685|ref|XM_002505228.1| 296587 g11230 i0 90 11.4431818181818 50 3 19 2 162 211 59 106 Micromonas commoda ABC transporter partial mRNA blastn 3021 63.9 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
8139834 8139834 PRJNA515078_P_NODE_14207_length_233_cov_2.867347_g13974_i0 PRJNA515078 14207 233 2.867347 6.68091851 Auxenochlorella protothecoides 3075 Plants Plants 145 3.34e-30   NTclustered gi|760448344|ref|XM_011402939.1| 3075 g13974 i0 80.749 77.9098712446352 187 34 80 2 15 200 1 186 Auxenochlorella protothecoides 60S ribosomal protein L15 partial mRNA blastn 18153 145 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella protothecoides
8140021 8140021 PRJNA515078_P_NODE_8527_length_313_cov_2.065217_g8294_i0 PRJNA515078 8527 313 2.065217 6.46412921 Chlamydomonas reinhardtii 3055 Plants Plants 171 7.75e-38   NTclustered gi|2082248650|ref|XM_043063418.1| 3055 g8294 i0 78.462 24.3003194888179 260 56 83 0 7 266 598 857 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA blastn 7606 171 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
9415069 9415069 PRJNA515078_P_NODE_5528_length_403_cov_1.352459_g5295_i0 PRJNA515078 5528 403 1.352459 5.45040977 Mantoniella tinhauana 3097027 Plants Plants 52.8 0.039   NTclustered gi|2735153279|gb|CP140064.1| 3097027 g5295 i0 100 0.0694789081885856 28 0 7 0 221 248 1376821 1376794 Mantoniella tinhauana isolate LFS chromosome 3 blastn 28 52.8 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Mantoniella Mantoniella tinhauana
17064056 17064056 PRJNA515078_P_NODE_17854_length_206_cov_1.591716_g17621_i0 PRJNA515078 17854 206 1.591716 3.27893496 Scherffelia dubia 3190 Plants Plants 75 3.84e-9   NTclustered gi|1783497212|ref|NC_045363.1| 3190 g17621 i0 77.536 26.5922330097087 138 21 66 9 49 178 31508 31373 Scherffelia dubia culture SAG:17.86 mitochondrion, complete genome blastn 5478 75 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorodendrophyceae Chlorodendrales Chlorodendraceae Scherffelia Scherffelia dubia
22163706 22163706 PRJNA515078_P_NODE_33478_length_152_cov_1.356522_g33245_i0 PRJNA515078 33478 152 1.356522 2.06191344 Mantoniella tinhauana 3097027 Plants Plants 172 9.14e-39   NTclustered gi|2735153278|gb|CP140063.1| 3097027 g33245 i0 87.333 2.51973684210526 150 19 99 0 3 152 631439 631588 Mantoniella tinhauana isolate LFS chromosome 2 blastn 383 172 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Mantoniella Mantoniella tinhauana
25337333 25337333 PRJNA515078_P_NODE_19500_length_196_cov_3.207547_g19267_i0 PRJNA515078 19500 196 3.207547 6.28679212 Opisthokonta 33154 Plants Plants 99 2.15e-16   NTclustered gi|612395756|ref|XM_007513336.1| 41875 g19267 i0 80.303 2.80102040816327 132 24 67 2 10 140 171 41 Bathycoccus prasinos 40S ribosomal protein S29 (Bathy04g01450), partial mRNA blastn 549 100 0.99 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Bathycoccus Bathycoccus prasinos

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