RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1188114 · 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
1594687 1594687 PRJNA1188114_P_NODE_18402_length_162_cov_0.902655_g18350_i0 PRJNA1188114 18402 162 0.902655 1.4623011 Paludisphaera borealis 1387353 Bacteria Bacteria 150 4.65e-32   NTclustered gi|1133581311|gb|CP019082.1| 1387353 g18350 i0 83.436 21.5555555555556 163 25 100 2 1 162 2034338 2034177 Paludisphaera borealis strain PX4 chromosome, complete genome blastn 3492 150 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Paludisphaera Paludisphaera borealis
14349032 14349032 PRJNA1188114_P_NODE_17632_length_162_cov_2.530973_g17580_i0 PRJNA1188114 17632 162 2.530973 4.10017626 Tautonia plasticadhaerens 2527974 Bacteria Bacteria 113 6.1e-21   NTclustered gi|1712720622|gb|CP036427.1| 2527974 g17580 i0 85.849 1.64814814814815 106 15 65 0 9 114 122633 122738 Tautonia plasticadhaerens strain ElP plasmid pElP_1, complete sequence blastn 267 113 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Tautonia Tautonia plasticadhaerens
15622758 15622758 PRJNA1188114_P_NODE_17933_length_162_cov_0.902655_g17881_i0 PRJNA1188114 17933 162 0.902655 1.4623011 Urbifossiella limnaea 2528023 Bacteria Bacteria 220 3.49e-53   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g17881 i0 91.304 7.37037037037037 161 14 99 0 1 161 6656581 6656741 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 1194 220 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
21996659 21996659 PRJNA1188114_P_NODE_10778_length_172_cov_1.601626_g10726_i0 PRJNA1188114 10778 172 1.601626 2.75479672 Urbifossiella limnaea 2528023 Bacteria Bacteria 115 1.81e-21   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g10726 i0 90 0.523255813953488 90 8 52 1 56 145 1120352 1120440 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 90 115 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
24546114 24546114 PRJNA1188114_P_NODE_9960_length_175_cov_1.619048_g9908_i0 PRJNA1188114 9960 175 1.619048 2.833334 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 281 1.73e-71   NTclustered gi|2874254106|emb|OY970189.1| 100233 g9908 i0 97.006 44.0571428571429 167 5 95 0 1 167 4317534 4317368 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 7710 281 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium

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