RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA851399", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA851399 · 3 ✖

analysis 1

tax_kingdom 0

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
1234103 1234103 PRJNA851399_P_NODE_9801_length_254_cov_1.385366_g9348_i0 PRJNA851399 9801 254 1.385366 3.51882964 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 335 2.0399999999999993e-87   NTclustered gi|296939561|gb|HM246407.1| 459251 g9348 i0 90.551 43.6574803149606 254 22 99 2 2 254 608 356 Colpoda henneguyi isolate Cohe contig 1 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 11089 335 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda henneguyi
14867118 14867118 PRJNA851399_P_NODE_13612_length_205_cov_0.852564_g13159_i0 PRJNA851399 13612 205 0.852564 1.7477562 Colpoda henneguyi 459251 SAR_Eukaryotes SAR_Eukaryotes 244 2.75e-60   NTclustered gi|296939562|gb|HM246408.1| 459251 g13159 i0 94.872 65.2780487804878 156 8 76 0 50 205 952 797 Colpoda henneguyi isolate Cohe contig 2 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 13382 244 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda henneguyi
21636147 21636147 PRJNA851399_P_NODE_4837_length_461_cov_16.893204_g4387_i0 PRJNA851399 4837 461 16.893204 77.87767044 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 383 1.4e-101   NTclustered gi|759083543|gb|KM222160.1| 5980 g4387 i0 98.611 66.4642082429501 216 3 96 0 1 216 526 741 Colpoda inflata voucher SXK2011071402 large subunit ribosomal RNA gene, partial sequence blastn 30640 383 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda inflata

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