contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA914897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 894804 | 894804 | PRJNA914897_P_NODE_27801_length_304_cov_1.519481_g27377_i0 | PRJNA914897 | 27801 | 304 | 1.519481 | 4.61922224 | Monoraphidium neglectum | 145388 | Plants | Plants | 244 | 4.35e-60 | NTclustered | gi|926776527|ref|XM_014041284.1| | 145388 | g27377 | i0 | 84.127 | 4.92763157894737 | 252 | 40 | 83 | 0 | 53 | 304 | 23 | 274 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 1498 | 244 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 894988 | 894988 | PRJNA914897_P_NODE_9001_length_637_cov_1.453901_g8588_i0 | PRJNA914897 | 9001 | 637 | 1.453901 | 9.26134937 | Chlamydomonas sp. ICE-L | 309537 | Plants | Plants | 99 | 8.01e-16 | NTclustered | gi|1433048025|gb|MF780879.1| | 309537 | g8588 | i0 | 82.051 | 2.67503924646782 | 117 | 19 | 18 | 2 | 425 | 540 | 1529 | 1414 | Chlamydomonas sp. ICE-L heat shock protein 70C (HSP70C) mRNA, partial cds | blastn | 1704 | 99 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. ICE-L | |
| 4723604 | 4723604 | PRJNA914897_P_NODE_9324_length_625_cov_1.315217_g8909_i0 | PRJNA914897 | 9324 | 625 | 1.315217 | 8.22010625 | Chlamydomonas incerta | 51695 | Plants | Plants | 285 | 5.619999999999999e-72 | NTclustered | gi|74272614|gb|DQ122872.1| | 51695 | g8909 | i0 | 77.344 | 6.5328 | 512 | 96 | 79 | 15 | 128 | 623 | 960 | 453 | Chlamydomonas incerta mitochondrial ADP/ATP translocator (ANT) mRNA, complete cds; nuclear gene for mitochondrial product | blastn | 4083 | 285 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 5998236 | 5998236 | PRJNA914897_P_NODE_39645_length_246_cov_0.890173_g39221_i0 | PRJNA914897 | 39645 | 246 | 0.890173 | 2.18982558 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 163 | 9.84e-36 | NTclustered | gi|760437194|ref|XM_011397364.1| | 3075 | g39221 | i0 | 79.498 | 7.09349593495935 | 239 | 42 | 96 | 5 | 9 | 245 | 175 | 408 | Auxenochlorella protothecoides 40S ribosomal protein S3a partial mRNA | blastn | 1745 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 8903832 | 8903832 | PRJNA914897_P_NODE_31287_length_281_cov_1.413462_g30863_i0 | PRJNA914897 | 31287 | 281 | 1.413462 | 3.97182822 | Trebouxiophyceae | 75966 | Plants | Plants | 520 | 5.909999999999999e-143 | NTclustered | gi|723456786|ref|NC_025525.1| | 3171 | g30863 | i0 | 100 | 106.537366548043 | 281 | 0 | 100 | 0 | 1 | 281 | 4442 | 4722 | Myrmecia israelensis culture-collection UTEX:1181 chloroplast, complete genome | blastn | 29937 | 520 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 12374039 | 12374039 | PRJNA914897_P_NODE_28550_length_298_cov_1.368889_g28126_i0 | PRJNA914897 | 28550 | 298 | 1.368889 | 4.07928922 | Helicosporidium sp. ex Simulium jonesi | 145475 | Plants | Plants | 113 | 1.25e-20 | NTclustered | gi|54399515|gb|AY729488.1| | 145475 | g28126 | i0 | 80.405 | 0.496644295302013 | 148 | 29 | 50 | 0 | 10 | 157 | 1277 | 1424 | Helicosporidium sp. ex Simulium jonesii EF-1 alpha-like protein (efl) mRNA, complete cds | blastn | 148 | 113 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ex Simulium jonesi | |
| 14922930 | 14922930 | PRJNA914897_P_NODE_39192_length_247_cov_0.885057_g38768_i0 | PRJNA914897 | 39192 | 247 | 0.885057 | 2.18609079 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 248 | 2.65e-61 | NTclustered | gi|2082259086|ref|XM_001697336.2| | 3055 | g38768 | i0 | 86.344 | 89.7935222672065 | 227 | 31 | 92 | 0 | 6 | 232 | 284 | 510 | Chlamydomonas reinhardtii ribosomal protein S14 (CHLRE_11g480150v5), mRNA | blastn | 22179 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17473153 | 17473153 | PRJNA914897_P_NODE_37314_length_250_cov_0.870056_g36890_i0 | PRJNA914897 | 37314 | 250 | 0.870056 | 2.17514 | Chlorella variabilis | 554065 | Plants | Plants | 320 | 5.62e-83 | NTclustered | gi|552844675|ref|XM_005851082.1| | 554065 | g36890 | i0 | 89.919 | 97.452 | 248 | 25 | 99 | 0 | 3 | 250 | 338 | 91 | Chlorella variabilis alpha-tubulin (CHLNCDRAFT_33793) mRNA, complete cds | blastn | 24363 | 320 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 17473167 | 17473167 | PRJNA914897_P_NODE_38814_length_247_cov_1.327586_g38390_i0 | PRJNA914897 | 38814 | 247 | 1.327586 | 3.27913742 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 148 | 2.77e-31 | NTclustered | gi|2082259988|ref|XM_001690973.2| | 3055 | g38390 | i0 | 89.076 | 5.25506072874494 | 119 | 13 | 48 | 0 | 126 | 244 | 1741 | 1859 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g508150v5), mRNA | blastn | 1298 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18746603 | 18746603 | PRJNA914897_P_NODE_40495_length_244_cov_2.935673_g40071_i0 | PRJNA914897 | 40495 | 244 | 2.935673 | 7.16304212 | Parachlorella kessleri | 3074 | Plants | Plants | 80.5 | 1.01e-10 | NTclustered | gi|319904013|gb|HQ336963.1| | 3074 | g40071 | i0 | 81.373 | 3.28688524590164 | 102 | 15 | 41 | 4 | 1 | 100 | 220 | 121 | Parachlorella kessleri strain 211-11g histone H3 mRNA, partial cds | blastn | 802 | 80.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 25120947 | 25120947 | PRJNA914897_P_NODE_25520_length_322_cov_1.783133_g25096_i0 | PRJNA914897 | 25520 | 322 | 1.783133 | 5.74168826 | Polytomella parva | 51329 | Plants | Plants | 259 | 1.66e-64 | NTclustered | gi|1861356253|gb|MT377354.1| | 51329 | g25096 | i0 | 82.759 | 82.0031055900621 | 290 | 50 | 90 | 0 | 11 | 300 | 167 | 456 | Polytomella parva clone 0016300227 component of cytosolic 80S ribosome and 60S large subunit (RPL12) mRNA, complete cds; plastid | blastn | 26405 | 259 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva |
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);;