RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1108009" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1108009 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
1020408 1020408 PRJNA1108009_P_NODE_24041_length_255_cov_1.653846_g23723_i0 PRJNA1108009 24041 255 1.653846 4.2173073 Opisthokonta 33154 Plants Plants 99 2.93e-16   NTclustered gi|612395756|ref|XM_007513336.1| 41875 g23723 i0 80.303 2.15294117647059 132 24 51 2 72 202 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
4039761 4039761 PRJNA1108009_P_NODE_21764_length_274_cov_0.865672_g21446_i0 PRJNA1108009 21764 274 0.865672 2.37194128 Micromonas commoda 296587 Plants Plants 165 3.1e-36   NTclustered gi|255072104|ref|XM_002499681.1| 296587 g21446 i0 78.195 27.4197080291971 266 52 96 5 4 266 1520 1258 Micromonas commoda predicted protein partial mRNA blastn 7513 165 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
6591208 6591208 PRJNA1108009_P_NODE_27506_length_247_cov_0.885057_g27188_i0 PRJNA1108009 27506 247 0.885057 2.18609079 Chlamydomonas reinhardtii 3055 Plants Plants 200 7.529999999999999e-47   NTclustered gi|18250309|gb|AY050666.1| 3055 g27188 i0 81.452 76.1619433198381 248 42 99 4 1 246 566 321 Chlamydomonas reinhardtii eukaryotic release factor 1 mRNA, complete cds blastn 18812 200 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
6591281 6591281 PRJNA1108009_P_NODE_30686_length_242_cov_1.349112_g30368_i0 PRJNA1108009 30686 242 1.349112 3.26485104 Ostreococcus tauri 70448 Plants Plants 150 7.509999999999998e-32   NTclustered gi|1275573527|ref|XM_022983366.1| 70448 g30368 i0 79.018 17.4834710743802 224 43 92 4 11 232 1107 886 Ostreococcus tauri S-adenosyl-L-homocysteine hydrolase, conserved site (OT_ostta09g02610), partial mRNA blastn 4231 150 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri
11691428 11691428 PRJNA1108009_P_NODE_13130_length_366_cov_1.406143_g12812_i0 PRJNA1108009 13130 366 1.406143 5.14648338 Haematococcus lacustris 44745 Plants Plants 385 3.02e-102   NTclustered gi|1279575454|gb|MF683078.1| 44745 g12812 i0 85.637 175.03825136612 369 49 100 4 1 366 3590 3223 Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast blastn 64064 385 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
11691600 11691600 PRJNA1108009_P_NODE_19230_length_294_cov_1.262443_g18912_i0 PRJNA1108009 19230 294 1.262443 3.71158242 Micromonas pusilla 38833 Plants Plants 54.7 0.008   NTclustered gi|303280172|ref|XM_003059333.1| 564608 g18912 i0 96.875 1.06122448979592 32 1 11 0 212 243 1036 1067 Micromonas pusilla CCMP1545 uncharacterized protein (MICPUCDRAFT_69362), partial mRNA blastn 312 54.7 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla
16790252 16790252 PRJNA1108009_P_NODE_28114_length_246_cov_0.890173_g27796_i0 PRJNA1108009 28114 246 0.890173 2.18982558 Mantoniella tinhauana 3097027 Plants Plants 156 1.65e-33   NTclustered gi|2735153293|gb|CP140078.1| 3097027 g27796 i0 78.486 46.3333333333333 251 44 100 8 1 246 29732 29977 Mantoniella tinhauana isolate LFS chromosome 17 blastn 11398 156 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Mantoniella Mantoniella tinhauana
23165512 23165512 PRJNA1108009_P_NODE_31959_length_236_cov_2.662577_g31641_i0 PRJNA1108009 31959 236 2.662577 6.28368172 Mantoniella tinhauana 3097027 Plants Plants 52.8 0.021   NTclustered gi|2735153294|gb|CP140079.1| 3097027 g31641 i0 100 0.11864406779661 28 0 12 0 16 43 38145 38118 Mantoniella tinhauana isolate LFS chromosome 18 blastn 28 52.8 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Mantoniella Mantoniella tinhauana

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