RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB15333" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJEB15333 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
26589669 26589669 PRJEB15333_P_NODE_9141_length_223_cov_1.385057_g9057_i0 PRJEB15333 9141 223 1.385057 3.08867711 Trebonia sp. 2767075 Bacteria Bacteria 43.5 0.0153   NR HEY7279562.1 2767075 g9057 i0 37 0.982062780269058 73 36 87.4 3 8 202 220 290 HEY7279562.1 hypothetical protein [Trebonia sp.] diamond 219 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Treboniaceae Trebonia Trebonia sp.
27222574 27222574 PRJEB15333_P_NODE_17443_length_168_cov_0.873950_g17359_i0 PRJEB15333 17443 168 0.87395 1.468236 Arthrobacter echini 1529066 Bacteria Bacteria 41.2 0.0492   NR WP_136454026.1 1529066 g17359 i0 36.5 0.928571428571429 52 28 83.9 1 25 165 16 67 WP_136454026.1 ATP-binding protein [Arthrobacter echini] diamond 156 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter echini
27254274 27254274 PRJEB15333_P_NODE_12863_length_191_cov_1.070423_g12779_i0 PRJEB15333 12863 191 1.070423 2.04450793 Brachybacterium sp. P6-1 1891286 Bacteria Bacteria 42 0.0312   NR WP_083713220.1 1903186 g12779 i0 40 1.57068062827225 50 28 75.4 1 15 158 155 204 WP_083713220.1 PGPGW domain-containing protein [Brachybacterium sp. P6-10-X1] diamond 300 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium sp. P6-10-X1
27475541 27475541 PRJEB15333_P_NODE_8823_length_226_cov_4.214689_g8739_i0 PRJEB15333 8823 226 4.214689 9.52519714 Actinomycetales bacterium 1911520 Bacteria Bacteria 43.9 0.0119   NR MBU6147104.1 1911520 g8739 i0 42.6 0.809734513274336 61 26 69 2 160 5 121 181 MBU6147104.1 hypothetical protein [Actinomycetales bacterium] diamond 183 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales     Actinomycetales bacterium
27823053 27823053 PRJEB15333_P_NODE_12944_length_190_cov_2.404255_g12860_i0 PRJEB15333 12944 190 2.404255 4.5680845 Actinomycetales bacterium 1911520 Bacteria Bacteria 43.5 0.0101   NR MBU6147104.1 1911520 g12860 i0 41 0.963157894736842 61 27 82.1 2 28 183 121 181 MBU6147104.1 hypothetical protein [Actinomycetales bacterium] diamond 183 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales     Actinomycetales bacterium
27917467 27917467 PRJEB15333_P_NODE_8045_length_236_cov_1.139037_g7961_i0 PRJEB15333 8045 236 1.139037 2.68812732 Gaiellaceae bacterium 2838783 Bacteria Bacteria 42.7 0.0332   NR MDX6438183.1 2838783 g7961 i0 47.2 0.673728813559322 53 26 66.1 2 3 158 308 359 MDX6438183.1 branched-chain amino acid transport system permease protein [Gaiellaceae bacterium] diamond 159 42.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
28106939 28106939 PRJEB15333_P_NODE_2025_length_424_cov_10.560000_g1943_i0 PRJEB15333 2025 424 10.56 44.7744 Frankiaceae bacterium 2654182 Bacteria Bacteria 43.1 0.0485   NR HWL37608.1 2654182 g1943 i0 31.4 0.608490566037736 86 48 53.1 2 43 267 5 90 HWL37608.1 hypothetical protein [Frankiaceae bacterium] diamond 258 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales Frankiaceae   Frankiaceae bacterium
28264749 28264749 PRJEB15333_P_NODE_3846_length_325_cov_1.514493_g3762_i0 PRJEB15333 3846 325 1.514493 4.92210225 Streptomyces sp. NPDC 1931 Bacteria Bacteria 45.4 0.011   NR WP_351510576.1 3154534 g3762 i0 38.2 0.701538461538462 76 44 67.4 1 70 288 50 125 WP_351510576.1 SpoIIE family protein phosphatase [Streptomyces sp. NPDC002055] diamond 228 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC002055
28296380 28296380 PRJEB15333_P_NODE_7006_length_251_cov_1.004950_g6922_i0 PRJEB15333 7006 251 1.00495 2.5224245 Umezawaea tangerina 84725 Bacteria Bacteria 43.9 0.0157   NR WP_106188173.1 84725 g6922 i0 36.9 0.776892430278884 65 39 75.3 2 51 239 293 357 WP_106188173.1 MFS transporter [Umezawaea tangerina] diamond 195 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Umezawaea Umezawaea tangerina
29395184 29395184 PRJEB15333_P_NODE_12549_length_193_cov_1.250000_g12465_i0 PRJEB15333 12549 193 1.25 2.4125 Micromonosporaceae 28056 Bacteria Bacteria 43.5 0.0104   NR MDT5032800.1 1871 g12465 i0 46.2 5.4559585492228 39 20 60.6 1 11 127 136 173 MDT5032800.1 transporter, Spinster family, sphingosine-phosphate transporter [Actinoplanes sp.] diamond 1053 43.9 0.990888382687927 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Actinoplanes Actinoplanes sp.
29811886 29811886 PRJEB15333_P_NODE_8971_length_225_cov_1.215909_g8887_i0 PRJEB15333 8971 225 1.215909 2.73579525 Actinoplanes lobatus 113568 Bacteria Bacteria 46.6 0.00124   NR WP_188119254.1 113568 g8887 i0 50 0.72 54 23 66.7 2 41 190 221 274 WP_188119254.1 hypothetical protein [Actinoplanes lobatus] diamond 162 46.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Actinoplanes Actinoplanes lobatus
29969917 29969917 PRJEB15333_P_NODE_19471_length_164_cov_0.904348_g19387_i0 PRJEB15333 19471 164 0.904348 1.48313072 Actinomycetota bacterium 2900548 Bacteria Bacteria 40.8 0.0144   NR MEP6903339.1 2900548 g19387 i0 42.6 0.859756097560976 47 24 82.3 2 30 164 13 58 MEP6903339.1 transcriptional regulator [Actinomycetota bacterium] diamond 141 40.8 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30412613 30412613 PRJEB15333_P_NODE_9073_length_224_cov_0.782857_g8989_i0 PRJEB15333 9073 224 0.782857 1.75359968 Nocardioides sp. 35761 Bacteria Bacteria 43.5 0.0152   NR WP_415143840.1 35761 g8989 i0 36.5 0.696428571428571 52 33 69.6 0 64 219 271 322 WP_415143840.1 MFS transporter [Nocardioides sp.] diamond 156 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp.
30507122 30507122 PRJEB15333_P_NODE_2853_length_368_cov_11.241379_g2769_i0 PRJEB15333 2853 368 11.241379 41.36827472 Frankiaceae bacterium 2654182 Bacteria Bacteria 44.3 0.0117   NR HWL37608.1 2654182 g2769 i0 31.7 0.668478260869565 82 45 57.9 2 43 255 5 86 HWL37608.1 hypothetical protein [Frankiaceae bacterium] diamond 246 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales Frankiaceae   Frankiaceae bacterium
30570022 30570022 PRJEB15333_P_NODE_11373_length_202_cov_0.973856_g11289_i0 PRJEB15333 11373 202 0.973856 1.96718912 Phycicoccus jejuensis 367299 Bacteria Bacteria 42.4 0.0287   NR WP_404347920.1 367299 g11289 i0 39.1 0.683168316831683 46 28 68.3 0 6 143 204 249 WP_404347920.1 acyltransferase family protein [Phycicoccus jejuensis] diamond 138 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Phycicoccus Phycicoccus jejuensis
31075925 31075925 PRJEB15333_P_NODE_1915_length_435_cov_39.740933_g1834_i0 PRJEB15333 1915 435 39.740933 172.87305855 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 45.1 0.0426   NR HEY6524554.1 2586742 g1834 i0 27.8 1.04137931034483 151 94 100 6 1 435 115 256 HEY6524554.1 IPT/TIG domain-containing protein [Solirubrobacteraceae bacterium] diamond 453 45.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
31201752 31201752 PRJEB15333_P_NODE_4455_length_306_cov_1.120623_g4371_i0 PRJEB15333 4455 306 1.120623 3.42910638 Streptomyces olivoreticuli 68246 Bacteria Bacteria 47 0.00263   NR WP_301890529.1 68246 g4371 i0 36 0.872549019607843 89 43 86.3 3 282 19 863 938 WP_301890529.1 DUF6603 domain-containing protein [Streptomyces olivoreticuli] diamond 267 47 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces olivoreticuli
32303257 32303257 PRJEB15333_P_NODE_19439_length_164_cov_0.904348_g19355_i0 PRJEB15333 19439 164 0.904348 1.48313072 Actinomycetes 1760 Bacteria Bacteria 42 0.0245   NR WP_037698221.1 1930 g19355 i0 48.6 1.26219512195122 37 18 65.9 1 2 109 768 804 WP_037698221.1 non-ribosomal peptide synthetase [Streptomyces scabiei] diamond 207 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces scabiei
32309690 32309690 PRJEB15333_P_NODE_7899_length_238_cov_0.888889_g7815_i0 PRJEB15333 7899 238 0.888889 2.11555582 Nocardia sp. NPDC 1821 Bacteria Bacteria 43.5 0.0195   NR WP_356996942.1 3155256 g7815 i0 31.1 0.932773109243697 74 47 90.8 2 225 10 531 602 WP_356996942.1 phage tail tape measure protein [Nocardia sp. NPDC046763] diamond 222 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia sp. NPDC046763
32594133 32594133 PRJEB15333_P_NODE_3140_length_354_cov_16.127869_g3056_i0 PRJEB15333 3140 354 16.127869 57.09265626 Nocardioides baculatus 2801337 Bacteria Bacteria 46.6 0.00474   NR WP_201935394.1 2801337 g3056 i0 35.9 0.991525423728814 117 57 88.1 4 344 33 24 135 WP_201935394.1 UbiA family prenyltransferase [Nocardioides baculatus] diamond 351 46.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides baculatus

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