RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA939415", tax_clade = "FCB group" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 7 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 7 ✖

bioproject 1

  • PRJNA939415 · 7 ✖

analysis 1

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
21317810 21317810 PRJNA939415_P_NODE_53977_length_279_cov_6.791262_g53555_i0 PRJNA939415 53977 279 6.791262 18.94762098 Balneolales bacterium 2497613 Bacteria Bacteria 172 4.059999999999999e-52   NR MCH8524869.1 2497613 g53555 i0 93.4 2.9247311827957 91 6 97.8 0 2 274 138 228 MCH8524869.1 class I fructose-bisphosphate aldolase [Balneolales bacterium] diamond 816 172 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales     Balneolales bacterium
27877952 27877952 PRJNA939415_P_NODE_37325_length_298_cov_2.924444_g36903_i0 PRJNA939415 37325 298 2.924444 8.71484312 Balneolaceae bacterium 2053516 Bacteria Bacteria 62.4 8.7e-9   NR MEQ9265114.1 2053516 g36903 i0 57.8 1.43959731543624 45 19 45.3 0 149 15 111 155 MEQ9265114.1 alpha-amylase family glycosyl hydrolase [Balneolaceae bacterium] diamond 429 62.4 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
28421842 28421842 PRJNA939415_P_NODE_25886_length_310_cov_5.008439_g25464_i0 PRJNA939415 25886 310 5.008439 15.5261609 Pseudomonadati 3379134 Bacteria Bacteria 58.5 2.25e-7   NR NIT58373.1 1872440 g25464 i0 51 2.37096774193548 49 24 47.4 0 310 164 326 374 NIT58373.1 hypothetical protein [Fodinibius sp.] diamond 735 58.9 0.99320882852292 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Fodinibius sp.
29172604 29172604 PRJNA939415_P_NODE_103969_length_228_cov_6.303226_g103547_i0 PRJNA939415 103969 228 6.303226 14.37135528 Balneolaceae bacterium 2053516 Bacteria Bacteria 100 7.6e-23   NR HYW35007.1 2053516 g103547 i0 64 1.93421052631579 75 27 98.7 0 225 1 128 202 HYW35007.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Balneolaceae bacterium] diamond 441 100 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
30372999 30372999 PRJNA939415_P_NODE_30872_length_310_cov_3.029536_g30450_i0 PRJNA939415 30872 310 3.029536 9.3915616 Balneolaceae bacterium 2053516 Bacteria Bacteria 94 7.7e-22   NR MDZ7716320.1 2053516 g30450 i0 89.8 0.474193548387097 49 5 47.4 0 2 148 91 139 MDZ7716320.1 redoxin domain-containing protein [Balneolaceae bacterium] diamond 147 94 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
30814897 30814897 PRJNA939415_P_NODE_21334_length_337_cov_4.034091_g20914_i0 PRJNA939415 21334 337 4.034091 13.59488667 Balneolaceae bacterium 2053516 Bacteria Bacteria 174 2.31e-50   NR MDZ7772649.1 2053516 g20914 i0 75.5 16.2373887240356 106 26 94.4 0 337 20 76 181 MDZ7772649.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Balneolaceae bacterium] diamond 5472 174 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
32554750 32554750 PRJNA939415_P_NODE_35059_length_307_cov_6.000000_g34637_i0 PRJNA939415 35059 307 6 18.42 Balneolales bacterium 2497613 Bacteria Bacteria 51.6 5.72e-5   NR HKI45271.1 2497613 g34637 i0 61 1.85667752442997 41 16 40.1 0 29 151 297 337 HKI45271.1 flagellar basal body P-ring protein FlgI [Balneolales bacterium] diamond 570 51.6 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales     Balneolales 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);;