contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1174207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4868851 | 4868851 | PRJNA1174207_P_NODE_43724_length_204_cov_4.251908_g43195_i0 | PRJNA1174207 | 43724 | 204 | 4.251908 | 8.67389232 | root | 1 | Root_unresolved | Root_unresolved | 287 | 4.479999999999999e-73 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g43195 | i0 | 92.233 | 100.78431372549 | 206 | 10 | 99 | 6 | 1 | 203 | 4838 | 5040 | Chloroidium ellipsoideum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 20560 | 287 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 11794520 | 11794520 | PRJNA1174207_P_NODE_42970_length_229_cov_2.205128_g42441_i0 | PRJNA1174207 | 42970 | 229 | 2.205128 | 5.04974312 | Chloromonas actinochloris | 158501 | Plants | Plants | 274 | 4.0099999999999997e-69 | NTclustered | gi|66864280|gb|DQ015735.1| | 158501 | g42441 | i0 | 88.261 | 100.2096069869 | 230 | 25 | 100 | 2 | 1 | 229 | 1624 | 1396 | Chloromonas actinochloris strain SAG 1.72 26S ribosomal RNA gene, partial sequence | blastn | 22948 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chloromonas | Chloromonas actinochloris | |
| 13793835 | 13793835 | PRJNA1174207_P_NODE_20671_length_311_cov_1.995798_g20142_i0 | PRJNA1174207 | 20671 | 311 | 1.995798 | 6.20693178 | Jaagichlorella | 2304164 | Plants | Plants | 564 | 3.02e-156 | NTclustered | gi|1802907783|gb|MT006204.1| | 2704669 | g20142 | i0 | 99.357 | 99.7781350482315 | 311 | 2 | 100 | 0 | 1 | 311 | 3193 | 3503 | Jaagichlorella nagensis strain FACHB-2415 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 | 31031 | 564 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella nagensis | |
| 15068493 | 15068493 | PRJNA1174207_P_NODE_43552_length_213_cov_4.600000_g43023_i0 | PRJNA1174207 | 43552 | 213 | 4.6 | 9.798 | Watanabeaceae | 2981775 | Plants | Plants | 383 | 5.8499999999999996e-102 | NTclustered | gi|1561005731|gb|MG493347.1| | 167235 | g43023 | i0 | 99.061 | 99.6244131455399 | 213 | 2 | 100 | 0 | 1 | 213 | 109 | 321 | Uncultured Trebouxiophyceae clone LSY2026 18S ribosomal RNA gene, partial sequence | blastn | 21220 | 383 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Trebouxiophyceae | ||||
| 16343185 | 16343185 | PRJNA1174207_P_NODE_31433_length_258_cov_3.405405_g30904_i0 | PRJNA1174207 | 31433 | 258 | 3.405405 | 8.7859449 | root | 1 | Root_unresolved | Root_unresolved | 455 | 1.53e-123 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g30904 | i0 | 98.456 | 100.352713178295 | 259 | 3 | 100 | 1 | 1 | 258 | 876 | 618 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 25891 | 455 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 23992668 | 23992668 | PRJNA1174207_P_NODE_18199_length_333_cov_4.519231_g17670_i0 | PRJNA1174207 | 18199 | 333 | 4.5192310000000004 | 15.04903923 | Trebouxiophyceae | 75966 | Plants | Plants | 599 | 8.94e-167 | NTclustered | gi|148763239|gb|EF595524.1| | 445995 | g17670 | i0 | 99.102 | 101.765765765766 | 334 | 2 | 100 | 1 | 1 | 333 | 1329 | 996 | Heveochlorella hainangensis strain FGG01 18S ribosomal RNA gene, complete sequence | blastn | 33888 | 604 | 0.991721854304636 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella hainangensis |
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);;