contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA902848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4710393 | 4710393 | PRJNA902848_P_NODE_10244_length_282_cov_1.119617_g10194_i0 | PRJNA902848 | 10244 | 282 | 1.119617 | 3.15731994 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 167 | 8.9e-37 | NTclustered | gi|2082253475|ref|XM_001695212.2| | 3055 | g10194 | i0 | 79.915 | 3.82269503546099 | 234 | 41 | 82 | 6 | 2 | 232 | 1589 | 1819 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g386750v5), mRNA | blastn | 1078 | 167 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 4710781 | 4710781 | PRJNA902848_P_NODE_8304_length_307_cov_1.333333_g8254_i0 | PRJNA902848 | 8304 | 307 | 1.333333 | 4.09333231 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 211 | 4.47e-50 | NTclustered | gi|545367524|ref|XM_005648521.1| | 574566 | g8254 | i0 | 83.475 | 8.73615635179153 | 236 | 29 | 75 | 10 | 1 | 231 | 367 | 137 | Coccomyxa subellipsoidea C-169 chloroplast ribulose 1,5-bisphosphate carboxylase/oxygenase small subunit mRNA | blastn | 2682 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 7260058 | 7260058 | PRJNA902848_P_NODE_17346_length_246_cov_1.271676_g17296_i0 | PRJNA902848 | 17346 | 246 | 1.271676 | 3.12832296 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 267 | 7.289999999999999e-67 | NTclustered | gi|27542564|gb|AY171229.1| | 3055 | g17296 | i0 | 91.282 | 73.5325203252033 | 195 | 17 | 79 | 0 | 52 | 246 | 792 | 598 | Chlamydomonas reinhardtii light-harvesting complex II protein (Lhcb) mRNA, complete cds; nuclear gene for chloroplast product | blastn | 18089 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 7260069 | 7260069 | PRJNA902848_P_NODE_17806_length_246_cov_0.901734_g17756_i0 | PRJNA902848 | 17806 | 246 | 0.901734 | 2.21826564 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 250 | 7.34e-62 | NTclustered | gi|545359564|ref|XM_005645183.1| | 574566 | g17756 | i0 | 90.86 | 2.38211382113821 | 186 | 17 | 76 | 0 | 38 | 223 | 3 | 188 | Coccomyxa subellipsoidea C-169 ribosomal protein L38 component of cytosolic 80S ribosome and 60S large subunit partial mRNA | blastn | 586 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 14001068 | 14001068 | PRJNA902848_P_NODE_6451_length_339_cov_1.109023_g6401_i0 | PRJNA902848 | 6451 | 339 | 1.109023 | 3.75958797 | Hydrodictyaceae | 3103 | Plants | Plants | 165 | 3.94e-36 | NTclustered | gi|21040380|gb|AF183479.2| | 3105 | g6401 | i0 | 95.192 | 29.7374631268437 | 104 | 5 | 31 | 0 | 236 | 339 | 2493 | 2596 | Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence | blastn | 10081 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pediastrum | Pediastrum duplex | |
| 14910087 | 14910087 | PRJNA902848_P_NODE_7072_length_327_cov_1.535433_g7022_i0 | PRJNA902848 | 7072 | 327 | 1.535433 | 5.02086591 | Monoraphidium neglectum | 145388 | Plants | Plants | 300 | 9.95e-77 | NTclustered | gi|926786183|ref|XM_014046112.1| | 145388 | g7022 | i0 | 83.18 | 31.4770642201835 | 327 | 55 | 100 | 0 | 1 | 327 | 82 | 408 | Monoraphidium neglectum 40S ribosomal protein S9-2 mRNA | blastn | 10293 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 16184801 | 16184801 | PRJNA902848_P_NODE_18113_length_245_cov_0.906977_g18063_i0 | PRJNA902848 | 18113 | 245 | 0.906977 | 2.22209365 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 453 | 5.1900000000000006e-123 | NTclustered | gi|2082251605|ref|XM_001701987.2| | 3055 | g18063 | i0 | 100 | 1 | 245 | 0 | 100 | 0 | 1 | 245 | 3120 | 3364 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_07g353450v5), mRNA | blastn | 245 | 453 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18733506 | 18733506 | PRJNA902848_P_NODE_19755_length_243_cov_0.864706_g19705_i0 | PRJNA902848 | 19755 | 243 | 0.864706 | 2.10123558 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 230 | 9.43e-56 | NTclustered | gi|545362485|ref|XM_005646412.1| | 574566 | g19705 | i0 | 83.817 | 12.0781893004115 | 241 | 39 | 99 | 0 | 3 | 243 | 1180 | 940 | Coccomyxa subellipsoidea C-169 phosphoglycerate kinase precursor partial mRNA | blastn | 2935 | 230 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 20008604 | 20008604 | PRJNA902848_P_NODE_17756_length_246_cov_0.901734_g17706_i0 | PRJNA902848 | 17756 | 246 | 0.901734 | 2.21826564 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 292 | 1.2e-74 | NTclustered | gi|545367589|ref|XM_005648552.1| | 574566 | g17706 | i0 | 91.163 | 1.1869918699187 | 215 | 19 | 87 | 0 | 1 | 215 | 114 | 328 | Coccomyxa subellipsoidea C-169 ribosomal protein L37 component of cytosolic 80S ribosome and 60S large subunit mRNA | blastn | 292 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 21284148 | 21284148 | PRJNA902848_P_NODE_8457_length_305_cov_1.439655_g8407_i0 | PRJNA902848 | 8457 | 305 | 1.439655 | 4.39094775 | Auxenochlorella pyrenoidosa | 3078 | Plants | Plants | 433 | 8.69e-117 | NTclustered | gi|49473447|gb|AY646197.1| | 3078 | g8407 | i0 | 92.409 | 20.0295081967213 | 303 | 23 | 99 | 0 | 3 | 305 | 374 | 72 | Chlorella pyrenoidosa chloroplast light-harvesting complex II (Lhc II) mRNA, partial cds; nuclear gene for chloroplast product | blastn | 6109 | 433 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 22558686 | 22558686 | PRJNA902848_P_NODE_10038_length_284_cov_1.563981_g9988_i0 | PRJNA902848 | 10038 | 284 | 1.563981 | 4.44170604 | Tetraselmis sp. RG-15 | 65602 | Plants | Plants | 259 | 1.44e-64 | NTclustered | gi|2407313|gb|AF017998.1|AF017998 | 65602 | g9988 | i0 | 83.755 | 33.3028169014084 | 277 | 41 | 97 | 3 | 8 | 282 | 1442 | 1168 | Tetraselmis sp. RG-15 chlorophyll a/b binding protein (LHCPII) gene, complete cds | blastn | 9458 | 259 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Tetraselmis | Tetraselmis sp. RG-15 | |
| 23834014 | 23834014 | PRJNA902848_P_NODE_12659_length_256_cov_1.240437_g12609_i0 | PRJNA902848 | 12659 | 256 | 1.240437 | 3.17551872 | Auxenochlorella pyrenoidosa | 3078 | Plants | Plants | 379 | 9.4e-101 | NTclustered | gi|49473447|gb|AY646197.1| | 3078 | g12609 | i0 | 93.359 | 74.7578125 | 256 | 17 | 100 | 0 | 1 | 256 | 271 | 526 | Chlorella pyrenoidosa chloroplast light-harvesting complex II (Lhc II) mRNA, partial cds; nuclear gene for chloroplast product | blastn | 19138 | 379 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa |
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);;