contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA788929" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2045088 | 2045088 | PRJNA788929_P_NODE_17962_length_390_cov_9.921136_g17302_i0 | PRJNA788929 | 17962 | 390 | 9.921136 | 38.6924304 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 54.7 | 0.01 | NTclustered | gi|2082264539|ref|XM_043069919.1| | 3055 | g17302 | i0 | 100 | 0.720512820512821 | 29 | 0 | 7 | 0 | 127 | 155 | 6137 | 6165 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_14g608150v5), mRNA | blastn | 281 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 3320323 | 3320323 | PRJNA788929_P_NODE_11743_length_509_cov_38.470183_g11088_i0 | PRJNA788929 | 11743 | 509 | 38.470183 | 195.81323147 | Yamagishiella unicocca | 51707 | Plants | Plants | 69.4 | 4.95e-7 | NTclustered | gi|1808707058|gb|MH511786.1| | 51707 | g11088 | i0 | 79.817 | 1.1335952848723 | 109 | 11 | 21 | 9 | 227 | 332 | 3440 | 3540 | Yamagishiella unicocca clone NODE_1113 photosystem II protein VI (psbF) and photosystem II protein L (psbL) genes, complete cds; plastid | blastn | 577 | 69.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Yamagishiella | Yamagishiella unicocca | |
| 4597642 | 4597642 | PRJNA788929_P_NODE_32564_length_274_cov_14.149254_g31903_i0 | PRJNA788929 | 32564 | 274 | 14.149254000000001 | 38.76895596 | Pseudendoclonium arthopyreniae | 926286 | Plants | Plants | 414 | 2.7899999999999998e-111 | NTclustered | gi|312165803|gb|HM068616.1| | 926286 | g31903 | i0 | 96.414 | 9.5 | 251 | 9 | 92 | 0 | 1 | 251 | 431 | 181 | Pseudendoclonium arthopyreniae strain SAG 467-2 23S ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 2603 | 414 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Kornmanniaceae | Pseudendoclonium | Pseudendoclonium arthopyreniae | |
| 7147902 | 7147902 | PRJNA788929_P_NODE_34426_length_265_cov_31.135417_g33765_i0 | PRJNA788929 | 34426 | 265 | 31.135417 | 82.50885505 | Prototheca wickerhamii | 3111 | Plants | Plants | 449 | 7.35e-122 | NTclustered | gi|1929550831|gb|MN794237.1| | 3111 | g33765 | i0 | 100 | 15.5584905660377 | 243 | 0 | 92 | 0 | 23 | 265 | 26 | 268 | Prototheca wickerhamii strain DBVPG mitochondrion, complete genome | blastn | 4123 | 449 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 8422409 | 8422409 | PRJNA788929_P_NODE_22967_length_337_cov_19.299242_g22306_i0 | PRJNA788929 | 22967 | 337 | 19.299242 | 65.03844554 | Lobosphaera incisa | 312850 | Plants | Plants | 95.3 | 5.21e-15 | NTclustered | gi|821316988|ref|NC_027060.1| | 312850 | g22306 | i0 | 85.106 | 26.1810089020772 | 94 | 12 | 27 | 2 | 141 | 232 | 18722 | 18629 | Lobosphaera incisa strain SAG 2468 mitochondrion, complete genome | blastn | 8823 | 95.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Lobosphaera | Lobosphaera incisa | |
| 9697529 | 9697529 | PRJNA788929_P_NODE_21048_length_355_cov_26.450355_g20388_i0 | PRJNA788929 | 21048 | 355 | 26.450355 | 93.89876025 | Chlamydomonas sp. | 2812568 | Plants | Plants | 193 | 1.9e-44 | NTclustered | gi|2862228870|gb|PQ645504.1| | 2812568 | g20388 | i0 | 78.209 | 61.6985915492958 | 335 | 50 | 91 | 17 | 10 | 332 | 4992 | 4669 | Chlamydomonas sp. isolate AGSB0357 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 | 21903 | 193 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. | |
| 9697942 | 9697942 | PRJNA788929_P_NODE_48748_length_206_cov_8.789474_g48087_i0 | PRJNA788929 | 48748 | 206 | 8.789474 | 18.10631644 | Desmochloris halophila | 138176 | Plants | Plants | 364 | 2.0399999999999993e-96 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g48087 | i0 | 98.544 | 100.315533980583 | 206 | 3 | 100 | 0 | 1 | 206 | 2808 | 2603 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 20665 | 364 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 13523069 | 13523069 | PRJNA788929_P_NODE_27311_length_304_cov_9.419913_g26650_i0 | PRJNA788929 | 27311 | 304 | 9.419913 | 28.63653552 | Koliella sp. HS-2024a | 3231931 | Plants | Plants | 91.6 | 6e-14 | NTclustered | gi|2754686564|gb|PP990794.1| | 3231931 | g26650 | i0 | 78.986 | 1.875 | 138 | 25 | 45 | 4 | 1 | 138 | 9483 | 9616 | Koliella sp. HS-2024a strain FACHB-3607 mitochondrion, complete genome | blastn | 570 | 91.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella sp. HS-2024a | |
| 17347902 | 17347902 | PRJNA788929_P_NODE_47494_length_214_cov_6.205674_g46833_i0 | PRJNA788929 | 47494 | 214 | 6.205674 | 13.28014236 | chlorobiont of Psora decipiens | 1938899 | Plants | Plants | 363 | 7.669999999999997e-96 | NTclustered | gi|1158556075|emb|LT717549.1| | 1938899 | g46833 | i0 | 99.497 | 92.5560747663551 | 199 | 1 | 93 | 0 | 16 | 214 | 469 | 271 | Chlorobiont of Psora decipiens partial 26S rRNA gene, isolate Ger1-Swe | blastn | 19807 | 363 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | chlorobiont of Psora decipiens | ||||
| 19896434 | 19896434 | PRJNA788929_P_NODE_45956_length_224_cov_6.887417_g45295_i0 | PRJNA788929 | 45956 | 224 | 6.887417 | 15.42781408 | Ulothrix zonata | 43941 | Plants | Plants | 340 | 3.789999999999999e-89 | NTclustered | gi|530445654|emb|HE860533.1| | 43941 | g45295 | i0 | 97.044 | 88.9955357142857 | 203 | 4 | 90 | 2 | 23 | 224 | 114 | 315 | Ulothrix zonata partial 28S rRNA gene, isolate Q19 | blastn | 19935 | 340 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Ulotrichaceae | Ulothrix | Ulothrix zonata |
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);;