RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1012699" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA1012699 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
158032 158032 PRJNA1012699_P_NODE_441_length_513_cov_1.763636_g409_i0 PRJNA1012699 441 513 1.763636 9.04745268 Arachnula sp. CL22 862246 SAR_Eukaryotes SAR_Eukaryotes 359 2.64e-94   NTclustered gi|301014696|gb|GQ377694.1| 862246 g409 i0 88.966 41.140350877193 290 32 57 0 193 482 2 291 Arachnula sp. CL22 ribosomal protein S23a (rps23a) mRNA, partial cds blastn 21105 359 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL22
7380073 7380073 PRJNA1012699_P_NODE_4186_length_221_cov_33.695946_g4154_i0 PRJNA1012699 4186 221 33.695946 74.46804066 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 407 3.63e-109   NTclustered gi|291495599|gb|GU823226.1| 152704 g4154 i0 100 99.5475113122172 220 0 99 0 1 220 841 1060 Uncultured stramenopile clone BCA5F13RJ3F09 18S ribosomal RNA gene, partial sequence blastn 22000 407 1 Eukaryota Sar             uncultured stramenopile
10361255 10361255 PRJNA1012699_P_NODE_2529_length_256_cov_2.530055_g2497_i0 PRJNA1012699 2529 256 2.530055 6.4769408 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 294 3.5e-75   NTclustered gi|238617605|gb|FJ973380.1| 45107 g2497 i0 87.5 99.5234375 256 30 100 2 1 256 1621 1368 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 25478 294 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa

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