contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1129273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 283258 | 283258 | PRJNA1129273_P_NODE_4761_length_326_cov_7.976285_g4481_i0 | PRJNA1129273 | 4761 | 326 | 7.976285 | 26.0026891 | Blidingia sp. DT1 | 2022611 | Plants | Plants | 342 | 1.6199999999999994e-89 | NTclustered | gi|1220117795|gb|KY401415.1| | 2022611 | g4481 | i0 | 85.933 | 83.4355828220859 | 327 | 39 | 99 | 6 | 2 | 325 | 3264 | 2942 | Blidingia sp. DT1 28S ribosomal RNA gene, partial sequence | blastn | 27200 | 342 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Blidingia | Blidingia sp. DT1 | |
| 1031653 | 1031653 | PRJNA1129273_P_NODE_2061_length_554_cov_4.347193_g1787_i0 | PRJNA1129273 | 2061 | 554 | 4.347193 | 24.08344922 | Trebouxia | 13786 | Plants | Plants | 985 | 0 | NTclustered | gi|21631|emb|Z21553.1| | 13787 | g1787 | i0 | 98.736 | 100.027075812274 | 554 | 7 | 100 | 0 | 1 | 554 | 1144 | 591 | T.asymmetrica gene encoding 18S ribosomal RNA | blastn | 55415 | 990 | 0.994949494949495 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica | |
| 1557876 | 1557876 | PRJNA1129273_P_NODE_7942_length_259_cov_1.956989_g7662_i0 | PRJNA1129273 | 7942 | 259 | 1.956989 | 5.06860151 | Trebouxia lynnae | 1825957 | Plants | Plants | 433 | 7.21e-117 | NTclustered | gi|1812100161|ref|NC_045839.1| | 1825957 | g7662 | i0 | 96.899 | 108.081081081081 | 258 | 8 | 99 | 0 | 2 | 259 | 178794 | 179051 | Trebouxia sp. TR9 chloroplast, partial genome | blastn | 27993 | 433 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 1557901 | 1557901 | PRJNA1129273_P_NODE_9962_length_245_cov_0.883721_g9682_i0 | PRJNA1129273 | 9962 | 245 | 0.883721 | 2.16511645 | Trebouxia aggregata | 160068 | Plants | Plants | 342 | 1.17e-89 | NTclustered | gi|162134279|gb|EU123962.1| | 160068 | g9682 | i0 | 94.57 | 3.3469387755102 | 221 | 12 | 90 | 0 | 24 | 244 | 7664 | 7884 | Trebouxia aggregata strain SAG 219-1d cell division protein (ftsH) gene, complete cds; chloroplast | blastn | 820 | 342 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 2307000 | 2307000 | PRJNA1129273_P_NODE_1002_length_869_cov_15.100503_g778_i0 | PRJNA1129273 | 1002 | 869 | 15.100503 | 131.22337107 | Trebouxia | 13786 | Plants | Plants | 1474 | 0 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g778 | i0 | 97.581 | 98.0092059838895 | 868 | 8 | 99 | 1 | 2 | 869 | 5960 | 6814 | Uncultured Trebouxia photobiont voucher Lendemer 46119 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 | 85170 | 1485 | 0.992592592592593 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 5386469 | 5386469 | PRJNA1129273_P_NODE_7065_length_271_cov_2.196970_g6785_i0 | PRJNA1129273 | 7065 | 271 | 2.19697 | 5.9537887 | Uvulifera verrucariae | 381758 | Plants | Plants | 401 | 2.1399999999999994e-107 | NTclustered | gi|922575234|gb|JQ921003.1| | 381758 | g6785 | i0 | 93.358 | 104.121771217712 | 271 | 18 | 100 | 0 | 1 | 271 | 467 | 197 | Coccobotrys verrucariae strain SAG 16.97 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 28217 | 401 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetophorales | Chaetophoraceae | Uvulifera | Uvulifera verrucariae | |
| 6661097 | 6661097 | PRJNA1129273_P_NODE_10946_length_233_cov_2.268750_g10666_i0 | PRJNA1129273 | 10946 | 233 | 2.26875 | 5.2861875 | Hazenia capsulata | 2202518 | Plants | Plants | 180 | 9.169999999999999e-41 | NTclustered | gi|17028245|gb|L42837.1|CMKCPRGOL | 2202518 | g10666 | i0 | 80.973 | 9.22317596566524 | 226 | 43 | 97 | 0 | 2 | 227 | 2113 | 1888 | Hazenia capsulata large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 2149 | 180 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Hazeniaceae | Hazenia | Hazenia capsulata | |
| 7409560 | 7409560 | PRJNA1129273_P_NODE_11046_length_230_cov_2.363057_g10766_i0 | PRJNA1129273 | 11046 | 230 | 2.363057 | 5.4350311 | Chlorophyta | 3041 | Plants | Plants | 422 | 1.36e-113 | NTclustered | gi|345425754|gb|JN573875.1| | 1077721 | g10766 | i0 | 100 | 98.295652173913 | 228 | 0 | 99 | 0 | 2 | 229 | 60 | 287 | Dilabifilum sp. W1017 18S ribosomal RNA gene, partial sequence | blastn | 22608 | 422 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetophorales | Chaetophoraceae | Dilabifilum | Dilabifilum sp. W1017 | |
| 7936289 | 7936289 | PRJNA1129273_P_NODE_5807_length_292_cov_2.853881_g5527_i0 | PRJNA1129273 | 5807 | 292 | 2.853881 | 8.33333252 | Stichococcus bacillaris | 37433 | Plants | Plants | 342 | 1.4299999999999999e-89 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g5527 | i0 | 97.97 | 64.1301369863014 | 197 | 4 | 67 | 0 | 95 | 291 | 7182 | 6986 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 18726 | 342 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 10486750 | 10486750 | PRJNA1129273_P_NODE_11289_length_214_cov_5.021277_g11009_i0 | PRJNA1129273 | 11289 | 214 | 5.021277 | 10.74553278 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 279 | 7.940000000000001e-71 | NTclustered | gi|1360638125|gb|AC277041.1| | 574566 | g11009 | i0 | 90.909 | 17.2102803738318 | 209 | 17 | 97 | 2 | 5 | 212 | 39769 | 39562 | Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence | blastn | 3683 | 279 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 10486768 | 10486768 | PRJNA1129273_P_NODE_4649_length_331_cov_5.717054_g4369_i0 | PRJNA1129273 | 4649 | 331 | 5.717054 | 18.92344874 | Annulotesta cochlephila | 2779403 | Plants | Plants | 508 | 1.54e-139 | NTclustered | gi|2085887820|dbj|LC577593.1| | 2779403 | g4369 | i0 | 94.562 | 100.117824773414 | 331 | 14 | 99 | 4 | 3 | 330 | 740 | 411 | Annulotesta cochlephila NN-OKN1A genes for 5.8S rRNA, ITS2 and 28S rRNA, partial and complete sequence | blastn | 33139 | 508 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Kornmanniaceae | Annulotesta | Annulotesta cochlephila | |
| 11761841 | 11761841 | PRJNA1129273_P_NODE_10930_length_233_cov_2.893750_g10650_i0 | PRJNA1129273 | 10930 | 233 | 2.89375 | 6.7424375 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 307 | 4.03e-79 | NTclustered | gi|2917929620|emb|OZ234908.1| | 3350044 | g10650 | i0 | 90.598 | 1.00429184549356 | 234 | 19 | 99 | 1 | 2 | 232 | 559173 | 558940 | Trebouxia sp. SL0000003 genome assembly, chromosome: 3 | blastn | 234 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 13785005 | 13785005 | PRJNA1129273_P_NODE_3431_length_396_cov_2.160991_g3151_i0 | PRJNA1129273 | 3431 | 396 | 2.160991 | 8.55752436 | Bracteacoccus | 50036 | Plants | Plants | 719 | 0 | NTclustered | gi|6119992|gb|AF183452.1| | 50037 | g3151 | i0 | 99.494 | 99.5151515151515 | 395 | 2 | 99 | 0 | 1 | 395 | 1822 | 1428 | Bracteacoccus minor strain UTEX 66 28S ribosomal RNA gene, partial sequence | blastn | 39408 | 725 | 0.991724137931035 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Bracteacoccaceae | Bracteacoccus | Bracteacoccus minor | |
| 16334081 | 16334081 | PRJNA1129273_P_NODE_3153_length_418_cov_8.115942_g2874_i0 | PRJNA1129273 | 3153 | 418 | 8.115942 | 33.92463756 | Halofilum | 1929135 | Plants | Plants | 758 | 0 | NTclustered | gi|1189013853|gb|MF034634.1| | 97102 | g2874 | i0 | 99.519 | 99.1435406698565 | 416 | 2 | 99 | 0 | 2 | 417 | 1193 | 1608 | Halofilum salinum strain SAG 1.95 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 | 41442 | 763 | 0.993446920052425 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Halofilum | Halofilum salinum | ||
| 16860416 | 16860416 | PRJNA1129273_P_NODE_11034_length_230_cov_2.872611_g10754_i0 | PRJNA1129273 | 11034 | 230 | 2.872611 | 6.6070053 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 357 | 3.89e-94 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g10754 | i0 | 94.76 | 100.813043478261 | 229 | 12 | 99 | 0 | 1 | 229 | 3052 | 2824 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 23187 | 357 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 16860426 | 16860426 | PRJNA1129273_P_NODE_3454_length_394_cov_5.931464_g3174_i0 | PRJNA1129273 | 3454 | 394 | 5.931464 | 23.36996816 | Blidingia sp. DT1 | 2022611 | Plants | Plants | 597 | 3.859999999999998e-166 | NTclustered | gi|1220117795|gb|KY401415.1| | 2022611 | g3174 | i0 | 94.148 | 99.8604060913706 | 393 | 22 | 99 | 1 | 2 | 393 | 1800 | 1408 | Blidingia sp. DT1 28S ribosomal RNA gene, partial sequence | blastn | 39345 | 597 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Blidingia | Blidingia sp. DT1 | |
| 16860453 | 16860453 | PRJNA1129273_P_NODE_6754_length_276_cov_2.261084_g6474_i0 | PRJNA1129273 | 6754 | 276 | 2.261084 | 6.24059184 | Trebouxia aggregata | 160068 | Plants | Plants | 496 | 9.75e-136 | NTclustered | gi|162134351|gb|EU123983.1| | 160068 | g6474 | i0 | 99.27 | 98.5724637681159 | 274 | 2 | 99 | 0 | 2 | 275 | 1870 | 2143 | Trebouxia aggregata strain SAG 219-1d D1 reaction center protein of photosystem II (psbA) and hypothetical protein (orf341) genes, complete cds; and tRNA-His (trnH(gug)) and tRNA-Gly (trnG(ucc)) genes, complete sequence; chloroplast | blastn | 27206 | 496 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 20684707 | 20684707 | PRJNA1129273_P_NODE_9077_length_249_cov_0.880682_g8797_i0 | PRJNA1129273 | 9077 | 249 | 0.880682 | 2.19289818 | Gormaniella terricola | 2904618 | Plants | Plants | 97.1 | 1.03e-15 | NTclustered | gi|2312623667|ref|NC_066823.1| | 2904618 | g8797 | i0 | 86.813 | 35.2771084337349 | 91 | 7 | 35 | 4 | 1 | 86 | 9611 | 9521 | Gormaniella terricola chloroplast, complete genome | blastn | 8784 | 97.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetopeltidales | Chaetopeltidaceae | Gormaniella | Gormaniella terricola | |
| 21960031 | 21960031 | PRJNA1129273_P_NODE_4198_length_351_cov_13.794964_g3918_i0 | PRJNA1129273 | 4198 | 351 | 13.794964 | 48.42032364 | Trebouxia lynnae | 1825957 | Plants | Plants | 634 | 2.5899999999999996e-177 | NTclustered | gi|1016111943|gb|KU716051.1| | 1825957 | g3918 | i0 | 99.427 | 70.025641025641 | 349 | 2 | 99 | 0 | 2 | 350 | 6992 | 6644 | Trebouxia lynnae 26S-18S intergenic spacer region, partial sequence; 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence; and 26S-18S rRNA intergenic spacer region, partial sequence | blastn | 24579 | 634 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 23235567 | 23235567 | PRJNA1129273_P_NODE_1239_length_764_cov_4.429812_g988_i0 | PRJNA1129273 | 1239 | 764 | 4.429812 | 33.84376368 | Trebouxia gigantea | 103878 | Plants | Plants | 1402 | 0 | NTclustered | gi|922575246|gb|JQ921008.1| | 103878 | g988 | i0 | 99.869 | 82.8769633507853 | 762 | 1 | 99 | 0 | 3 | 764 | 776 | 15 | Trebouxia gigantea strain UTEX 2231 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 63318 | 1402 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia gigantea |
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);;