contig_metadata
12 rows where bioproject = "PRJNA682370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 664327 | 664327 | PRJNA682370_S_NODE_21981_length_156_cov_1.264463_g21369_i0 | PRJNA682370 | 21981 | 156 | 1.264463 | 1.97256228 | Tetraselmis suecica | 270643 | Plants | Plants | 134 | 4.4600000000000006e-27 | NTclustered | gi|1486933343|gb|MF957257.1| | 270643 | g21369 | i0 | 82.468 | 40.5448717948718 | 154 | 25 | 98 | 2 | 4 | 156 | 999 | 847 | Tetraselmis suecica heat shock protein 70 mRNA, complete cds | blastn | 6325 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Tetraselmis | Tetraselmis suecica | |
| 664537 | 664537 | PRJNA682370_S_NODE_7061_length_287_cov_2.134921_g6449_i0 | PRJNA682370 | 7061 | 287 | 2.134921 | 6.12722327 | Dicloster acuatus | 91190 | Plants | Plants | 134 | 9.21e-27 | NTclustered | gi|2724824305|gb|PP746556.1| | 91190 | g6449 | i0 | 80.925 | 76.0313588850174 | 173 | 30 | 60 | 3 | 43 | 214 | 1587 | 1417 | Dicloster acuatus culture SAG:41.98 mitochondrion, complete genome | blastn | 21821 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 5003002 | 5003002 | PRJNA682370_S_NODE_15064_length_184_cov_2.120805_g14452_i0 | PRJNA682370 | 15064 | 184 | 2.120805 | 3.9022812 | Trebouxiaceae | 2507902 | Plants | Plants | 126 | 9.12e-25 | NTclustered | gi|1750939486|gb|MH917293.1| | 1825957 | g14452 | i0 | 91.304 | 98.8315217391304 | 92 | 8 | 50 | 0 | 47 | 138 | 15464 | 15373 | Trebouxia sp. TR9 mitochondrion, complete genome | blastn | 18185 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 5003006 | 5003006 | PRJNA682370_S_NODE_15704_length_180_cov_2.606897_g15092_i0 | PRJNA682370 | 15704 | 180 | 2.606897 | 4.6924146 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 85.9 | 5.97e-18 | NR | XP_005648509.1 | 574566 | g15092 | i0 | 63.8 | 4.75 | 58 | 18 | 96.7 | 1 | 5 | 178 | 127 | 181 | XP_005648509.1 glutamine synthetase [Coccomyxa subellipsoidea C-169] | diamond | 855 | 85.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 10868241 | 10868241 | PRJNA682370_S_NODE_16689_length_175_cov_1.835714_g16077_i0 | PRJNA682370 | 16689 | 175 | 1.835714 | 3.2124995 | Eukaryota | 2759 | Plants | Plants | 110 | 8.34e-29 | NR | KAF5828155.1 | 3046 | g16077 | i0 | 87.9 | 21.8571428571429 | 58 | 7 | 99.4 | 0 | 174 | 1 | 81 | 138 | KAF5828155.1 cyclophilin [Dunaliella salina] | diamond | 3825 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 13418239 | 13418239 | PRJNA682370_S_NODE_17271_length_172_cov_2.299270_g16659_i0 | PRJNA682370 | 17271 | 172 | 2.29927 | 3.9547444 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 82 | 1.95e-16 | NR | GMH46020.1 | 3041901 | g16659 | i0 | 64.3 | 0.976744186046512 | 56 | 20 | 97.7 | 0 | 170 | 3 | 475 | 530 | GMH46020.1 hypothetical protein BSKO_13984 [Bryopsis sp. KO-2023] | diamond | 168 | 82 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 27093722 | 27093722 | PRJNA682370_S_NODE_11382_length_215_cov_1.872222_g10770_i0 | PRJNA682370 | 11382 | 215 | 1.872222 | 4.0252773 | root | 1 | Root_unresolved | Root_unresolved | 68.2 | 2.68e-11 | NR | KAG2485882.1 | 47281 | g10770 | i0 | 30.9 | 6.01395348837209 | 136 | 28 | 97.7 | 1 | 213 | 4 | 198 | 333 | KAG2485882.1 hypothetical protein HYH03_015465 [Edaphochlamys debaryana] | diamond | 1293 | 68.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 27946595 | 27946595 | PRJNA682370_S_NODE_18705_length_166_cov_2.106870_g18093_i0 | PRJNA682370 | 18705 | 166 | 2.10687 | 3.4974042 | Eukaryota | 2759 | Plants | Plants | 93.2 | 1.01e-20 | NR | KAK9817935.1 | 41462 | g18093 | i0 | 64.8 | 48.7951807228916 | 54 | 19 | 97.6 | 0 | 164 | 3 | 180 | 233 | KAK9817935.1 hypothetical protein WJX72_004517 [[Myrmecia] bisecta] | diamond | 8100 | 94 | 0.991489361702128 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 29955775 | 29955775 | PRJNA682370_S_NODE_22991_length_153_cov_1.915254_g22379_i0 | PRJNA682370 | 22991 | 153 | 1.915254 | 2.93033862 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 54.3 | 1.72e-7 | NR | CAG9466578.1 | 765719 | g22379 | i0 | 51.9 | 1.01960784313725 | 52 | 24 | 100 | 1 | 153 | 1 | 79 | 130 | CAG9466578.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 156 | 54.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 29967471 | 29967471 | PRJNA682370_S_NODE_8871_length_250_cov_2.762791_g8259_i0 | PRJNA682370 | 8871 | 250 | 2.762791 | 6.9069775 | Eukaryota | 2759 | Plants | Plants | 115 | 4.07e-31 | NR | KAK2080556.1 | 3111 | g8259 | i0 | 70.3 | 7.104 | 74 | 22 | 88.8 | 0 | 249 | 28 | 33 | 106 | KAK2080556.1 hypothetical protein QBZ16_000409 [Prototheca wickerhamii] | diamond | 1776 | 116 | 0.991379310344828 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 30050378 | 30050378 | PRJNA682370_S_NODE_20271_length_161_cov_1.261905_g19659_i0 | PRJNA682370 | 20271 | 161 | 1.261905 | 2.03166705 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 78.2 | 2.71e-15 | NR | GMH32513.1 | 3041901 | g19659 | i0 | 67.9 | 4.93788819875776 | 53 | 17 | 98.8 | 0 | 161 | 3 | 293 | 345 | GMH32513.1 hypothetical protein BSKO_00347 [Bryopsis sp. KO-2023] | diamond | 795 | 78.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 31294423 | 31294423 | PRJNA682370_S_NODE_21915_length_156_cov_1.438017_g21303_i0 | PRJNA682370 | 21915 | 156 | 1.438017 | 2.24330652 | Chlamydomonas | 3052 | Plants | Plants | 58.5 | 9.28e-9 | NR | KAG2438503.1 | 51695 | g21303 | i0 | 53.2 | 3.67307692307692 | 47 | 22 | 90.4 | 0 | 4 | 144 | 82 | 128 | KAG2438503.1 hypothetical protein HXX76_005054 [Chlamydomonas incerta] | diamond | 573 | 58.9 | 0.99320882852292 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta |
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);;