RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA492280", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA492280 · 4 ✖

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
1726753 1726753 PRJNA492280_P_NODE_2722_length_287_cov_2.928000_g2615_i0 PRJNA492280 2722 287 2.928 8.40336 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 315 3.07e-81   NTclustered gi|1083263100|gb|KX982500.1| 5963 g2615 i0 94.712 39.9616724738676 208 2 69 2 89 287 1534 1741 Stentor coeruleus strain MSU large subunit ribosomal RNA gene, partial sequence blastn 11469 315 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
5555748 5555748 PRJNA492280_P_NODE_8565_length_182_cov_2.524138_g8458_i0 PRJNA492280 8565 182 2.524138 4.59393116 Halodinium verrucatum 2448773 SAR_Eukaryotes SAR_Eukaryotes 211 2.41e-50   NTclustered gi|1489895921|dbj|LC424402.1| 2448773 g8458 i0 86.096 51.543956043956 187 16 98 3 4 181 66 251 Halodinium verrucatum KC36_KC37 gene for 28S ribosomal RNA, partial sequence blastn 9381 211 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida   Halodinium Halodinium verrucatum
6202220 6202220 PRJNA492280_P_NODE_3945_length_250_cov_3.596244_g3838_i0 PRJNA492280 3945 250 3.596244 8.99061 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 100 7.97e-17   NTclustered gi|1955372076|gb|MW466719.1| 74487 g3838 i0 90.789 25.436 76 6 30 1 2 77 1185 1111 Frontonia sp. isolate MUFS1 large subunit ribosomal RNA gene, partial sequence blastn 6359 100 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Frontoniidae Frontonia Frontonia sp.
23404301 23404301 PRJNA492280_P_NODE_28199_length_157_cov_3.750000_g28092_i0 PRJNA492280 28199 157 3.75 5.8875 Halodinium verrucatum 2448773 SAR_Eukaryotes SAR_Eukaryotes 172 9.53e-39   NTclustered gi|1489895921|dbj|LC424402.1| 2448773 g28092 i0 86.364 40.0891719745223 176 2 98 1 4 157 958 1133 Halodinium verrucatum KC36_KC37 gene for 28S ribosomal RNA, partial sequence blastn 6294 172 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida   Halodinium Halodinium verrucatum

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