contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJEB8827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25530356 | 25530356 | PRJEB8827h_S_NODE_4241_length_205_cov_5.141176_g4222_i0 | PRJEB8827 | 4241 | 205 | 5.141176 | 10.5394108 | Chlamydomonas incerta | 51695 | Plants | Plants | 113 | 8.1e-21 | NTclustered | gi|74272608|gb|DQ122869.1| | 51695 | g4222 | i0 | 84.348 | 2.40975609756098 | 115 | 18 | 56 | 0 | 57 | 171 | 631 | 517 | Chlamydomonas incerta 40S ribosomal protein S8 mRNA, complete cds | blastn | 494 | 113 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 25617682 | 25617682 | PRJEB8827f_S_NODE_2209_length_283_cov_2.576613_g2189_i0 | PRJEB8827 | 2209 | 283 | 2.576613 | 7.29181479 | Trebouxia | 13786 | Plants | Plants | 481 | 2.81e-131 | NTclustered | gi|94448778|emb|AJ969606.1| | 285713 | g2189 | i0 | 99.248 | 94.0318021201413 | 266 | 2 | 94 | 0 | 18 | 283 | 1346 | 1081 | Uncultured Trebouxia photobiont 18S rRNA gene (partial), ITS1, 5.8S rRNA gene, ITS2 and 26S rRNA gene (partial), isolate L-337 | blastn | 26611 | 481 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 25617824 | 25617824 | PRJEB8827h_S_NODE_217_length_464_cov_3172.111888_g198_i0 | PRJEB8827 | 217 | 464 | 3172.111888 | 14718.59916032 | Eukaryota | 2759 | Plants | Plants | 675 | 0 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g198 | i0 | 100 | 78.5258620689655 | 365 | 0 | 79 | 0 | 100 | 464 | 872 | 508 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 36436 | 675 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 25666045 | 25666045 | PRJEB8827f_S_NODE_5162_length_208_cov_4.635838_g5142_i0 | PRJEB8827 | 5162 | 208 | 4.635838 | 9.64254304 | Myrmecia israelensis | 3171 | Plants | Plants | 346 | 7.460000000000001e-91 | NTclustered | gi|723456786|ref|NC_025525.1| | 3171 | g5142 | i0 | 100 | 104.528846153846 | 187 | 0 | 90 | 0 | 1 | 187 | 2368 | 2182 | Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome | blastn | 21742 | 346 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 25666312 | 25666312 | PRJEB8827h_S_NODE_42842_length_160_cov_2.144000_g42823_i0 | PRJEB8827 | 42842 | 160 | 2.144 | 3.4304 | uncultured Apatococcus | 1229086 | Plants | Plants | 219 | 1.2399999999999999e-52 | NTclustered | gi|1031961068|gb|KX025109.1| | 1229086 | g42823 | i0 | 91.25 | 77.45625 | 160 | 14 | 100 | 0 | 1 | 160 | 1298 | 1457 | Uncultured Apatococcus clone GOGs_K08 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 12393 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Apatococcus | ||||
| 25753992 | 25753992 | PRJEB8827f_S_NODE_6426_length_197_cov_1.672840_g6406_i0 | PRJEB8827 | 6426 | 197 | 1.67284 | 3.2954948 | Chlorophyta | 3041 | Plants | Plants | 230 | 7.339999999999999e-56 | NTclustered | gi|1518373083|gb|MK201746.1| | 152768 | g6406 | i0 | 94.631 | 88.238578680203 | 149 | 7 | 76 | 1 | 31 | 179 | 999 | 852 | Diplosphaera chodatii strain KZ-26-5 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17383 | 231 | 0.995670995670996 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera chodatii | |
| 25754089 | 25754089 | PRJEB8827i_S_NODE_1314_length_204_cov_3.591716_g1309_i0 | PRJEB8827 | 1314 | 204 | 3.591716 | 7.32710064 | Eukaryota | 2759 | Plants | Plants | 372 | 1.2e-98 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g1309 | i0 | 100 | 89.3970588235294 | 201 | 0 | 99 | 0 | 4 | 204 | 199 | 399 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 18237 | 372 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 25937870 | 25937870 | PRJEB8827d_S_NODE_404_length_286_cov_10.203187_g400_i0 | PRJEB8827 | 404 | 286 | 10.203187 | 29.18111482 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 102 | 2.59e-17 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g400 | i0 | 85.294 | 2.08741258741259 | 102 | 12 | 36 | 2 | 26 | 127 | 86129 | 86227 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 597 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 25938763 | 25938763 | PRJEB8827j_S_NODE_116_length_369_cov_1246.221557_g112_i0 | PRJEB8827 | 116 | 369 | 1246.221557 | 4598.55754533 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 102 | 3.43e-17 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g112 | i0 | 85.294 | 1.61788617886179 | 102 | 12 | 28 | 2 | 157 | 258 | 86227 | 86129 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 597 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 26073824 | 26073824 | PRJEB8827c_S_NODE_389_length_219_cov_1.565217_g376_i0 | PRJEB8827 | 389 | 219 | 1.565217 | 3.42782523 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 80.5 | 8.89e-11 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g376 | i0 | 88.406 | 1.63926940639269 | 69 | 5 | 32 | 2 | 1 | 69 | 86162 | 86227 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 359 | 80.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 26161992 | 26161992 | PRJEB8827d_S_NODE_277_length_322_cov_2.243902_g273_i0 | PRJEB8827 | 277 | 322 | 2.243902 | 7.22536444 | Eukaryota | 2759 | Plants | Plants | 595 | 1.1099999999999995e-165 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g273 | i0 | 100 | 99.8167701863354 | 322 | 0 | 100 | 0 | 1 | 322 | 863 | 542 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 32141 | 595 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 26162023 | 26162023 | PRJEB8827e_S_NODE_21621_length_177_cov_3.056338_g21593_i0 | PRJEB8827 | 21621 | 177 | 3.0563380000000002 | 5.40971826 | Eukaryota | 2759 | Plants | Plants | 327 | 2.2199999999999996e-85 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g21593 | i0 | 100 | 99.909604519774 | 177 | 0 | 100 | 0 | 1 | 177 | 867 | 1043 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 17684 | 327 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 26162262 | 26162262 | PRJEB8827h_S_NODE_53501_length_150_cov_2.956522_g53482_i0 | PRJEB8827 | 53501 | 150 | 2.956522 | 4.434783 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.001 | NTclustered | gi|1808706810|gb|MH511706.1| | 33099 | g53482 | i0 | 100 | 5.2 | 30 | 0 | 20 | 0 | 1 | 30 | 4440 | 4411 | Pandorina morum clone NODE_202 plastid sequence | blastn | 780 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pandorina | Pandorina morum | |
| 26210257 | 26210257 | PRJEB8827e_S_NODE_38702_length_159_cov_7.169355_g38674_i0 | PRJEB8827 | 38702 | 159 | 7.169355 | 11.39927445 | Myrmecia israelensis | 3171 | Plants | Plants | 294 | 1.98e-75 | NTclustered | gi|723456786|ref|NC_025525.1| | 3171 | g38674 | i0 | 100 | 109.660377358491 | 159 | 0 | 100 | 0 | 1 | 159 | 2182 | 2340 | Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome | blastn | 17436 | 294 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 26433849 | 26433849 | PRJEB8827b_S_NODE_3255_length_220_cov_2.394595_g3203_i0 | PRJEB8827 | 3255 | 220 | 2.394595 | 5.268109 | Jaagichlorella | 2304164 | Plants | Plants | 313 | 8.09e-81 | NTclustered | gi|1802907783|gb|MT006204.1| | 2704669 | g3203 | i0 | 92.273 | 100.877272727273 | 220 | 17 | 100 | 0 | 1 | 220 | 3484 | 3265 | Jaagichlorella nagensis strain FACHB-2415 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 | 22193 | 313 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella nagensis | |
| 26433878 | 26433878 | PRJEB8827e_S_NODE_1143_length_360_cov_2.360000_g1115_i0 | PRJEB8827 | 1143 | 360 | 2.36 | 8.496 | Myrmecia | 13617 | Plants | Plants | 547 | 3.5699999999999986e-151 | NTclustered | gi|1158556075|emb|LT717549.1| | 1938899 | g1115 | i0 | 100 | 79.3888888888889 | 296 | 0 | 82 | 0 | 59 | 354 | 241 | 536 | Chlorobiont of Psora decipiens partial 26S rRNA gene, isolate Ger1-Swe | blastn | 28580 | 547 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | chlorobiont of Psora decipiens | ||||
| 26434101 | 26434101 | PRJEB8827g_S_NODE_399_length_403_cov_1110.524457_g379_i0 | PRJEB8827 | 399 | 403 | 1110.524457 | 4475.41356171 | Eukaryota | 2759 | Plants | Plants | 612 | 1.4099999999999996e-170 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g379 | i0 | 99.701 | 82.4913151364764 | 334 | 1 | 83 | 0 | 4 | 337 | 872 | 539 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 33244 | 612 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 26434169 | 26434169 | PRJEB8827j_S_NODE_111_length_374_cov_5.421829_g107_i0 | PRJEB8827 | 111 | 374 | 5.421829 | 20.27764046 | Eukaryota | 2759 | Plants | Plants | 691 | 0 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g107 | i0 | 100 | 99.8716577540107 | 374 | 0 | 100 | 0 | 1 | 374 | 493 | 866 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 37352 | 691 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 26482985 | 26482985 | PRJEB8827h_S_NODE_41904_length_162_cov_2.818898_g41885_i0 | PRJEB8827 | 41904 | 162 | 2.818898 | 4.56661476 | Pseudochlorella signiensis | 173497 | Plants | Plants | 255 | 9.570000000000001e-64 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g41885 | i0 | 95.062 | 97.2469135802469 | 162 | 8 | 100 | 0 | 1 | 162 | 150009 | 150170 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 15754 | 255 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis |
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);;