RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJEB9859 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
999046 999046 PRJEB9859_P_NODE_7261_length_215_cov_102.467742_g7226_i0 PRJEB9859 7261 215 102.467742 220.3056453 Myrmecia 13617 Plants Plants 122 1.42e-23   NTclustered gi|1158556132|emb|LT717572.1| 1938899 g7226 i0 100 30.7023255813953 66 0 31 0 1 66 348 283 Chlorobiont of Psora decipiens partial 26S rRNA gene, isolate Swe2-Aus blastn 6601 122 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae       chlorobiont of Psora decipiens
7797439 7797439 PRJEB9859_P_NODE_4007_length_254_cov_294.182222_g3972_i0 PRJEB9859 4007 254 294.182222 747.22284388 Polulichloris maxima 2704661 Plants Plants 255 1.64e-63   NTclustered gi|2473928686|ref|NC_072905.1| 2704661 g3972 i0 96.154 4.87795275590551 156 6 61 0 76 231 125440 125285 Polulichloris maxima clone L123 chloroplast, complete genome blastn 1239 255 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Polulichloris Polulichloris maxima
8652196 8652196 PRJEB9859_S_NODE_307_length_299_cov_403.537879_g302_i0 PRJEB9859 307 299 403.537879 1206.57825821 Trebouxia 13786 Plants Plants 374 5.22e-99   NTclustered gi|2105086|emb|Z95380.1| 13787 g302 i0 99.512 68.7123745819398 205 1 69 0 41 245 305 101 T.asymmetrica 26S rRNA gene blastn 20545 374 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia asymmetrica
9072442 9072442 PRJEB9859_S_NODE_468_length_193_cov_128.632911_g463_i0 PRJEB9859 468 193 128.632911 248.26151823 Polulichloris maxima 2704661 Plants Plants 287 4.189999999999999e-73   NTclustered gi|2473928686|ref|NC_072905.1| 2704661 g463 i0 97.059 10.2072538860104 170 5 88 0 1 170 125454 125285 Polulichloris maxima clone L123 chloroplast, complete genome blastn 1970 287 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Polulichloris Polulichloris maxima
17996649 17996649 PRJEB9859_P_NODE_3675_length_262_cov_471.351931_g3640_i0 PRJEB9859 3675 262 471.351931 1234.94205922 Polulichloris maxima 2704661 Plants Plants 255 1.7e-63   NTclustered gi|2473928686|ref|NC_072905.1| 2704661 g3640 i0 96.154 15.2290076335878 156 6 60 0 24 179 125285 125440 Polulichloris maxima clone L123 chloroplast, complete genome blastn 3990 255 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Polulichloris Polulichloris maxima

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