contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJEB3181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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. | |
| 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 | |
| 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);;