RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJDB14275" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

bioproject 1

  • PRJDB14275 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2558450 2558450 PRJDB14275_P_NODE_2863_length_372_cov_12.261261_g2804_i0 PRJDB14275 2863 372 12.261261 45.61189092 Campanella sinica 2828877 SAR_Eukaryotes SAR_Eukaryotes 673 0   NTclustered gi|2027858488|gb|MW969625.1| 2828877 g2804 i0 99.194 86.0537634408602 372 3 100 0 1 372 42 413 Campanella sinica large subunit ribosomal RNA gene, partial sequence blastn 32012 673 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Campanella Campanella sinica
15310692 15310692 PRJDB14275_P_NODE_4133_length_267_cov_7.144737_g4074_i0 PRJDB14275 4133 267 7.144737 19.07644779 Planilamina ovata 2684848 SAR_Eukaryotes SAR_Eukaryotes 261 3.73e-65   NTclustered gi|1784308423|gb|MN830171.1| 2684848 g4074 i0 84.328 63.7790262172285 268 40 100 2 1 267 63 329 Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence blastn 17029 261 1 Eukaryota Sar   Ciliophora Phyllopharyngea Dysteriida Kyaroikeidae Planilamina Planilamina ovata
17559001 17559001 PRJDB14275_P_NODE_5214_length_216_cov_4.395480_g5155_i0 PRJDB14275 5214 216 4.39548 9.4942368 Epistylidae 155141 SAR_Eukaryotes SAR_Eukaryotes 399 5.909999999999999e-107   NTclustered gi|13384084|gb|AF335513.1|AF335513 155143 g5155 i0 100 99.0138888888889 216 0 100 0 1 216 1424 1639 Epistylis hentscheli small subunit ribosomal RNA gene, complete sequence blastn 21387 399 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis hentscheli
21383313 21383313 PRJDB14275_P_NODE_8177_length_153_cov_1.438596_g8118_i0 PRJDB14275 8177 153 1.438596 2.20105188 Kyaroikeidae 2684845 SAR_Eukaryotes SAR_Eukaryotes 255 8.900000000000001e-64   NTclustered gi|1784308423|gb|MN830171.1| 2684848 g8118 i0 96.732 95.8039215686274 153 5 100 0 1 153 969 1121 Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence blastn 14658 255 1 Eukaryota Sar   Ciliophora Phyllopharyngea Dysteriida Kyaroikeidae Planilamina Planilamina ovata
21685196 21685196 PRJDB14275_P_NODE_6158_length_187_cov_3.216216_g6099_i0 PRJDB14275 6158 187 3.216216 6.01432392 Opercularia sp. 2 2979175 SAR_Eukaryotes SAR_Eukaryotes 291 3.1199999999999993e-74   NTclustered gi|2304601488|gb|OP458309.1| 2979175 g6099 i0 94.652 92.096256684492 187 10 100 0 1 187 324 138 Opercularia sp. 2 large subunit ribosomal RNA gene, partial sequence blastn 17222 291 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Operculariidae Opercularia Opercularia sp. 2
22960572 22960572 PRJDB14275_P_NODE_6739_length_174_cov_6.037037_g6680_i0 PRJDB14275 6739 174 6.037037 10.50444438 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 183 4.969999999999999e-42   NTclustered gi|49616744|gb|AY643504.1| 282688 g6680 i0 89.116 60.2701149425287 147 16 84 0 28 174 252 106 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 10487 183 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi

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