RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA640143" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA640143 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
609969 609969 PRJNA640143_S_NODE_27301_length_168_cov_1.190840_g27091_i0 PRJNA640143 27301 168 1.19084 2.0006112 Bacteria 2 Bacteria Bacteria 90.9 4.2e-22   NR MDQ3132555.1 1978231 g27091 i0 86.3 4.51785714285714 51 7 91.1 0 167 15 52 102 MDQ3132555.1 30S ribosomal protein S7 [Acidobacteriota bacterium] diamond 759 90.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26637789 26637789 PRJNA640143_S_NODE_30921_length_155_cov_1.796610_g30711_i0 PRJNA640143 30921 155 1.79661 2.7847455 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 62.4 4.23e-11   NR MBA2736638.1 2283092 g30711 i0 60 1.93548387096774 50 19 96.8 1 4 153 1 49 MBA2736638.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 300 62.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
26681879 26681879 PRJNA640143_S_NODE_29321_length_160_cov_3.170732_g29111_i0 PRJNA640143 29321 160 3.170732 5.0731712 Bacteria 2 Bacteria Bacteria 83.6 4.75e-17   NR MDQ1353206.1 1978231 g29111 i0 82.6 7.7625 46 8 86.3 0 3 140 235 280 MDQ1353206.1 hypothetical protein [Acidobacteriota bacterium] diamond 1242 84 0.995238095238095 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26828004 26828004 PRJNA640143_S_NODE_32781_length_150_cov_1.663717_g32571_i0 PRJNA640143 32781 150 1.663717 2.4955755 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 72.4 2.91e-15   NR MBA2735665.1 2283092 g32571 i0 94.7 0.76 38 2 76 0 36 149 9 46 MBA2735665.1 50S ribosomal protein L29 [Pyrinomonadaceae bacterium] diamond 114 72.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28502222 28502222 PRJNA640143_S_NODE_14947_length_225_cov_10.377660_g14737_i0 PRJNA640143 14947 225 10.37766 23.349735 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 111 2.13e-28   NR MCK6693374.1 2651171 g14737 i0 86.2 0.866666666666667 65 9 86.7 0 196 2 16 80 MCK6693374.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 195 111 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
28565294 28565294 PRJNA640143_S_NODE_12247_length_248_cov_1.696682_g12037_i0 PRJNA640143 12247 248 1.696682 4.20777136 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 145 1.72e-39   NR HXG84575.1 2283092 g12037 i0 92.7 2.9758064516129 82 6 99.2 0 247 2 378 459 HXG84575.1 TolC family protein [Pyrinomonadaceae bacterium] diamond 738 145 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28767178 28767178 PRJNA640143_S_NODE_31787_length_153_cov_1.344828_g31577_i0 PRJNA640143 31787 153 1.344828 2.05758684 Bacteria 2 Bacteria Bacteria 84.3 2.43e-17   NR MDQ3131757.1 1978231 g31577 i0 88.9 3.52941176470588 45 5 88.2 0 150 16 625 669 MDQ3131757.1 S8 family serine peptidase [Acidobacteriota bacterium] diamond 540 84.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28861807 28861807 PRJNA640143_S_NODE_27048_length_169_cov_1.416667_g26838_i0 PRJNA640143 27048 169 1.416667 2.39416723 Bacteria 2 Bacteria Bacteria 83.6 6.62e-19   NR MDQ3132141.1 1978231 g26838 i0 95.7 5.71597633136095 46 2 81.7 0 139 2 35 80 MDQ3132141.1 hemerythrin domain-containing protein [Acidobacteriota bacterium] diamond 966 84 0.995238095238095 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29259747 29259747 PRJNA640143_S_NODE_32209_length_152_cov_1.017391_g31999_i0 PRJNA640143 32209 152 1.017391 1.54643432 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 57.8 5.3e-8   NR HXT71982.1 2910147 g31999 i0 55.3 1.85526315789474 47 21 92.8 0 11 151 157 203 HXT71982.1 alpha-L-arabinofuranosidase C-terminal domain-containing protein [Vicinamibacterales bacterium] diamond 282 57.8 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
29891636 29891636 PRJNA640143_S_NODE_31351_length_154_cov_1.461538_g31141_i0 PRJNA640143 31351 154 1.461538 2.25076852 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 82.8 1.93e-18   NR MBA2735508.1 2283092 g31141 i0 86 0.974025974025974 50 7 97.4 0 152 3 3 52 MBA2735508.1 hemerythrin domain-containing protein [Pyrinomonadaceae bacterium] diamond 150 82.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31073022 31073022 PRJNA640143_S_NODE_31795_length_153_cov_1.310345_g31585_i0 PRJNA640143 31795 153 1.310345 2.00482785 Bacteria 2 Bacteria Bacteria 88.6 9.86e-21   NR MBA3631548.1 1978231 g31585 i0 86.3 2 51 7 100 0 153 1 56 106 MBA3631548.1 outer membrane protein assembly factor BamD [Acidobacteriota bacterium] diamond 306 88.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31471683 31471683 PRJNA640143_S_NODE_31036_length_155_cov_1.322034_g30826_i0 PRJNA640143 31036 155 1.322034 2.0491527 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 102 4.17e-25   NR MEO7157222.1 2910147 g30826 i0 90.2 1.9741935483871 51 5 98.7 0 2 154 5 55 MEO7157222.1 50S ribosomal protein L3 [Vicinamibacterales bacterium] diamond 306 102 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
31661111 31661111 PRJNA640143_S_NODE_26497_length_171_cov_1.746269_g26287_i0 PRJNA640143 26497 171 1.746269 2.98611999 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 41.2 0.0491   NR HYO15783.1 2651171 g26287 i0 38.5 0.912280701754386 52 31 89.5 1 8 160 271 322 HYO15783.1 O-antigen ligase family protein [Thermoanaerobaculia bacterium] diamond 156 41.2 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia 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);;