RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJNA982720" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA982720 · 23 ✖

analysis 1

  • blastn · 23 ✖

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
964211 964211 PRJNA982720_S_NODE_1501_length_398_cov_4.944615_g1473_i0 PRJNA982720 1501 398 4.944615 19.6795677 Paraburkholderia fungorum 134537 Bacteria Bacteria 684 0   NTclustered gi|2263174463|gb|CP099645.1| 134537 g1473 i0 99.732 248.603015075377 373 1 94 0 26 398 2243549 2243177 Paraburkholderia fungorum strain OTU2SAUBB1 chromosome 2, complete sequence blastn 98944 684 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
4792283 4792283 PRJNA982720_S_NODE_1244_length_412_cov_3.418879_g1216_i0 PRJNA982720 1244 412 3.418879 14.08578148 Paraburkholderia fungorum 134537 Bacteria Bacteria 756 0   NTclustered gi|780553163|gb|CP010026.1| 134537 g1216 i0 99.757 78.2864077669903 412 1 100 0 1 412 3709040 3709451 Paraburkholderia fungorum strain ATCC BAA-463 chromosome 1, complete sequence blastn 32254 756 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
4792313 4792313 PRJNA982720_S_NODE_2144_length_371_cov_2.932886_g2116_i0 PRJNA982720 2144 371 2.932886 10.88100706 Paraburkholderia fungorum 134537 Bacteria Bacteria 673 0   NTclustered gi|2261094427|gb|CP099627.1| 134537 g2116 i0 99.728 11.0377358490566 367 1 99 0 5 371 2253818 2254184 Paraburkholderia fungorum strain OTU2BAGNBA2 chromosome 1, complete sequence blastn 4095 673 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
4792332 4792332 PRJNA982720_S_NODE_2764_length_351_cov_2.226619_g2736_i0 PRJNA982720 2764 351 2.226619 7.81543269 Paraburkholderia fungorum 134537 Bacteria Bacteria 586 7.349999999999997e-163   NTclustered gi|780553163|gb|CP010026.1| 134537 g2736 i0 98.784 92.8233618233618 329 4 94 0 23 351 11521 11849 Paraburkholderia fungorum strain ATCC BAA-463 chromosome 1, complete sequence blastn 32581 586 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
7342030 7342030 PRJNA982720_S_NODE_1806_length_384_cov_3.299035_g1778_i0 PRJNA982720 1806 384 3.299035 12.6682944 Paraburkholderia fungorum 134537 Bacteria Bacteria 686 0   NTclustered gi|2739558560|gb|CP157346.1| 134537 g1778 i0 99.733 97.1927083333333 374 1 97 0 1 374 631897 631524 Paraburkholderia fungorum strain zafu-N9 chromosome 1, complete sequence blastn 37322 686 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
8617374 8617374 PRJNA982720_S_NODE_5207_length_300_cov_4.735683_g5179_i0 PRJNA982720 5207 300 4.735683 14.207049 Paraburkholderia fungorum 134537 Bacteria Bacteria 555 1.7399999999999995e-153   NTclustered gi|1865493873|gb|CP028830.1| 134537 g5179 i0 100 99.5366666666667 300 0 100 0 1 300 435503 435802 Paraburkholderia fungorum strain UM_TBK chromosome 2 blastn 29861 555 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
9892320 9892320 PRJNA982720_S_NODE_10468_length_223_cov_5.286667_g10440_i0 PRJNA982720 10468 223 5.286667 11.78926741 Paraburkholderia fungorum 134537 Bacteria Bacteria 412 7.88e-111   NTclustered gi|780553163|gb|CP010026.1| 134537 g10440 i0 100 11.627802690583 223 0 100 0 1 223 2678713 2678935 Paraburkholderia fungorum strain ATCC BAA-463 chromosome 1, complete sequence blastn 2593 412 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
11167674 11167674 PRJNA982720_S_NODE_3169_length_340_cov_4.385768_g3141_i0 PRJNA982720 3169 340 4.385768 14.9116112 Paraburkholderia fungorum 134537 Bacteria Bacteria 628 1.1699999999999999e-175   NTclustered gi|1865490366|gb|CP028829.1| 134537 g3141 i0 100 98.3970588235294 340 0 100 0 1 340 2732922 2733261 Paraburkholderia fungorum strain UM_TBK chromosome 1 blastn 33455 628 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
12443507 12443507 PRJNA982720_S_NODE_5210_length_300_cov_3.850220_g5182_i0 PRJNA982720 5210 300 3.85022 11.55066 Paraburkholderia fungorum 134537 Bacteria Bacteria 542 1.36e-149   NTclustered gi|780553163|gb|CP010026.1| 134537 g5182 i0 99.331 24.4733333333333 299 2 99 0 2 300 4254485 4254187 Paraburkholderia fungorum strain ATCC BAA-463 chromosome 1, complete sequence blastn 7342 542 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
14992396 14992396 PRJNA982720_S_NODE_9432_length_244_cov_1.707602_g9404_i0 PRJNA982720 9432 244 1.707602 4.16654888 Paraburkholderia fungorum 134537 Bacteria Bacteria 451 1.86e-122   NTclustered gi|2261094427|gb|CP099627.1| 134537 g9404 i0 100 96.5040983606557 244 0 100 0 1 244 3839996 3840239 Paraburkholderia fungorum strain OTU2BAGNBA2 chromosome 1, complete sequence blastn 23547 451 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
17542227 17542227 PRJNA982720_S_NODE_5014_length_303_cov_6.817391_g4986_i0 PRJNA982720 5014 303 6.817391 20.65669473 Paraburkholderia fungorum 134537 Bacteria Bacteria 560 3.79e-155   NTclustered gi|1865493873|gb|CP028830.1| 134537 g4986 i0 100 9.98679867986799 303 0 100 0 1 303 3308538 3308236 Paraburkholderia fungorum strain UM_TBK chromosome 2 blastn 3026 560 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
17542254 17542254 PRJNA982720_S_NODE_5794_length_290_cov_7.705069_g5766_i0 PRJNA982720 5794 290 7.705069 22.3447001 Paraburkholderia fungorum 134537 Bacteria Bacteria 531 2.83e-146   NTclustered gi|2739566769|gb|CP157349.1| 134537 g5766 i0 100 6.04827586206897 287 0 99 0 1 287 295421 295707 Paraburkholderia fungorum strain zafu-N9 plasmid unnamed2, complete sequence blastn 1754 531 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
18816123 18816123 PRJNA982720_S_NODE_5995_length_287_cov_3.140187_g5967_i0 PRJNA982720 5995 287 3.140187 9.01233669 Paraburkholderia fungorum 134537 Bacteria Bacteria 531 2.799999999999999e-146   NTclustered gi|2261094427|gb|CP099627.1| 134537 g5967 i0 100 31.9477351916376 287 0 100 0 1 287 847763 847477 Paraburkholderia fungorum strain OTU2BAGNBA2 chromosome 1, complete sequence blastn 9169 531 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
20090692 20090692 PRJNA982720_S_NODE_1136_length_420_cov_5.293948_g1108_i0 PRJNA982720 1136 420 5.293948 22.2345816 Paraburkholderia fungorum 134537 Bacteria Bacteria 776 0   NTclustered gi|1865490366|gb|CP028829.1| 134537 g1108 i0 100 19.5785714285714 420 0 100 0 1 420 2761864 2761445 Paraburkholderia fungorum strain UM_TBK chromosome 1 blastn 8223 776 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
20090716 20090716 PRJNA982720_S_NODE_1756_length_386_cov_4.233227_g1728_i0 PRJNA982720 1756 386 4.233227 16.34025622 Paraburkholderia fungorum 134537 Bacteria Bacteria 706 0   NTclustered gi|1865490366|gb|CP028829.1| 134537 g1728 i0 100 97.7046632124352 382 0 99 0 5 386 2008693 2008312 Paraburkholderia fungorum strain UM_TBK chromosome 1 blastn 37714 706 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
20090799 20090799 PRJNA982720_S_NODE_4116_length_320_cov_4.165992_g4088_i0 PRJNA982720 4116 320 4.165992 13.3311744 Paraburkholderia fungorum 134537 Bacteria Bacteria 592 1.4299999999999996e-164   NTclustered gi|1865493873|gb|CP028830.1| 134537 g4088 i0 100 14.3375 320 0 100 0 1 320 99080 99399 Paraburkholderia fungorum strain UM_TBK chromosome 2 blastn 4588 592 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
20090818 20090818 PRJNA982720_S_NODE_4656_length_310_cov_1.502110_g4628_i0 PRJNA982720 4656 310 1.50211 4.656541 Paraburkholderia fungorum 134537 Bacteria Bacteria 527 3.9499999999999986e-145   NTclustered gi|2261094427|gb|CP099627.1| 134537 g4628 i0 100 44.441935483871 285 0 92 0 26 310 1202398 1202682 Paraburkholderia fungorum strain OTU2BAGNBA2 chromosome 1, complete sequence blastn 13777 527 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
20090868 20090868 PRJNA982720_S_NODE_6316_length_282_cov_4.416268_g6288_i0 PRJNA982720 6316 282 4.416268 12.45387576 Paraburkholderia fungorum 134537 Bacteria Bacteria 521 1.6499999999999996e-143   NTclustered gi|2739566769|gb|CP157349.1| 134537 g6288 i0 100 6 282 0 100 0 1 282 220741 221022 Paraburkholderia fungorum strain zafu-N9 plasmid unnamed2, complete sequence blastn 1692 521 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
21366317 21366317 PRJNA982720_S_NODE_1957_length_378_cov_7.531148_g1929_i0 PRJNA982720 1957 378 7.531148 28.46773944 Paraburkholderia fungorum 134537 Bacteria Bacteria 699 0   NTclustered gi|1865490366|gb|CP028829.1| 134537 g1929 i0 100 100.047619047619 378 0 100 0 1 378 2635684 2636061 Paraburkholderia fungorum strain UM_TBK chromosome 1 blastn 37818 699 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
23917050 23917050 PRJNA982720_S_NODE_7939_length_260_cov_3.679144_g7911_i0 PRJNA982720 7939 260 3.679144 9.5657744 Paraburkholderia fungorum 134537 Bacteria Bacteria 479 9.17e-131   NTclustered gi|2739558560|gb|CP157346.1| 134537 g7911 i0 100 99.5076923076923 259 0 99 0 2 260 2086842 2086584 Paraburkholderia fungorum strain zafu-N9 chromosome 1, complete sequence blastn 25872 479 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
25190443 25190443 PRJNA982720_S_NODE_1760_length_386_cov_3.607029_g1732_i0 PRJNA982720 1760 386 3.607029 13.92313194 Paraburkholderia fungorum 134537 Bacteria Bacteria 713 0   NTclustered gi|1865490366|gb|CP028829.1| 134537 g1732 i0 100 98.5647668393782 386 0 100 0 1 386 1993798 1994183 Paraburkholderia fungorum strain UM_TBK chromosome 1 blastn 38046 713 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
25190590 25190590 PRJNA982720_S_NODE_6120_length_285_cov_3.750000_g6092_i0 PRJNA982720 6120 285 3.75 10.6875 Paraburkholderia fungorum 134537 Bacteria Bacteria 527 3.59e-145   NTclustered gi|2263177777|gb|CP099647.1| 134537 g6092 i0 100 50.4315789473684 285 0 100 0 1 285 2186750 2186466 Paraburkholderia fungorum strain OTU2SAUBB1 chromosome 1, complete sequence blastn 14373 527 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia fungorum
25190672 25190672 PRJNA982720_S_NODE_8500_length_254_cov_1.243094_g8472_i0 PRJNA982720 8500 254 1.243094 3.15745876 Paraburkholderia phytofirmans 261302 Bacteria Bacteria 176 1.31e-39   NTclustered gi|187720305|gb|CP001054.1| 398527 g8472 i0 87.919 1.77952755905512 149 18 74 0 1 149 41788 41640 Paraburkholderia phytofirmans PsJN plasmid pBPHYT01, complete sequence blastn 452 176 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia phytofirmans

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