RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB25789" 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

  • PRJEB25789 · 23 ✖

analysis 1

  • diamond · 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
22999 22999 PRJEB25789_S_NODE_10421_length_301_cov_0.934211_g10342_i0 PRJEB25789 10421 301 0.934211 2.81197511 Rheinheimera texasensis 306205 Bacteria Bacteria 149 1.1e-42   NR WP_031569283.1 306205 g10342 i0 71.2 2.07308970099668 104 25 99.7 2 300 1 108 210 WP_031569283.1 type 1 glutamine amidotransferase domain-containing protein [Rheinheimera texasensis] diamond 624 149 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera texasensis
2572949 2572949 PRJEB25789_S_NODE_11723_length_288_cov_1.051163_g11644_i0 PRJEB25789 11723 288 1.051163 3.02734944 Pseudophaeobacter profundi 3034152 Bacteria Bacteria 174 1.32e-54   NR WP_278924711.1 3034152 g11644 i0 100 1.9375 91 0 94.8 0 275 3 1 91 WP_278924711.1 ribosomal L7Ae/L30e/S12e/Gadd45 family protein, partial [Pseudophaeobacter profundi] diamond 558 174 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Pseudophaeobacter Pseudophaeobacter profundi
6401325 6401325 PRJEB25789_S_NODE_18686_length_245_cov_0.895349_g18607_i0 PRJEB25789 18686 245 0.895349 2.19360505 Undibacterium griseum 2762295 Bacteria Bacteria 159 3.46e-45   NR WP_186863411.1 2762295 g18607 i0 98.8 0.991836734693878 81 1 99.2 0 3 245 120 200 WP_186863411.1 ergothioneine biosynthesis protein EgtB [Undibacterium griseum] diamond 243 159 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium griseum
10226013 10226013 PRJEB25789_S_NODE_2589_length_530_cov_3.140044_g2510_i0 PRJEB25789 2589 530 3.140044 16.6422332 Undibacterium griseum 2762295 Bacteria Bacteria 258 1.92e-85   NR WP_186863170.1 2762295 g2510 i0 100 0.769811320754717 136 0 77 0 530 123 25 160 WP_186863170.1 ClpXP protease specificity-enhancing factor [Undibacterium griseum] diamond 408 258 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium griseum
11501269 11501269 PRJEB25789_S_NODE_3570_length_462_cov_1.336761_g3491_i0 PRJEB25789 3570 462 1.336761 6.17583582 Undibacterium griseum 2762295 Bacteria Bacteria 294 2.9999999999999997e-97   NR WP_186862914.1 2762295 g3491 i0 98.7 0.993506493506494 153 2 99.4 0 2 460 181 333 WP_186862914.1 ornithine cyclodeaminase [Undibacterium griseum] diamond 459 294 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium griseum
12776686 12776686 PRJEB25789_S_NODE_14791_length_263_cov_0.831579_g14712_i0 PRJEB25789 14791 263 0.831579 2.18705277 Undibacterium curvum 2762294 Bacteria Bacteria 181 4.4199999999999985e-56   NR WP_186901997.1 2762294 g14712 i0 95.3 2.95437262357414 86 4 98.1 0 2 259 70 155 WP_186901997.1 cytochrome-c oxidase, cbb3-type subunit II [Undibacterium curvum] diamond 777 181 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium curvum
14051258 14051258 PRJEB25789_S_NODE_15092_length_260_cov_2.764706_g15013_i0 PRJEB25789 15092 260 2.764706 7.1882356 Chitinibacter bivalviorum 2739434 Bacteria Bacteria 128 3.11e-32   NR WP_179356969.1 2739434 g15013 i0 69.4 2.87307692307692 85 26 98.1 0 4 258 814 898 WP_179356969.1 glycosyl hydrolase family 18 protein [Chitinibacter bivalviorum] diamond 747 128 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Chitinibacter Chitinibacter bivalviorum
23939084 23939084 PRJEB25789_S_NODE_7879_length_333_cov_2.400000_g7800_i0 PRJEB25789 7879 333 2.4 7.992 Undibacterium griseum 2762295 Bacteria Bacteria 209 1.44e-64   NR WP_186862914.1 2762295 g7800 i0 99.1 1 111 1 100 0 1 333 65 175 WP_186862914.1 ornithine cyclodeaminase [Undibacterium griseum] diamond 333 209 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium griseum
27033121 27033121 PRJEB25789_S_NODE_8002_length_332_cov_0.891892_g7923_i0 PRJEB25789 8002 332 0.891892 2.96108144 Undibacterium oligocarboniphilum 666702 Bacteria Bacteria 217 1.78e-66   NR WP_176803384.1 666702 g7923 i0 98.2 0.993975903614458 110 2 99.4 0 2 331 35 144 WP_176803384.1 hypothetical protein [Undibacterium oligocarboniphilum] diamond 330 217 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium oligocarboniphilum
27191093 27191093 PRJEB25789_S_NODE_20102_length_241_cov_0.916667_g20023_i0 PRJEB25789 20102 241 0.916667 2.20916747 Sphingomonas 13687 Bacteria Bacteria 82.8 3.96e-19   NR WP_281047999.1 13687 g20023 i0 90.5 0.522821576763486 42 4 52.3 0 211 86 1 42 WP_281047999.1 MULTISPECIES: hypothetical protein [Sphingomonas] diamond 126 82.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
27728546 27728546 PRJEB25789_S_NODE_2764_length_516_cov_4.424379_g2685_i0 PRJEB25789 2764 516 4.424379 22.82979564 Undibacterium sp. KW1 2058624 Bacteria Bacteria 322 1.61e-108   NR WP_162057812.1 2058624 g2685 i0 91.2 1.96511627906977 170 15 98.8 0 7 516 1 170 WP_162057812.1 arginase [Undibacterium sp. KW1] diamond 1014 322 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium sp. KW1
28511111 28511111 PRJEB25789_S_NODE_10467_length_300_cov_1.559471_g10388_i0 PRJEB25789 10467 300 1.559471 4.678413 Pseudomonadati 3379134 Bacteria Bacteria 113 7.96e-30   NR HHB83264.1 1871048 g10388 i0 62.9 8.57 89 33 89 0 268 2 1 89 HHB83264.1 DUF302 domain-containing protein [Devosia sp.] diamond 2571 113 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Devosiaceae Devosia Devosia sp.
28959795 28959795 PRJEB25789_S_NODE_11668_length_288_cov_1.739535_g11589_i0 PRJEB25789 11668 288 1.739535 5.0098608 Undibacterium griseum 2762295 Bacteria Bacteria 108 5.42e-27   NR WP_186862795.1 2762295 g11589 i0 100 0.572916666666667 55 0 57.3 0 287 123 168 222 WP_186862795.1 (d)CMP kinase [Undibacterium griseum] diamond 165 108 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium griseum
28959796 28959796 PRJEB25789_S_NODE_14908_length_262_cov_1.185185_g14829_i0 PRJEB25789 14908 262 1.185185 3.1051847 Undibacterium oligocarboniphilum 666702 Bacteria Bacteria 147 8.419999999999997e-42   NR WP_176804617.1 666702 g14829 i0 90.7 0.984732824427481 86 8 98.5 0 260 3 1 86 WP_176804617.1 substrate-binding periplasmic protein [Undibacterium oligocarboniphilum] diamond 258 147 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium oligocarboniphilum
29180781 29180781 PRJEB25789_S_NODE_5729_length_378_cov_1.311475_g5650_i0 PRJEB25789 5729 378 1.311475 4.9573755 Candidatus Nasuia deltocephalinicola 1301080 Bacteria Bacteria 190 4.519999999999999e-55   NR QSF25248.1 1160784 g5650 i0 75.4 1 126 29 98.4 1 1 372 413 538 QSF25248.1 chaperonin GroEL [Candidatus Nasuia deltocephalinicola] diamond 378 190 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria     Candidatus Nasuia Candidatus Nasuia deltocephalincola
29678988 29678988 PRJEB25789_S_NODE_4670_length_411_cov_1.505917_g4591_i0 PRJEB25789 4670 411 1.505917 6.18931887 Bacteria 2 Bacteria Bacteria 71.6 1.44e-11   NR WP_051377901.1 203699 g4591 i0 37.3 2.36496350364964 110 62 77.4 2 318 1 28 134 WP_051377901.1 M35 family metallo-endopeptidase [Derxia gummosa] diamond 972 71.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Alcaligenaceae Derxia Derxia gummosa
30286366 30286366 PRJEB25789_S_NODE_14972_length_261_cov_1.787234_g14893_i0 PRJEB25789 14972 261 1.787234 4.66468074 Pseudomonas sp. GW531-E2 2070679 Bacteria Bacteria 57 1.15e-8   NR WP_218277165.1 2070679 g14893 i0 62.8 0.494252873563218 43 16 49.4 0 197 69 17 59 WP_218277165.1 hypothetical protein, partial [Pseudomonas sp. GW531-E2] diamond 129 57 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. GW531-E2
30286367 30286367 PRJEB25789_S_NODE_4092_length_435_cov_1.132597_g4013_i0 PRJEB25789 4092 435 1.132597 4.92679695 Salmonella enterica 28901 Bacteria Bacteria 52.8 4.87e-6   NR WP_348246255.1 28901 g4013 i0 36.7 0.544827586206897 79 44 51.7 3 173 397 4 80 WP_348246255.1 hypothetical protein, partial [Salmonella enterica] diamond 237 52.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
31107306 31107306 PRJEB25789_S_NODE_18575_length_245_cov_0.895349_g18496_i0 PRJEB25789 18575 245 0.895349 2.19360505 Undibacterium griseum 2762295 Bacteria Bacteria 161 1.8e-49   NR WP_186861577.1 2762295 g18496 i0 100 0.991836734693878 81 0 99.2 0 244 2 16 96 WP_186861577.1 DUF2917 domain-containing protein [Undibacterium griseum] diamond 243 161 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium griseum
31613394 31613394 PRJEB25789_S_NODE_2816_length_511_cov_2.116438_g2737_i0 PRJEB25789 2816 511 2.116438 10.81499818 Chitinibacter bivalviorum 2739434 Bacteria Bacteria 259 3.08e-77   NR WP_179356969.1 2739434 g2737 i0 73.5 0.998043052837573 170 42 99.8 1 511 2 651 817 WP_179356969.1 glycosyl hydrolase family 18 protein [Chitinibacter bivalviorum] diamond 510 259 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Chitinibacter Chitinibacter bivalviorum
32372875 32372875 PRJEB25789_S_NODE_18959_length_244_cov_0.900585_g18880_i0 PRJEB25789 18959 244 0.900585 2.1974274 Undibacterium griseum 2762295 Bacteria Bacteria 86.7 4.92e-19   NR WP_186863015.1 2762295 g18880 i0 100 0.479508196721311 39 0 48 0 126 242 1 39 WP_186863015.1 YIP1 family protein [Undibacterium griseum] diamond 117 86.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium griseum
32467871 32467871 PRJEB25789_S_NODE_19519_length_242_cov_1.491124_g19440_i0 PRJEB25789 19519 242 1.491124 3.60852008 Undibacterium oligocarboniphilum 666702 Bacteria Bacteria 92.4 8.6e-22   NR WP_176802823.1 666702 g19440 i0 87.7 0.805785123966942 65 7 80.6 1 239 45 1 64 WP_176802823.1 flagellar protein FlaG [Undibacterium oligocarboniphilum] diamond 195 92.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium oligocarboniphilum
32562801 32562801 PRJEB25789_S_NODE_3099_length_490_cov_13.282974_g3020_i0 PRJEB25789 3099 490 13.282974 65.0865726 Undibacterium griseum 2762295 Bacteria Bacteria 88.6 4.89e-18   NR WP_186863723.1 2762295 g3020 i0 100 0.26326530612244903 43 0 26.3 0 47 175 201 243 WP_186863723.1 tetratricopeptide repeat protein [Undibacterium griseum] diamond 129 88.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium griseum

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