RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA407886" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA407886 · 19 ✖

analysis 1

  • blastn · 19 ✖
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
1692857 1692857 PRJNA407886_P_NODE_71382_length_250_cov_0.870056_g69688_i0 PRJNA407886 71382 250 0.870056 2.17514 Chloropicon roscoffensis 1461544 Plants Plants 180 9.95e-41   NTclustered gi|2863407684|gb|CP145442.1| 1461544 g69688 i0 80.242 24.516 248 41 98 8 7 250 400636 400393 Chloropicon roscoffensis strain CCMP1998 chromosome 2 blastn 6129 180 1 Eukaryota   Viridiplantae Chlorophyta Chloropicophyceae Chloropicales Chloropicaceae Chloropicon Chloropicon roscoffensis
4244873 4244873 PRJNA407886_P_NODE_61384_length_270_cov_4.781726_g59690_i0 PRJNA407886 61384 270 4.781726 12.9106602 Chlamydomonas incerta 51695 Plants Plants 115 3.11e-21   NTclustered gi|74272608|gb|DQ122869.1| 51695 g59690 i0 82.946 0.477777777777778 129 20 47 2 87 214 502 629 Chlamydomonas incerta 40S ribosomal protein S8 mRNA, complete cds blastn 129 115 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas incerta
5521644 5521644 PRJNA407886_P_NODE_63765_length_264_cov_2.968586_g62071_i0 PRJNA407886 63765 264 2.968586 7.83706704 Dunaliella sp. KU22 1545437 Plants Plants 291 4.69e-74   NTclustered gi|685431495|gb|KM033846.1| 1545437 g62071 i0 86.641 95.9393939393939 262 35 99 0 1 262 92 353 Dunaliella sp. KU22 alpha-tubulin protein (ATUB) mRNA, partial cds blastn 25328 291 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Dunaliellaceae Dunaliella Dunaliella sp. KU22
6794573 6794573 PRJNA407886_P_NODE_16926_length_652_cov_3.412781_g15269_i0 PRJNA407886 16926 652 3.412781 22.25133212 Chlamydomonas reinhardtii 3055 Plants Plants 335 5.749999999999999e-87   NTclustered gi|2082248650|ref|XM_043063418.1| 3055 g15269 i0 77.526 74.6503067484663 574 117 87 11 67 634 857 290 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA blastn 48672 335 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
8070577 8070577 PRJNA407886_P_NODE_36387_length_368_cov_1.040678_g34693_i0 PRJNA407886 36387 368 1.040678 3.82969504 Micromonas pusilla 38833 Plants Plants 52.8 0.035   NTclustered gi|1360907821|gb|AC277405.1| 564608 g34693 i0 96.875 0.0869565217391304 32 0 9 1 136 167 22965 22935 Micromonas pusilla CCMP1545 clone BOUY249-D16, complete sequence blastn 32 52.8 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla
8734615 8734615 PRJNA407886_P_NODE_11567_length_883_cov_2.020988_g10177_i0 PRJNA407886 11567 883 2.020988 17.84532404 Chlamydomonas 3052 Plants Plants 403 2.1299999999999992e-107   NTclustered gi|2082247947|ref|XM_001698013.2| 3055 g10177 i0 77.131 30.1868629671574 739 142 82 22 123 846 924 198 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g278222v5), mRNA blastn 26655 403 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
9344947 9344947 PRJNA407886_P_NODE_13088_length_802_cov_3.463649_g11595_i0 PRJNA407886 13088 802 3.463649 27.77846498 Chlamydomonas incerta 51695 Plants Plants 315 9.3e-81   NTclustered gi|74272614|gb|DQ122872.1| 51695 g11595 i0 78.113 7.56359102244389 530 92 64 19 291 802 956 433 Chlamydomonas incerta mitochondrial ADP/ATP translocator (ANT) mRNA, complete cds; nuclear gene for mitochondrial product blastn 6066 315 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas incerta
9344999 9344999 PRJNA407886_P_NODE_15268_length_709_cov_3.820755_g13656_i0 PRJNA407886 15268 709 3.820755 27.08915295 Scherffelia dubia 3190 Plants Plants 75 1.51e-8   NTclustered gi|1783497212|ref|NC_045363.1| 3190 g13656 i0 77.536 7.72637517630465 138 21 19 9 121 250 31508 31373 Scherffelia dubia culture SAG:17.86 mitochondrion, complete genome blastn 5478 75 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorodendrophyceae Chlorodendrales Chlorodendraceae Scherffelia Scherffelia dubia
11896065 11896065 PRJNA407886_P_NODE_32790_length_393_cov_2.653125_g31096_i0 PRJNA407886 32790 393 2.653125 10.42678125 Micromonas commoda 296587 Plants Plants 60.2 2.25e-4   NTclustered gi|255070112|ref|XM_002507092.1| 296587 g31096 i0 92.683 0.450381679389313 41 3 10 0 167 207 2094 2134 Micromonas commoda JmjC transcription factor domain-containing protein partial mRNA blastn 177 60.2 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
11896154 11896154 PRJNA407886_P_NODE_37910_length_358_cov_1.512281_g36216_i0 PRJNA407886 37910 358 1.512281 5.41396598 Mantoniella tinhauana 3097027 Plants Plants 54.7 0.009   NTclustered gi|2735153282|gb|CP140067.1| 3097027 g36216 i0 100 0.0810055865921788 29 0 8 0 318 346 29217 29189 Mantoniella tinhauana isolate LFS chromosome 6 blastn 29 54.7 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Mantoniella Mantoniella tinhauana
11896766 11896766 PRJNA407886_P_NODE_66250_length_258_cov_4.362162_g64556_i0 PRJNA407886 66250 258 4.362162 11.25437796 Monoraphidium neglectum 145388 Plants Plants 63.9 1.08e-5   NTclustered gi|926791790|ref|XM_014048915.1| 145388 g64556 i0 82.667 1.5 75 10 28 2 81 152 1112 1186 Monoraphidium neglectum WD repeat, SAM and U-box domain-containing protein 1 mRNA blastn 387 63.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Monoraphidium Monoraphidium neglectum
11896888 11896888 PRJNA407886_P_NODE_72010_length_249_cov_0.875000_g70316_i0 PRJNA407886 72010 249 0.875 2.17875 Micromonas pusilla 38833 Plants Plants 196 9.84e-46   NTclustered gi|303280492|ref|XM_003059493.1| 564608 g70316 i0 81.481 3.4578313253012 243 42 97 3 3 243 581 340 Micromonas pusilla CCMP1545 long flagella protein (LF4), partial mRNA blastn 861 196 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla
13171282 13171282 PRJNA407886_P_NODE_48311_length_310_cov_2.265823_g46617_i0 PRJNA407886 48311 310 2.265823 7.0240513 Micromonas commoda 296587 Plants Plants 267 9.5e-67   NTclustered gi|255088120|ref|XM_002505937.1| 296587 g46617 i0 82.353 10.4870967741935 306 54 99 0 1 306 1160 1465 Micromonas commoda adenosylhomocysteinase partial mRNA blastn 3251 267 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
16994868 16994868 PRJNA407886_P_NODE_40614_length_343_cov_2.607407_g38920_i0 PRJNA407886 40614 343 2.607407 8.94340601 Chlorella variabilis 554065 Plants Plants 89.8 2.47e-13   NTclustered gi|552839615|ref|XM_005849780.1| 554065 g38920 i0 78.322 2.35860058309038 143 27 41 4 44 184 121 261 Chlorella variabilis hypothetical protein (CHLNCDRAFT_143002) mRNA, complete cds blastn 809 89.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella variabilis
18268963 18268963 PRJNA407886_P_NODE_40515_length_344_cov_1.321033_g38821_i0 PRJNA407886 40515 344 1.321033 4.54435352 Chlamydomonas sp. ICE-L 309537 Plants Plants 195 5.11e-45   NTclustered gi|1433048021|gb|MF780877.1| 309537 g38821 i0 77.581 94.0872093023256 339 65 97 9 1 333 1336 1003 Chlamydomonas sp. ICE-L heat shock protein 70A (HSP70A) mRNA, partial cds blastn 32366 195 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas sp. ICE-L
18934078 18934078 PRJNA407886_P_NODE_79835_length_242_cov_1.804734_g78141_i0 PRJNA407886 79835 242 1.804734 4.36745628 Micromonas 38832 Plants Plants 200 7.359999999999999e-47   NTclustered gi|148524160|gb|EF551325.1| 38833 g78141 i0 83.486 49.1859504132231 218 32 89 4 2 217 568 353 Micromonas pusilla clone EFL11-12 elongation factor-1 alpha-like protein mRNA, partial cds blastn 11903 200 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla
20818733 20818733 PRJNA407886_P_NODE_26417_length_458_cov_3.420779_g24725_i0 PRJNA407886 26417 458 3.420779 15.66716782 Chlamydomonas reinhardtii 3055 Plants Plants 553 9.989999999999996e-153   NTclustered gi|167449|gb|M11448.1|CRETBA2A 3055 g24725 i0 88.428 99.8449781659389 458 53 100 0 1 458 1365 908 Chlamydomonas reinhardtii alpha-2 tubulin gene, complete cds blastn 45729 553 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
22093952 22093952 PRJNA407886_P_NODE_47278_length_314_cov_1.825726_g45584_i0 PRJNA407886 47278 314 1.825726 5.73277964 Chlamydomonas reinhardtii 3055 Plants Plants 58.4 6.31e-4   NTclustered gi|2082238366|ref|XM_043059241.1| 3055 g45584 i0 89.13 0.146496815286624 46 5 15 0 137 182 1556 1511 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g081250v5), mRNA blastn 46 58.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
22759348 22759348 PRJNA407886_P_NODE_56298_length_284_cov_2.919431_g54604_i0 PRJNA407886 56298 284 2.919431 8.29118404 Opisthokonta 33154 Plants Plants 99 3.32e-16   NTclustered gi|612395756|ref|XM_007513336.1| 41875 g54604 i0 80.303 1.9330985915493 132 24 46 2 102 232 171 41 Bathycoccus prasinos 40S ribosomal protein S29 (Bathy04g01450), partial mRNA blastn 549 100 0.99 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Bathycoccus Bathycoccus prasinos

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;