RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA610520" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA610520 · 8 ✖

analysis 1

  • blastn · 8 ✖

tax_clade 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
4416008 4416008 PRJNA610520_S_NODE_42404_length_289_cov_1.782407_g42314_i0 PRJNA610520 42404 289 1.782407 5.15115623 Ralstonia pickettii 329 Bacteria Bacteria 503 6.139999999999998e-138   NTclustered gi|2556944802|gb|CP104381.1| 329 g42314 i0 98.592 98.4186851211073 284 4 98 0 1 284 2240175 2240458 Ralstonia pickettii strain MCR chromosome 1, complete sequence blastn 28443 503 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia Ralstonia pickettii
4975553 4975553 PRJNA610520_S_NODE_46484_length_280_cov_1.115942_g46394_i0 PRJNA610520 46484 280 1.115942 3.1246376 Psychrobacter 497 Bacteria Bacteria 501 2.13e-137   NTclustered gi|2565764499|gb|CP132595.1| 3064892 g46394 i0 98.929 35.6214285714286 280 3 100 0 1 280 2945658 2945937 Psychrobacter sp. van23A chromosome, complete genome blastn 9974 501 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Psychrobacter Psychrobacter sp. van23A
5692006 5692006 PRJNA610520_S_NODE_32745_length_314_cov_11.423237_g32655_i0 PRJNA610520 32745 314 11.423237 35.86896418 Eleftheria terrae 1597781 Bacteria Bacteria 159 1.68e-34   NTclustered gi|2533425405|gb|CP106951.1| 1597781 g32655 i0 82.258 6.45541401273885 186 31 59 2 128 312 4460414 4460598 Eleftheria terrae strain P9846-PB chromosome, complete genome blastn 2027 159 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Eleftheria Eleftheria terrae
8241468 8241468 PRJNA610520_S_NODE_39087_length_297_cov_4.160714_g38997_i0 PRJNA610520 39087 297 4.160714 12.35732058 Sphingomonas leidyi 68569 Bacteria Bacteria 80.5 1.27e-10   NTclustered gi|2814041301|gb|CP170557.1| 68569 g38997 i0 91.379 16.010101010101 58 5 20 0 240 297 1856210 1856153 Sphingomonas leidyi strain UC122_23 chromosome, complete genome blastn 4755 80.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas leidyi
15891430 15891430 PRJNA610520_S_NODE_51573_length_269_cov_1.571429_g51483_i0 PRJNA610520 51573 269 1.571429 4.22714401 Ralstonia pickettii 329 Bacteria Bacteria 475 1.2299999999999999e-129   NTclustered gi|2556944802|gb|CP104381.1| 329 g51483 i0 98.513 99.7323420074349 269 4 100 0 1 269 1156129 1156397 Ralstonia pickettii strain MCR chromosome 1, complete sequence blastn 26828 475 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia Ralstonia pickettii
18440493 18440493 PRJNA610520_S_NODE_50915_length_270_cov_2.345178_g50825_i0 PRJNA610520 50915 270 2.345178 6.3319806 Psychrobacter sp. G 571800 Bacteria Bacteria 200 8.349999999999999e-47   NTclustered gi|521014486|gb|CP006265.1| 571800 g50825 i0 81.526 1.6962962962963 249 41 92 3 1 248 1838348 1838592 Psychrobacter sp. G, complete genome blastn 458 200 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Psychrobacter Psychrobacter sp. G
19715120 19715120 PRJNA610520_S_NODE_72056_length_222_cov_4.114094_g71966_i0 PRJNA610520 72056 222 4.114094 9.13328868 Microvirga ossetica 1882682 Bacteria Bacteria 82.4 2.51e-11   NTclustered gi|1049766302|gb|CP016616.1| 1882682 g71966 i0 80.531 1.36036036036036 113 16 50 5 110 219 1052218 1052327 Microvirga ossetica strain V5/3M, complete sequence. blastn 302 82.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Microvirga Microvirga ossetica
22265697 22265697 PRJNA610520_S_NODE_69738_length_239_cov_2.638554_g69648_i0 PRJNA610520 69738 239 2.638554 6.30614406 Acinetobacter baumannii 470 Bacteria Bacteria 52.8 0.021   NTclustered gi|2470454228|gb|CP113071.1| 470 g69648 i0 100 0.702928870292887 28 0 12 0 162 189 2016407 2016380 Acinetobacter baumannii strain A118 DeltaH0N27_10830::kan chromosome, complete genome blastn 168 52.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii

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