RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1228616" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1228616 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
1610204 1610204 PRJNA1228616_S_NODE_1802_length_276_cov_2.064378_g1779_i0 PRJNA1228616 1802 276 2.064378 5.69768328 Staphylococcus epidermidis 1282 Bacteria Bacteria 499 7.54e-137   NTclustered gi|2179631034|gb|CP090928.1| 1282 g1779 i0 99.275 107.550724637681 276 2 100 0 1 276 359 84 Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence blastn 29684 499 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
4875200 4875200 PRJNA1228616_S_NODE_5364_length_182_cov_1.892086_g5341_i0 PRJNA1228616 5364 182 1.892086 3.44359652 root 1 Root_unresolved Root_unresolved 228 2.4e-55   NTclustered gi|2179631034|gb|CP090928.1| 1282 g5341 i0 98.45 104.818681318681 129 2 100 0 1 129 1156 1284 Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence blastn 19077 228 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
17624858 17624858 PRJNA1228616_S_NODE_5214_length_184_cov_1.347518_g5191_i0 PRJNA1228616 5214 184 1.347518 2.47943312 root 1 Root_unresolved Root_unresolved 329 6.47e-86   NTclustered gi|1796972337|gb|CP033085.1| 1280 g5191 i0 98.913 99.3152173913043 184 2 100 0 1 184 2679770 2679953 Staphylococcus aureus strain WH3018 chromosome blastn 18274 329 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
20173426 20173426 PRJNA1228616_S_NODE_456_length_426_cov_3.825065_g433_i0 PRJNA1228616 456 426 3.825065 16.2947769 root 1 Root_unresolved Root_unresolved 691 0   NTclustered gi|2179631034|gb|CP090928.1| 1282 g433 i0 96.009 151.30985915493 426 16 100 1 1 426 691 1115 Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence blastn 64458 691 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
20737017 20737017 PRJNA1228616_S_NODE_2677_length_239_cov_3.887755_g2654_i0 PRJNA1228616 2677 239 3.887755 9.29173445 Roseburia rectibacter 2763062 Bacteria Bacteria 56.5 0.002   NTclustered gi|2206258461|gb|CP092473.1| 2763062 g2654 i0 96.97 0.138075313807531 33 1 14 0 90 122 2892630 2892662 Roseburia rectibacter strain NSJ-69 chromosome, complete genome blastn 33 56.5 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Roseburia Roseburia rectibacter

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