contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA760904" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 742250 | 742250 | PRJNA760904_P_NODE_2221_length_539_cov_2.212446_g2165_i0 | PRJNA760904 | 2221 | 539 | 2.212446 | 11.92508394 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 226 | 2.9499999999999995e-54 | NTclustered | gi|2082260551|ref|XM_001702928.2| | 3055 | g2165 | i0 | 79.688 | 14.7736549165121 | 320 | 60 | 59 | 5 | 77 | 394 | 475 | 159 | Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA | blastn | 7963 | 226 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 7582951 | 7582951 | PRJNA760904_P_NODE_1566_length_625_cov_2.153986_g1512_i0 | PRJNA760904 | 1566 | 625 | 2.153986 | 13.4624125 | Chlamydomonas | 3052 | Plants | Plants | 315 | 7.16e-81 | NTclustered | gi|2082260397|ref|XM_043068042.1| | 3055 | g1512 | i0 | 77.632 | 28.2992 | 532 | 109 | 84 | 10 | 61 | 587 | 1497 | 971 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g498600v5), mRNA | blastn | 17687 | 315 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9670709 | 9670709 | PRJNA760904_P_NODE_7748_length_318_cov_3.004082_g7691_i0 | PRJNA760904 | 7748 | 318 | 3.004082 | 9.55298076 | Monoraphidium neglectum | 145388 | Plants | Plants | 196 | 1.3e-45 | NTclustered | gi|926773763|ref|XM_014039902.1| | 145388 | g7691 | i0 | 79.208 | 6.05974842767296 | 303 | 47 | 93 | 14 | 3 | 297 | 295 | 1 | Monoraphidium neglectum 60S ribosomal protein L19-2 mRNA | blastn | 1927 | 196 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 11408769 | 11408769 | PRJNA760904_P_NODE_6589_length_341_cov_0.940299_g6532_i0 | PRJNA760904 | 6589 | 341 | 0.940299 | 3.20641959 | Eukaryota | 2759 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2082241839|ref|XM_043060656.1| | 3055 | g6532 | i0 | 94.444 | 0.6158357771261 | 36 | 2 | 11 | 0 | 254 | 289 | 441 | 406 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g158900v5), mRNA | blastn | 210 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 13495970 | 13495970 | PRJNA760904_P_NODE_11171_length_278_cov_1.126829_g11114_i0 | PRJNA760904 | 11171 | 278 | 1.126829 | 3.13258462 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 211 | 3.9900000000000002e-50 | NTclustered | gi|545373285|ref|XM_005650966.1| | 574566 | g11114 | i0 | 80.645 | 7.70863309352518 | 279 | 48 | 99 | 3 | 1 | 276 | 2937 | 2662 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 2143 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 13958961 | 13958961 | PRJNA760904_P_NODE_18731_length_244_cov_0.900585_g18674_i0 | PRJNA760904 | 18731 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | Plants | Plants | 246 | 9.409999999999999e-61 | NTclustered | gi|2082258180|ref|XM_043067316.1| | 3055 | g18674 | i0 | 89.637 | 120.172131147541 | 193 | 20 | 79 | 0 | 52 | 244 | 823 | 1015 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_11g467567v5), mRNA | blastn | 29322 | 246 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17320500 | 17320500 | PRJNA760904_P_NODE_10154_length_286_cov_1.352113_g10097_i0 | PRJNA760904 | 10154 | 286 | 1.352113 | 3.86704318 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 165 | 3.25e-36 | NTclustered | gi|2082235647|ref|XM_001702061.2| | 3055 | g10097 | i0 | 79.498 | 29.2937062937063 | 239 | 43 | 83 | 6 | 51 | 286 | 1515 | 1280 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g004300v5), mRNA | blastn | 8378 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17320533 | 17320533 | PRJNA760904_P_NODE_16294_length_248_cov_1.365714_g16237_i0 | PRJNA760904 | 16294 | 248 | 1.365714 | 3.38697072 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 246 | 9.59e-61 | NTclustered | gi|760439218|ref|XM_011398376.1| | 3075 | g16237 | i0 | 86.818 | 53.9233870967742 | 220 | 29 | 89 | 0 | 29 | 248 | 214 | 433 | Auxenochlorella protothecoides 40S ribosomal protein S15 partial mRNA | blastn | 13373 | 246 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 19869147 | 19869147 | PRJNA760904_P_NODE_21316_length_226_cov_4.000000_g21259_i0 | PRJNA760904 | 21316 | 226 | 4 | 9.04 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 102 | 1.97e-17 | NTclustered | gi|2082267188|ref|XM_043070972.1| | 3055 | g21259 | i0 | 79.054 | 3.04867256637168 | 148 | 31 | 65 | 0 | 79 | 226 | 126 | 273 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_16g660150v5), mRNA | blastn | 689 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19869161 | 19869161 | PRJNA760904_P_NODE_4456_length_399_cov_1.297546_g4399_i0 | PRJNA760904 | 4456 | 399 | 1.297546 | 5.17720854 | Chlorella variabilis | 554065 | Plants | Plants | 278 | 5.7900000000000006e-70 | NTclustered | gi|552841589|ref|XM_005850287.1| | 554065 | g4399 | i0 | 84.452 | 53.3959899749373 | 283 | 42 | 71 | 2 | 105 | 386 | 1036 | 755 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_30080) mRNA, partial cds | blastn | 21305 | 278 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 22882675 | 22882675 | PRJNA760904_P_NODE_17078_length_247_cov_0.885057_g17021_i0 | PRJNA760904 | 17078 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | Plants | Plants | 62.1 | 3.71e-5 | NTclustered | gi|2082243232|ref|XM_043061198.1| | 3055 | g17021 | i0 | 94.872 | 24.2307692307692 | 39 | 2 | 16 | 0 | 35 | 73 | 3315 | 3353 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g192400v5), mRNA | blastn | 5985 | 62.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 23695168 | 23695168 | PRJNA760904_P_NODE_15919_length_249_cov_0.875000_g15862_i0 | PRJNA760904 | 15919 | 249 | 0.875 | 2.17875 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 176 | 1.28e-39 | NTclustered | gi|2082247499|ref|XM_043062974.1| | 3055 | g15862 | i0 | 81.034 | 13.578313253012 | 232 | 35 | 93 | 7 | 11 | 242 | 1556 | 1778 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g273300v5), mRNA | blastn | 3381 | 176 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;