contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA438111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1709061 | 1709061 | PRJNA438111_P_NODE_41882_length_191_cov_4.740741_g41257_i0 | PRJNA438111 | 41882 | 191 | 4.740741 | 9.05481531 | Chlorella variabilis | 554065 | Plants | Plants | 207 | 3.31e-49 | NTclustered | gi|552840730|ref|XM_005850063.1| | 554065 | g41257 | i0 | 88.068 | 1.09424083769634 | 176 | 20 | 92 | 1 | 14 | 188 | 195 | 370 | Chlorella variabilis 40S ribosomal protein S18 (CHLNCDRAFT_34417) mRNA, complete cds | blastn | 209 | 207 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 1709138 | 1709138 | PRJNA438111_P_NODE_47482_length_184_cov_5.148387_g46857_i0 | PRJNA438111 | 47482 | 184 | 5.148387 | 9.47303208 | Trebouxia aggregata | 160068 | Plants | Plants | 137 | 4.21e-28 | NTclustered | gi|162134313|gb|EU123973.1| | 160068 | g46857 | i0 | 97.5 | 20.0217391304348 | 80 | 2 | 73 | 0 | 31 | 110 | 4620 | 4541 | Trebouxia aggregata strain SAG 219-1d septum site-determining protein (minD) gene, complete cds; tRNA-Arg (trnR(acg)) gene, complete sequence; and apocytochrome f of cytochrome b6/f complex (petA) gene, complete cds; chloroplast | blastn | 3684 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 2984969 | 2984969 | PRJNA438111_P_NODE_50943_length_180_cov_5.403974_g50318_i0 | PRJNA438111 | 50943 | 180 | 5.403974 | 9.7271532 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 130 | 6.86e-26 | NTclustered | gi|2917929625|emb|OZ234913.1| | 3350044 | g50318 | i0 | 97.368 | 0.422222222222222 | 76 | 2 | 42 | 0 | 96 | 171 | 3111687 | 3111762 | Trebouxia sp. SL0000003 genome assembly, chromosome: 8 | blastn | 76 | 130 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 8087948 | 8087948 | PRJNA438111_P_NODE_83727_length_155_cov_2.666667_g83102_i0 | PRJNA438111 | 83727 | 155 | 2.666667 | 4.13333385 | Trebouxia aggregata | 160068 | Plants | Plants | 287 | 3.21e-73 | NTclustered | gi|162134301|gb|EU123970.1| | 160068 | g83102 | i0 | 100 | 1 | 155 | 0 | 100 | 0 | 1 | 155 | 3984 | 3830 | Trebouxia aggregata strain SAG 219-1d ATP-binding subunit of protochlorophyllide (chlL) gene, complete cds; and heme attachment to plastid cytochrome c (ccsA) gene, partial cds; chloroplast | blastn | 155 | 287 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 10018855 | 10018855 | PRJNA438111_P_NODE_62988_length_169_cov_2.900000_g62363_i0 | PRJNA438111 | 62988 | 169 | 2.9 | 4.901 | Chlorophyta | 3041 | Plants | Plants | 165 | 1.74e-36 | NTclustered | gi|1241929125|ref|NC_035823.1| | 83791 | g62363 | i0 | 84.431 | 73.4852071005917 | 167 | 26 | 99 | 0 | 1 | 167 | 20161 | 20327 | Ulva flexuosa chloroplast, complete genome | blastn | 12419 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva flexuosa | |
| 11912890 | 11912890 | PRJNA438111_P_NODE_38470_length_196_cov_4.886228_g37845_i0 | PRJNA438111 | 38470 | 196 | 4.886228 | 9.57700688 | Pseudochlorella signiensis | 173497 | Plants | Plants | 348 | 1.93e-91 | NTclustered | gi|2724824453|gb|PP746560.1| | 173497 | g37845 | i0 | 98.492 | 1.01530612244898 | 199 | 0 | 100 | 1 | 1 | 196 | 13129 | 12931 | Pseudochlorella signiensis culture SAG:7.90 mitochondrion, complete genome | blastn | 199 | 348 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 13188490 | 13188490 | PRJNA438111_P_NODE_90171_length_150_cov_4.694215_g89546_i0 | PRJNA438111 | 90171 | 150 | 4.694215 | 7.0413225 | Chloroidium sp. UTEX 3077 | 2686440 | Plants | Plants | 278 | 1.85e-70 | NTclustered | gi|1785188440|gb|MN646686.1| | 2686440 | g89546 | i0 | 100 | 1 | 150 | 0 | 100 | 0 | 1 | 150 | 37608 | 37459 | Chloroidium sp. UTEX 3077 mitochondrion, complete genome | blastn | 150 | 278 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. UTEX 3077 | |
| 14463240 | 14463240 | PRJNA438111_P_NODE_67812_length_166_cov_1.839416_g67187_i0 | PRJNA438111 | 67812 | 166 | 1.839416 | 3.05343056 | Trebouxia aggregata | 160068 | Plants | Plants | 126 | 8.08e-25 | NTclustered | gi|162134325|gb|EU123976.1| | 160068 | g67187 | i0 | 96.154 | 3.53012048192771 | 78 | 2 | 48 | 1 | 4 | 80 | 8845 | 8768 | Trebouxia aggregata strain SAG 219-1d probable transport protein (cysT), hypothetical chloroplast RF1 (ycf1), ribosomal protein S12 (rps12), ribosomal protein S7 (rps7), translational elongation factor Tu (tufA), and ribosomal protein L19 (rpl19) genes, complete cds; chloroplast | blastn | 586 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 17668388 | 17668388 | PRJNA438111_P_NODE_61874_length_170_cov_2.014184_g61249_i0 | PRJNA438111 | 61874 | 170 | 2.014184 | 3.4241128 | Viridiplantae | 33090 | Plants | Plants | 217 | 4.76e-52 | NTclustered | gi|725675941|ref|NC_025528.1| | 3083 | g61249 | i0 | 92.667 | 120.905882352941 | 150 | 11 | 88 | 0 | 19 | 168 | 121603 | 121752 | 'Chlorella' mirabilis culture-collection SAG:38.88 chloroplast, complete genome | blastn | 20554 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Prasiolaceae | Edaphochlorella | Edaphochlorella mirabilis | |
| 18286167 | 18286167 | PRJNA438111_P_NODE_69335_length_165_cov_1.551471_g68710_i0 | PRJNA438111 | 69335 | 165 | 1.551471 | 2.55992715 | Parachlorella kessleri | 3074 | Plants | Plants | 163 | 6.11e-36 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g68710 | i0 | 84.663 | 9.52121212121212 | 163 | 25 | 99 | 0 | 1 | 163 | 47356 | 47518 | Parachlorella kessleri chloroplast, complete genome | blastn | 1571 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 20835872 | 20835872 | PRJNA438111_P_NODE_46317_length_186_cov_2.331210_g45692_i0 | PRJNA438111 | 46317 | 186 | 2.33121 | 4.3360506 | uncultured Symbiochloris | 2562465 | Plants | Plants | 219 | 1.48e-52 | NTclustered | gi|2509725906|gb|OR042192.1| | 2562465 | g45692 | i0 | 90 | 32.9139784946237 | 170 | 16 | 91 | 1 | 17 | 186 | 1017 | 1185 | Uncultured Symbiochloris clone BW01 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 | 6122 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Symbiochloris | ||||
| 24660745 | 24660745 | PRJNA438111_P_NODE_64120_length_168_cov_3.964029_g63495_i0 | PRJNA438111 | 64120 | 168 | 3.964029 | 6.65956872 | Bryopsis plumosa | 3130 | Plants | Plants | 93.5 | 8.32e-15 | NTclustered | gi|806636891|ref|NC_026795.1| | 3130 | g63495 | i0 | 92.308 | 4.31547619047619 | 65 | 5 | 39 | 0 | 2 | 66 | 62277 | 62341 | Bryopsis plumosa chloroplast complete genome, strain West4718 | blastn | 725 | 93.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis plumosa |
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);;