contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2719255 | 2719255 | PRJNA1035005_P_NODE_35743_length_275_cov_1.465347_g35337_i0 | PRJNA1035005 | 35743 | 275 | 1.465347 | 4.02970425 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 60.2 | 1.51e-4 | NTclustered | gi|2917929620|emb|OZ234908.1| | 3350044 | g35337 | i0 | 89.362 | 0.170909090909091 | 47 | 5 | 17 | 0 | 222 | 268 | 2144501 | 2144455 | Trebouxia sp. SL0000003 genome assembly, chromosome: 3 | blastn | 47 | 60.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 7821546 | 7821546 | PRJNA1035005_P_NODE_53587_length_253_cov_0.866667_g53181_i0 | PRJNA1035005 | 53587 | 253 | 0.866667 | 2.19266751 | Lobosphaera incisa | 312850 | Plants | Plants | 333 | 7.319999999999999e-87 | NTclustered | gi|725539263|gb|KM821265.1| | 312850 | g53181 | i0 | 90.514 | 130.355731225296 | 253 | 23 | 100 | 1 | 1 | 253 | 135849 | 135598 | Lobosphaera incisa chloroplast, complete genome | blastn | 32980 | 333 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Lobosphaera | Lobosphaera incisa | |
| 7821624 | 7821624 | PRJNA1035005_P_NODE_64627_length_249_cov_0.886364_g64221_i0 | PRJNA1035005 | 64627 | 249 | 0.886364 | 2.20704636 | Ignatius tetrasporus | 231078 | Plants | Plants | 161 | 3.59e-35 | NTclustered | gi|220966697|gb|FJ539138.1| | 231078 | g64221 | i0 | 78.838 | 62.5381526104418 | 241 | 49 | 96 | 2 | 1 | 240 | 523 | 762 | Ignatius tetrasporus strain UTEX B 2012 elongation factor-1 alpha mRNA, partial cds | blastn | 15572 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ignatiales | Ignatiaceae | Ignatius | Ignatius tetrasporus | |
| 9096535 | 9096535 | PRJNA1035005_P_NODE_54868_length_253_cov_0.866667_g54462_i0 | PRJNA1035005 | 54868 | 253 | 0.866667 | 2.19266751 | Chlamydomonas incerta | 51695 | Plants | Plants | 172 | 1.69e-38 | NTclustered | gi|74272614|gb|DQ122872.1| | 51695 | g54462 | i0 | 79.752 | 6.90909090909091 | 242 | 45 | 95 | 4 | 12 | 251 | 420 | 659 | Chlamydomonas incerta mitochondrial ADP/ATP translocator (ANT) mRNA, complete cds; nuclear gene for mitochondrial product | blastn | 1748 | 172 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 10372071 | 10372071 | PRJNA1035005_P_NODE_4009_length_534_cov_1.216920_g3611_i0 | PRJNA1035005 | 4009 | 534 | 1.21692 | 6.4983528 | Pseudochlorella signiensis | 173497 | Plants | Plants | 874 | 0 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g3611 | i0 | 96.591 | 130.063670411985 | 528 | 17 | 99 | 1 | 8 | 534 | 151059 | 151586 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 69454 | 874 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 11647633 | 11647633 | PRJNA1035005_P_NODE_7510_length_399_cov_2.352761_g7108_i0 | PRJNA1035005 | 7510 | 399 | 2.352761 | 9.38751639 | Trentepohlia sp. BN17 | 3063876 | Plants | Plants | 76.8 | 2.27e-9 | NTclustered | gi|2192923729|ref|NC_060532.1| | 3063876 | g7108 | i0 | 92.453 | 0.894736842105263 | 53 | 4 | 13 | 0 | 79 | 131 | 223485 | 223433 | Trentepohlia sp. BN17 chloroplast, complete genome | blastn | 357 | 76.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Trentepohlia | Trentepohlia sp. BN17 |
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);;