RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA879314" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 8 ✖

bioproject 1

  • PRJNA879314 · 8 ✖

analysis 1

  • blastn · 8 ✖

tax_kingdom 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
857863 857863 PRJNA879314_P_NODE_1301_length_380_cov_88.478827_g1251_i0 PRJNA879314 1301 380 88.478827 336.2195426 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 701 0   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g1251 i0 100 10.4684210526316 379 0 99 0 2 380 690934 691312 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 3978 701 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
857876 857876 PRJNA879314_P_NODE_2321_length_312_cov_9.811715_g2271_i0 PRJNA879314 2321 312 9.811715 30.6125508 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 575 1.3999999999999999e-159   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g2271 i0 100 0.996794871794872 311 0 99 0 2 312 685571 685881 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 311 575 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
7235974 7235974 PRJNA879314_P_NODE_1186_length_394_cov_48.252336_g1136_i0 PRJNA879314 1186 394 48.252336 190.11420384 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 726 0   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g1136 i0 100 4.45431472081218 393 0 99 0 2 394 687434 687826 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 1755 726 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
14885831 14885831 PRJNA879314_P_NODE_11552_length_204_cov_24.122137_g11502_i0 PRJNA879314 11552 204 24.122137 49.20915948 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 377 2.59e-100   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g11502 i0 100 3.41176470588235 204 0 100 0 1 204 567931 568134 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 696 377 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
16160494 16160494 PRJNA879314_P_NODE_1413_length_370_cov_1.451178_g1363_i0 PRJNA879314 1413 370 1.451178 5.3693586 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 684 0   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g1363 i0 100 1.2 370 0 100 0 1 370 101798 101429 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 444 684 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
21259869 21259869 PRJNA879314_P_NODE_10777_length_243_cov_0.917647_g10727_i0 PRJNA879314 10777 243 0.917647 2.22988221 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 438 1.4399999999999996e-118   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g10727 i0 99.177 335.267489711934 243 2 100 0 1 243 668074 668316 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 81470 438 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
22534529 22534529 PRJNA879314_P_NODE_2938_length_288_cov_1.879070_g2888_i0 PRJNA879314 2938 288 1.87907 5.4117216 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 532 7.8e-147   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g2888 i0 100 1 288 0 100 0 1 288 234580 234293 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 288 532 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
25083986 25083986 PRJNA879314_P_NODE_6900_length_249_cov_0.886364_g6850_i0 PRJNA879314 6900 249 0.886364 2.20704636 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 459 1.1399999999999998e-124   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g6850 i0 100 0.995983935742972 248 0 99 0 2 249 625908 626155 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 248 459 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i

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