contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA436017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7467195 | 7467195 | PRJNA436017_P_NODE_7446_length_325_cov_6.295139_g7149_i0 | PRJNA436017 | 7446 | 325 | 6.295139 | 20.45920175 | Eukaryota | 2759 | Plants | Plants | 464 | 3.3099999999999995e-126 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g7149 | i0 | 92.901 | 99.6184615384615 | 324 | 15 | 99 | 3 | 2 | 325 | 821 | 506 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 32376 | 464 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 9358831 | 9358831 | PRJNA436017_P_NODE_18808_length_189_cov_1.171053_g18510_i0 | PRJNA436017 | 18808 | 189 | 1.171053 | 2.21329017 | Chaetophoropsis cf. attenuata FACHB-2291 | 2725790 | Plants | Plants | 172 | 1.19e-38 | NTclustered | gi|1831430457|gb|MN701986.1| | 2725790 | g18510 | i0 | 83.77 | 136.772486772487 | 191 | 21 | 97 | 8 | 6 | 189 | 4604 | 4417 | Chaetophoropsis cf. attenuata FACHB-2291 chloroplast, complete genome | blastn | 25850 | 172 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetophorales | Chaetophoraceae | Chaetophoropsis | Chaetophoropsis cf. attenuata FACHB-2291 | |
| 11292298 | 11292298 | PRJNA436017_P_NODE_7809_length_316_cov_13.899642_g7512_i0 | PRJNA436017 | 7809 | 316 | 13.899642 | 43.92286872 | Eukaryota | 2759 | Plants | Plants | 584 | 2.359999999999999e-162 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g7512 | i0 | 100 | 99.9335443037975 | 316 | 0 | 100 | 0 | 1 | 316 | 821 | 506 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 31579 | 584 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 18940462 | 18940462 | PRJNA436017_P_NODE_10555_length_264_cov_6632.859031_g10257_i0 | PRJNA436017 | 10555 | 264 | 6632.859031 | 17510.74784184 | root | 1 | Root_unresolved | Root_unresolved | 416 | 7.419999999999999e-112 | NTclustered | gi|2507491536|dbj|LC749599.1| | 51714 | g10257 | i0 | 95.113 | 100.912878787879 | 266 | 10 | 100 | 3 | 1 | 264 | 112046 | 111782 | Volvox africanus NIES-4468 DNA, SD-like region | blastn | 26641 | 416 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 21490889 | 21490889 | PRJNA436017_P_NODE_29177_length_151_cov_1.368421_g28879_i0 | PRJNA436017 | 29177 | 151 | 1.368421 | 2.06631571 | root | 1 | Root_unresolved | Root_unresolved | 257 | 2.43e-64 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g28879 | i0 | 97.351 | 81.7615894039735 | 151 | 4 | 100 | 0 | 1 | 151 | 68 | 218 | 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 | 12346 | 257 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 24656967 | 24656967 | PRJNA436017_P_NODE_14280_length_220_cov_2.289617_g13982_i0 | PRJNA436017 | 14280 | 220 | 2.289617 | 5.0371574 | Polulichloris maxima | 2704661 | Plants | Plants | 97.1 | 8.87e-16 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g13982 | i0 | 88.608 | 0.359090909090909 | 79 | 9 | 36 | 0 | 54 | 132 | 127394 | 127472 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 79 | 97.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima |
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);;