RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA661142" 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

  • PRJNA661142 · 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
1904243 1904243 PRJNA661142_P_NODE_1662_length_592_cov_16.449355_g1602_i0 PRJNA661142 1662 592 16.449355 97.3801816 Euplotes cf. encysticus 2994703 SAR_Eukaryotes SAR_Eukaryotes 1031 0   NTclustered gi|2328859141|gb|OP828540.1| 2994703 g1602 i0 99.645 64.3091216216216 564 2 95 0 1 564 781 218 Euplotes cf. encysticus isolate LCY2016040803 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 38071 1031 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes cf. encysticus
5731635 5731635 PRJNA661142_P_NODE_8885_length_244_cov_2.615385_g8820_i0 PRJNA661142 8885 244 2.615385 6.3815394 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 420 5.24e-113   NTclustered gi|512134943|gb|JX178902.1| 1295638 g8820 i0 97.934 98.2622950819672 242 5 99 0 3 244 1093 1334 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 23976 420 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
20288240 20288240 PRJNA661142_P_NODE_9796_length_220_cov_1.654971_g9731_i0 PRJNA661142 9796 220 1.654971 3.6409362 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 202 1.8299999999999998e-47   NTclustered gi|859809373|gb|KM590652.1| 52554 g9731 i0 99.107 53.7954545454545 112 1 51 0 109 220 1472 1361 Synura mammillosa strain S89C3 26S ribosomal RNA gene, partial sequence blastn 11835 202 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura mammillosa

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