contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1249535" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 356545 | 356545 | PRJNA1249535_S_NODE_223701_length_294_cov_1.411765_g220318_i0 | PRJNA1249535 | 223701 | 294 | 1.411765 | 4.1505891 | Chloroidium sp. KL-2023a | 3031248 | Plants | Plants | 403 | 6.5399999999999995e-108 | NTclustered | gi|2450595352|gb|ON986219.1| | 3031248 | g220318 | i0 | 95.968 | 96.1598639455782 | 248 | 10 | 97 | 0 | 3 | 250 | 248 | 1 | Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome | blastn | 28271 | 403 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a | |
| 2907387 | 2907387 | PRJNA1249535_S_NODE_219583_length_296_cov_2.008969_g216200_i0 | PRJNA1249535 | 219583 | 296 | 2.008969 | 5.94654824 | Pectinodesmus pectinatus | 91197 | Plants | Plants | 52.8 | 0.027 | NTclustered | gi|1331211341|ref|NC_036668.1| | 91197 | g216200 | i0 | 100 | 0.0945945945945946 | 28 | 0 | 9 | 0 | 4 | 31 | 35920 | 35893 | Pectinodesmus pectinatus chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Pectinodesmus | Pectinodesmus pectinatus | |
| 2907829 | 2907829 | PRJNA1249535_S_NODE_256683_length_276_cov_3.566502_g253300_i0 | PRJNA1249535 | 256683 | 276 | 3.566502 | 9.84354552 | Cephaleuros karstenii | 1985640 | Plants | Plants | 54.7 | 0.007 | NTclustered | gi|2192923902|ref|NC_060534.1| | 1985640 | g253300 | i0 | 100 | 0.206521739130435 | 29 | 0 | 11 | 0 | 1 | 29 | 2090 | 2062 | Cephaleuros karstenii strain GD1942 chloroplast, complete genome | blastn | 57 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Cephaleuros | Cephaleuros karstenii | |
| 8011541 | 8011541 | PRJNA1249535_S_NODE_34547_length_547_cov_4.635021_g31269_i0 | PRJNA1249535 | 34547 | 547 | 4.635021 | 25.35356487 | Cephaleuros diffusus | 1519597 | Plants | Plants | 56.5 | 0.004 | NTclustered | gi|2692956661|ref|NC_086864.1| | 1519597 | g31269 | i0 | 96.97 | 0.0603290676416819 | 33 | 1 | 6 | 0 | 334 | 366 | 147036 | 147068 | Cephaleuros diffusus chloroplast, complete genome | blastn | 33 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Cephaleuros | Cephaleuros diffusus | |
| 14384529 | 14384529 | PRJNA1249535_S_NODE_131672_length_347_cov_6.489051_g128289_i0 | PRJNA1249535 | 131672 | 347 | 6.489051 | 22.51700697 | Cephaleuros karstenii | 1985640 | Plants | Plants | 52.8 | 0.033 | NTclustered | gi|2192923902|ref|NC_060534.1| | 1985640 | g128289 | i0 | 100 | 0.0806916426512968 | 28 | 0 | 8 | 0 | 121 | 148 | 143934 | 143961 | Cephaleuros karstenii strain GD1942 chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Cephaleuros | Cephaleuros karstenii | |
| 15661155 | 15661155 | PRJNA1249535_S_NODE_43433_length_503_cov_27.672093_g40105_i0 | PRJNA1249535 | 43433 | 503 | 27.672093 | 139.19062779 | Hydrodictyon reticulatum | 3107 | Plants | Plants | 54.7 | 0.014 | NTclustered | gi|1197510262|ref|NC_034655.1| | 3107 | g40105 | i0 | 90.476 | 0.0834990059642147 | 42 | 2 | 8 | 1 | 80 | 119 | 11454 | 11495 | Hydrodictyon reticulatum voucher HAM0289 chloroplast, complete genome | blastn | 42 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Hydrodictyon | Hydrodictyon reticulatum | |
| 21454316 | 21454316 | PRJNA1249535_S_NODE_297357_length_254_cov_2.337017_g293974_i0 | PRJNA1249535 | 297357 | 254 | 2.337017 | 5.93602318 | Stichococcaceae | 2910630 | Plants | Plants | 453 | 5.41e-123 | NTclustered | gi|728042166|gb|KM438447.1| | 358140 | g293974 | i0 | 98.819 | 99.8779527559055 | 254 | 3 | 100 | 0 | 1 | 254 | 517 | 264 | Stichococcus jenerensis isolate CAUP J 1302 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast | blastn | 25369 | 453 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Tetratostichococcus | Tetratostichococcus jenerensis | |
| 24582730 | 24582730 | PRJNA1249535_S_NODE_200560_length_306_cov_2.334764_g197177_i0 | PRJNA1249535 | 200560 | 306 | 2.334764 | 7.14437784 | Sykidion marinum | 44573 | Plants | Plants | 52.8 | 0.029 | NTclustered | gi|1197510977|ref|NC_034710.1| | 44573 | g197177 | i0 | 100 | 0.0915032679738562 | 28 | 0 | 9 | 0 | 224 | 251 | 6491 | 6464 | Pseudoneochloris marina culture UTEX:1445 chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Sykidiales | Sykidiacaeae | Sykidion | Sykidion marinum |
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);;