contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA540466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508238 | 508238 | PRJNA540466_S_NODE_53601_length_257_cov_1.255435_g53052_i0 | PRJNA540466 | 53601 | 257 | 1.255435 | 3.22646795 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 154 | 6.23e-33 | NTclustered | gi|2082263148|ref|XM_001693658.2| | 3055 | g53052 | i0 | 81.152 | 11.2529182879377 | 191 | 36 | 74 | 0 | 1 | 191 | 545 | 735 | Chlamydomonas reinhardtii ribosomal protein S3a (CHLRE_13g568650v5), mRNA | blastn | 2892 | 154 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 6885716 | 6885716 | PRJNA540466_S_NODE_40266_length_289_cov_2.097222_g39717_i0 | PRJNA540466 | 40266 | 289 | 2.097222 | 6.06097158 | Ulva prolifera | 3117 | Plants | Plants | 67.6 | 9.55e-7 | NTclustered | gi|254558247|gb|GQ285222.1| | 3117 | g39717 | i0 | 95.238 | 0.934256055363322 | 42 | 2 | 19 | 0 | 225 | 266 | 1976 | 1935 | Ulva prolifera heat shock protein 70 mRNA, complete cds | blastn | 270 | 67.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva prolifera | |
| 10711940 | 10711940 | PRJNA540466_S_NODE_19569_length_399_cov_21.257669_g19020_i0 | PRJNA540466 | 19569 | 399 | 21.257669 | 84.81809931 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 102 | 3.74e-17 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g19020 | i0 | 85.294 | 1.49624060150376 | 102 | 12 | 26 | 2 | 211 | 312 | 86227 | 86129 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 597 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 11321490 | 11321490 | PRJNA540466_S_NODE_20889_length_388_cov_1.546032_g20340_i0 | PRJNA540466 | 20889 | 388 | 1.546032 | 5.99860416 | Chlorophyta | 3041 | Plants | Plants | 84.2 | 1.31e-11 | NTclustered | gi|2724824566|gb|PP746563.1| | 3171 | g20340 | i0 | 86.667 | 30.4072164948454 | 75 | 10 | 19 | 0 | 60 | 134 | 2789 | 2863 | Myrmecia israelensis culture UTEX:1181 mitochondrion, complete genome | blastn | 11798 | 84.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 11986893 | 11986893 | PRJNA540466_S_NODE_50310_length_263_cov_4.089474_g49761_i0 | PRJNA540466 | 50310 | 263 | 4.089474 | 10.75531662 | Chlorella variabilis | 554065 | Plants | Plants | 71.3 | 6.63e-8 | NTclustered | gi|552839912|ref|XM_005849855.1| | 554065 | g49761 | i0 | 76.027 | 0.665399239543726 | 146 | 30 | 55 | 4 | 9 | 152 | 490 | 632 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_56085) mRNA, complete cds | blastn | 175 | 71.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 13261795 | 13261795 | PRJNA540466_S_NODE_31451_length_322_cov_1.100402_g30902_i0 | PRJNA540466 | 31451 | 322 | 1.100402 | 3.54329444 | Monoraphidium neglectum | 145388 | Plants | Plants | 291 | 5.88e-74 | NTclustered | gi|926798264|ref|XM_014051102.1| | 145388 | g30902 | i0 | 83.882 | 37.7701863354037 | 304 | 49 | 94 | 0 | 1 | 304 | 522 | 219 | Monoraphidium neglectum 60S ribosomal protein L18-3 mRNA | blastn | 12162 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 15146554 | 15146554 | PRJNA540466_S_NODE_52012_length_260_cov_1.534759_g51463_i0 | PRJNA540466 | 52012 | 260 | 1.534759 | 3.9903734 | Chlamydomonadales | 3042 | Plants | Plants | 442 | 1.1999999999999999e-119 | NTclustered | gi|1212783794|gb|MF083691.1| | 3055 | g51463 | i0 | 97.308 | 162.7 | 260 | 7 | 100 | 0 | 1 | 260 | 37376 | 37635 | Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome | blastn | 42302 | 442 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22185081 | 22185081 | PRJNA540466_S_NODE_71478_length_204_cov_7.664122_g70929_i0 | PRJNA540466 | 71478 | 204 | 7.664122 | 15.63480888 | Prototheca wickerhamii | 3111 | Plants | Plants | 211 | 2.77e-50 | NTclustered | gi|11497452|ref|NC_001613.1| | 3111 | g70929 | i0 | 94.203 | 5.14705882352941 | 138 | 8 | 68 | 0 | 44 | 181 | 52716 | 52579 | Prototheca wickerhamii mitochondrion, complete genome | blastn | 1050 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii |
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);;