RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA473201" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA473201 · 17 ✖

analysis 1

  • blastn · 17 ✖
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
1718553 1718553 PRJNA473201_P_NODE_32742_length_346_cov_1.219780_g32000_i0 PRJNA473201 32742 346 1.21978 4.2204388 Micromonas commoda 296587 Plants Plants 239 2.34e-58   NTclustered gi|255088120|ref|XM_002505937.1| 296587 g32000 i0 80.312 23.9306358381503 320 59 92 4 15 332 820 1137 Micromonas commoda adenosylhomocysteinase partial mRNA blastn 8280 239 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
2370413 2370413 PRJNA473201_P_NODE_52262_length_286_cov_2.056338_g51520_i0 PRJNA473201 52262 286 2.0563380000000002 5.88112668 Haematococcus 44744 Plants Plants 529 1e-145   NTclustered gi|66864272|gb|DQ015727.1| 44745 g51520 i0 100 99.7027972027972 286 0 100 0 1 286 562 277 Haematococcus lacustris strain UTEX 16 26S ribosomal RNA gene, partial sequence blastn 28515 529 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
4270795 4270795 PRJNA473201_P_NODE_40244_length_315_cov_2.103306_g39502_i0 PRJNA473201 40244 315 2.103306 6.6254139 Haematococcus lacustris 44745 Plants Plants 582 8.459999999999998e-162   NTclustered gi|2201040776|gb|MN709220.1| 44745 g39502 i0 100 3 315 0 100 0 1 315 930897 931211 Haematococcus lacustris strain FACHB-712 chloroplast, complete genome blastn 945 582 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
6822154 6822154 PRJNA473201_P_NODE_76346_length_246_cov_0.890173_g75604_i0 PRJNA473201 76346 246 0.890173 2.18982558 Chlamydomonas reinhardtii 3055 Plants Plants 283 7.239999999999999e-72   NTclustered gi|82658789|gb|DQ279079.1| 3055 g75604 i0 87.449 2.98373983739837 247 29 100 2 1 246 2512 2267 Chlamydomonas reinhardtii PhoA (PHOA) mRNA, complete cds; nuclear gene for plastid product blastn 734 283 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
10647892 10647892 PRJNA473201_P_NODE_54929_length_279_cov_40.752427_g54187_i0 PRJNA473201 54929 279 40.752427 113.69927133 Eudorina elegans 47282 Plants Plants 52.8 0.026   NTclustered gi|1851762454|gb|MH161344.1| 47282 g54187 i0 100 0.100358422939068 28 0 10 0 47 74 232550 232577 Eudorina elegans chloroplast, complete genome blastn 28 52.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Eudorina Eudorina elegans
13197324 13197324 PRJNA473201_P_NODE_35231_length_335_cov_1.175573_g34489_i0 PRJNA473201 35231 335 1.175573 3.93816955 Haematococcus lacustris 44745 Plants Plants 619 6.91e-173   NTclustered gi|2201040776|gb|MN709220.1| 44745 g34489 i0 100 104.271641791045 335 0 100 0 1 335 7867 8201 Haematococcus lacustris strain FACHB-712 chloroplast, complete genome blastn 34931 619 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
13197536 13197536 PRJNA473201_P_NODE_46391_length_300_cov_1.356828_g45649_i0 PRJNA473201 46391 300 1.356828 4.070484 Haematococcus lacustris 44745 Plants Plants 555 1.7399999999999995e-153   NTclustered gi|1169296930|gb|KY364700.1| 44745 g45649 i0 100 98.9966666666667 300 0 100 0 1 300 2833 2534 Haematococcus lacustris 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 29699 555 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
14473304 14473304 PRJNA473201_P_NODE_84372_length_241_cov_1.375000_g83630_i0 PRJNA473201 84372 241 1.375 3.31375 Micromonas commoda 296587 Plants Plants 95.3 3.55e-15   NTclustered gi|255081477|ref|XM_002507915.1| 296587 g83630 i0 84.536 0.75103734439834 97 13 40 2 72 167 364 459 Micromonas commoda predicted protein mRNA blastn 181 95.3 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
15746489 15746489 PRJNA473201_P_NODE_39953_length_316_cov_3.065844_g39211_i0 PRJNA473201 39953 316 3.065844 9.68806704 Haematococcus lacustris 44745 Plants Plants 582 8.489999999999998e-162   NTclustered gi|2201040776|gb|MN709220.1| 44745 g39211 i0 100 114.212025316456 315 0 99 0 1 315 8484 8170 Haematococcus lacustris strain FACHB-712 chloroplast, complete genome blastn 36091 582 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
19569280 19569280 PRJNA473201_P_NODE_25796_length_388_cov_2.047619_g25054_i0 PRJNA473201 25796 388 2.047619 7.94476172 Haematococcus lacustris 44745 Plants Plants 560 4.98e-155   NTclustered gi|2201040776|gb|MN709220.1| 44745 g25054 i0 99.673 139.765463917526 306 1 99 0 2 307 9332 9637 Haematococcus lacustris strain FACHB-712 chloroplast, complete genome blastn 54229 560 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
19569307 19569307 PRJNA473201_P_NODE_27416_length_376_cov_4.148515_g26674_i0 PRJNA473201 27416 376 4.148515 15.5984164 Chlamydomonas reinhardtii 3055 Plants Plants 56.5 0.003   NTclustered gi|2082258293|ref|XM_043067370.1| 3055 g26674 i0 96.97 0.63031914893617 33 1 9 0 53 85 5665 5633 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_11g467619v5), mRNA blastn 237 56.5 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
19569895 19569895 PRJNA473201_P_NODE_60016_length_266_cov_1.414508_g59274_i0 PRJNA473201 60016 266 1.414508 3.76259128 Micromonas pusilla 38833 Plants Plants 176 1.38e-39   NTclustered gi|303290617|ref|XM_003064550.1| 564608 g59274 i0 81.333 0.845864661654135 225 35 84 6 44 266 107 326 Micromonas pusilla CCMP1545 mitochondrial carrier family (MICPUCDRAFT_30402), mRNA blastn 225 176 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas pusilla
22120408 22120408 PRJNA473201_P_NODE_45478_length_303_cov_0.917391_g44736_i0 PRJNA473201 45478 303 0.917391 2.77969473 Monoraphidium neglectum 145388 Plants Plants 135 2.7200000000000004e-27   NTclustered gi|926781367|ref|XM_014043704.1| 145388 g44736 i0 80.22 0.600660066006601 182 34 60 2 123 303 122 302 Monoraphidium neglectum 60S ribosomal protein L26-1 mRNA blastn 182 135 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Monoraphidium Monoraphidium neglectum
23395502 23395502 PRJNA473201_P_NODE_13499_length_545_cov_7.779661_g12760_i0 PRJNA473201 13499 545 7.779661 42.39915245 Pseudopediastrum sp. CL0201VA 2184484 Plants Plants 178 8.47e-40   NTclustered gi|1418583337|ref|NC_037922.1| 2184484 g12760 i0 88.435 0.759633027522936 147 17 27 0 3 149 169264 169118 Pseudopediastrum sp. CL0201VA chloroplast, complete genome blastn 414 178 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Hydrodictyaceae Pseudopediastrum Pseudopediastrum sp. CL0201VA
23395829 23395829 PRJNA473201_P_NODE_31259_length_354_cov_1.078292_g30517_i0 PRJNA473201 31259 354 1.078292 3.81715368 Bathycoccus prasinos 41875 Plants Plants 86.1 3.3e-12   NTclustered gi|290770787|emb|FN563099.1| 41875 g30517 i0 89.706 19.5762711864407 68 5 19 2 140 205 2256 2189 Bathycoccus prasinos plastid 16S rRNA gene (partial), ITS1, tRNA-Ile gene, tRNA-Ala gene and 23S rRNA gene (partial), strain SCCAP K-0417 blastn 6930 86.1 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Bathycoccus Bathycoccus prasinos
23396040 23396040 PRJNA473201_P_NODE_42699_length_310_cov_2.303797_g41957_i0 PRJNA473201 42699 310 2.303797 7.1417707 Chlamydomonas reinhardtii 3055 Plants Plants 163 1.2799999999999998e-35   NTclustered gi|2082248650|ref|XM_043063418.1| 3055 g41957 i0 80.374 20.0548387096774 214 42 69 0 95 308 857 644 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA blastn 6217 163 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
24669593 24669593 PRJNA473201_P_NODE_21140_length_429_cov_1.584270_g20398_i0 PRJNA473201 21140 429 1.58427 6.7965183 Haematococcus lacustris 44745 Plants Plants 776 0   NTclustered gi|2201040776|gb|MN709220.1| 44745 g20398 i0 99.302 134.179487179487 430 2 100 1 1 429 638663 639092 Haematococcus lacustris strain FACHB-712 chloroplast, complete genome blastn 57563 776 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris

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