RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA745553 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
14753228 14753228 PRJNA745553_S_NODE_30212_length_205_cov_5.325758_g30017_i0 PRJNA745553 30212 205 5.325758 10.9178039 Longimicrobium sp. 2029185 Bacteria Bacteria 67 6.38e-11   NR HEU0016457.1 2029185 g30017 i0 51.7 2.5609756097561 60 29 87.8 0 16 195 968 1027 HEU0016457.1 amino acid adenylation domain-containing protein [Longimicrobium sp.] diamond 525 67 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
26894776 26894776 PRJNA745553_S_NODE_5901_length_476_cov_1.352357_g5707_i0 PRJNA745553 5901 476 1.352357 6.43721932 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 207 4.34e-62   NR HEX2611036.1 2448054 g5707 i0 82.1 0.775210084033613 123 22 77.5 0 3 371 320 442 HEX2611036.1 IS4 family transposase [Gemmatimonadales bacterium] diamond 369 207 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29326329 29326329 PRJNA745553_S_NODE_13709_length_332_cov_4.119691_g13514_i0 PRJNA745553 13709 332 4.119691 13.67737412 Gemmatimonas sp. 1962908 Bacteria Bacteria 91.3 9.78e-19   NR HYW30166.1 1962908 g13514 i0 59.2 0.885542168674699 98 34 83.1 1 14 289 1 98 HYW30166.1 group II intron reverse transcriptase/maturase [Gemmatimonas sp.] diamond 294 91.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
29863162 29863162 PRJNA745553_S_NODE_7331_length_438_cov_1.265753_g7137_i0 PRJNA745553 7331 438 1.265753 5.54399814 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 172 9.44e-49   NR HEU4748609.1 2026741 g7137 i0 67.5 0.842465753424658 123 40 84.2 0 69 437 1 123 HEU4748609.1 phage portal protein [Gemmatimonadaceae bacterium] diamond 369 172 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31168315 31168315 PRJNA745553_S_NODE_19095_length_283_cov_1.466667_g18900_i0 PRJNA745553 19095 283 1.466667 4.15066761 Pseudomonadati 3379134 Bacteria Bacteria 123 3.829999999999999e-31   NR MBL8983312.1 2026742 g18900 i0 62.5 10.2614840989399 88 33 93.3 0 2 265 335 422 MBL8983312.1 amidohydrolase [Gemmatimonadota bacterium] diamond 2904 123 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31885957 31885957 PRJNA745553_S_NODE_15537_length_313_cov_0.962500_g15342_i0 PRJNA745553 15537 313 0.9625 3.012625 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 72 5.44e-13   NR MDP1861746.1 2026741 g15342 i0 61.8 1.03514376996805 55 21 52.7 0 148 312 23 77 MDP1861746.1 GNAT family N-acetyltransferase [Gemmatimonadaceae bacterium] diamond 324 72 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium

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