RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA773625" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA773625 · 22 ✖

analysis 1

  • blastn · 22 ✖

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
2025242 2025242 PRJNA773625_P_NODE_6802_length_172_cov_1.308943_g6787_i0 PRJNA773625 6802 172 1.308943 2.25138196 Undibacterium cyanobacteriorum 3073561 Bacteria Bacteria 228 2.2299999999999997e-55   NTclustered gi|2575695762|gb|CP133720.1| 3073561 g6787 i0 95.745 173.156976744186 141 6 82 0 32 172 740484 740344 Undibacterium cyanobacteriorum strain 20NA77.5 chromosome, complete genome blastn 29783 228 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium cyanobacteriorum
3758907 3758907 PRJNA773625_P_NODE_7663_length_168_cov_0.873950_g7648_i0 PRJNA773625 7663 168 0.87395 1.468236 Escherichia 561 Bacteria Bacteria 305 9.81e-79   NTclustered gi|2650988455|gb|CP142548.1| 562 g7648 i0 99.405 100 168 1 100 0 1 168 3497366 3497199 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 16800 305 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
3758908 3758908 PRJNA773625_P_NODE_8163_length_167_cov_0.881356_g8148_i0 PRJNA773625 8163 167 0.881356 1.47186452 Enterobacteriaceae 543 Bacteria Bacteria 309 7.53e-80   NTclustered gi|2161252967|gb|CP088071.1| 562 g8148 i0 100 100 167 0 100 0 1 167 1967743 1967909 Escherichia coli strain 427603 chromosome, complete genome blastn 16700 309 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
5035502 5035502 PRJNA773625_P_NODE_7944_length_168_cov_0.873950_g7929_i0 PRJNA773625 7944 168 0.87395 1.468236 Enterobacteriaceae 543 Bacteria Bacteria 311 2.11e-80   NTclustered gi|2650988455|gb|CP142548.1| 562 g7929 i0 100 100 168 0 100 0 1 168 1986399 1986566 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 16800 311 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
5852897 5852897 PRJNA773625_P_NODE_7005_length_170_cov_1.090909_g6990_i0 PRJNA773625 7005 170 1.090909 1.8545453 Escherichia coli 562 Bacteria Bacteria 270 3.61e-68   NTclustered gi|2044032419|gb|CP075374.1| 562 g6990 i0 99.329 608.617647058824 149 1 88 0 1 149 4888143 4888291 Escherichia coli strain no107 chromosome, complete genome blastn 103465 270 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
6311172 6311172 PRJNA773625_P_NODE_8005_length_168_cov_0.865546_g7990_i0 PRJNA773625 8005 168 0.865546 1.45411728 Escherichia 561 Bacteria Bacteria 311 2.11e-80   NTclustered gi|2211724983|gb|CP066839.1| 562 g7990 i0 100 99.9642857142857 168 0 100 0 1 168 4531527 4531694 Escherichia coli strain Ec-RL2-1X chromosome, complete genome blastn 16794 311 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
7128031 7128031 PRJNA773625_P_NODE_7326_length_169_cov_0.866667_g7311_i0 PRJNA773625 7326 169 0.866667 1.46466723 Rhizobium oryzihabitans 2267833 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|1810208023|gb|CP048632.1| 2267833 g7311 i0 100 100.917159763314 169 0 100 0 1 169 2028409 2028577 Rhizobium oryzihabitans strain M15 chromosome M15-11, complete sequence blastn 17055 313 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium Rhizobium oryzihabitans
7585221 7585221 PRJNA773625_P_NODE_8226_length_167_cov_0.881356_g8211_i0 PRJNA773625 8226 167 0.881356 1.47186452 Escherichia 561 Bacteria Bacteria 309 7.53e-80   NTclustered gi|2211724983|gb|CP066839.1| 562 g8211 i0 100 2934.01796407186 167 0 100 0 1 167 4010068 4009902 Escherichia coli strain Ec-RL2-1X chromosome, complete genome blastn 489981 309 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
7585222 7585222 PRJNA773625_P_NODE_8806_length_166_cov_0.888889_g8791_i0 PRJNA773625 8806 166 0.888889 1.47555574 Acinetobacter 469 Bacteria Bacteria 307 2.69e-79   NTclustered gi|1527242478|gb|CP033572.1| 106654 g8791 i0 100 100.186746987952 166 0 100 0 1 166 3666781 3666946 Acinetobacter nosocomialis strain 2010N17-248 chromosome, complete genome blastn 16631 307 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter nosocomialis
8860356 8860356 PRJNA773625_P_NODE_10567_length_163_cov_0.912281_g10552_i0 PRJNA773625 10567 163 0.912281 1.48701803 Escherichia 561 Bacteria Bacteria 296 5.68e-76   NTclustered gi|2841922414|gb|CP163901.1| 562 g10552 i0 99.387 100 163 1 100 0 1 163 3876685 3876523 Escherichia coli strain OXEC-129 chromosome, complete genome blastn 16300 296 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
10135764 10135764 PRJNA773625_P_NODE_7328_length_169_cov_0.866667_g7313_i0 PRJNA773625 7328 169 0.866667 1.46466723 Escherichia 561 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|2653344983|gb|CP142438.1| 562 g7313 i0 100 100 169 0 100 0 1 169 4502692 4502524 Escherichia coli strain Case 2 chromosome, complete genome blastn 16900 313 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
13502953 13502953 PRJNA773625_P_NODE_10911_length_162_cov_0.920354_g10896_i0 PRJNA773625 10911 162 0.920354 1.49097348 Acinetobacter nosocomialis 106654 Bacteria Bacteria 300 4.36e-77   NTclustered gi|1580078055|gb|CP036171.1| 106654 g10896 i0 100 100 162 0 100 0 1 162 2901904 2902065 Acinetobacter nosocomialis strain KAN02 chromosome, complete genome blastn 16200 300 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter nosocomialis
13961097 13961097 PRJNA773625_P_NODE_2651_length_252_cov_1.280788_g2636_i0 PRJNA773625 2651 252 1.280788 3.22758576 Enterobacteriaceae 543 Bacteria Bacteria 327 3.39e-85   NTclustered gi|2650988455|gb|CP142548.1| 562 g2636 i0 99.448 71.8253968253968 181 0 71 1 51 230 4574808 4574988 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 18100 327 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
13961101 13961101 PRJNA773625_P_NODE_7431_length_169_cov_0.866667_g7416_i0 PRJNA773625 7431 169 0.866667 1.46466723 Enterobacteriaceae 543 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|2650988455|gb|CP142548.1| 562 g7416 i0 100 100 169 0 100 0 1 169 168241 168073 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 16900 313 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
13961102 13961102 PRJNA773625_P_NODE_7671_length_168_cov_0.873950_g7656_i0 PRJNA773625 7671 168 0.87395 1.468236 Escherichia 561 Bacteria Bacteria 311 2.11e-80   NTclustered gi|2161252967|gb|CP088071.1| 562 g7656 i0 100 100 168 0 100 0 1 168 4266782 4266949 Escherichia coli strain 427603 chromosome, complete genome blastn 16800 311 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
16510073 16510073 PRJNA773625_P_NODE_8213_length_167_cov_0.881356_g8198_i0 PRJNA773625 8213 167 0.881356 1.47186452 Escherichia 561 Bacteria Bacteria 309 7.53e-80   NTclustered gi|2650988455|gb|CP142548.1| 562 g8198 i0 100 100 167 0 100 0 1 167 3990066 3990232 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 16700 309 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
17327557 17327557 PRJNA773625_P_NODE_10834_length_162_cov_0.920354_g10819_i0 PRJNA773625 10834 162 0.920354 1.49097348 Eikenella halliae 1795832 Bacteria Bacteria 278 2.04e-70   NTclustered gi|2831284858|gb|CP171110.1| 1795832 g10819 i0 97.531 11.7222222222222 162 4 100 0 1 162 903914 903753 Eikenella halliae strain WGS1533 chromosome, complete genome blastn 1899 278 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Eikenella Eikenella halliae
17784770 17784770 PRJNA773625_P_NODE_7394_length_169_cov_0.866667_g7379_i0 PRJNA773625 7394 169 0.866667 1.46466723 Bradyrhizobium 374 Bacteria Bacteria 172 1.04e-38   NTclustered gi|2707295499|gb|CP147717.1| 1404429 g7379 i0 90.698 77.2721893491124 129 12 76 0 41 169 5216939 5216811 Bradyrhizobium sp. 2S1 chromosome, complete genome blastn 13059 172 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. 2S1
17784771 17784771 PRJNA773625_P_NODE_8554_length_167_cov_0.881356_g8539_i0 PRJNA773625 8554 167 0.881356 1.47186452 Bacteria 2 Bacteria Bacteria 309 7.53e-80   NTclustered gi|2161252967|gb|CP088071.1| 562 g8539 i0 100 100 167 0 100 0 1 167 5312531 5312365 Escherichia coli strain 427603 chromosome, complete genome blastn 16700 309 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
20333611 20333611 PRJNA773625_P_NODE_10216_length_163_cov_0.912281_g10201_i0 PRJNA773625 10216 163 0.912281 1.48701803 Enterobacteriaceae 543 Bacteria Bacteria 302 1.22e-77   NTclustered gi|2650988455|gb|CP142548.1| 562 g10201 i0 100 100 163 0 100 0 1 163 3296175 3296013 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 16300 302 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
21609296 21609296 PRJNA773625_P_NODE_7197_length_169_cov_0.866667_g7182_i0 PRJNA773625 7197 169 0.866667 1.46466723 Enterobacteriaceae 543 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|2211724983|gb|CP066839.1| 562 g7182 i0 100 100 169 0 100 0 1 169 3415345 3415177 Escherichia coli strain Ec-RL2-1X chromosome, complete genome blastn 16900 313 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
25433818 25433818 PRJNA773625_P_NODE_9920_length_164_cov_0.904348_g9905_i0 PRJNA773625 9920 164 0.904348 1.48313072 Enterobacteriaceae 543 Bacteria Bacteria 303 3.42e-78   NTclustered gi|2653344983|gb|CP142438.1| 562 g9905 i0 100 100 164 0 100 0 1 164 719274 719111 Escherichia coli strain Case 2 chromosome, complete genome blastn 16400 303 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli

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