RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 7 ✖

bioproject 1

  • PRJEB10140 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
13360 13360 PRJEB10140_P_NODE_77561_length_473_cov_1.992925_g60338_i0 PRJEB10140 77561 473 1.992925 9.42653525 Valonia macrophysa 432605 Plants Plants 244 7.07e-60   NTclustered gi|969822378|gb|KT950956.1| 432605 g60338 i0 79.379 27.830866807611 354 67 74 6 1 351 351 1 Valonia macrophysa isolate 1528 actin gene, partial cds blastn 13164 244 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Cladophorales Valoniaceae Valonia Valonia macrophysa
1287581 1287581 PRJEB10140_P_NODE_71482_length_514_cov_1.866667_g54345_i0 PRJEB10140 71482 514 1.866667 9.59466838 Coccomyxa subellipsoidea 248742 Plants Plants 429 1.9899999999999999e-115   NTclustered gi|545368295|ref|XM_005648872.1| 574566 g54345 i0 81.853 3.2431906614786 518 86 100 8 1 514 760 247 Coccomyxa subellipsoidea C-169 thiazole biosynthetic enzyme partial mRNA blastn 1667 429 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
4810319 4810319 PRJEB10140_P_NODE_5764_length_2916_cov_6.731427_g3202_i0 PRJEB10140 5764 2916 6.731427 196.28841132 root 1 Root_unresolved Root_unresolved 65.8 3.89e-5   NTclustered gi|1063759841|gb|KX641170.1| 3046 g3202 i0 100 0.162208504801097 35 0 1 0 2470 2504 31221 31187 Dunaliella salina strain SQ mitochondrion, complete genome blastn 473 65.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Dunaliellaceae Dunaliella Dunaliella salina
5115577 5115577 PRJEB10140_P_NODE_54605_length_671_cov_4.062701_g38354_i0 PRJEB10140 54605 671 4.062701 27.26072371 Ulva gigantea 523338 Plants Plants 54.7 0.019   NTclustered gi|2017997621|ref|NC_053613.1| 523338 g38354 i0 100 0.0432190760059613 29 0 4 0 440 468 8261 8289 Ulva gigantea strain U57 chloroplast, complete genome blastn 29 54.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulvales Ulvaceae Ulva Ulva gigantea
6085456 6085456 PRJEB10140_P_NODE_27885_length_1199_cov_5.818261_g3202_i1 PRJEB10140 27885 1199 5.818261 69.76094939 root 1 Root_unresolved Root_unresolved 65.8 1.57e-5   NTclustered gi|1063759841|gb|KX641170.1| 3046 g3202 i1 100 0.563803169307756 35 0 3 0 413 447 31187 31221 Dunaliella salina strain SQ mitochondrion, complete genome blastn 676 65.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Dunaliellaceae Dunaliella Dunaliella salina
15313858 15313858 PRJEB10140_P_NODE_144233_length_256_cov_1.507246_g126925_i0 PRJEB10140 144233 256 1.507246 3.85854976 Trebouxia sp. SL0000003 3350044 Plants Plants 270 5.899999999999999e-68   NTclustered gi|2917930139|emb|OZ234925.1| 3350044 g126925 i0 87.295 0.953125 244 21 95 7 7 250 1835004 1835237 Trebouxia sp. SL0000003 genome assembly, chromosome: 20 blastn 244 270 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. SL0000003
22965160 22965160 PRJEB10140_P_NODE_66799_length_550_cov_1.437126_g49779_i0 PRJEB10140 66799 550 1.437126 7.904193 Coccomyxa subellipsoidea 248742 Plants Plants 350 1.71e-91   NTclustered gi|545375904|ref|XM_005652027.1| 574566 g49779 i0 78.676 38.9490909090909 544 102 98 12 14 550 1898 2434 Coccomyxa subellipsoidea C-169 endoplasmic reticulum-type calcium-transporting ATPase partial mRNA blastn 21422 350 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea

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