RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA795663" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 8 ✖

bioproject 1

  • PRJNA795663 · 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
5882901 5882901 PRJNA795663_S_NODE_1565_length_445_cov_3.156863_g1460_i0 PRJNA795663 1565 445 3.156863 14.04804035 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 717 0   NTclustered gi|922689899|gb|CP012410.1| 712357 g1460 i0 95.73 303.260674157303 445 19 100 0 1 445 53246 52802 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 134951 717 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
7594447 7594447 PRJNA795663_S_NODE_13446_length_171_cov_2.552239_g13341_i0 PRJNA795663 13446 171 2.552239 4.36432869 Leptotrichia 32067 Bacteria Bacteria 195 2.25e-45   NTclustered gi|922689899|gb|CP012410.1| 712357 g13341 i0 88.024 26.3567251461988 167 16 100 4 1 165 53009 53173 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 4507 195 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
14808140 14808140 PRJNA795663_S_NODE_9592_length_196_cov_1.924528_g9487_i0 PRJNA795663 9592 196 1.924528 3.77207488 Leptotrichia sp. SK-5 3075818 Bacteria Bacteria 339 1.16e-88   NTclustered gi|2899356158|dbj|AP028931.1| 3075818 g9487 i0 97.949 146.698979591837 195 4 99 0 2 196 200373 200567 Leptotrichia sp. SK-5 DNA, complete genome blastn 28753 339 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. SK-5
16519293 16519293 PRJNA795663_S_NODE_593_length_668_cov_8.377179_g510_i0 PRJNA795663 593 668 8.377179 55.95955572 Fusobacterium 848 Bacteria Bacteria 1199 0   NTclustered gi|1370537877|gb|CP028108.1| 860 g510 i0 99.695 471.787425149701 655 2 98 0 14 668 463206 462552 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 315154 1210 0.990909090909091 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
17357694 17357694 PRJNA795663_S_NODE_14674_length_165_cov_2.078125_g14569_i0 PRJNA795663 14674 165 2.078125 3.42890625 Leptotrichia sp. HMT-225 3058373 Bacteria Bacteria 228 2.139999999999999e-55   NTclustered gi|2557559843|gb|CP130323.1| 3058373 g14569 i0 91.667 479.521212121212 168 9 100 4 1 165 197965 197800 Leptotrichia sp. HMT-225 chromosome, complete genome blastn 79121 228 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. HMT-225
17794120 17794120 PRJNA795663_S_NODE_6694_length_229_cov_1.901042_g6589_i0 PRJNA795663 6694 229 1.901042 4.35338618 Fusobacterium 848 Bacteria Bacteria 424 3.76e-114   NTclustered gi|2705020071|gb|CP084132.1| 851 g6589 i0 100 476.161572052402 229 0 100 0 1 229 106642 106414 Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome blastn 109041 424 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
18630795 18630795 PRJNA795663_S_NODE_11575_length_182_cov_1.372414_g11470_i0 PRJNA795663 11575 182 1.372414 2.49779348 Leptotrichia alba 3239304 Bacteria Bacteria 302 1.3900000000000001e-77   NTclustered gi|2785244533|gb|CP165647.1| 3239304 g11470 i0 99.398 15.510989010989 166 1 91 0 1 166 83263 83428 Leptotrichia sp. HSP-536 chromosome, complete genome blastn 2823 302 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia alba
24167889 24167889 PRJNA795663_S_NODE_10939_length_186_cov_1.805369_g10834_i0 PRJNA795663 10939 186 1.805369 3.35798634 Fusobacterium 848 Bacteria Bacteria 209 8.92e-50   NTclustered gi|2446175567|gb|CP117964.1| 851 g10834 i0 89.941 423.94623655914 169 8 90 6 1 167 2087546 2087385 Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome blastn 78854 209 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum

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