contig_metadata
17 rows where bioproject = "PRJNA674050" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3194139 | 3194139 | PRJNA674050_P_NODE_11763_length_289_cov_2.523148_g11560_i0 | PRJNA674050 | 11763 | 289 | 2.523148 | 7.29189772 | Tetrabaena socialis | 47790 | Plants | Plants | 420 | 6.359999999999998e-113 | NTclustered | gi|1042780592|gb|KX232643.1| | 47790 | g11560 | i0 | 92.833 | 221.110726643599 | 293 | 15 | 99 | 5 | 2 | 289 | 23811 | 23520 | Tetrabaena socialis chloroplast | blastn | 63901 | 420 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Tetrabaenaceae | Tetrabaena | Tetrabaena socialis | |
| 3718084 | 3718084 | PRJNA674050_P_NODE_8343_length_312_cov_4.899582_g8140_i0 | PRJNA674050 | 8343 | 312 | 4.899582 | 15.28669584 | Chlamydomonadales | 3042 | Plants | Plants | 577 | 3.89e-160 | NTclustered | gi|430007894|gb|JX888471.1| | 3055 | g8140 | i0 | 100 | 100 | 312 | 0 | 100 | 0 | 1 | 312 | 930 | 619 | Chlamydomonas reinhardtii strain CC-620 18S ribosomal RNA gene, partial sequence | blastn | 31200 | 577 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 7023104 | 7023104 | PRJNA674050_P_NODE_6346_length_332_cov_1.084942_g6143_i0 | PRJNA674050 | 6346 | 332 | 1.084942 | 3.60200744 | Prototheca bovis | 2509265 | Plants | Plants | 327 | 4.639999999999999e-85 | NTclustered | gi|1770690688|ref|NC_045058.1| | 2509265 | g6143 | i0 | 85.397 | 83.1867469879518 | 315 | 46 | 95 | 0 | 18 | 332 | 29435 | 29121 | Prototheca zopfii strain SAG 2021 mitochondrion, complete genome | blastn | 27618 | 327 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca bovis | |
| 8819426 | 8819426 | PRJNA674050_P_NODE_36747_length_243_cov_2.017647_g36544_i0 | PRJNA674050 | 36747 | 243 | 2.017647 | 4.90288221 | Eukaryota | 2759 | Plants | Plants | 449 | 6.65e-122 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g36544 | i0 | 100 | 100.004115226337 | 243 | 0 | 100 | 0 | 1 | 243 | 25 | 267 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 24301 | 449 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 12645597 | 12645597 | PRJNA674050_P_NODE_11590_length_290_cov_1.423963_g11387_i0 | PRJNA674050 | 11590 | 290 | 1.423963 | 4.1294927 | Chlamydomonadales | 3042 | Plants | Plants | 531 | 2.83e-146 | NTclustered | gi|17028282|gb|L43356.1|CRECPRRNLG | 28464 | g11387 | i0 | 99.655 | 133.51724137931 | 290 | 1 | 100 | 0 | 1 | 290 | 3687 | 3976 | Chlamydomonas zebra chloroplast large subunit ribosomal RNA (rrnL) gene | blastn | 38720 | 531 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas zebra | |
| 15194948 | 15194948 | PRJNA674050_P_NODE_9572_length_303_cov_2.000000_g9369_i0 | PRJNA674050 | 9572 | 303 | 2 | 6.06 | root | 1 | Root_unresolved | Root_unresolved | 560 | 3.79e-155 | NTclustered | gi|1212783794|gb|MF083691.1| | 3055 | g9369 | i0 | 100 | 120.26402640264 | 303 | 0 | 100 | 0 | 1 | 303 | 36582 | 36884 | Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome | blastn | 36440 | 560 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17222538 | 17222538 | PRJNA674050_P_NODE_7134_length_323_cov_3.556000_g6931_i0 | PRJNA674050 | 7134 | 323 | 3.556 | 11.48588 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 597 | 3.11e-166 | NTclustered | gi|167047969|gb|EU410621.1| | 3055 | g6931 | i0 | 100 | 61.5572755417957 | 323 | 0 | 100 | 0 | 1 | 323 | 3330 | 3008 | Chlamydomonas reinhardtii 26S ribosomal RNA gene, partial sequence | blastn | 19883 | 597 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18496422 | 18496422 | PRJNA674050_P_NODE_33155_length_245_cov_1.744186_g32952_i0 | PRJNA674050 | 33155 | 245 | 1.744186 | 4.2732557 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 448 | 2.41e-121 | NTclustered | gi|1212783794|gb|MF083691.1| | 3055 | g32952 | i0 | 99.592 | 147.897959183673 | 245 | 1 | 100 | 0 | 1 | 245 | 41115 | 40871 | Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome | blastn | 36235 | 448 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19770238 | 19770238 | PRJNA674050_P_NODE_1456_length_554_cov_2.216216_g1258_i0 | PRJNA674050 | 1456 | 554 | 2.216216 | 12.27783664 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 1024 | 0 | NTclustered | gi|1212783794|gb|MF083691.1| | 3055 | g1258 | i0 | 100 | 149.404332129964 | 554 | 0 | 100 | 0 | 1 | 554 | 40598 | 40045 | Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome | blastn | 82770 | 1024 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22843836 | 22843836 | PRJNA674050_P_NODE_5318_length_346_cov_1.054945_g5115_i0 | PRJNA674050 | 5318 | 346 | 1.054945 | 3.6501097 | Marvania | 97104 | Plants | Plants | 211 | 5.11e-50 | NTclustered | gi|2724824493|gb|PP746561.1| | 97105 | g5115 | i0 | 81.004 | 38.4508670520231 | 279 | 42 | 79 | 10 | 8 | 282 | 28725 | 28996 | Marvania geminata culture SAG:12.88 mitochondrion, complete genome | blastn | 13304 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Marvania | Marvania geminata | |
| 25392754 | 25392754 | PRJNA674050_P_NODE_19960_length_258_cov_21.102703_g19757_i0 | PRJNA674050 | 19960 | 258 | 21.102703 | 54.44497374 | Eukaryota | 2759 | Plants | Plants | 292 | 1.27e-74 | NTclustered | gi|1255307117|gb|KY198301.1| | 3067 | g19757 | i0 | 100 | 77.6589147286822 | 158 | 0 | 86 | 0 | 9 | 166 | 379 | 222 | Volvox carteri isolate EMBOSS_001 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20036 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 25392796 | 25392796 | PRJNA674050_P_NODE_3720_length_380_cov_3.175896_g3517_i0 | PRJNA674050 | 3720 | 380 | 3.175896 | 12.0684048 | Chlamydomonas | 3052 | Plants | Plants | 702 | 0 | NTclustered | gi|2082265827|ref|XM_043070485.1| | 3055 | g3517 | i0 | 100 | 100.189473684211 | 380 | 0 | 100 | 0 | 1 | 380 | 2278 | 1899 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_14g634365v5), mRNA | blastn | 38072 | 702 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 26669948 | 26669948 | PRJNA674050_P_NODE_39461_length_242_cov_0.917160_g39258_i0 | PRJNA674050 | 39461 | 242 | 0.91716 | 2.2195272 | Trebouxia sp. C | 2796353 | Plants | Plants | 51.2 | 3.85e-5 | NR | KAL0043787.1 | 2905655 | g39258 | i0 | 39 | 0.954545454545455 | 77 | 42 | 89.3 | 1 | 225 | 10 | 482 | 558 | KAL0043787.1 hypothetical protein WJX82_010718 [Trebouxia sp. C0006] | diamond | 231 | 51.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0006 | |
| 28250200 | 28250200 | PRJNA674050_P_NODE_28586_length_248_cov_0.891429_g28383_i0 | PRJNA674050 | 28586 | 248 | 0.891429 | 2.21074392 | Chlamydomonas incerta | 51695 | Plants | Plants | 120 | 2.15e-29 | NR | KAG2442811.1 | 51695 | g28383 | i0 | 67.1 | 3.82258064516129 | 79 | 26 | 95.6 | 0 | 12 | 248 | 340 | 418 | KAG2442811.1 hypothetical protein HXX76_002890 [Chlamydomonas incerta] | diamond | 948 | 120 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 30081617 | 30081617 | PRJNA674050_P_NODE_31252_length_247_cov_0.873563_g31049_i0 | PRJNA674050 | 31252 | 247 | 0.873563 | 2.15770061 | Haematococcus lacustris | 44745 | Plants | Plants | 90.1 | 8.52e-19 | NR | KAJ9513997.1 | 44745 | g31049 | i0 | 48.9 | 1.09311740890688 | 90 | 38 | 99.6 | 1 | 246 | 1 | 541 | 630 | KAJ9513997.1 hypothetical protein QJQ45_021078 [Haematococcus lacustris] | diamond | 270 | 90.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 30346970 | 30346970 | PRJNA674050_P_NODE_15892_length_272_cov_1.924623_g15689_i0 | PRJNA674050 | 15892 | 272 | 1.924623 | 5.23497456 | Chlorellales | 35460 | Plants | Plants | 84.3 | 1.17e-18 | NR | PRW20803.1 | 3076 | g15689 | i0 | 58.9 | 6.9375 | 90 | 26 | 99.3 | 2 | 270 | 1 | 27 | 105 | PRW20803.1 60S ribosomal L35-like [Chlorella sorokiniana] | diamond | 1887 | 85.1 | 0.990599294947121 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 32516500 | 32516500 | PRJNA674050_P_NODE_35399_length_244_cov_0.912281_g35196_i0 | PRJNA674050 | 35399 | 244 | 0.912281 | 2.22596564 | Tetradesmus obliquus | 3088 | Plants | Plants | 61.6 | 8.02e-9 | NR | WIA09331.1 | 3088 | g35196 | i0 | 55.6 | 3.90983606557377 | 45 | 20 | 55.3 | 0 | 233 | 99 | 500 | 544 | WIA09331.1 hypothetical protein OEZ85_008738 [Tetradesmus obliquus] | diamond | 954 | 61.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus |
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);;