contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA734348" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1197389 | 1197389 | PRJNA734348_P_NODE_66361_length_273_cov_1.925000_g65664_i0 | PRJNA734348 | 66361 | 273 | 1.925 | 5.25525 | Prototheca | 3110 | Plants | Plants | 505 | 1.6e-138 | NTclustered | gi|1562121201|gb|MK445207.1| | 3111 | g65664 | i0 | 100 | 95.2600732600733 | 273 | 0 | 100 | 0 | 1 | 273 | 313 | 41 | Prototheca wickerhamii strain UTEX 1437 from USA small subunit ribosomal RNA gene, partial sequence | blastn | 26006 | 505 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 1994922 | 1994922 | PRJNA734348_P_NODE_77102_length_263_cov_1.621053_g76404_i0 | PRJNA734348 | 77102 | 263 | 1.621053 | 4.26336939 | Protosiphon botryoides | 44656 | Plants | Plants | 414 | 2.66e-111 | NTclustered | gi|1509778905|gb|MG778499.1| | 44656 | g76404 | i0 | 95.437 | 131.296577946768 | 263 | 6 | 100 | 5 | 1 | 263 | 35169 | 34913 | Protosiphon botryoides ribosomal protein S2 (rps2) gene, complete cds; tRNA-Asp (trnD(guc)) gene, complete sequence; 10 kDa phosphoprotein of photosystem II (psbH), photosystem II protein N (psbN), photosystem II protein T (psbT), and PSII 47 kDa protein (psbB) genes, complete cds; tRNA-Tyr (trnY(gua)) gene, complete sequence; ribosomal protein S11 (rps11), P700 apoprotein A2 of photosystem I (psaB), and RNA polymerase alpha subunit (rpoA) genes, complete cds; tRNA-Met (trnM(cau)) and tRNA-Lys (trnK(uuu)) genes, complete sequence; hypothetical chloroplast RF12 (ycf12) gene, complete cds; tRNA-Ser (trnS(gcu)) gene, complete sequence; ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, complete cds; tRNA-Leu (trnL(uaa)) gene, complete sequence; hypothetical chloroplast RF3 (ycf3), hypothetical chloroplast protein RF4 (ycf4), ribosomal protein S9 (rps9), photosystem II protein V (psbE), ATP synthase CF0 B subunit (atpF), ATP synthase CF0 C subunit (atpH), ATP synthase CF1 epsilon subunit (atpE), ribosomal protein S7 (rps7), ribosomal protein S14 (rps14), M protein of photosystem II (psbM), photosystem II reaction center Z protein (psbZ), and heme attachment to plastid cytochrome c (ccsA) genes, complete cds; 5S ribosomal RNA (rrf), large subunit ribosomal RNA (rrl), tRNA-Ala (trnA(ugc)), tRNA-Ile (trnI(gau)), and small subunit ribosomal RNA (rrs) genes, complete sequence; protochlorophyllide reductase subunit B (chlB) gene, complete cds; tRNA-Arg (trnR(ucu)) gene, complete sequence; cytochrome b6/f complex subunit 4 (petD), apocytochrome f of cytochrome b6/f complex (petA), and RNA polymerase beta' subunit (rpoC1) genes, complete cds; tRNA-Pro (trnP(ugg)) and tRNA-Val (trnV(uac)) genes, complete sequence; translation elongation factor Tu (tufA) gene, complete cds; tRNA-Glu (trnE(uuc)) gene, complete sequence; ribosomal protein L36 (rpl36) and apocytochrome b6 of cytochrome b6/f complex (petB) genes, complete cds; tRNA-His (trnH(gug)) gene, complete sequence; ribosomal protein S12 (rps12), phot… | blastn | 34531 | 414 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Protosiphonaceae | Protosiphon | Protosiphon botryoides | |
| 2472615 | 2472615 | PRJNA734348_P_NODE_39262_length_312_cov_4.025105_g38566_i0 | PRJNA734348 | 39262 | 312 | 4.025105 | 12.5583276 | Trebouxiophyceae | 75966 | Plants | Plants | 161 | 4.65e-35 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g38566 | i0 | 88.148 | 9.22435897435897 | 135 | 16 | 43 | 0 | 178 | 312 | 5552 | 5418 | Chloroidium ellipsoideum 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 | 2878 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 5025319 | 5025319 | PRJNA734348_P_NODE_18864_length_469_cov_2.512626_g18174_i0 | PRJNA734348 | 18864 | 469 | 2.512626 | 11.78421594 | Eukaryota | 2759 | Plants | Plants | 806 | 0 | NTclustered | gi|1189013852|gb|MF034633.1| | 43939 | g18174 | i0 | 97.655 | 100.00852878464801 | 469 | 11 | 100 | 0 | 1 | 469 | 617 | 1085 | Hazenia basiliensis strain ULVO-15 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 | 46904 | 811 | 0.99383477188656 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Hazeniaceae | Hazenia | Hazenia basiliensis | |
| 6301615 | 6301615 | PRJNA734348_P_NODE_89565_length_252_cov_2.944134_g88867_i0 | PRJNA734348 | 89565 | 252 | 2.944134 | 7.41921768 | Scenedesmaceae | 3086 | Plants | Plants | 399 | 7.079999999999999e-107 | NTclustered | gi|2692951716|ref|NC_086754.1| | 119574 | g88867 | i0 | 95.238 | 115.015873015873 | 252 | 12 | 100 | 0 | 1 | 252 | 89543 | 89794 | Tetradesmus dimorphus strain FBCC-A0330 chloroplast, complete genome | blastn | 28984 | 399 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus dimorphus | |
| 8370258 | 8370258 | PRJNA734348_P_NODE_113787_length_246_cov_0.849711_g113089_i0 | PRJNA734348 | 113787 | 246 | 0.849711 | 2.09028906 | Coelastrella saipanensis | 152631 | Plants | Plants | 375 | 1.16e-99 | NTclustered | gi|1642520538|ref|NC_042181.1| | 152631 | g113089 | i0 | 96.104 | 157.467479674797 | 231 | 8 | 94 | 1 | 1 | 231 | 109885 | 109656 | Coelastrella saipanensis chloroplast, complete genome | blastn | 38737 | 375 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coelastrella | Coelastrella saipanensis | |
| 8372003 | 8372003 | PRJNA734348_P_NODE_69047_length_270_cov_4.055838_g68349_i0 | PRJNA734348 | 69047 | 270 | 4.055838 | 10.9507626 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 394 | 3.57e-105 | NTclustered | gi|1432231416|gb|MH654823.1| | 332213 | g68349 | i0 | 93.015 | 72.5703703703704 | 272 | 15 | 100 | 4 | 1 | 270 | 3643 | 3374 | Chlorosarcinopsis eremi strain MKA.28 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19594 | 394 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 10125701 | 10125701 | PRJNA734348_P_NODE_22568_length_416_cov_0.883382_g21873_i0 | PRJNA734348 | 22568 | 416 | 0.883382 | 3.67486912 | Prototheca | 3110 | Plants | Plants | 689 | 0 | NTclustered | gi|1334452569|gb|MG832932.1| | 3112 | g21873 | i0 | 99.734 | 97.6778846153846 | 376 | 1 | 100 | 0 | 41 | 416 | 946 | 571 | Prototheca zopfii isolate o23c small subunit ribosomal RNA gene, partial sequence | blastn | 40634 | 689 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca zopfii | |
| 11401238 | 11401238 | PRJNA734348_P_NODE_88589_length_253_cov_2.200000_g87891_i0 | PRJNA734348 | 88589 | 253 | 2.2 | 5.566 | Prototheca | 3110 | Plants | Plants | 451 | 1.94e-122 | NTclustered | gi|378925972|gb|JQ070133.1| | 3112 | g87891 | i0 | 99.2 | 61.2252964426877 | 250 | 2 | 99 | 0 | 4 | 253 | 556 | 307 | Prototheca zopfii strain ATCC MYA-4789 28S ribosomal RNA gene, complete sequence | blastn | 15490 | 451 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca zopfii | |
| 13951466 | 13951466 | PRJNA734348_P_NODE_86631_length_255_cov_1.478022_g85933_i0 | PRJNA734348 | 86631 | 255 | 1.478022 | 3.7689561 | Eukaryota | 2759 | Plants | Plants | 460 | 3.25e-125 | NTclustered | gi|1898545223|gb|MT951391.1| | 3078 | g85933 | i0 | 99.216 | 99.2470588235294 | 255 | 2 | 100 | 0 | 1 | 255 | 1662 | 1408 | Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence | blastn | 25308 | 460 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 14748158 | 14748158 | PRJNA734348_P_NODE_95872_length_250_cov_0.870056_g95174_i0 | PRJNA734348 | 95872 | 250 | 0.870056 | 2.17514 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2917929696|emb|OZ234923.1| | 3350044 | g95174 | i0 | 100 | 0.792 | 30 | 0 | 12 | 0 | 212 | 241 | 2061772 | 2061743 | Trebouxia sp. SL0000003 genome assembly, chromosome: 18 | blastn | 198 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 17297071 | 17297071 | PRJNA734348_P_NODE_82934_length_258_cov_1.616216_g82236_i0 | PRJNA734348 | 82934 | 258 | 1.616216 | 4.16983728 | Gloeotilopsis planctonica | 34157 | Plants | Plants | 427 | 3.34e-115 | NTclustered | gi|1052423830|gb|KX306824.1| | 34157 | g82236 | i0 | 96.512 | 43.2403100775194 | 258 | 9 | 100 | 0 | 1 | 258 | 9924 | 10181 | Gloeotilopsis planctonica chloroplast, complete genome | blastn | 11156 | 427 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Ulotrichaceae | Gloeotilopsis | Gloeotilopsis planctonica | |
| 22396693 | 22396693 | PRJNA734348_P_NODE_97838_length_250_cov_0.870056_g97140_i0 | PRJNA734348 | 97838 | 250 | 0.870056 | 2.17514 | Protosiphon botryoides | 44656 | Plants | Plants | 200 | 7.639999999999999e-47 | NTclustered | gi|1509778905|gb|MG778499.1| | 44656 | g97140 | i0 | 92.754 | 56.956 | 138 | 10 | 76 | 0 | 60 | 197 | 35684 | 35821 | Protosiphon botryoides ribosomal protein S2 (rps2) gene, complete cds; tRNA-Asp (trnD(guc)) gene, complete sequence; 10 kDa phosphoprotein of photosystem II (psbH), photosystem II protein N (psbN), photosystem II protein T (psbT), and PSII 47 kDa protein (psbB) genes, complete cds; tRNA-Tyr (trnY(gua)) gene, complete sequence; ribosomal protein S11 (rps11), P700 apoprotein A2 of photosystem I (psaB), and RNA polymerase alpha subunit (rpoA) genes, complete cds; tRNA-Met (trnM(cau)) and tRNA-Lys (trnK(uuu)) genes, complete sequence; hypothetical chloroplast RF12 (ycf12) gene, complete cds; tRNA-Ser (trnS(gcu)) gene, complete sequence; ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, complete cds; tRNA-Leu (trnL(uaa)) gene, complete sequence; hypothetical chloroplast RF3 (ycf3), hypothetical chloroplast protein RF4 (ycf4), ribosomal protein S9 (rps9), photosystem II protein V (psbE), ATP synthase CF0 B subunit (atpF), ATP synthase CF0 C subunit (atpH), ATP synthase CF1 epsilon subunit (atpE), ribosomal protein S7 (rps7), ribosomal protein S14 (rps14), M protein of photosystem II (psbM), photosystem II reaction center Z protein (psbZ), and heme attachment to plastid cytochrome c (ccsA) genes, complete cds; 5S ribosomal RNA (rrf), large subunit ribosomal RNA (rrl), tRNA-Ala (trnA(ugc)), tRNA-Ile (trnI(gau)), and small subunit ribosomal RNA (rrs) genes, complete sequence; protochlorophyllide reductase subunit B (chlB) gene, complete cds; tRNA-Arg (trnR(ucu)) gene, complete sequence; cytochrome b6/f complex subunit 4 (petD), apocytochrome f of cytochrome b6/f complex (petA), and RNA polymerase beta' subunit (rpoC1) genes, complete cds; tRNA-Pro (trnP(ugg)) and tRNA-Val (trnV(uac)) genes, complete sequence; translation elongation factor Tu (tufA) gene, complete cds; tRNA-Glu (trnE(uuc)) gene, complete sequence; ribosomal protein L36 (rpl36) and apocytochrome b6 of cytochrome b6/f complex (petB) genes, complete cds; tRNA-His (trnH(gug)) gene, complete sequence; ribosomal protein S12 (rps12), phot… | blastn | 14239 | 200 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Protosiphonaceae | Protosiphon | Protosiphon botryoides | |
| 23669984 | 23669984 | PRJNA734348_P_NODE_111599_length_246_cov_0.890173_g110901_i0 | PRJNA734348 | 111599 | 246 | 0.890173 | 2.18982558 | Ulva laetevirens | 585852 | Plants | Plants | 52.8 | 0.022 | NTclustered | gi|2181839309|gb|MW531676.1| | 585852 | g110901 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 176 | 203 | 37002 | 36975 | Ulva laetevirens isolate CNS00533 chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva laetevirens |
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);;