RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA909412" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA909412 · 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
27751246 27751246 PRJNA909412_P_NODE_3544_length_279_cov_1.654167_g3403_i0 PRJNA909412 3544 279 1.654167 4.61512593 Acidobacteriota bacterium 1978231 Bacteria Bacteria 59.7 6.17e-8   NR MBX3265733.1 1978231 g3403 i0 34.8 0.956989247311828 89 52 91.4 4 273 19 146 232 MBX3265733.1 hypothetical protein [Acidobacteriota bacterium] diamond 267 59.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28066722 28066722 PRJNA909412_P_NODE_5245_length_228_cov_1.751323_g5104_i0 PRJNA909412 5245 228 1.751323 3.99301644 Terriglobia bacterium 2081523 Bacteria Bacteria 42 0.0323   NR MBZ5571431.1 2081523 g5104 i0 45.5 0.578947368421053 44 24 57.9 0 74 205 28 71 MBZ5571431.1 hypothetical protein [Terriglobia bacterium] diamond 132 42 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
29266384 29266384 PRJNA909412_P_NODE_4949_length_234_cov_4.415385_g4808_i0 PRJNA909412 4949 234 4.415385 10.3320009 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 103 4.06e-25   NR HZS53291.1 2212468 g4808 i0 51.9 0.987179487179487 77 37 98.7 0 232 2 43 119 HZS53291.1 HXXEE domain-containing protein [Bryobacteraceae bacterium] diamond 231 103 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
31067298 31067298 PRJNA909412_P_NODE_795_length_629_cov_4.249153_g685_i0 PRJNA909412 795 629 4.249153 26.72717237 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 95.5 7.58e-20   NR HEV1996461.1 3069120 g685 i0 36.1 0.753577106518283 158 92 74.9 3 157 627 76 225 HEV1996461.1 VOC family protein [Candidatus Acidiferrum sp.] diamond 474 95.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
31794199 31794199 PRJNA909412_P_NODE_15437_length_154_cov_1.808696_g15296_i0 PRJNA909412 15437 154 1.808696 2.78539184 Blastocatellia bacterium 2052146 Bacteria Bacteria 63.9 1.24e-10   NR HZS46962.1 2052146 g15296 i0 54 2.9025974025974 50 23 97.4 0 3 152 25 74 HZS46962.1 methylthioribulose 1-phosphate dehydratase [Blastocatellia bacterium] diamond 447 63.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
32015862 32015862 PRJNA909412_P_NODE_5678_length_219_cov_2.333333_g5537_i0 PRJNA909412 5678 219 2.333333 5.10999927 Acidobacteriota bacterium 1978231 Bacteria Bacteria 102 5.85e-24   NR MCG6962339.1 1978231 g5537 i0 62 3.93150684931507 71 27 97.3 0 5 217 215 285 MCG6962339.1 NAD-dependent epimerase/dehydratase family protein [Acidobacteriota bacterium] diamond 861 102 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32585554 32585554 PRJNA909412_P_NODE_9939_length_172_cov_3.533835_g9798_i0 PRJNA909412 9939 172 3.533835 6.0781962 Terriglobales bacterium 2282142 Bacteria Bacteria 49.7 5.1e-5   NR HUM05428.1 2282142 g9798 i0 81.5 1.3953488372093 27 5 47.1 0 1 81 368 394 HUM05428.1 glycoside hydrolase family 27 protein [Terriglobales bacterium] diamond 240 49.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
32868685 32868685 PRJNA909412_P_NODE_4200_length_256_cov_3.078341_g4059_i0 PRJNA909412 4200 256 3.078341 7.88055296 Acidicapsa acidisoli 1615681 Bacteria Bacteria 50.4 8.52e-5   NR WP_263354560.1 1615681 g4059 i0 53.3 1.921875 45 21 52.7 0 213 79 24 68 WP_263354560.1 beta-glucosidase [Acidicapsa acidisoli] diamond 492 50.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Acidicapsa Acidicapsa acidisoli

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