contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1023223 | 1023223 | PRJNA1112809_P_NODE_158501_length_256_cov_0.841530_g155226_i0 | PRJNA1112809 | 158501 | 256 | 0.84153 | 2.1543168 | Haematococcus | 44744 | Plants | Plants | 468 | 1.95e-127 | NTclustered | gi|1341122420|gb|MG022682.1| | 44745 | g155226 | i0 | 99.609 | 100.01953125 | 256 | 1 | 100 | 0 | 1 | 256 | 766 | 511 | Haematococcus lacustris isolate CCAP 34/1F small subunit ribosomal RNA gene, partial sequence | blastn | 25605 | 468 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 1494956 | 1494956 | PRJNA1112809_P_NODE_195962_length_236_cov_2.558282_g192687_i0 | PRJNA1112809 | 195962 | 236 | 2.558282 | 6.03754552 | Chlamydomonas peterfii | 28462 | Plants | Plants | 403 | 5.07e-108 | NTclustered | gi|952953330|gb|KT624938.1| | 28462 | g192687 | i0 | 97.458 | 153.46186440678 | 236 | 6 | 100 | 0 | 1 | 236 | 1811 | 2046 | Chlamydomonas peterfii clone contig00007 chloroplast, partial genome | blastn | 36217 | 403 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas peterfii | |
| 2298588 | 2298588 | PRJNA1112809_P_NODE_129322_length_285_cov_1.726415_g126047_i0 | PRJNA1112809 | 129322 | 285 | 1.726415 | 4.92028275 | Trebouxia | 13786 | Plants | Plants | 527 | 3.59e-145 | NTclustered | gi|49781197|gb|AY648107.1| | 283661 | g126047 | i0 | 100 | 99.8175438596491 | 285 | 0 | 100 | 0 | 1 | 285 | 324 | 40 | Trebouxia sp. Wei 22-c 26S ribosomal RNA gene, partial sequence | blastn | 28448 | 527 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. Wei 22-c | |
| 14248420 | 14248420 | PRJNA1112809_P_NODE_150432_length_263_cov_1.542105_g147157_i0 | PRJNA1112809 | 150432 | 263 | 1.542105 | 4.05573615 | Haematococcus lacustris | 44745 | Plants | Plants | 403 | 5.75e-108 | NTclustered | gi|2201040776|gb|MN709220.1| | 44745 | g147157 | i0 | 94.074 | 146.368821292776 | 270 | 9 | 100 | 3 | 1 | 263 | 638869 | 638600 | Haematococcus lacustris strain FACHB-712 chloroplast, complete genome | blastn | 38495 | 403 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 16796389 | 16796389 | PRJNA1112809_P_NODE_137554_length_276_cov_1.517241_g134279_i0 | PRJNA1112809 | 137554 | 276 | 1.517241 | 4.18758516 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 298 | 2.95e-76 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g134279 | i0 | 86.545 | 14.9855072463768 | 275 | 32 | 99 | 5 | 1 | 273 | 5419 | 5690 | 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 | 4136 | 298 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 16798708 | 16798708 | PRJNA1112809_P_NODE_85174_length_367_cov_1.479592_g81899_i0 | PRJNA1112809 | 85174 | 367 | 1.479592 | 5.43010264 | Chloroidium sp. KL-2023a | 3031248 | Plants | Plants | 628 | 1.2699999999999998e-175 | NTclustered | gi|2450595352|gb|ON986219.1| | 3031248 | g81899 | i0 | 97.548 | 108.891008174387 | 367 | 9 | 100 | 0 | 1 | 367 | 220550 | 220916 | Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome | blastn | 39963 | 628 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a | |
| 18070644 | 18070644 | PRJNA1112809_P_NODE_125075_length_290_cov_1.465438_g121800_i0 | PRJNA1112809 | 125075 | 290 | 1.465438 | 4.2497702 | Chloroidium sp. KL-2023a | 3031248 | Plants | Plants | 503 | 6.17e-138 | NTclustered | gi|2450595352|gb|ON986219.1| | 3031248 | g121800 | i0 | 97.931 | 106.744827586207 | 290 | 6 | 100 | 0 | 1 | 290 | 2051 | 1762 | Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome | blastn | 30956 | 503 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a | |
| 18874894 | 18874894 | PRJNA1112809_P_NODE_142315_length_271_cov_1.555556_g139040_i0 | PRJNA1112809 | 142315 | 271 | 1.555556 | 4.21555676 | Viridiplantae | 33090 | Plants | Plants | 339 | 1.7e-88 | NTclustered | gi|2082253475|ref|XM_001695212.2| | 3055 | g139040 | i0 | 89.85 | 98.5719557195572 | 266 | 23 | 97 | 3 | 8 | 271 | 1413 | 1150 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g386750v5), mRNA | blastn | 26713 | 340 | 0.997058823529412 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 23173423 | 23173423 | PRJNA1112809_P_NODE_62779_length_455_cov_2.408377_g59506_i0 | PRJNA1112809 | 62779 | 455 | 2.408377 | 10.95811535 | Chlamydomonas chlamydogama | 225041 | Plants | Plants | 673 | 0 | NTclustered | gi|66864258|gb|DQ015713.1| | 225041 | g59506 | i0 | 95.082 | 94.1054945054945 | 427 | 21 | 94 | 0 | 23 | 449 | 1855 | 1429 | Chlamydomonas chlamydogama strain UTEX 102 26S ribosomal RNA gene, partial sequence | blastn | 42818 | 673 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas chlamydogama | |
| 24447531 | 24447531 | PRJNA1112809_P_NODE_76100_length_396_cov_2.167183_g72825_i0 | PRJNA1112809 | 76100 | 396 | 2.167183 | 8.58204468 | Haematococcus lacustris | 44745 | Plants | Plants | 534 | 3.089999999999999e-147 | NTclustered | gi|2201040776|gb|MN709220.1| | 44745 | g72825 | i0 | 90.998 | 121.068181818182 | 411 | 15 | 100 | 10 | 1 | 396 | 8351 | 7948 | Haematococcus lacustris strain FACHB-712 chloroplast, complete genome | blastn | 47943 | 534 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris |
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);;