contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 213413 | 213413 | PRJNA1108487_P_NODE_4361_length_333_cov_4.665385_g4295_i0 | PRJNA1108487 | 4361 | 333 | 4.665385 | 15.53573205 | Polytomella parva | 51329 | Plants | Plants | 361 | 4.59e-95 | NTclustered | gi|1861356233|gb|MT377344.1| | 51329 | g4295 | i0 | 86.186 | 99.2102102102102 | 333 | 46 | 100 | 0 | 1 | 333 | 780 | 1112 | Polytomella parva clone 0016303185 chain x, ATP synthase subunit beta (ATP5F1B) mRNA, complete cds; plastid | blastn | 33037 | 361 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 1020494 | 1020494 | PRJNA1108487_P_NODE_6381_length_284_cov_2.208531_g6315_i0 | PRJNA1108487 | 6381 | 284 | 2.208531 | 6.27222804 | Eukaryota | 2759 | Plants | Plants | 340 | 4.999999999999999e-89 | NTclustered | gi|969822378|gb|KT950956.1| | 432605 | g6315 | i0 | 92.149 | 85.4049295774648 | 242 | 17 | 85 | 2 | 1 | 241 | 253 | 13 | Valonia macrophysa isolate 1528 actin gene, partial cds | blastn | 24255 | 340 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Valoniaceae | Valonia | Valonia macrophysa | |
| 3571131 | 3571131 | PRJNA1108487_P_NODE_6843_length_275_cov_2.292079_g6777_i0 | PRJNA1108487 | 6843 | 275 | 2.292079 | 6.30321725 | Polytomella | 3049 | Plants | Plants | 161 | 4.02e-35 | NTclustered | gi|28193497|emb|AJ439528.1| | 37502 | g6777 | i0 | 77.617 | 19.1272727272727 | 277 | 54 | 99 | 8 | 3 | 275 | 449 | 177 | Polytomella sp. 'Pringsheim 198.80' mRNA for 40S ribosomal protein s5 (rs5 gene) | blastn | 5260 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 4040203 | 4040203 | PRJNA1108487_P_NODE_2364_length_441_cov_1.483696_g2298_i0 | PRJNA1108487 | 2364 | 441 | 1.483696 | 6.54309936 | Chlorella variabilis | 554065 | Plants | Plants | 202 | 4e-47 | NTclustered | gi|552841589|ref|XM_005850287.1| | 554065 | g2298 | i0 | 89.024 | 37.6326530612245 | 164 | 16 | 37 | 2 | 26 | 188 | 863 | 1025 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_30080) mRNA, partial cds | blastn | 16596 | 202 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 4040221 | 4040221 | PRJNA1108487_P_NODE_4804_length_320_cov_1.838057_g4738_i0 | PRJNA1108487 | 4804 | 320 | 1.838057 | 5.8817824 | Volvox carteri | 3067 | Plants | Plants | 276 | 1.64e-69 | NTclustered | gi|302836142|ref|XM_002949586.1| | 3068 | g4738 | i0 | 82.298 | 92.003125 | 322 | 53 | 100 | 4 | 1 | 320 | 785 | 1104 | Volvox carteri f. nagariensis succinate dehydrogenase subunit A, mitochondrial (sdh1), mRNA | blastn | 29441 | 276 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 5316327 | 5316327 | PRJNA1108487_P_NODE_665_length_796_cov_7.035961_g607_i0 | PRJNA1108487 | 665 | 796 | 7.035961 | 56.00624956 | Monoraphidium neglectum | 145388 | Plants | Plants | 231 | 9.56e-56 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g607 | i0 | 80.192 | 19.285175879397 | 313 | 58 | 39 | 4 | 83 | 393 | 55 | 365 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 15351 | 231 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 6123604 | 6123604 | PRJNA1108487_P_NODE_1645_length_524_cov_1.432373_g1579_i0 | PRJNA1108487 | 1645 | 524 | 1.432373 | 7.50563452 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.014 | NTclustered | gi|2082265843|ref|XM_043070493.1| | 3055 | g1579 | i0 | 100 | 0.110687022900763 | 29 | 0 | 6 | 0 | 275 | 303 | 775 | 803 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_15g634750v5), mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 6591498 | 6591498 | PRJNA1108487_P_NODE_106_length_1572_cov_3.486991_g82_i0 | PRJNA1108487 | 106 | 1572 | 3.486991 | 54.81549852 | Monoraphidium neglectum | 145388 | Plants | Plants | 911 | 0 | NTclustered | gi|926791444|ref|XM_014048742.1| | 145388 | g82 | i0 | 79.259 | 86.9961832061069 | 1350 | 246 | 85 | 30 | 106 | 1441 | 1678 | 3007 | Monoraphidium neglectum adenosylhomocysteinase mRNA | blastn | 136758 | 911 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 7866180 | 7866180 | PRJNA1108487_P_NODE_4767_length_321_cov_1.758065_g4701_i0 | PRJNA1108487 | 4767 | 321 | 1.758065 | 5.64338865 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 228 | 4.659999999999999e-55 | NTclustered | gi|2082251132|ref|XM_001692487.2| | 3055 | g4701 | i0 | 81.852 | 68.0467289719626 | 270 | 49 | 84 | 0 | 36 | 305 | 1507 | 1238 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_07g343700v5), mRNA | blastn | 21843 | 228 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 11223977 | 11223977 | PRJNA1108487_P_NODE_11189_length_242_cov_0.923077_g11123_i0 | PRJNA1108487 | 11189 | 242 | 0.923077 | 2.23384634 | Eukaryota | 2759 | Plants | Plants | 58.4 | 4.69e-4 | NTclustered | gi|2082266707|ref|XM_043070771.1| | 3055 | g11123 | i0 | 100 | 4.38429752066116 | 31 | 0 | 13 | 0 | 152 | 182 | 4304 | 4334 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_16g649433v5), mRNA | blastn | 1061 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 12967252 | 12967252 | PRJNA1108487_P_NODE_1591_length_529_cov_2.936404_g1525_i0 | PRJNA1108487 | 1591 | 529 | 2.936404 | 15.53357716 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 346 | 2.13e-90 | NTclustered | gi|2082241923|ref|XM_001697441.2| | 3055 | g1525 | i0 | 80.973 | 69.1039697542533 | 452 | 72 | 84 | 12 | 37 | 481 | 755 | 1199 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g160500v5), mRNA | blastn | 36556 | 346 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 16323118 | 16323118 | PRJNA1108487_P_NODE_893_length_689_cov_10.477273_g831_i0 | PRJNA1108487 | 893 | 689 | 10.477273 | 72.18841097 | Eukaryota | 2759 | Plants | Plants | 324 | 1.32e-83 | NTclustered | gi|552825417|ref|XM_005846759.1| | 554065 | g831 | i0 | 81.818 | 29.3323657474601 | 385 | 70 | 56 | 0 | 135 | 519 | 13 | 397 | Chlorella variabilis 40S ribosomal protein S14 (CHLNCDRAFT_135401) mRNA, complete cds | blastn | 20210 | 327 | 0.990825688073395 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 18065091 | 18065091 | PRJNA1108487_P_NODE_1935_length_487_cov_18.582126_g1869_i0 | PRJNA1108487 | 1935 | 487 | 18.582126 | 90.49495362 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 106 | 3.59e-18 | NTclustered | gi|2082260798|ref|XM_001697008.2| | 3055 | g1869 | i0 | 92 | 1.13963039014374 | 75 | 6 | 15 | 0 | 283 | 357 | 957 | 1031 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g520500v5), mRNA | blastn | 555 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20146947 | 20146947 | PRJNA1108487_P_NODE_616_length_822_cov_1.144192_g558_i0 | PRJNA1108487 | 616 | 822 | 1.144192 | 9.40525824 | Chlorophyta | 3041 | Plants | Plants | 494 | 1.14e-134 | NTclustered | gi|2082256114|ref|XM_001702538.2| | 3055 | g558 | i0 | 80.787 | 76.0182481751825 | 635 | 118 | 77 | 4 | 1 | 633 | 899 | 1531 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_10g422600v5), mRNA | blastn | 62487 | 494 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20614533 | 20614533 | PRJNA1108487_P_NODE_11617_length_228_cov_2.225806_g11551_i0 | PRJNA1108487 | 11617 | 228 | 2.225806 | 5.07483768 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 220 | 5.26e-53 | NTclustered | gi|2082257783|ref|XM_001698358.2| | 3055 | g11551 | i0 | 84.211 | 18.4912280701754 | 228 | 35 | 100 | 1 | 1 | 228 | 1399 | 1173 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_10g461050v5), mRNA | blastn | 4216 | 220 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 21422632 | 21422632 | PRJNA1108487_P_NODE_7657_length_262_cov_2.444444_g7591_i0 | PRJNA1108487 | 7657 | 262 | 2.444444 | 6.40444328 | Eukaryota | 2759 | Plants | Plants | 484 | 1.99e-132 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g7591 | i0 | 100 | 100.003816793893 | 262 | 0 | 100 | 0 | 1 | 262 | 25 | 286 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 26201 | 484 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. |
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);;