RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB10140 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1287433 1287433 PRJEB10140_P_NODE_46222_length_783_cov_106.664850_g30955_i0 PRJEB10140 46222 783 106.66485 835.1857755 Gimesia algae 2527971 Bacteria Bacteria 54.7 0.022   NTclustered gi|1712549334|gb|CP036343.1| 2527971 g30955 i0 100 0.037037037037037 29 0 4 0 728 756 7522186 7522158 Gimesia algae strain Pan161 chromosome blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia algae
3837779 3837779 PRJEB10140_P_NODE_134344_length_273_cov_4.330357_g117037_i0 PRJEB10140 134344 273 4.330357 11.82187461 Gimesia algae 2527971 Bacteria Bacteria 54.7 0.007   NTclustered gi|1712549334|gb|CP036343.1| 2527971 g117037 i0 100 0.208791208791209 29 0 11 0 239 267 7522158 7522186 Gimesia algae strain Pan161 chromosome blastn 57 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia algae
15315119 15315119 PRJEB10140_P_NODE_284513_length_163_cov_0.903509_g267204_i0 PRJEB10140 284513 163 0.903509 1.47271967 Phycisphaera sp. 2030824 Bacteria Bacteria 207 2.74e-49   NTclustered gi|2323351239|gb|CP098402.1| 2030824 g267204 i0 89.571 4.80981595092025 163 17 100 0 1 163 1554269 1554107 MAG: Phycisphaera sp. isolate MAG12 chromosome blastn 784 207 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
19137573 19137573 PRJEB10140_P_NODE_208876_length_189_cov_1.557143_g191567_i0 PRJEB10140 208876 189 1.557143 2.94300027 Singulisphaera sp. Ch08 3120278 Bacteria Bacteria 52.8 0.016   NTclustered gi|2732846650|gb|CP155447.1| 3120278 g191567 i0 100 0.148148148148148 28 0 15 0 24 51 4441849 4441876 Singulisphaera sp. Ch08 chromosome, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. Ch08

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