RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA603943 · 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
3127839 3127839 PRJNA603943_P_NODE_2843_length_856_cov_2.212005_g2686_i0 PRJNA603943 2843 856 2.212005 18.9347628 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 1003 0   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g2686 i0 88.098 171.394859813084 857 87 99 11 1 852 2582553 2581707 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 146714 1003 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
9506115 9506115 PRJNA603943_P_NODE_57828_length_248_cov_0.880000_g57636_i0 PRJNA603943 57828 248 0.88 2.1824 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 287 5.649999999999999e-73   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g57636 i0 87.805 1.58064516129032 246 28 99 2 1 245 156010 156254 Planctomyces sp. SH-PL62, complete genome blastn 392 287 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
15879761 15879761 PRJNA603943_P_NODE_29173_length_332_cov_2.200772_g28981_i0 PRJNA603943 29173 332 2.200772 7.30656304 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 257 6.18e-64   NTclustered gi|1938775668|gb|CP054178.1| 2026777 g28981 i0 80.938 62.0180722891566 341 51 100 13 1 332 193100 193435 MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome blastn 20590 257 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
18429301 18429301 PRJNA603943_P_NODE_42975_length_282_cov_1.138756_g42783_i0 PRJNA603943 42975 282 1.138756 3.21129192 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 106 1.97e-18   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g42783 i0 96.825 4.9468085106383 63 2 23 0 3 65 485120 485182 Planctomyces sp. SH-PL62, complete genome blastn 1395 106 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62

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