contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA796753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3331658 | 3331658 | PRJNA796753_P_NODE_11763_length_407_cov_1.832335_g11451_i0 | PRJNA796753 | 11763 | 407 | 1.832335 | 7.45760345 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 195 | 6.13e-45 | NTclustered | gi|2082260551|ref|XM_001702928.2| | 3055 | g11451 | i0 | 82.301 | 2.56265356265356 | 226 | 38 | 55 | 2 | 135 | 359 | 159 | 383 | Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA | blastn | 1043 | 195 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 3768354 | 3768354 | PRJNA796753_P_NODE_19003_length_336_cov_1.262357_g18691_i0 | PRJNA796753 | 19003 | 336 | 1.262357 | 4.24151952 | Eukaryota | 2759 | Plants | Plants | 309 | 1.7e-79 | NTclustered | gi|18243|emb|X60826.1| | 3055 | g18691 | i0 | 85.862 | 179.651785714286 | 290 | 41 | 86 | 0 | 45 | 334 | 392 | 103 | C.reinhardtii UBI3 mRNA for ubiquitin-fusion protein (UbCEP52) | blastn | 60363 | 311 | 0.993569131832797 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 3768418 | 3768418 | PRJNA796753_P_NODE_3763_length_687_cov_4.114007_g3470_i0 | PRJNA796753 | 3763 | 687 | 4.114007 | 28.26322809 | Eukaryota | 2759 | Plants | Plants | 660 | 0 | NTclustered | gi|2082244282|ref|XM_001703058.2| | 3055 | g3470 | i0 | 85.226 | 85.7278020378457 | 643 | 93 | 93 | 2 | 46 | 687 | 563 | 1204 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_04g216850v5), mRNA | blastn | 58895 | 660 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 7594806 | 7594806 | PRJNA796753_P_NODE_28346_length_285_cov_2.174528_g28034_i0 | PRJNA796753 | 28346 | 285 | 2.174528 | 6.1974048 | Eukaryota | 2759 | Plants | Plants | 250 | 8.699999999999999e-62 | NTclustered | gi|371782091|emb|HE610123.1| | 3107 | g28034 | i0 | 91.398 | 65.9263157894737 | 186 | 10 | 65 | 5 | 66 | 250 | 5126 | 4946 | Hydrodictyon reticulatum 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M2243 | blastn | 18789 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Hydrodictyon | Hydrodictyon reticulatum | |
| 8433766 | 8433766 | PRJNA796753_P_NODE_25187_length_299_cov_1.362832_g24875_i0 | PRJNA796753 | 25187 | 299 | 1.362832 | 4.07486768 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 204 | 7.249999999999999e-48 | NTclustered | gi|2082240135|ref|XM_001699602.2| | 3055 | g24875 | i0 | 83.26 | 16.4013377926421 | 227 | 32 | 75 | 6 | 62 | 285 | 298 | 75 | Chlamydomonas reinhardtii ribosomal protein L27a (CHLRE_02g115200v5), mRNA | blastn | 4904 | 204 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 8433784 | 8433784 | PRJNA796753_P_NODE_27667_length_288_cov_1.027907_g27355_i0 | PRJNA796753 | 27667 | 288 | 1.027907 | 2.96037216 | Chlorella variabilis | 554065 | Plants | Plants | 156 | 1.97e-33 | NTclustered | gi|552839912|ref|XM_005849855.1| | 554065 | g27355 | i0 | 85.43 | 11.3298611111111 | 151 | 20 | 52 | 2 | 139 | 288 | 586 | 437 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_56085) mRNA, complete cds | blastn | 3263 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 10984553 | 10984553 | PRJNA796753_P_NODE_1529_length_1008_cov_3.659893_g1327_i0 | PRJNA796753 | 1529 | 1008 | 3.659893 | 36.89172144 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 425 | 5.23e-114 | NTclustered | gi|2082263148|ref|XM_001693658.2| | 3055 | g1327 | i0 | 78.066 | 31.2688492063492 | 693 | 138 | 68 | 12 | 1 | 683 | 36 | 724 | Chlamydomonas reinhardtii ribosomal protein S3a (CHLRE_13g568650v5), mRNA | blastn | 31519 | 425 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10984855 | 10984855 | PRJNA796753_P_NODE_9129_length_456_cov_4.391645_g8817_i0 | PRJNA796753 | 9129 | 456 | 4.391645 | 20.0259012 | Monoraphidium neglectum | 145388 | Plants | Plants | 220 | 1.15e-52 | NTclustered | gi|926796681|ref|XM_014050626.1| | 145388 | g8817 | i0 | 81.455 | 37.5482456140351 | 275 | 45 | 60 | 6 | 43 | 314 | 38 | 309 | Monoraphidium neglectum 60S ribosomal protein L30 mRNA | blastn | 17122 | 220 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 12260277 | 12260277 | PRJNA796753_P_NODE_44050_length_248_cov_0.880000_g43738_i0 | PRJNA796753 | 44050 | 248 | 0.88 | 2.1824 | Chlamydomonas sp. CCMP225 | 429245 | Plants | Plants | 206 | 1.6299999999999998e-48 | NTclustered | gi|134142236|gb|EF432456.1| | 429245 | g43738 | i0 | 86.559 | 86.741935483871 | 186 | 25 | 75 | 0 | 63 | 248 | 10 | 195 | Chlamydomonas sp. CCMP225 clone B1 beta tubulin (btub) mRNA, partial cds | blastn | 21512 | 206 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. CCMP225 | |
| 13534532 | 13534532 | PRJNA796753_P_NODE_5811_length_561_cov_4.778689_g5503_i0 | PRJNA796753 | 5811 | 561 | 4.778689 | 26.80844529 | Monoraphidium neglectum | 145388 | Plants | Plants | 102 | 5.41e-17 | NTclustered | gi|926765541|ref|XM_014036369.1| | 145388 | g5503 | i0 | 87.64 | 1.01247771836007 | 89 | 9 | 16 | 2 | 63 | 150 | 44 | 131 | Monoraphidium neglectum 40S ribosomal protein S29 mRNA | blastn | 568 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 15245069 | 15245069 | PRJNA796753_P_NODE_1512_length_1012_cov_4.648562_g1311_i0 | PRJNA796753 | 1512 | 1012 | 4.648562 | 47.04344744 | Chlorophyta | 3041 | Plants | Plants | 372 | 6.94e-98 | NTclustered | gi|2082260161|ref|XM_001690941.2| | 3055 | g1311 | i0 | 83.929 | 29.6225296442688 | 392 | 59 | 39 | 4 | 43 | 432 | 160 | 549 | Chlamydomonas reinhardtii ribosomal protein S23 (CHLRE_12g504200v5), mRNA | blastn | 29978 | 374 | 0.994652406417112 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 16083367 | 16083367 | PRJNA796753_P_NODE_54653_length_241_cov_0.916667_g54341_i0 | PRJNA796753 | 54653 | 241 | 0.916667 | 2.20916747 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 182 | 2.65e-41 | NTclustered | gi|2082244625|ref|XM_001698617.2| | 3055 | g54341 | i0 | 82.243 | 1.77593360995851 | 214 | 34 | 88 | 4 | 30 | 241 | 519 | 308 | Chlamydomonas reinhardtii ribosomal protein S12 (CHLRE_04g214503v5), mRNA | blastn | 428 | 182 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17359032 | 17359032 | PRJNA796753_P_NODE_26114_length_294_cov_1.357466_g25802_i0 | PRJNA796753 | 26114 | 294 | 1.357466 | 3.99095004 | Chlorella variabilis | 554065 | Plants | Plants | 252 | 2.51e-62 | NTclustered | gi|552811023|ref|XM_005843291.1| | 554065 | g25802 | i0 | 86.017 | 27.2448979591837 | 236 | 32 | 80 | 1 | 48 | 283 | 895 | 661 | Chlorella variabilis S-adenosyl-L-homocysteine hydrolase (CHLNCDRAFT_37522) mRNA, complete cds | blastn | 8010 | 252 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 23733430 | 23733430 | PRJNA796753_P_NODE_23639_length_308_cov_0.982979_g23327_i0 | PRJNA796753 | 23639 | 308 | 0.982979 | 3.02757532 | Monoraphidium neglectum | 145388 | Plants | Plants | 193 | 1.62e-44 | NTclustered | gi|926780633|ref|XM_014043337.1| | 145388 | g23327 | i0 | 82.222 | 15.2564935064935 | 225 | 38 | 73 | 2 | 85 | 308 | 452 | 229 | Monoraphidium neglectum 40S ribosomal protein S14-3 mRNA | blastn | 4699 | 193 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;