RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1036688" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1036688 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
10372866 10372866 PRJNA1036688_P_NODE_11649_length_155_cov_1.313559_g11357_i0 PRJNA1036688 11649 155 1.313559 2.03601645 Undibacterium 401469 Bacteria Bacteria 90.9 5.8e-22   NR WP_189357193.1 401469 g11357 i0 100 0.987096774193548 51 0 98.7 0 2 154 38 88 WP_189357193.1 MULTISPECIES: 50S ribosomal protein L18 [Undibacterium] diamond 153 90.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium  
15472465 15472465 PRJNA1036688_P_NODE_10833_length_162_cov_1.232000_g10541_i0 PRJNA1036688 10833 162 1.232 1.99584 Undibacterium luofuense 2828733 Bacteria Bacteria 98.2 3.58e-22   NR WP_212686705.1 2828733 g10541 i0 100 0.981481481481482 53 0 98.1 0 2 160 137 189 WP_212686705.1 catecholate siderophore receptor Fiu [Undibacterium luofuense] diamond 159 98.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium luofuense
18021571 18021571 PRJNA1036688_P_NODE_9435_length_176_cov_1.633094_g9143_i0 PRJNA1036688 9435 176 1.633094 2.87424544 Stenotrophomonas sp. 69392 Bacteria Bacteria 98.2 1.2800000000000001e-22   NR WP_287256582.1 69392 g9143 i0 77.6 0.988636363636364 58 13 98.9 0 174 1 93 150 WP_287256582.1 integrase, partial [Stenotrophomonas sp.] diamond 174 98.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas sp.
26845550 26845550 PRJNA1036688_P_NODE_7381_length_206_cov_1.591716_g7089_i0 PRJNA1036688 7381 206 1.591716 3.27893496 Acinetobacter baumannii 470 Bacteria Bacteria 118 6.36e-33   NR WP_227516975.1 470 g7089 i0 96.8 0.902912621359223 62 2 90.3 0 205 20 34 95 WP_227516975.1 hypothetical protein, partial [Acinetobacter baumannii] diamond 186 118 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
27856422 27856422 PRJNA1036688_P_NODE_8785_length_184_cov_1.748299_g8493_i0 PRJNA1036688 8785 184 1.748299 3.21687016 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 46.2 9.36e-5   NR WP_267991923.1 715 g8493 i0 56.3 0.521739130434783 32 14 52.2 0 5 100 34 65 WP_267991923.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae] diamond 96 46.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae
28203570 28203570 PRJNA1036688_P_NODE_11426_length_157_cov_0.925000_g11134_i0 PRJNA1036688 11426 157 0.925 1.45225 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 60.1 4.06e-10   NR WP_267992332.1 715 g11134 i0 66.7 0.687898089171974 36 12 68.8 0 49 156 33 68 WP_267992332.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae] diamond 108 60.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae
29245779 29245779 PRJNA1036688_P_NODE_10849_length_162_cov_1.008000_g10557_i0 PRJNA1036688 10849 162 1.008 1.63296 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 60.1 1.48e-9   NR WP_267994764.1 715 g10557 i0 52 1.85185185185185 50 23 92.6 1 1 150 82 130 WP_267994764.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae] diamond 300 60.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae
29561334 29561334 PRJNA1036688_P_NODE_11810_length_154_cov_0.846154_g11518_i0 PRJNA1036688 11810 154 0.846154 1.30307716 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 73.2 7.97e-15   NR WP_267995017.1 715 g11518 i0 75.5 0.954545454545455 49 12 95.5 0 2 148 42 90 WP_267995017.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae] diamond 147 73.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae
29750699 29750699 PRJNA1036688_P_NODE_10591_length_164_cov_1.677165_g10299_i0 PRJNA1036688 10591 164 1.677165 2.7505506 Salmonella enterica 28901 Bacteria Bacteria 69.3 6.78e-14   NR WP_218972368.1 28901 g10299 i0 94.4 0.658536585365854 36 2 65.9 0 110 3 1 36 WP_218972368.1 hypothetical protein, partial [Salmonella enterica] diamond 108 69.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
30066734 30066734 PRJNA1036688_P_NODE_9232_length_178_cov_2.560284_g8940_i0 PRJNA1036688 9232 178 2.560284 4.55730552 Burkholderiales bacterium 1891238 Bacteria Bacteria 43.5 0.00112   NR HXM83151.1 1891238 g8940 i0 78.9 1.24719101123595 19 4 32 0 10 66 46 64 HXM83151.1 membrane protein insertion efficiency factor YidD [Burkholderiales bacterium] diamond 222 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales     Burkholderiales bacterium
30161348 30161348 PRJNA1036688_P_NODE_10712_length_163_cov_1.317460_g10420_i0 PRJNA1036688 10712 163 1.31746 2.1474598 Stenotrophomonas sp. 69392 Bacteria Bacteria 76.6 9.75e-15   NR WP_287256582.1 69392 g10420 i0 63.5 0.957055214723926 52 19 95.7 0 158 3 246 297 WP_287256582.1 integrase, partial [Stenotrophomonas sp.] diamond 156 76.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas sp.
30540704 30540704 PRJNA1036688_P_NODE_8233_length_192_cov_1.393548_g7941_i0 PRJNA1036688 8233 192 1.393548 2.67561216 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 62 9.82e-11   NR WP_267994951.1 715 g7941 i0 70 0.78125 50 11 71.9 1 190 53 37 86 WP_267994951.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae] diamond 150 62 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae
30793401 30793401 PRJNA1036688_P_NODE_8374_length_190_cov_1.307190_g8082_i0 PRJNA1036688 8374 190 1.30719 2.483661 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 61.2 6.62e-10   NR WP_267994742.1 715 g8082 i0 83.8 0.58421052631579 37 4 58.4 1 113 3 1 35 WP_267994742.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae] diamond 111 61.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae
30943601 30943601 PRJNA1036688_P_NODE_3674_length_336_cov_7.351171_g3383_i0 PRJNA1036688 3674 336 7.351171 24.69993456 Oxalobacteraceae 75682 Bacteria Bacteria 204 1.43e-60   NR WP_223826888.1 1537398 g3383 i0 93.5 5.77678571428571 107 7 95.5 0 1 321 87 193 WP_223826888.1 terminase large subunit [Undibacterium aquatile] diamond 1941 204 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium aquatile
31203791 31203791 PRJNA1036688_P_NODE_8195_length_192_cov_3.645161_g7903_i0 PRJNA1036688 8195 192 3.645161 6.99870912 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 42.4 0.0255   NR MFM7118878.1 1913989 g7903 i0 36.7 0.9375 60 29 87.5 2 20 187 316 370 MFM7118878.1 SLC13 family permease [Gammaproteobacteria bacterium] diamond 180 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
31394181 31394181 PRJNA1036688_P_NODE_9096_length_180_cov_1.601399_g8804_i0 PRJNA1036688 9096 180 1.601399 2.8825182 Acinetobacter baumannii 470 Bacteria Bacteria 119 1.9499999999999998e-32   NR OIC52161.1 470 g8804 i0 98.3 1 60 1 100 0 180 1 63 122 OIC52161.1 hypothetical protein A7L55_19745 [Acinetobacter baumannii] diamond 180 119 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
32018637 32018637 PRJNA1036688_P_NODE_8158_length_193_cov_1.500000_g7866_i0 PRJNA1036688 8158 193 1.5 2.895 Azospirillum 191 Bacteria Bacteria 45.4 0.00216   NR WP_085556800.1 1720247 g7866 i0 90 0.932642487046632 20 2 31.1 0 2 61 453 472 WP_085556800.1 homospermidine synthase [Azospirillum agricola] diamond 180 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Azospirillaceae Azospirillum Azospirillum agricola
32184958 32184958 PRJNA1036688_P_NODE_9198_length_179_cov_0.802817_g8906_i0 PRJNA1036688 9198 179 0.802817 1.43704243 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 105 4.34e-28   NR WP_369124389.1 715 g8906 i0 87.7 0.955307262569832 57 7 95.5 0 1 171 19 75 WP_369124389.1 integrase catalytic domain-containing protein, partial [Actinobacillus pleuropneumoniae] diamond 171 105 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae
32596145 32596145 PRJNA1036688_P_NODE_11060_length_160_cov_1.260163_g10768_i0 PRJNA1036688 11060 160 1.260163 2.0162608 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 39.3 0.0363   NR MDA8389609.1 1913989 g10768 i0 54.8 0.58125 31 14 58.1 0 19 111 20 50 MDA8389609.1 CDGSH iron-sulfur domain-containing protein [Gammaproteobacteria bacterium] diamond 93 39.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
32784855 32784855 PRJNA1036688_P_NODE_6280_length_232_cov_1.805128_g5988_i0 PRJNA1036688 6280 232 1.805128 4.18789696 Escherichia coli 562 Bacteria Bacteria 75.1 9.93e-16   NR MDW3502763.1 562 g5988 i0 62.1 0.75 58 22 75 0 180 7 15 72 MDW3502763.1 retrotransposon gag domain-containing protein [Escherichia coli] diamond 174 75.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32847902 32847902 PRJNA1036688_P_NODE_9320_length_177_cov_2.192857_g9028_i0 PRJNA1036688 9320 177 2.192857 3.88135689 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 41.2 0.0114   NR WP_267994688.1 715 g9028 i0 100 0.322033898305085 19 0 32.2 0 117 173 1 19 WP_267994688.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae] diamond 57 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae

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