contig_metadata
11 rows where bioproject = "PRJEB2925" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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);;