contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 644656 | 644656 | PRJNA674308_P_NODE_3101_length_553_cov_1.525794_g2870_i0 | PRJNA674308 | 3101 | 553 | 1.525794 | 8.43764082 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 62.1 | 9.04e-5 | NTclustered | gi|2082252565|ref|XM_043065027.1| | 3055 | g2870 | i0 | 100 | 0.547920433996383 | 33 | 0 | 6 | 0 | 223 | 255 | 1472 | 1504 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_08g370700v5), mRNA | blastn | 303 | 62.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 1166776 | 1166776 | PRJNA674308_P_NODE_5201_length_416_cov_24.673025_g4966_i0 | PRJNA674308 | 5201 | 416 | 24.673025 | 102.639784 | Chlamydomonas | 3052 | Plants | Plants | 760 | 0 | NTclustered | gi|2082265827|ref|XM_043070485.1| | 3055 | g4966 | i0 | 100 | 98.9783653846154 | 411 | 0 | 99 | 0 | 1 | 411 | 1901 | 2311 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_14g634365v5), mRNA | blastn | 41175 | 760 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 1920689 | 1920689 | PRJNA674308_P_NODE_13182_length_264_cov_9.837209_g12947_i0 | PRJNA674308 | 13182 | 264 | 9.837209 | 25.97023176 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 483 | 7.219999999999998e-132 | NTclustered | gi|1212783794|gb|MF083691.1| | 3055 | g12947 | i0 | 100 | 131.007575757576 | 261 | 0 | 100 | 0 | 4 | 264 | 39898 | 39638 | Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome | blastn | 34586 | 483 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 1920775 | 1920775 | PRJNA674308_P_NODE_21742_length_212_cov_2.263804_g21507_i0 | PRJNA674308 | 21742 | 212 | 2.263804 | 4.79926448 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 392 | 9.67e-105 | NTclustered | gi|162009877|gb|EU306617.1| | 3055 | g21507 | i0 | 100 | 29.4622641509434 | 212 | 0 | 100 | 0 | 1 | 212 | 11058 | 10847 | Chlamydomonas reinhardtii strain CC-1373 mt+ mitochondrion, complete genome | blastn | 6246 | 392 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 2441831 | 2441831 | PRJNA674308_P_NODE_20502_length_217_cov_9.107143_g20267_i0 | PRJNA674308 | 20502 | 217 | 9.107143 | 19.76250031 | Chlamydomonadales | 3042 | Plants | Plants | 401 | 1.6499999999999994e-107 | NTclustered | gi|430007894|gb|JX888471.1| | 3055 | g20267 | i0 | 100 | 99.9677419354839 | 217 | 0 | 100 | 0 | 1 | 217 | 70 | 286 | Chlamydomonas reinhardtii strain CC-620 18S ribosomal RNA gene, partial sequence | blastn | 21693 | 401 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 6270471 | 6270471 | PRJNA674308_P_NODE_26845_length_193_cov_3.736111_g26610_i0 | PRJNA674308 | 26845 | 193 | 3.736111 | 7.21069423 | Chlamydomonas | 3052 | Plants | Plants | 357 | 3.1499999999999996e-94 | NTclustered | gi|167047969|gb|EU410621.1| | 3055 | g26610 | i0 | 100 | 101.40932642487 | 193 | 0 | 100 | 0 | 1 | 193 | 2379 | 2571 | Chlamydomonas reinhardtii 26S ribosomal RNA gene, partial sequence | blastn | 19572 | 357 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 8819496 | 8819496 | PRJNA674308_P_NODE_14327_length_254_cov_58.921951_g14092_i0 | PRJNA674308 | 14327 | 254 | 58.921951 | 149.66175554 | Chlamydomonas | 3052 | Plants | Plants | 459 | 1.1599999999999999e-124 | NTclustered | gi|167047969|gb|EU410621.1| | 3055 | g14092 | i0 | 99.213 | 100.905511811024 | 254 | 2 | 100 | 0 | 1 | 254 | 2097 | 1844 | Chlamydomonas reinhardtii 26S ribosomal RNA gene, partial sequence | blastn | 25630 | 459 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10849002 | 10849002 | PRJNA674308_P_NODE_989_length_1006_cov_13.923720_g842_i0 | PRJNA674308 | 989 | 1006 | 13.92372 | 140.0726232 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 1506 | 0 | NTclustered | gi|1212783794|gb|MF083691.1| | 3055 | g842 | i0 | 93.688 | 127.760437375746 | 1014 | 51 | 99 | 10 | 1 | 1005 | 39796 | 40805 | Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome | blastn | 128527 | 1506 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 12124112 | 12124112 | PRJNA674308_P_NODE_39790_length_167_cov_294.669492_g39555_i0 | PRJNA674308 | 39790 | 167 | 294.669492 | 492.09805164 | Chlamydomonas sp. TK-1983 | 3056 | Plants | Plants | 195 | 2.2e-45 | NTclustered | gi|174203|gb|K02345.1|CRERRA | 3056 | g39555 | i0 | 100 | 1 | 105 | 0 | 100 | 0 | 1 | 105 | 105 | 1 | Chlamydomonas sp. TK-1983 5S ribosomal RNA gene, complete sequence | blastn | 167 | 195 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. TK-1983 | |
| 13398855 | 13398855 | PRJNA674308_P_NODE_37771_length_168_cov_1.747899_g37536_i0 | PRJNA674308 | 37771 | 168 | 1.747899 | 2.93647032 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 311 | 2.11e-80 | NTclustered | gi|2082260566|ref|XM_043068286.1| | 3055 | g37536 | i0 | 100 | 1 | 168 | 0 | 100 | 0 | 1 | 168 | 4478 | 4645 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g515000v5), mRNA | blastn | 168 | 311 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 15947553 | 15947553 | PRJNA674308_P_NODE_48613_length_164_cov_0.904348_g48378_i0 | PRJNA674308 | 48613 | 164 | 0.904348 | 1.48313072 | Nannochloris normandinae | 926285 | Plants | Plants | 292 | 7.41e-75 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g48378 | i0 | 98.788 | 129.481707317073 | 165 | 1 | 100 | 1 | 1 | 164 | 317 | 481 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 21235 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 16469470 | 16469470 | PRJNA674308_P_NODE_3473_length_517_cov_29.920940_g3240_i0 | PRJNA674308 | 3473 | 517 | 29.92094 | 154.6912598 | Chlamydomonadales | 3042 | Plants | Plants | 955 | 0 | NTclustered | gi|1212783794|gb|MF083691.1| | 3055 | g3240 | i0 | 100 | 149.025145067698 | 517 | 0 | 100 | 0 | 1 | 517 | 42078 | 41562 | Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome | blastn | 77046 | 955 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18497318 | 18497318 | PRJNA674308_P_NODE_7895_length_338_cov_20.000000_g7660_i0 | PRJNA674308 | 7895 | 338 | 20 | 67.6 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 623 | 5.389999999999999e-174 | NTclustered | gi|167047969|gb|EU410621.1| | 3055 | g7660 | i0 | 100 | 69.3698224852071 | 337 | 0 | 99 | 0 | 1 | 337 | 2966 | 3302 | Chlamydomonas reinhardtii 26S ribosomal RNA gene, partial sequence | blastn | 23447 | 623 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19771859 | 19771859 | PRJNA674308_P_NODE_8996_length_317_cov_2.679104_g8761_i0 | PRJNA674308 | 8996 | 317 | 2.679104 | 8.49275968 | Volvox carteri | 3067 | Plants | Plants | 180 | 1.31e-40 | NTclustered | gi|302850550|ref|XM_002956756.1| | 3068 | g8761 | i0 | 88.514 | 45.397476340694 | 148 | 17 | 47 | 0 | 170 | 317 | 312 | 165 | Volvox carteri f. nagariensis histone H4 (hstH4-4), partial mRNA | blastn | 14391 | 180 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 20292825 | 20292825 | PRJNA674308_P_NODE_11016_length_288_cov_1.640167_g10781_i0 | PRJNA674308 | 11016 | 288 | 1.640167 | 4.72368096 | Prototheca | 3110 | Plants | Plants | 196 | 1.16e-45 | NTclustered | gi|1381389463|ref|NC_037449.1| | 1973153 | g10781 | i0 | 80.545 | 8.09722222222222 | 257 | 48 | 89 | 2 | 33 | 288 | 27983 | 28238 | Prototheca zopfii strain SAG 2063 mitochondrion, complete genome | blastn | 2332 | 196 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca ciferrii | |
| 21047081 | 21047081 | PRJNA674308_P_NODE_10197_length_298_cov_18.606426_g9962_i0 | PRJNA674308 | 10197 | 298 | 18.606426 | 55.44714948 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 551 | 2.239999999999999e-152 | NTclustered | gi|422779560|gb|JX839535.1| | 3055 | g9962 | i0 | 100 | 94.6342281879195 | 298 | 0 | 100 | 0 | 1 | 298 | 587 | 290 | Chlamydomonas reinhardtii strain CC-621 28S ribosomal RNA gene, partial sequence | blastn | 28201 | 551 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24118475 | 24118475 | PRJNA674308_P_NODE_27119_length_193_cov_1.083333_g26884_i0 | PRJNA674308 | 27119 | 193 | 1.083333 | 2.09083269 | Marvania | 97104 | Plants | Plants | 178 | 2.63e-40 | NTclustered | gi|2724824493|gb|PP746561.1| | 97105 | g26884 | i0 | 83.42 | 64.8549222797927 | 193 | 30 | 99 | 2 | 2 | 193 | 28871 | 28680 | Marvania geminata culture SAG:12.88 mitochondrion, complete genome | blastn | 12517 | 178 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Marvania | Marvania geminata | |
| 24118534 | 24118534 | PRJNA674308_P_NODE_34759_length_171_cov_13.467213_g34524_i0 | PRJNA674308 | 34759 | 171 | 13.467213 | 23.02893423 | Chlamydomonas | 3052 | Plants | Plants | 316 | 4.6e-82 | NTclustered | gi|1233083424|gb|MF678012.1| | 3055 | g34524 | i0 | 100 | 96.6959064327485 | 171 | 0 | 100 | 0 | 1 | 171 | 2160 | 1990 | Chlamydomonas reinhardtii strain CCAP 11/32B small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 16535 | 316 | 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);;