contig_metadata
11 rows where bioproject = "PRJNA846486" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2108696 | 2108696 | PRJNA846486_P_NODE_40722_length_214_cov_1.260606_g40626_i0 | PRJNA846486 | 40722 | 214 | 1.260606 | 2.69769684 | [Myrmecia] bisecta | 41462 | Plants | Plants | 105 | 2.12e-26 | NR | KAK9811451.1 | 41462 | g40626 | i0 | 76.1 | 1.86448598130841 | 67 | 16 | 93.9 | 0 | 2 | 202 | 138 | 204 | KAK9811451.1 hypothetical protein WJX72_004104 [[Myrmecia] bisecta] | diamond | 399 | 105 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 3384095 | 3384095 | PRJNA846486_P_NODE_74623_length_170_cov_1.388430_g74527_i0 | PRJNA846486 | 74623 | 170 | 1.38843 | 2.360331 | Tetradesmus obliquus | 3088 | Plants | Plants | 309 | 7.64e-80 | NTclustered | gi|1240946771|gb|KX756229.1| | 3088 | g74527 | i0 | 99.412 | 21.0117647058824 | 170 | 1 | 100 | 0 | 1 | 170 | 80269 | 80100 | Tetradesmus obliquus chloroplast, complete genome | blastn | 3572 | 309 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 8486202 | 8486202 | PRJNA846486_P_NODE_96827_length_151_cov_28.754902_g96731_i0 | PRJNA846486 | 96827 | 151 | 28.754902 | 43.41990202 | Microglena monadina | 47904 | Plants | Plants | 52.8 | 0.012 | NTclustered | gi|952953016|gb|KT624790.1| | 47904 | g96731 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 63 | 90 | 1738 | 1711 | Microglena monadina clone contig-59 chloroplast, partial genome | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Microglena | Microglena monadina | |
| 17411492 | 17411492 | PRJNA846486_P_NODE_70434_length_174_cov_1.248000_g70338_i0 | PRJNA846486 | 70434 | 174 | 1.248 | 2.17152 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 126 | 8.5e-25 | NTclustered | gi|2082265001|ref|XM_001689780.2| | 3055 | g70338 | i0 | 86.726 | 0.649425287356322 | 113 | 15 | 65 | 0 | 50 | 162 | 368 | 480 | Chlamydomonas reinhardtii ribosomal protein L35 (CHLRE_14g617900v5), mRNA | blastn | 113 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17808961 | 17808961 | PRJNA846486_P_NODE_62774_length_182_cov_1.075188_g62678_i0 | PRJNA846486 | 62774 | 182 | 1.075188 | 1.95684216 | Eukaryota | 2759 | Plants | Plants | 292 | 8.38e-75 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g62678 | i0 | 99.379 | 103.368131868132 | 161 | 1 | 100 | 0 | 22 | 182 | 58 | 218 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 18813 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 21235400 | 21235400 | PRJNA846486_P_NODE_75937_length_169_cov_1.300000_g75841_i0 | PRJNA846486 | 75937 | 169 | 1.3 | 2.197 | Jenufa minuta | 993092 | Plants | Plants | 291 | 2.75e-74 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g75841 | i0 | 97.633 | 1 | 169 | 4 | 100 | 0 | 1 | 169 | 159152 | 158984 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 169 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 24182990 | 24182990 | PRJNA846486_P_NODE_10279_length_386_cov_1.323442_g10184_i0 | PRJNA846486 | 10279 | 386 | 1.323442 | 5.10848612 | Bryopsis | 3128 | Plants | Plants | 409 | 1.9e-109 | NTclustered | gi|969822372|gb|KT950953.1| | 3129 | g10184 | i0 | 85.751 | 99.6450777202073 | 386 | 55 | 100 | 0 | 1 | 386 | 194 | 579 | Bryopsis maxima actin gene, partial cds | blastn | 38463 | 409 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis maxima | |
| 30568398 | 30568398 | PRJNA846486_P_NODE_88653_length_164_cov_0.904348_g88557_i0 | PRJNA846486 | 88653 | 164 | 0.904348 | 1.48313072 | root | 1 | Root_unresolved | Root_unresolved | 67 | 3.49e-11 | NR | WIA33345.1 | 3088 | g88557 | i0 | 60 | 11.1951219512195 | 45 | 18 | 82.3 | 0 | 163 | 29 | 1616 | 1660 | WIA33345.1 hypothetical protein OEZ86_006482 [Tetradesmus obliquus] | diamond | 1836 | 67.4 | 0.99406528189911 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 31919715 | 31919715 | PRJNA846486_P_NODE_45917_length_204_cov_1.677419_g45821_i0 | PRJNA846486 | 45917 | 204 | 1.677419 | 3.42193476 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 42 | 0.0427 | NR | GFR50714.1 | 47775 | g45821 | i0 | 46.2 | 0.764705882352941 | 52 | 23 | 72.1 | 3 | 170 | 24 | 203 | 252 | GFR50714.1 hypothetical protein Agub_g12971 [Astrephomene gubernaculifera] | diamond | 156 | 42 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 32457750 | 32457750 | PRJNA846486_P_NODE_42639_length_210_cov_1.614907_g42543_i0 | PRJNA846486 | 42639 | 210 | 1.614907 | 3.3913047 | Chlamydomonas incerta | 51695 | Plants | Plants | 92 | 1.03e-21 | NR | KAG2442829.1 | 51695 | g42543 | i0 | 58.6 | 3 | 70 | 29 | 100 | 0 | 1 | 210 | 12 | 81 | KAG2442829.1 hypothetical protein HXX76_002908 [Chlamydomonas incerta] | diamond | 630 | 92 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 32835860 | 32835860 | PRJNA846486_P_NODE_81700_length_167_cov_0.881356_g81604_i0 | PRJNA846486 | 81700 | 167 | 0.881356 | 1.47186452 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 47.8 | 2.2e-4 | NR | KAF6262770.1 | 2650976 | g81604 | i0 | 65.9 | 0.736526946107784 | 41 | 14 | 73.7 | 0 | 6 | 128 | 64 | 104 | KAF6262770.1 hypothetical protein COO60DRAFT_571601 [Scenedesmus sp. NREL 46B-D3] | diamond | 123 | 47.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 |
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);;