contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJEB3181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2264107 | 2264107 | PRJEB3181_P_NODE_1202_length_560_cov_15.992439_g1054_i0 | PRJEB3181 | 1202 | 560 | 15.992439 | 89.5576584 | Trebouxiophyceae | 75966 | Plants | Plants | 63.9 | 2.55e-5 | NTclustered | gi|371782132|emb|HE610164.1| | 33092 | g1054 | i0 | 95 | 11.0267857142857 | 40 | 2 | 7 | 0 | 127 | 166 | 76 | 37 | Koliella longiseta plastid partial 23S rRNA gene, strain SAG 470-1 | blastn | 6175 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 3539416 | 3539416 | PRJEB3181_S_NODE_1823_length_381_cov_56.150289_g1531_i0 | PRJEB3181 | 1823 | 381 | 56.150289 | 213.93260109 | Eukaryota | 2759 | Plants | Plants | 671 | 0 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g1531 | i0 | 100 | 95.1076115485564 | 363 | 0 | 95 | 0 | 19 | 381 | 872 | 510 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 36236 | 671 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 5158487 | 5158487 | PRJEB3181_S_NODE_4145_length_289_cov_26045.539370_g3852_i0 | PRJEB3181 | 4145 | 289 | 26045.53937 | 75271.6087793 | Chlamydomonas incerta | 51695 | Plants | Plants | 113 | 1.21e-20 | NTclustered | gi|74272608|gb|DQ122869.1| | 51695 | g3852 | i0 | 84.348 | 18.0968858131488 | 115 | 18 | 40 | 0 | 55 | 169 | 517 | 631 | Chlamydomonas incerta 40S ribosomal protein S8 mRNA, complete cds | blastn | 5230 | 113 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 7366411 | 7366411 | PRJEB3181_P_NODE_24786_length_162_cov_1.473282_g24521_i0 | PRJEB3181 | 24786 | 162 | 1.473282 | 2.38671684 | Eukaryota | 2759 | Plants | Plants | 265 | 1.5899999999999998e-66 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g24521 | i0 | 98.658 | 99.8703703703704 | 149 | 2 | 92 | 0 | 1 | 149 | 959 | 811 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 16179 | 265 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 7708248 | 7708248 | PRJEB3181_P_NODE_23807_length_166_cov_0.955556_g23542_i0 | PRJEB3181 | 23807 | 166 | 0.955556 | 1.58622296 | Polulichloris maxima | 2704661 | Plants | Plants | 250 | 4.59e-62 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g23542 | i0 | 96.078 | 10.789156626506 | 153 | 6 | 92 | 0 | 14 | 166 | 125437 | 125285 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 1791 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 7708519 | 7708519 | PRJEB3181_S_NODE_8987_length_211_cov_2.090909_g8694_i0 | PRJEB3181 | 8987 | 211 | 2.090909 | 4.41181799 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 91.6 | 3.93e-14 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g8694 | i0 | 88.312 | 2.89099526066351 | 77 | 8 | 36 | 1 | 78 | 153 | 86205 | 86129 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 610 | 91.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 9916996 | 9916996 | PRJEB3181_P_NODE_16628_length_204_cov_18.502890_g16364_i0 | PRJEB3181 | 16628 | 204 | 18.50289 | 37.7458956 | Tetradesmus | 91192 | Plants | Plants | 342 | 9.429999999999999e-90 | NTclustered | gi|1240946771|gb|KX756229.1| | 3088 | g16364 | i0 | 97.5 | 144.196078431373 | 200 | 5 | 98 | 0 | 1 | 200 | 80565 | 80764 | Tetradesmus obliquus chloroplast, complete genome | blastn | 29416 | 342 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 10258762 | 10258762 | PRJEB3181_P_NODE_9_length_1790_cov_108.555429_g5_i0 | PRJEB3181 | 9 | 1790 | 108.555429 | 1943.1421791 | Bathycoccus prasinos | 41875 | Plants | Plants | 86.1 | 1.82e-11 | NTclustered | gi|290770787|emb|FN563099.1| | 41875 | g5 | i0 | 89.706 | 3.87150837988827 | 68 | 5 | 4 | 2 | 1149 | 1214 | 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 | ||
| 12809532 | 12809532 | PRJEB3181_P_NODE_5711_length_343_cov_3.003205_g5457_i0 | PRJEB3181 | 5711 | 343 | 3.003205 | 10.30099315 | Micromonas commoda | 296587 | Plants | Plants | 187 | 8.52e-43 | NTclustered | gi|255082645|ref|XM_002504263.1| | 296587 | g5457 | i0 | 86.127 | 16.8542274052478 | 173 | 24 | 50 | 0 | 169 | 341 | 488 | 316 | Micromonas commoda predicted protein mRNA | blastn | 5781 | 187 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 13742311 | 13742311 | PRJEB3181_P_NODE_4811_length_365_cov_100.508982_g4563_i0 | PRJEB3181 | 4811 | 365 | 100.508982 | 366.8577843 | Eukaryota | 2759 | Plants | Plants | 660 | 0 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g4563 | i0 | 100 | 97.6 | 357 | 0 | 98 | 0 | 9 | 365 | 872 | 516 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 35624 | 660 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 14084228 | 14084228 | PRJEB3181_P_NODE_2032_length_484_cov_12.750552_g1848_i0 | PRJEB3181 | 2032 | 484 | 12.750552 | 61.71267168 | Ostreococcus tauri | 70448 | Plants | Plants | 209 | 2.65e-49 | NTclustered | gi|308805007|ref|XM_003079768.1| | 70448 | g1848 | i0 | 80.277 | 12.8553719008264 | 289 | 47 | 59 | 9 | 57 | 340 | 419 | 136 | Ostreococcus tauri Nucleic acid-binding, OB-fold (OT_ostta06g01860), partial mRNA | blastn | 6222 | 209 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 17907514 | 17907514 | PRJEB3181_P_NODE_12395_length_240_cov_17.215311_g12131_i0 | PRJEB3181 | 12395 | 240 | 17.215311 | 41.3167464 | Caulerpa verticillata | 177082 | Plants | Plants | 82.4 | 2.75e-11 | NTclustered | gi|1509835109|ref|NC_039523.1| | 177082 | g12131 | i0 | 96 | 2.59583333333333 | 50 | 2 | 21 | 0 | 42 | 91 | 32160 | 32111 | Caulerpa verticillata voucher HV05119 chloroplast, complete genome | blastn | 623 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Caulerpaceae | Caulerpa | Caulerpa verticillata | |
| 19181496 | 19181496 | PRJEB3181_S_NODE_11836_length_187_cov_2.934211_g11543_i0 | PRJEB3181 | 11836 | 187 | 2.934211 | 5.48697457 | Caulerpa verticillata | 177082 | Plants | Plants | 76.8 | 9.5e-10 | NTclustered | gi|1509835109|ref|NC_039523.1| | 177082 | g11543 | i0 | 97.727 | 0.614973262032086 | 44 | 1 | 24 | 0 | 1 | 44 | 32154 | 32111 | Caulerpa verticillata voucher HV05119 chloroplast, complete genome | blastn | 115 | 76.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Caulerpaceae | Caulerpa | Caulerpa verticillata | |
| 20456764 | 20456764 | PRJEB3181_P_NODE_22757_length_170_cov_9.712230_g22492_i0 | PRJEB3181 | 22757 | 170 | 9.71223 | 16.510791 | Chlamydomonas sp. TK-1983 | 3056 | Plants | Plants | 219 | 1.3199999999999996e-52 | NTclustered | gi|174203|gb|K02345.1|CRERRA | 3056 | g22492 | i0 | 100 | 0.694117647058824 | 118 | 0 | 69 | 0 | 22 | 139 | 1 | 118 | Chlamydomonas sp. TK-1983 5S ribosomal RNA gene, complete sequence | blastn | 118 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. TK-1983 | |
| 21732632 | 21732632 | PRJEB3181_P_NODE_11258_length_253_cov_4.279279_g10994_i0 | PRJEB3181 | 11258 | 253 | 4.279279 | 10.82657587 | Micromonas commoda | 296587 | Plants | Plants | 187 | 6.0299999999999984e-43 | NTclustered | gi|255082645|ref|XM_002504263.1| | 296587 | g10994 | i0 | 86.127 | 22.8498023715415 | 173 | 24 | 68 | 0 | 3 | 175 | 316 | 488 | Micromonas commoda predicted protein mRNA | blastn | 5781 | 187 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 23007961 | 23007961 | PRJEB3181_P_NODE_1679_length_510_cov_9.384134_g1512_i0 | PRJEB3181 | 1679 | 510 | 9.384134 | 47.8590834 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 102 | 4.89e-17 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g1512 | i0 | 85.294 | 25.8921568627451 | 102 | 12 | 20 | 2 | 263 | 364 | 86129 | 86227 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 13205 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 23941185 | 23941185 | PRJEB3181_P_NODE_20759_length_179_cov_13.337838_g20495_i0 | PRJEB3181 | 20759 | 179 | 13.337838 | 23.87473002 | Eukaryota | 2759 | Plants | Plants | 331 | 1.74e-86 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g20495 | i0 | 100 | 83.2960893854749 | 179 | 0 | 100 | 0 | 1 | 179 | 182 | 360 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 14910 | 331 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa |
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);;