contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA489308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 450412 | 450412 | PRJNA489308_P_NODE_6141_length_430_cov_2.235294_g6065_i0 | PRJNA489308 | 6141 | 430 | 2.235294 | 9.6117642 | Monoraphidium neglectum | 145388 | Plants | Plants | 63.9 | 1.92e-5 | NTclustered | gi|926791232|ref|XM_014048636.1| | 145388 | g6065 | i0 | 97.297 | 1.0093023255814 | 37 | 1 | 9 | 0 | 391 | 427 | 188 | 152 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 434 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 1725000 | 1725000 | PRJNA489308_P_NODE_40002_length_233_cov_2.406250_g39926_i0 | PRJNA489308 | 40002 | 233 | 2.40625 | 5.6065625 | Chlorella variabilis | 554065 | Plants | Plants | 215 | 2.51e-51 | NTclustered | gi|552843554|ref|XM_005850806.1| | 554065 | g39926 | i0 | 83.7 | 26.244635193133 | 227 | 37 | 97 | 0 | 7 | 233 | 433 | 207 | Chlorella variabilis cytoplasmic ribosomal protein S13 (CHLNCDRAFT_55999) mRNA, complete cds | blastn | 6115 | 215 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 4926243 | 4926243 | PRJNA489308_P_NODE_4644_length_482_cov_2.652812_g4568_i0 | PRJNA489308 | 4644 | 482 | 2.652812 | 12.78655384 | root | 1 | Root_unresolved | Root_unresolved | 289 | 3.29e-73 | NTclustered | gi|926791444|ref|XM_014048742.1| | 145388 | g4568 | i0 | 78.604 | 95.8879668049793 | 444 | 89 | 91 | 6 | 32 | 472 | 2886 | 2446 | Monoraphidium neglectum adenosylhomocysteinase mRNA | blastn | 46218 | 291 | 0.993127147766323 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 5553797 | 5553797 | PRJNA489308_P_NODE_325_length_1315_cov_3.604670_g291_i0 | PRJNA489308 | 325 | 1315 | 3.60467 | 47.4014105 | Monoraphidium neglectum | 145388 | Plants | Plants | 861 | 0 | NTclustered | gi|926791444|ref|XM_014048742.1| | 145388 | g291 | i0 | 79.755 | 92.9437262357415 | 1225 | 218 | 92 | 26 | 1 | 1213 | 2884 | 1678 | Monoraphidium neglectum adenosylhomocysteinase mRNA | blastn | 122221 | 861 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 9377885 | 9377885 | PRJNA489308_P_NODE_11668_length_339_cov_1.157895_g11592_i0 | PRJNA489308 | 11668 | 339 | 1.157895 | 3.92526405 | Chlamydomonas incerta | 51695 | Plants | Plants | 250 | 1.06e-61 | NTclustered | gi|74272614|gb|DQ122872.1| | 51695 | g11592 | i0 | 80.982 | 76.3097345132743 | 326 | 53 | 96 | 2 | 11 | 336 | 770 | 454 | Chlamydomonas incerta mitochondrial ADP/ATP translocator (ANT) mRNA, complete cds; nuclear gene for mitochondrial product | blastn | 25869 | 250 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 10026401 | 10026401 | PRJNA489308_P_NODE_28328_length_257_cov_2.304348_g28252_i0 | PRJNA489308 | 28328 | 257 | 2.304348 | 5.92217436 | Chlorellales | 35460 | Plants | Plants | 150 | 8.06e-32 | NTclustered | gi|9188542|dbj|AB036814.1| | 3077 | g28252 | i0 | 88.372 | 39.6381322957198 | 129 | 9 | 50 | 4 | 7 | 135 | 328 | 450 | Chlorella vulgaris tubA mRNA for alpha-tubulin, partial cds | blastn | 10187 | 150 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 10653817 | 10653817 | PRJNA489308_P_NODE_2089_length_664_cov_3.925550_g2014_i0 | PRJNA489308 | 2089 | 664 | 3.92555 | 26.065652 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 335 | 5.859999999999999e-87 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g2014 | i0 | 77.526 | 73.3012048192771 | 574 | 117 | 86 | 11 | 78 | 645 | 857 | 290 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 48672 | 335 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 11928752 | 11928752 | PRJNA489308_P_NODE_16570_length_304_cov_1.194805_g16494_i0 | PRJNA489308 | 16570 | 304 | 1.194805 | 3.6322072 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 195 | 4.4499999999999995e-45 | NTclustered | gi|2082237330|ref|XM_001689650.2| | 3055 | g16494 | i0 | 79 | 55.2335526315789 | 300 | 51 | 97 | 8 | 11 | 304 | 2129 | 2422 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g042750v5), mRNA | blastn | 16791 | 195 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 13203996 | 13203996 | PRJNA489308_P_NODE_5291_length_457_cov_6.611979_g5215_i0 | PRJNA489308 | 5291 | 457 | 6.611979 | 30.21674403 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 106 | 3.35e-18 | NTclustered | gi|2082260798|ref|XM_001697008.2| | 3055 | g5215 | i0 | 92 | 1.2144420131291 | 75 | 6 | 16 | 0 | 281 | 355 | 957 | 1031 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g520500v5), mRNA | blastn | 555 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 15752775 | 15752775 | PRJNA489308_P_NODE_1553_length_749_cov_3.436391_g1482_i0 | PRJNA489308 | 1553 | 749 | 3.436391 | 25.73856859 | Monoraphidium neglectum | 145388 | Plants | Plants | 231 | 8.98e-56 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g1482 | i0 | 80.192 | 20.8504672897196 | 313 | 58 | 42 | 4 | 75 | 385 | 55 | 365 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 15617 | 231 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 15753021 | 15753021 | PRJNA489308_P_NODE_9333_length_365_cov_1.544521_g9257_i0 | PRJNA489308 | 9333 | 365 | 1.544521 | 5.63750165 | Auxenochlorella pyrenoidosa | 3078 | Plants | Plants | 664 | 0 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g9257 | i0 | 99.452 | 95.345205479452 | 365 | 2 | 100 | 0 | 1 | 365 | 593 | 957 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 34801 | 664 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 20851893 | 20851893 | PRJNA489308_P_NODE_34157_length_247_cov_0.885057_g34081_i0 | PRJNA489308 | 34157 | 247 | 0.885057 | 2.18609079 | Scherffelia dubia | 3190 | Plants | Plants | 211 | 3.48e-50 | NTclustered | gi|21208|emb|X69220.1| | 3190 | g34081 | i0 | 82.186 | 2.97165991902834 | 247 | 42 | 99 | 2 | 1 | 246 | 420 | 175 | S.dubia mRNA for caltractin | blastn | 734 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Scherffelia | Scherffelia dubia |
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);;