RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA558770" 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

  • PRJNA558770 · 8 ✖

analysis 1

  • diamond · 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
539282 539282 PRJNA558770_P_NODE_208501_length_234_cov_3.467337_g206496_i0 PRJNA558770 208501 234 3.467337 8.11356858 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 80.1 2.29e-15   NR CDE92689.1 1262901 g206496 i0 59.7 7.8974358974359 77 4 98.7 1 2 232 299 348 CDE92689.1 pyruvate-flavodoxin oxidoreductase [Fusobacterium sp. CAG:815] diamond 1848 80.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp. CAG:815
27141730 27141730 PRJNA558770_P_NODE_238522_length_234_cov_2.577889_g236517_i0 PRJNA558770 238522 234 2.577889 6.03226026 Fusobacteriaceae bacterium 2053555 Bacteria Bacteria 61.2 9.52e-9   NR MBP6409455.1 2053555 g236517 i0 100 0.320512820512821 25 0 32.1 0 233 159 42 66 MBP6409455.1 hypothetical protein [Fusobacteriaceae bacterium] diamond 75 61.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae   Fusobacteriaceae bacterium
27711190 27711190 PRJNA558770_P_NODE_336284_length_233_cov_4.671717_g334279_i0 PRJNA558770 336284 233 4.671717 10.88510061 Fusobacterium nucleatum 851 Bacteria Bacteria 49.3 6.04e-6   NR KXA14115.1 851 g334279 i0 100 0.270386266094421 21 0 27 0 233 171 20 40 KXA14115.1 hypothetical protein HMPREF3221_02325 [Fusobacterium nucleatum] diamond 63 49.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
28468737 28468737 PRJNA558770_P_NODE_330886_length_233_cov_6.035354_g328881_i0 PRJNA558770 330886 233 6.035354 14.06237482 Leptotrichia hofstadii 157688 Bacteria Bacteria 50.1 8.42e-5   NR WP_006804306.1 157688 g328881 i0 92 0.321888412017167 25 2 32.2 0 233 159 417 441 WP_006804306.1 ABC transporter permease/substrate-binding protein [Leptotrichia hofstadii] diamond 75 50.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hofstadii
29194866 29194866 PRJNA558770_P_NODE_202369_length_234_cov_3.693467_g200364_i0 PRJNA558770 202369 234 3.693467 8.64271278 Sebaldella sp. 2819260 Bacteria Bacteria 84 9.96e-17   NR MBP9477828.1 2819260 g200364 i0 63.6 0.987179487179487 77 0 98.7 1 232 2 132 180 MBP9477828.1 ABC-F family ATP-binding cassette domain-containing protein [Sebaldella sp.] diamond 231 84 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Sebaldella Sebaldella sp.
29478625 29478625 PRJNA558770_P_NODE_358050_length_232_cov_9.035533_g356045_i0 PRJNA558770 358050 232 9.035533 20.96243656 uncultured Leptotrichia sp. 159271 Bacteria Bacteria 70.9 3.32e-12   NR WP_299266637.1 159271 g356045 i0 49 1.24137931034483 96 29 98.3 1 1 228 106 201 WP_299266637.1 metal ABC transporter permease [uncultured Leptotrichia sp.] diamond 288 70.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia uncultured Leptotrichia sp.
30173613 30173613 PRJNA558770_P_NODE_208652_length_234_cov_3.462312_g206647_i0 PRJNA558770 208652 234 3.462312 8.10181008 uncultured Streptobacillus sp. 316096 Bacteria Bacteria 53.5 4.87e-6   NR ANA06927.1 316096 g206647 i0 95.8 0.615384615384615 24 1 30.8 0 231 160 272 295 ANA06927.1 GyrB, partial [uncultured Streptobacillus sp.] diamond 144 53.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus uncultured Streptobacillus sp.
32228826 32228826 PRJNA558770_P_NODE_271698_length_234_cov_1.874372_g269693_i0 PRJNA558770 271698 234 1.874372 4.38603048 Streptobacillus moniliformis 34105 Bacteria Bacteria 47 0.00102   NR WP_064581320.1 34105 g269693 i0 91.7 0.307692307692308 24 2 30.8 0 229 158 365 388 WP_064581320.1 glucose-6-phosphate isomerase [Streptobacillus moniliformis] diamond 72 47 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis

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