RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1093008" 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 · 6 ✖

bioproject 1

  • PRJNA1093008 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
4025109 4025109 PRJNA1093008_S_NODE_2504_length_684_cov_17.978723_g2216_i0 PRJNA1093008 2504 684 17.978723 122.97446532 Carteria sp. UTEX2 104529 Plants Plants 267 2.24e-66   NTclustered gi|6119999|gb|AF183459.1| 104529 g2216 i0 74.928 64.7090643274854 698 118 99 43 1 682 1193 1849 Carteria sp. UTEX2 strain UTEX 2 28S ribosomal RNA gene, partial sequence blastn 44261 267 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Carteria Carteria sp. UTEX2
7851184 7851184 PRJNA1093008_S_NODE_32067_length_332_cov_2.289575_g31740_i0 PRJNA1093008 32067 332 2.289575 7.601389 Trebouxia sp. URa8 1472635 Plants Plants 171 8.28e-38   NTclustered gi|594019455|gb|KF907615.1| 1472635 g31740 i0 100 3.68975903614458 92 0 28 0 236 327 345 254 Trebouxia sp. URa8 voucher Herbarium Tuerk51463 PsbL (psbL) gene, partial cds; and psbL-psbJ intergenic spacer, partial sequence; chloroplast blastn 1225 171 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. URa8
9126248 9126248 PRJNA1093008_S_NODE_44188_length_304_cov_3.943723_g43861_i0 PRJNA1093008 44188 304 3.943723 11.98891792 Trebouxia aggregata 160068 Plants Plants 102 2.77e-17   NTclustered gi|162134354|gb|EU123984.1| 160068 g43861 i0 81.25 1.45723684210526 144 12 47 5 161 304 4 132 Trebouxia aggregata strain SAG 219-1d ribosomal protein S18 (rps18) and ribosomal protein S14 (rps14) genes, complete cds; chloroplast blastn 443 102 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia aggregata
12952477 12952477 PRJNA1093008_S_NODE_60111_length_278_cov_1.502439_g59784_i0 PRJNA1093008 60111 278 1.502439 4.17678042 Binuclearia lauterbornii 3087189 Plants Plants 71.3 7.06e-8   NTclustered gi|2724824417|gb|PP746559.1| 3087189 g59784 i0 89.286 0.201438848920863 56 6 20 0 223 278 270 215 Binuclearia lauterbornii culture SAG:68.94 mitochondrion, complete genome blastn 56 71.3 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Oocystaceae Binuclearia Binuclearia lauterbornii
16775723 16775723 PRJNA1093008_S_NODE_52194_length_290_cov_1.774194_g51867_i0 PRJNA1093008 52194 290 1.774194 5.1451626 Trebouxia aggregata 160068 Plants Plants 435 2.28e-117   NTclustered gi|162134351|gb|EU123983.1| 160068 g51867 i0 97.628 60.8068965517241 253 6 87 0 1 253 2215 2467 Trebouxia aggregata strain SAG 219-1d D1 reaction center protein of photosystem II (psbA) and hypothetical protein (orf341) genes, complete cds; and tRNA-His (trnH(gug)) and tRNA-Gly (trnG(ucc)) genes, complete sequence; chloroplast blastn 17634 435 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia aggregata
24424459 24424459 PRJNA1093008_S_NODE_40680_length_312_cov_1.267782_g40353_i0 PRJNA1093008 40680 312 1.267782 3.95547984 Trebouxia sp. SL0000003 3350044 Plants Plants 211 4.55e-50   NTclustered gi|2917929620|emb|OZ234908.1| 3350044 g40353 i0 92 0.788461538461538 150 12 78 0 104 253 639079 638930 Trebouxia sp. SL0000003 genome assembly, chromosome: 3 blastn 246 211 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. SL0000003

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