contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA849172" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 834358 | 834358 | PRJNA849172_P_NODE_111001_length_240_cov_2.520958_g110641_i0 | PRJNA849172 | 111001 | 240 | 2.520958 | 6.0502992 | Yamagishiella unicocca | 51707 | Plants | Plants | 52.8 | 0.022 | NTclustered | gi|1361864716|dbj|LC314413.1| | 51707 | g110641 | i0 | 96.875 | 0.4 | 32 | 0 | 13 | 1 | 76 | 106 | 242883 | 242914 | Yamagishiella unicocca DNA, mating locus, mating-type minus rearranged domain, strain: NIES-3983 | blastn | 96 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Yamagishiella | Yamagishiella unicocca | |
| 2109780 | 2109780 | PRJNA849172_P_NODE_109042_length_241_cov_14.208333_g108682_i0 | PRJNA849172 | 109042 | 241 | 14.208333 | 34.24208253 | Nannochloris normandinae | 926285 | Plants | Plants | 429 | 8.58e-116 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g108682 | i0 | 98.755 | 109.643153526971 | 241 | 3 | 100 | 0 | 1 | 241 | 769 | 529 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 26424 | 429 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 4662643 | 4662643 | PRJNA849172_P_NODE_105004_length_243_cov_7.670588_g104644_i0 | PRJNA849172 | 105004 | 243 | 7.670588 | 18.63952884 | Pseudochlorella signiensis | 173497 | Plants | Plants | 335 | 1.9399999999999993e-87 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g104644 | i0 | 94.47 | 107.670781893004 | 217 | 12 | 89 | 0 | 27 | 243 | 150053 | 150269 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 26164 | 335 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 10160791 | 10160791 | PRJNA849172_P_NODE_18428_length_482_cov_18.315403_g18069_i0 | PRJNA849172 | 18428 | 482 | 18.315403 | 88.28024246 | Chlorellales | 35460 | Plants | Plants | 143 | 2.71e-29 | NTclustered | gi|404276808|gb|JQ655149.1| | 3077 | g18069 | i0 | 78.541 | 9.53319502074689 | 233 | 38 | 47 | 10 | 257 | 482 | 2128 | 1901 | Chlorella vulgaris heat shock protein 90 mRNA, complete cds | blastn | 4595 | 143 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 10161560 | 10161560 | PRJNA849172_P_NODE_86808_length_253_cov_20.494444_g86448_i0 | PRJNA849172 | 86808 | 253 | 20.494444 | 51.85094332 | Stichococcaceae | 2910630 | Plants | Plants | 457 | 4.16e-124 | NTclustered | gi|1518373087|gb|MK201750.1| | 29647 | g86448 | i0 | 99.209 | 99.798418972332 | 253 | 2 | 100 | 0 | 1 | 253 | 792 | 1044 | Stichococcus sp. strain KZ-5-1-1 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25249 | 457 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 13590927 | 13590927 | PRJNA849172_P_NODE_72791_length_266_cov_17.321244_g72431_i0 | PRJNA849172 | 72791 | 266 | 17.321244 | 46.07450904 | Jenufa perforata | 993091 | Plants | Plants | 62.1 | 4.04e-5 | NTclustered | gi|1829768140|ref|NC_046779.1| | 993091 | g72431 | i0 | 92.857 | 0.665413533834586 | 42 | 3 | 16 | 0 | 5 | 46 | 616 | 575 | Jenufa perforata culture CAUP:H8101 mitochondrion, complete genome | blastn | 177 | 62.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa perforata | |||
| 19962679 | 19962679 | PRJNA849172_P_NODE_40596_length_324_cov_10.988048_g40236_i0 | PRJNA849172 | 40596 | 324 | 10.988048 | 35.60127552 | Chromochloris zofingiensis | 31302 | Plants | Plants | 405 | 2.03e-108 | NTclustered | gi|674840721|ref|NC_024758.1| | 31302 | g40236 | i0 | 89.231 | 1.00308641975309 | 325 | 33 | 99 | 2 | 1 | 323 | 40409 | 40733 | Chromochloris zofingiensis strain UTEX 56 mitochondrion, complete genome | blastn | 325 | 405 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Chromochloridaceae | Chromochloris | Chromochloris zofingiensis | |
| 21236717 | 21236717 | PRJNA849172_P_NODE_120377_length_231_cov_6.000000_g120017_i0 | PRJNA849172 | 120377 | 231 | 6 | 13.86 | Prototheca lentecrescens | 2836214 | Plants | Plants | 84.2 | 7.32e-12 | NTclustered | gi|2038040444|gb|MZ198751.1| | 2836214 | g120017 | i0 | 79.339 | 11.8831168831169 | 121 | 23 | 52 | 2 | 14 | 133 | 1129 | 1010 | Prototheca lentecrescens strain PK1 small subunit ribosomal RNA gene, partial sequence | blastn | 2745 | 84.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca lentecrescens | |
| 22910598 | 22910598 | PRJNA849172_P_NODE_80878_length_259_cov_1.672043_g80518_i0 | PRJNA849172 | 80878 | 259 | 1.672043 | 4.33059137 | Borodinellopsis | 1148059 | Plants | Plants | 147 | 1.0500000000000001e-30 | NTclustered | gi|1509777659|gb|MG778126.1| | 1148060 | g80518 | i0 | 94.792 | 34.4478764478764 | 96 | 2 | 36 | 3 | 123 | 215 | 19408 | 19313 | Borodinellopsis texensis heme attachment to plastid cytochrome c (ccsA), photosystem II reaction center Z protein (psbZ), M protein of photosystem II (psbM), ribosomal protein S14 (rps14), ribosomal protein S7 (rps7), and ATP synthase CF1 epsilon subunit (atpE) genes, complete cds; tRNA-Leu (trnL-UAA) gene, complete sequence; ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, complete cds; tRNA-Asp (trnD-GUC) gene, complete sequence; CP47 chlorophyll apoprotein of photosystem II (psbB), hypothetical protein (psbB), photosystem II protein T (psbT), photosystem II protein N (psbN), and photosystem II protein H (psbH) genes, complete cds; tRNA-Glu (trnE-UUC) gene, complete sequence; and photosystem II protein V (psbE) and ribosomal protein S9 (rps9) genes, complete cds; chloroplast | blastn | 8922 | 147 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlorococcaceae | Borodinellopsis | Borodinellopsis texensis | |
| 25061926 | 25061926 | PRJNA849172_P_NODE_2300_length_1453_cov_21.331884_g2134_i0 | PRJNA849172 | 2300 | 1453 | 21.331884 | 309.95227452 | Haematococcus lacustris | 44745 | Plants | Plants | 1297 | 0 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g2134 | i0 | 83.391 | 245.563661390227 | 1445 | 195 | 98 | 39 | 3 | 1427 | 3556 | 2137 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 356804 | 1297 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 25062603 | 25062603 | PRJNA849172_P_NODE_45760_length_308_cov_14.051064_g45400_i0 | PRJNA849172 | 45760 | 308 | 14.051064 | 43.27727712 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 219 | 2.68e-52 | NTclustered | gi|18243|emb|X60826.1| | 3055 | g45400 | i0 | 85.577 | 18.5551948051948 | 208 | 30 | 68 | 0 | 101 | 308 | 399 | 192 | C.reinhardtii UBI3 mRNA for ubiquitin-fusion protein (UbCEP52) | blastn | 5715 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;