contig_metadata
10 rows where bioproject = "PRJNA293022", tax_clade = "core chlorophytes" and tax_kingdom = "Viridiplantae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4887682 | 4887682 | PRJNA293022_P_NODE_58384_length_182_cov_1.548872_g57647_i0 | PRJNA293022 | 58384 | 182 | 1.548872 | 2.81894704 | root | 1 | Root_unresolved | Root_unresolved | 176 | 8.8e-40 | NTclustered | gi|2507491536|dbj|LC749599.1| | 51714 | g57647 | i0 | 84.916 | 96.8131868131868 | 179 | 22 | 97 | 5 | 3 | 178 | 113026 | 112850 | Volvox africanus NIES-4468 DNA, SD-like region | blastn | 17620 | 176 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 4887687 | 4887687 | PRJNA293022_P_NODE_60144_length_179_cov_1.753846_g59407_i0 | PRJNA293022 | 60144 | 179 | 1.753846 | 3.13938434 | Eukaryota | 2759 | Plants | Plants | 54.7 | 0.004 | NTclustered | gi|2667916624|gb|OQ848499.1| | 173371 | g59407 | i0 | 100 | 0.324022346368715 | 29 | 0 | 16 | 0 | 135 | 163 | 9596 | 9568 | Cephaleuros virescens chloroplast, complete genome | blastn | 58 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Cephaleuros | Cephaleuros virescens | |
| 5476663 | 5476663 | PRJNA293022_P_NODE_21305_length_308_cov_2.250965_g20568_i0 | PRJNA293022 | 21305 | 308 | 2.250965 | 6.9329722 | Haematococcus lacustris | 44745 | Plants | Plants | 305 | 2e-78 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g20568 | i0 | 85.065 | 173.431818181818 | 308 | 36 | 97 | 8 | 1 | 300 | 3585 | 3280 | 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 | 53417 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 8712462 | 8712462 | PRJNA293022_P_NODE_76527_length_163_cov_2.201754_g75790_i0 | PRJNA293022 | 76527 | 163 | 2.201754 | 3.58885902 | root | 1 | Root_unresolved | Root_unresolved | 211 | 2.12e-50 | NTclustered | gi|1279575452|gb|MF683076.1| | 162062 | g75790 | i0 | 90.184 | 210.509202453988 | 163 | 14 | 99 | 2 | 1 | 162 | 3477 | 3316 | Aegagropila linnaei 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 34313 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Pithophoraceae | Aegagropila | Aegagropila linnaei | |
| 11262833 | 11262833 | PRJNA293022_P_NODE_32969_length_244_cov_0.943590_g32232_i0 | PRJNA293022 | 32969 | 244 | 0.94359 | 2.3023596 | Chlamydomonas | 3052 | Plants | Plants | 392 | 1.14e-104 | NTclustered | gi|397121|emb|X68924.1| | 133709 | g32232 | i0 | 95.868 | 150.25 | 242 | 10 | 99 | 0 | 3 | 244 | 959 | 1200 | Chloroplast Chlamydomonas sp. 66.72 rrnL gene, exon 2 | blastn | 36661 | 392 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. 66.72 | |
| 13813157 | 13813157 | PRJNA293022_P_NODE_72271_length_166_cov_0.888889_g71534_i0 | PRJNA293022 | 72271 | 166 | 0.888889 | 1.47555574 | root | 1 | Root_unresolved | Root_unresolved | 292 | 7.52e-75 | NTclustered | gi|1929550831|gb|MN794237.1| | 3111 | g71534 | i0 | 98.78 | 1.97590361445783 | 164 | 2 | 99 | 0 | 1 | 164 | 217 | 54 | Prototheca wickerhamii strain DBVPG mitochondrion, complete genome | blastn | 328 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 16362249 | 16362249 | PRJNA293022_P_NODE_66133_length_170_cov_2.446281_g65396_i0 | PRJNA293022 | 66133 | 170 | 2.446281 | 4.1586777 | root | 1 | Root_unresolved | Root_unresolved | 311 | 2.12e-80 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g65396 | i0 | 100 | 97.7176470588235 | 168 | 0 | 99 | 0 | 1 | 168 | 328 | 161 | 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 | 16612 | 311 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 16362256 | 16362256 | PRJNA293022_P_NODE_68833_length_168_cov_1.025210_g68096_i0 | PRJNA293022 | 68833 | 168 | 1.02521 | 1.7223528 | Chlorophyceae | 3166 | Plants | Plants | 274 | 2.7699999999999997e-69 | NTclustered | gi|1432231416|gb|MH654823.1| | 332213 | g68096 | i0 | 96.933 | 97.2559523809524 | 163 | 5 | 97 | 0 | 3 | 165 | 525 | 687 | 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 | 16339 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 19499287 | 19499287 | PRJNA293022_P_NODE_62956_length_175_cov_1.222222_g62219_i0 | PRJNA293022 | 62956 | 175 | 1.222222 | 2.1388885 | Chloroidium sp. KL-2023a | 3031248 | Plants | Plants | 298 | 1.72e-76 | NTclustered | gi|2450595352|gb|ON986219.1| | 3031248 | g62219 | i0 | 97.688 | 145.394285714286 | 173 | 4 | 99 | 0 | 1 | 173 | 220528 | 220356 | Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome | blastn | 25444 | 298 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a | |
| 21461446 | 21461446 | PRJNA293022_P_NODE_30377_length_254_cov_5.795122_g29640_i0 | PRJNA293022 | 30377 | 254 | 5.795122 | 14.71960988 | Eukaryota | 2759 | Plants | Plants | 466 | 6.95e-127 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g29640 | i0 | 100 | 99.1141732283465 | 252 | 0 | 99 | 0 | 3 | 254 | 577 | 828 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 25175 | 466 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. |
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);;