RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA561138" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA561138 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
12024034 12024034 PRJNA561138_P_NODE_11490_length_382_cov_0.996764_g11295_i0 PRJNA561138 11490 382 0.996764 3.80763848 Balneola sp. 2024824 Bacteria Bacteria 584 2.909999999999999e-162   NTclustered gi|2021960826|gb|CP051255.1| 2024824 g11295 i0 94.459 0.992146596858639 379 21 99 0 1 379 806722 807100 MAG: Balneola sp. isolate EhC07 chromosome blastn 379 584 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
13299053 13299053 PRJNA561138_P_NODE_16291_length_325_cov_1.222222_g16096_i0 PRJNA561138 16291 325 1.222222 3.9722215 Balneola sp. 2024824 Bacteria Bacteria 492 1.5199999999999999e-134   NTclustered gi|2021960826|gb|CP051255.1| 2024824 g16096 i0 94.118 0.993846153846154 323 19 99 0 3 325 2451821 2451499 MAG: Balneola sp. isolate EhC07 chromosome blastn 323 492 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
14574084 14574084 PRJNA561138_P_NODE_25792_length_249_cov_0.875000_g25597_i0 PRJNA561138 25792 249 0.875 2.17875 Balneola sp. 2024824 Bacteria Bacteria 388 1.51e-103   NTclustered gi|2021960826|gb|CP051255.1| 2024824 g25597 i0 94.779 1 249 13 100 0 1 249 734941 734693 MAG: Balneola sp. isolate EhC07 chromosome blastn 249 388 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
15847941 15847941 PRJNA561138_P_NODE_24533_length_251_cov_0.865169_g24338_i0 PRJNA561138 24533 251 0.865169 2.17157419 Balneola sp. 2024824 Bacteria Bacteria 398 2.5399999999999994e-106   NTclustered gi|2021960826|gb|CP051255.1| 2024824 g24338 i0 95.219 1.17131474103586 251 12 100 0 1 251 3945439 3945189 MAG: Balneola sp. isolate EhC07 chromosome blastn 294 398 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
19671468 19671468 PRJNA561138_P_NODE_13516_length_356_cov_0.992933_g13321_i0 PRJNA561138 13516 356 0.992933 3.53484148 Balneola sp. 2024824 Bacteria Bacteria 652 0   NTclustered gi|2021960826|gb|CP051255.1| 2024824 g13321 i0 99.719 1 356 1 100 0 1 356 413652 413297 MAG: Balneola sp. isolate EhC07 chromosome blastn 356 652 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
22222026 22222026 PRJNA561138_P_NODE_11358_length_384_cov_0.990354_g11163_i0 PRJNA561138 11358 384 0.990354 3.80295936 Balneola sp. 2024824 Bacteria Bacteria 671 0   NTclustered gi|2021960826|gb|CP051255.1| 2024824 g11163 i0 98.177 3.95052083333333 384 7 100 0 1 384 3786304 3786687 MAG: Balneola sp. isolate EhC07 chromosome blastn 1517 671 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
24771248 24771248 PRJNA561138_P_NODE_14060_length_349_cov_1.115942_g13865_i0 PRJNA561138 14060 349 1.115942 3.89463758 Balneola sp. 2024824 Bacteria Bacteria 444 4.65e-120   NTclustered gi|2021960826|gb|CP051255.1| 2024824 g13865 i0 89.685 1 349 34 99 2 1 348 1749623 1749970 MAG: Balneola sp. isolate EhC07 chromosome blastn 349 444 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.
24771276 24771276 PRJNA561138_P_NODE_16600_length_322_cov_1.032129_g16405_i0 PRJNA561138 16600 322 1.032129 3.32345538 Balneola sp. 2024824 Bacteria Bacteria 582 8.669999999999997e-162   NTclustered gi|2021960826|gb|CP051255.1| 2024824 g16405 i0 99.377 1.09627329192547 321 2 99 0 1 321 2450637 2450957 MAG: Balneola sp. isolate EhC07 chromosome blastn 353 582 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.

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