contig_metadata
18 rows where bioproject = "PRJEB2925" and tax_phylum = "Chlorophyta"
This data as json, CSV (advanced)
| 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 | ||
| 2575960 | 2575960 | PRJEB2925_P_NODE_16683_length_237_cov_2.014851_g15405_i0 | PRJEB2925 | 16683 | 237 | 2.014851 | 4.77519687 | Symbiochloris irregularis | 706552 | Plants | Plants | 126 | 8.360000000000001e-36 | NR | KAK9808445.1 | 706552 | g15405 | i0 | 74.7 | 2.87341772151899 | 75 | 19 | 94.9 | 0 | 236 | 12 | 20 | 94 | KAK9808445.1 hypothetical protein WJX73_006634 [Symbiochloris irregularis] | diamond | 681 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 3852202 | 3852202 | PRJEB2925_P_NODE_11644_length_321_cov_2.541958_g10369_i0 | PRJEB2925 | 11644 | 321 | 2.541958 | 8.15968518 | Chlorophyta | 3041 | Plants | Plants | 164 | 7.36e-49 | NR | KAK3248960.1 | 36881 | g10369 | i0 | 73.3 | 4.8785046728972 | 105 | 28 | 98.1 | 0 | 6 | 320 | 8 | 112 | KAK3248960.1 ribosomal protein S5 [Cymbomonas tetramitiformis] | diamond | 1566 | 164 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 8641230 | 8641230 | PRJEB2925_P_NODE_10587_length_349_cov_2.595541_g9315_i0 | PRJEB2925 | 10587 | 349 | 2.595541 | 9.05843809 | Trebouxia sp. C | 2796353 | Plants | Plants | 99.8 | 6.27e-25 | NR | KAL0020376.1 | 2905654 | g9315 | i0 | 71.2 | 1.89111747851003 | 73 | 19 | 62.8 | 1 | 13 | 231 | 1 | 71 | KAL0020376.1 hypothetical protein WJX79_009890 [Trebouxia sp. C0005] | diamond | 660 | 99.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0005 | |
| 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 | ||
| 21702796 | 21702796 | PRJEB2925_P_NODE_11658_length_321_cov_1.636364_g10383_i0 | PRJEB2925 | 11658 | 321 | 1.636364 | 5.25272844 | Eukaryota | 2759 | Plants | Plants | 94 | 9.89e-20 | NR | PRW60925.1 | 3076 | g10383 | i0 | 90 | 12.1495327102804 | 50 | 5 | 46.7 | 0 | 152 | 3 | 512 | 561 | PRW60925.1 putative DNA primase large subunit [Chlorella sorokiniana] | diamond | 3900 | 94.7 | 0.992608236536431 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 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 | ||
| 28328022 | 28328022 | PRJEB2925_P_NODE_4526_length_647_cov_2.550654_g3576_i0 | PRJEB2925 | 4526 | 647 | 2.550654 | 16.50273138 | Derbesia sp. WEST4838 | 1847751 | Plants | Plants | 103 | 2.789999999999999e-23 | NR | YP_009306319.1 | 1847751 | g3576 | i0 | 37.3 | 2.36012364760433 | 177 | 103 | 80.2 | 3 | 645 | 127 | 25 | 197 | YP_009306319.1 hypothetical protein [Derbesia sp. WEST4838] | diamond | 1527 | 103 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Derbesiaceae | Derbesia | Derbesia sp. WEST4838 | |
| 29212406 | 29212406 | PRJEB2925_P_NODE_10189_length_360_cov_3.963077_g8917_i0 | PRJEB2925 | 10189 | 360 | 3.963077 | 14.2670772 | Dunaliella salina | 3046 | Plants | Plants | 89.4 | 1.57e-20 | NR | KAF5840039.1 | 3046 | g8917 | i0 | 68.4 | 1.425 | 57 | 18 | 47.5 | 0 | 2 | 172 | 4 | 60 | KAF5840039.1 ribosomal protein L37a component of cytosolic 80S ribosome and 60S large subunit [Dunaliella salina] | diamond | 513 | 89.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 31771586 | 31771586 | PRJEB2925_P_NODE_10257_length_358_cov_5.120743_g8985_i0 | PRJEB2925 | 10257 | 358 | 5.120743 | 18.33225994 | Raphidocelis subcapitata | 307507 | Plants | Plants | 135 | 9.55e-38 | NR | GBF93448.1 | 307507 | g8985 | i0 | 79.1 | 20.3296089385475 | 86 | 17 | 72.1 | 1 | 85 | 342 | 47 | 131 | GBF93448.1 ribosomal protein S1 [Raphidocelis subcapitata] | diamond | 7278 | 135 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 31834697 | 31834697 | PRJEB2925_P_NODE_7217_length_473_cov_8.299087_g6048_i0 | PRJEB2925 | 7217 | 473 | 8.299087 | 39.25468151 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 100 | 7.71e-24 | NR | CAG9460866.1 | 765719 | g6048 | i0 | 47.3 | 0.830866807610994 | 131 | 53 | 83.1 | 1 | 452 | 60 | 8 | 122 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 393 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 31993060 | 31993060 | PRJEB2925_P_NODE_7358_length_468_cov_2.697460_g6181_i0 | PRJEB2925 | 7358 | 468 | 2.69746 | 12.6241128 | [Myrmecia] bisecta | 41462 | Plants | Plants | 167 | 5.34e-49 | NR | KAK9817933.1 | 41462 | g6181 | i0 | 60.8 | 2.74358974358974 | 143 | 54 | 90.4 | 1 | 8 | 430 | 63 | 205 | KAK9817933.1 hypothetical protein WJX72_004502 [[Myrmecia] bisecta] | diamond | 1284 | 167 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta |
Advanced export
JSON shape: default, array, newline-delimited
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);;