RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA721440" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA721440 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
3261455 3261455 PRJNA721440_S_NODE_21063_length_156_cov_3.598131_g20937_i0 PRJNA721440 21063 156 3.598131 5.61308436 FCB group 1783270 Bacteria Bacteria 73.6 5.5e-14   NR WP_203087144.1 79881 g20937 i0 59.6 9.88461538461539 52 21 100 0 156 1 24 75 WP_203087144.1 PAS domain-containing protein [Alkalicoccobacillus gibsonii] diamond 1542 73.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alkalicoccobacillus Alkalicoccobacillus gibsonii
27589304 27589304 PRJNA721440_S_NODE_5944_length_248_cov_1.743719_g5818_i0 PRJNA721440 5944 248 1.743719 4.32442312 Bacillota bacterium 1879010 Bacteria Bacteria 45.1 0.00472   NR MBT9153026.1 1879010 g5818 i0 47.1 0.616935483870968 51 26 60.5 1 202 53 32 82 MBT9153026.1 Butyrate--acetoacetate CoA-transferase subunit B [Bacillota bacterium] diamond 153 45.1 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
28547090 28547090 PRJNA721440_S_NODE_11487_length_195_cov_1.328767_g11361_i0 PRJNA721440 11487 195 1.328767 2.59109565 FCB group 1783270 Bacteria Bacteria 55.1 8.8e-7   NR MBP2654693.1 1879010 g11361 i0 42.2 3.86153846153846 64 37 98.5 0 194 3 621 684 MBP2654693.1 amino acid adenylation domain protein [Bacillota bacterium] diamond 753 55.1 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
31632213 31632213 PRJNA721440_S_NODE_1556_length_431_cov_2.900524_g1430_i0 PRJNA721440 1556 431 2.900524 12.50125844 Clostridia bacterium 2044939 Bacteria Bacteria 49.3 8.85e-5   NR MBQ6847602.1 2044939 g1430 i0 35.4 0.549883990719258 79 43 54.3 2 15 248 4 75 MBQ6847602.1 acyl carrier protein [Clostridia bacterium] diamond 237 49.3 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31990618 31990618 PRJNA721440_S_NODE_8898_length_213_cov_2.530488_g8772_i0 PRJNA721440 8898 213 2.530488 5.38993944 Ructibacterium 2884634 Bacteria Bacteria 86.3 1.19e-17   NR MBQ8995572.1 2485925 g8772 i0 68.5 5.32394366197183 54 17 76.1 0 162 1 439 492 MBQ8995572.1 ABC transporter ATP-binding protein [Oscillospiraceae bacterium] diamond 1134 86.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32106781 32106781 PRJNA721440_S_NODE_15538_length_174_cov_1.656000_g15412_i0 PRJNA721440 15538 174 1.656 2.88144 Anaerovoracaceae bacterium 3030912 Bacteria Bacteria 44.3 0.00434   NR MEF9921931.1 3030912 g15412 i0 45.1 2.6551724137931 51 25 82.8 1 28 171 293 343 MEF9921931.1 HAMP domain-containing sensor histidine kinase [Anaerovoracaceae bacterium] diamond 462 44.3 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   Anaerovoracaceae bacterium
32370606 32370606 PRJNA721440_S_NODE_8519_length_217_cov_1.232143_g8393_i0 PRJNA721440 8519 217 1.232143 2.67375031 Bacteria 2 Bacteria Bacteria 111 9.039999999999999e-30   NR MCA9749906.1 1965302 g8393 i0 85.9 1.963133640553 71 10 98.2 0 3 215 32 102 MCA9749906.1 F0F1 ATP synthase subunit A [Romboutsia sp.] diamond 426 111 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia sp.
32528847 32528847 PRJNA721440_S_NODE_4639_length_274_cov_3.311111_g4513_i0 PRJNA721440 4639 274 3.311111 9.07244414 Bacteria 2 Bacteria Bacteria 55.1 2.49e-6   NR MCI8599263.1 1898203 g4513 i0 47.5 3.47080291970803 61 30 66.8 2 274 92 131 189 MCI8599263.1 VWA domain-containing protein [Lachnospiraceae bacterium] diamond 951 55.5 0.992792792792793 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32896093 32896093 PRJNA721440_S_NODE_15260_length_175_cov_2.365079_g15134_i0 PRJNA721440 15260 175 2.365079 4.13888825 Sporolactobacillus sp. STSJ-5 2965076 Bacteria Bacteria 41.6 0.0299   NR WP_255746576.1 2965076 g15134 i0 37.7 0.908571428571429 53 33 90.9 0 163 5 8 60 WP_255746576.1 hypothetical protein [Sporolactobacillus sp. STSJ-5] diamond 159 41.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Sporolactobacillus Sporolactobacillus sp. STSJ-5

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