RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA565778" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA565778 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1833979 1833979 PRJNA565778_S_NODE_9882_length_345_cov_44.100649_g9586_i0 PRJNA565778 9882 345 44.100649 152.14723905 Parachlamydia acanthamoebae 83552 Bacteria Bacteria 573 5.629999999999999e-159   NTclustered gi|336478352|emb|FR872580.1| 765952 g9586 i0 100 0.898550724637681 310 0 90 0 36 345 1597045 1596736 Parachlamydia acanthamoebae UV-7, complete genome blastn 310 573 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Parachlamydia Parachlamydia acanthamoebae
19684965 19684965 PRJNA565778_S_NODE_6796_length_408_cov_2.908356_g6522_i0 PRJNA565778 6796 408 2.908356 11.86609248 Parachlamydia acanthamoebae 83552 Bacteria Bacteria 702 0   NTclustered gi|336478352|emb|FR872580.1| 765952 g6522 i0 100 0.931372549019608 380 0 93 0 1 380 1910955 1910576 Parachlamydia acanthamoebae UV-7, complete genome blastn 380 702 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Parachlamydia Parachlamydia acanthamoebae
23510527 23510527 PRJNA565778_S_NODE_16299_length_274_cov_2.303797_g16003_i0 PRJNA565778 16299 274 2.303797 6.31240378 Parachlamydia acanthamoebae 83552 Bacteria Bacteria 496 9.67e-136   NTclustered gi|336478352|emb|FR872580.1| 765952 g16003 i0 99.27 1 274 2 100 0 1 274 2776375 2776102 Parachlamydia acanthamoebae UV-7, complete genome blastn 274 496 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Parachlamydia Parachlamydia acanthamoebae
23510917 23510917 PRJNA565778_S_NODE_9039_length_359_cov_178.478261_g8743_i0 PRJNA565778 9039 359 178.478261 640.73695699 Parachlamydia acanthamoebae 83552 Bacteria Bacteria 582 9.75e-162   NTclustered gi|336478352|emb|FR872580.1| 765952 g8743 i0 99.074 0.902506963788301 324 3 90 0 36 359 2775805 2776128 Parachlamydia acanthamoebae UV-7, complete genome blastn 324 582 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Parachlamydia Parachlamydia acanthamoebae

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