RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJEB2925" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB2925 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
1300374 1300374 PRJEB2925_P_NODE_2302_length_1051_cov_5.170276_g1716_i0 PRJEB2925 2302 1051 5.170276 54.33960076 Micromonas commoda 296587 Plants Plants 62.1 1.77e-4   NTclustered gi|255086672|ref|XM_002509257.1| 296587 g1716 i0 100 0.169362511893435 33 0 3 0 859 891 8325 8293 Micromonas commoda predicted protein partial mRNA blastn 178 62.1 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
12779669 12779669 PRJEB2925_P_NODE_17051_length_227_cov_2.489583_g15773_i0 PRJEB2925 17051 227 2.489583 5.65135341 Monoraphidium neglectum 145388 Plants Plants 254 5.16e-63   NTclustered gi|926795717|ref|XM_014050538.1| 145388 g15773 i0 86.842 84.9383259911894 228 28 100 2 1 227 346 120 Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA blastn 19281 254 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Monoraphidium Monoraphidium neglectum
14054271 14054271 PRJEB2925_P_NODE_3612_length_750_cov_2.797203_g2775_i0 PRJEB2925 3612 750 2.797203 20.9790225 Chlorella variabilis 554065 Plants Plants 593 9.959999999999998e-165   NTclustered gi|552822727|ref|XM_005846130.1| 554065 g2775 i0 81.266 51.544 758 120 99 19 1 747 927 181 Chlorella variabilis ATP/ADP translocator (CHLNCDRAFT_136213) mRNA, complete cds blastn 38658 593 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella variabilis
15015988 15015988 PRJEB2925_P_NODE_8832_length_406_cov_19.711590_g7572_i0 PRJEB2925 8832 406 19.71159 80.0290554 Eukaryota 2759 Plants Plants 721 0   NTclustered gi|1898545223|gb|MT951391.1| 3078 g7572 i0 98.768 100.002463054187 406 4 100 1 1 406 957 553 Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence blastn 40601 726 0.993112947658402 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella pyrenoidosa
17877708 17877708 PRJEB2925_P_NODE_12855_length_295_cov_2.150000_g11578_i0 PRJEB2925 12855 295 2.15 6.3425 Mantoniella tinhauana 3097027 Plants Plants 111 4.45e-20   NTclustered gi|2735153281|gb|CP140066.1| 3097027 g11578 i0 84.685 11.1118644067797 111 17 38 0 12 122 682148 682258 Mantoniella tinhauana isolate LFS chromosome 5 blastn 3278 111 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Mantoniella Mantoniella tinhauana
19151591 19151591 PRJEB2925_P_NODE_11856_length_316_cov_2.932384_g10581_i0 PRJEB2925 11856 316 2.932384 9.26633344 Micromonas pusilla 38833 Plants Plants 254 7.560000000000001e-63   NTclustered gi|303279025|ref|XM_003058760.1| 564608 g10581 i0 81.188 20.6392405063291 303 47 95 7 1 300 345 50 Micromonas pusilla CCMP1545 uncharacterized protein (MICPUCDRAFT_33445), partial mRNA blastn 6522 254 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla
20426756 20426756 PRJEB2925_P_NODE_11737_length_319_cov_2.253521_g10462_i0 PRJEB2925 11737 319 2.253521 7.18873199 Ostreococcus tauri 70448 Plants Plants 206 2.17e-48   NTclustered gi|308805007|ref|XM_003079768.1| 70448 g10462 i0 80.139 15.7398119122257 287 47 88 9 1 282 417 136 Ostreococcus tauri Nucleic acid-binding, OB-fold (OT_ostta06g01860), partial mRNA blastn 5021 206 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri
20426857 20426857 PRJEB2925_P_NODE_6877_length_489_cov_2.803965_g5720_i0 PRJEB2925 6877 489 2.803965 13.71138885 Micromonas commoda 296587 Plants Plants 407 8.84e-109   NTclustered gi|255088288|ref|XM_002506021.1| 296587 g5720 i0 89.873 64.8916155419223 316 32 65 0 1 316 1077 1392 Micromonas commoda alpha tubulin 1 (TUA1), mRNA blastn 31732 407 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
21702835 21702835 PRJEB2925_P_NODE_1778_length_1312_cov_6.116680_g1314_i0 PRJEB2925 1778 1312 6.11668 80.2508416 Bathycoccus prasinos 41875 Plants Plants 86.1 1.32e-11   NTclustered gi|290770787|emb|FN563099.1| 41875 g1314 i0 89.706 5.28201219512195 68 5 5 2 727 792 2256 2189 Bathycoccus prasinos plastid 16S rRNA gene (partial), ITS1, tRNA-Ile gene, tRNA-Ala gene and 23S rRNA gene (partial), strain SCCAP K-0417 blastn 6930 86.1 1 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);;