contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA488043" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1097934 | 1097934 | PRJNA488043_P_NODE_20121_length_170_cov_3.425532_g17879_i0 | PRJNA488043 | 20121 | 170 | 3.425532 | 5.8234044 | Chloroidium | 1034479 | Plants | Plants | 315 | 1.64e-81 | NTclustered | gi|1802907788|gb|MT006209.1| | 2704674 | g17879 | i0 | 100 | 88.8647058823529 | 170 | 0 | 100 | 0 | 1 | 170 | 4298 | 4467 | Chloroidium sp. FACHB-2420 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15107 | 315 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. FACHB-2420 | |
| 1724556 | 1724556 | PRJNA488043_P_NODE_16102_length_213_cov_1.750000_g13860_i0 | PRJNA488043 | 16102 | 213 | 1.75 | 3.7275 | Dicloster acuatus | 91190 | Plants | Plants | 283 | 6.109999999999999e-72 | NTclustered | gi|725651324|ref|NC_025546.1| | 91190 | g13860 | i0 | 90.61 | 135.389671361502 | 213 | 20 | 100 | 0 | 1 | 213 | 131666 | 131878 | Dicloster acuatus culture-collection SAG:41.98 chloroplast, complete genome | blastn | 28838 | 283 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 2373365 | 2373365 | PRJNA488043_P_NODE_15162_length_225_cov_5.780612_g12920_i0 | PRJNA488043 | 15162 | 225 | 5.780612 | 13.006377 | Chlorellaceae | 35461 | Plants | Plants | 379 | 8.079999999999999e-101 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g12920 | i0 | 97.309 | 170.031111111111 | 223 | 6 | 99 | 0 | 3 | 225 | 91885 | 92107 | Parachlorella kessleri chloroplast, complete genome | blastn | 38257 | 379 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 3000525 | 3000525 | PRJNA488043_P_NODE_10303_length_330_cov_2.956811_g8062_i0 | PRJNA488043 | 10303 | 330 | 2.956811 | 9.7574763 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 285 | 2.8099999999999996e-72 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g8062 | i0 | 83.819 | 10.9121212121212 | 309 | 41 | 92 | 8 | 1 | 305 | 5444 | 5747 | Chloroidium ellipsoideum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 3601 | 285 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 3649000 | 3649000 | PRJNA488043_P_NODE_16043_length_213_cov_4.021739_g13801_i0 | PRJNA488043 | 16043 | 213 | 4.021739 | 8.56630407 | Dictyosphaerium | 247496 | Plants | Plants | 344 | 2.76e-90 | NTclustered | gi|1231294796|gb|MF664509.1| | 2026435 | g13801 | i0 | 95.775 | 99.4460093896714 | 213 | 9 | 100 | 0 | 1 | 213 | 2984 | 2772 | Dictyosphaerium sp. WfA2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 21182 | 344 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dictyosphaerium | Dictyosphaerium sp. WfA2 | |
| 6201095 | 6201095 | PRJNA488043_P_NODE_2745_length_905_cov_23.372146_g1385_i0 | PRJNA488043 | 2745 | 905 | 23.372146 | 211.5179213 | Chlorellaceae | 35461 | Plants | Plants | 913 | 0 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g1385 | i0 | 91.395 | 169.270718232044 | 674 | 47 | 74 | 10 | 1 | 668 | 93872 | 93204 | Parachlorella kessleri chloroplast, complete genome | blastn | 153190 | 922 | 0.990238611713666 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 7475884 | 7475884 | PRJNA488043_P_NODE_15946_length_214_cov_5.135135_g13704_i0 | PRJNA488043 | 15946 | 214 | 5.135135 | 10.9891889 | Chloroidium | 1034479 | Plants | Plants | 198 | 2.29e-46 | NTclustered | gi|1021681228|gb|KX024689.1| | 3082 | g13704 | i0 | 100 | 50.1822429906542 | 107 | 0 | 76 | 0 | 108 | 214 | 2885 | 2991 | Chloroidium saccharophilum strain FACHB-1796 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 10739 | 198 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium saccharophilum | |
| 11301176 | 11301176 | PRJNA488043_P_NODE_20829_length_164_cov_1.785185_g18587_i0 | PRJNA488043 | 20829 | 164 | 1.785185 | 2.9277034 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 2.94e-4 | NTclustered | gi|1388162558|gb|MF276981.1| | 3105 | g18587 | i0 | 97.143 | 5.84146341463415 | 35 | 0 | 21 | 1 | 15 | 48 | 181030 | 181064 | Pediastrum duplex chloroplast, complete genome | blastn | 958 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pediastrum | Pediastrum duplex | |
| 11301252 | 11301252 | PRJNA488043_P_NODE_5809_length_537_cov_12.905512_g3819_i0 | PRJNA488043 | 5809 | 537 | 12.905512 | 69.30259944 | Chlorellaceae | 35461 | Plants | Plants | 878 | 0 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g3819 | i0 | 96.442 | 134.929236499069 | 534 | 16 | 99 | 3 | 6 | 537 | 92975 | 92443 | Parachlorella kessleri chloroplast, complete genome | blastn | 72457 | 883 | 0.994337485843715 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 15125917 | 15125917 | PRJNA488043_P_NODE_20292_length_169_cov_1.607143_g18050_i0 | PRJNA488043 | 20292 | 169 | 1.607143 | 2.71607167 | Coccomyxa | 41891 | Plants | Plants | 69.4 | 1.4e-7 | NTclustered | gi|2106301899|dbj|AP025007.1| | 2315456 | g18050 | i0 | 80.682 | 1.0414201183432 | 88 | 17 | 52 | 0 | 2 | 89 | 47434 | 47521 | Coccomyxa sp. Obi mitochondrial DNA, complete genome | blastn | 176 | 69.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 15752556 | 15752556 | PRJNA488043_P_NODE_20133_length_170_cov_2.822695_g17891_i0 | PRJNA488043 | 20133 | 170 | 2.822695 | 4.7985815 | Chloroidium sp. KL-2023a | 3031248 | Plants | Plants | 143 | 8.2e-30 | NTclustered | gi|2450595352|gb|ON986219.1| | 3031248 | g17891 | i0 | 85.401 | 7.36470588235294 | 137 | 20 | 81 | 0 | 5 | 141 | 222269 | 222133 | Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome | blastn | 1252 | 143 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a | |
| 16400617 | 16400617 | PRJNA488043_S_NODE_1653_length_150_cov_4.652893_g1642_i0 | PRJNA488043 | 1653 | 150 | 4.652893 | 6.9793395 | Prototheca | 3110 | Plants | Plants | 78.7 | 2.02e-10 | NTclustered | gi|1381389463|ref|NC_037449.1| | 1973153 | g1642 | i0 | 86.301 | 1.43333333333333 | 73 | 8 | 48 | 2 | 1 | 72 | 5638 | 5567 | Prototheca zopfii strain SAG 2063 mitochondrion, complete genome | blastn | 215 | 78.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca ciferrii | |
| 17675697 | 17675697 | PRJNA488043_P_NODE_8734_length_383_cov_32.192090_g6517_i0 | PRJNA488043 | 8734 | 383 | 32.19209 | 123.2957047 | Chloroidium | 1034479 | Plants | Plants | 248 | 4.34e-61 | NTclustered | gi|1802907788|gb|MT006209.1| | 2704674 | g6517 | i0 | 91.209 | 48.621409921671 | 182 | 16 | 48 | 0 | 1 | 182 | 4405 | 4224 | Chloroidium sp. FACHB-2420 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 18622 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. FACHB-2420 | |
| 23402089 | 23402089 | PRJNA488043_P_NODE_13759_length_247_cov_6.518349_g11517_i0 | PRJNA488043 | 13759 | 247 | 6.518349 | 16.10032203 | Parachlorella kessleri | 3074 | Plants | Plants | 355 | 1.52e-93 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g11517 | i0 | 93.033 | 104.623481781377 | 244 | 16 | 100 | 1 | 1 | 244 | 94587 | 94829 | Parachlorella kessleri chloroplast, complete genome | blastn | 25842 | 355 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri |
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);;