RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA493632" and tax_phylum = "Candidatus Kapaibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Kapaibacteriota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA493632 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
17044127 17044127 PRJNA493632_P_NODE_605374_length_244_cov_2.350877_g601933_i0 PRJNA493632 605374 244 2.350877 5.73613988 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 451 1.86e-122   NTclustered gi|2556937695|gb|CP129493.1| 2447898 g601933 i0 100 3.98360655737705 244 0 100 0 1 244 1294161 1294404 MAG: Candidatus Kapaibacterium sp. isolate cMAG.3 chromosome, complete genome blastn 972 451 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
19593637 19593637 PRJNA493632_P_NODE_661616_length_241_cov_0.916667_g658175_i0 PRJNA493632 661616 241 0.916667 2.20916747 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 52.8 0.022   NTclustered gi|2907625642|emb|OZ223202.1| 2447898 g658175 i0 100 0.116182572614108 28 0 12 0 133 160 501995 501968 MAG: Candidatus Kapaibacterium sp. isolate 09316a08-0405-4927-8c64-54324f316411 genome assembly, chromosome: 6 blastn 28 52.8 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium sp.
24690216 24690216 PRJNA493632_P_NODE_461560_length_259_cov_3.607527_g458121_i0 PRJNA493632 461560 259 3.607527 9.34349493 Candidatus Kapaibacterium sp. 2447898 Bacteria Bacteria 355 1.61e-93   NTclustered gi|2621703255|emb|OY762428.1| 2447898 g458121 i0 91.538 437.687258687259 260 18 100 3 1 259 2680185 2679929 MAG: Candidatus Kapabacteria bacterium isolate a44c304e-2480-4604-92e3-6035b9b042d9 genome assembly, chromosome: 1 blastn 113361 355 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota Candidatus Kapaibacteriia Candidatus Kapaibacteriales Candidatus Kapaibacteriaceae Candidatus Kapaibacterium Candidatus Kapaibacterium 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);;