RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA772154" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA772154 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
3758581 3758581 PRJNA772154_P_NODE_6243_length_494_cov_2.009501_g6058_i0 PRJNA772154 6243 494 2.009501 9.92693494 Gemmata 113 Bacteria Bacteria 708 0   NTclustered gi|1804905141|emb|LR593886.1| 1210884 g6058 i0 92.51 53.834008097166 494 37 100 0 1 494 3634937 3634444 Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1 blastn 26594 713 0.992987377279102 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata massiliana
17784457 17784457 PRJNA772154_P_NODE_6374_length_487_cov_1.541063_g6189_i0 PRJNA772154 6374 487 1.541063 7.50497681 Gemmata 113 Bacteria Bacteria 767 0   NTclustered gi|12583965|gb|AF245369.1|AF245369 114 g6189 i0 95.072 167.523613963039 487 24 100 0 1 487 1896 2382 Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence blastn 81584 767 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
19874242 19874242 PRJNA772154_P_NODE_2596_length_878_cov_2.642236_g2439_i0 PRJNA772154 2596 878 2.642236 23.19883208 Gemmata algarum 2975278 Bacteria Bacteria 1349 0   NTclustered gi|2589385451|gb|OR644607.1| 2975278 g2439 i0 94.425 117.771070615034 879 45 100 4 1 878 20 895 Gemmata algarum strain JC673 16S ribosomal RNA gene, partial sequence blastn 103403 1349 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata algarum
24158482 24158482 PRJNA772154_P_NODE_2179_length_975_cov_2.548780_g2037_i0 PRJNA772154 2179 975 2.54878 24.850605 Gemmata 113 Bacteria Bacteria 1408 0   NTclustered gi|1727537522|gb|CP042911.1| 114 g2037 i0 92.748 145.629743589744 979 63 100 8 1 975 4798379 4797405 Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome blastn 141989 1408 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
25433482 25433482 PRJNA772154_P_NODE_18060_length_252_cov_0.871508_g17875_i0 PRJNA772154 18060 252 0.871508 2.19620016 Rosistilla 2795779 Bacteria Bacteria 455 1.49e-123   NTclustered gi|1712438206|gb|CP036261.1| 1930277 g17875 i0 99.206 120.277777777778 252 2 100 0 1 252 976654 976905 Rosistilla ulvae strain EC9 chromosome blastn 30310 455 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rosistilla Rosistilla ulvae

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