RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA168635 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
14393596 14393596 PRJNA168635_P_NODE_22292_length_175_cov_5.119048_g21876_i0 PRJNA168635 22292 175 5.119048 8.958334 Sulfurospirillum sp. 2053622 Bacteria Bacteria 99 1.16e-22   NR WP_333803353.1 2053622 g21876 i0 84.7 1.01142857142857 59 8 99.4 1 175 2 84 142 WP_333803353.1 OprD family outer membrane porin [Sulfurospirillum sp.] diamond 177 99 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum sp.
26693999 26693999 PRJNA168635_P_NODE_31221_length_163_cov_0.912281_g30805_i0 PRJNA168635 31221 163 0.912281 1.48701803 Desulfurellales bacterium 2482794 Bacteria Bacteria 43.9 0.00484   NR TXH52673.1 2482794 g30805 i0 50 0.883435582822086 48 24 88.3 0 158 15 351 398 TXH52673.1 MAG: DUF2793 domain-containing protein [Desulfurellales bacterium] diamond 144 43.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
26852656 26852656 PRJNA168635_P_NODE_19221_length_185_cov_1.514706_g18805_i0 PRJNA168635 19221 185 1.514706 2.8022061 Desulfurellales bacterium 2482794 Bacteria Bacteria 56.2 2.98e-7   NR TXH56868.1 2482794 g18805 i0 58 0.810810810810811 50 21 81.1 0 183 34 277 326 TXH56868.1 MAG: hypothetical protein E6Q97_05590 [Desulfurellales bacterium] diamond 150 56.2 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
27249757 27249757 PRJNA168635_P_NODE_27643_length_166_cov_2.905983_g27227_i0 PRJNA168635 27643 166 2.905983 4.82393178 Sulfurospirillum 57665 Bacteria Bacteria 70.9 3.62e-13   NR WP_039673726.1 57665 g27227 i0 92.1 1.37349397590361 38 3 68.7 0 53 166 1 38 WP_039673726.1 MULTISPECIES: response regulator transcription factor [Sulfurospirillum] diamond 228 71.6 0.990223463687151 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum  
27439660 27439660 PRJNA168635_P_NODE_26323_length_168_cov_0.873950_g25907_i0 PRJNA168635 26323 168 0.87395 1.468236 Sulfurospirillum 57665 Bacteria Bacteria 110 1.25e-26   NR WP_223809708.1 66821 g25907 i0 90.9 4.91071428571429 55 5 98.2 0 3 167 545 599 WP_223809708.1 GGDEF domain-containing protein [Sulfurospirillum multivorans] diamond 825 111 0.990990990990991 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum multivorans
27579398 27579398 PRJNA168635_P_NODE_34984_length_153_cov_2.788462_g34568_i0 PRJNA168635 34984 153 2.788462 4.26634686 Desulfurellales bacterium 2482794 Bacteria Bacteria 109 2.88e-26   NR TXH46783.1 2482794 g34568 i0 98 1 51 1 100 0 153 1 134 184 TXH46783.1 MAG: hypothetical protein E6Q97_28800 [Desulfurellales bacterium] diamond 153 109 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
28084500 28084500 PRJNA168635_P_NODE_20405_length_181_cov_1.537879_g19989_i0 PRJNA168635 20405 181 1.537879 2.78356099 Desulfurellales bacterium 2482794 Bacteria Bacteria 43.9 0.00128   NR TXH50991.1 2482794 g19989 i0 44.4 0.74585635359116 45 25 74.6 0 1 135 6 50 TXH50991.1 MAG: hypothetical protein E6Q97_19300 [Desulfurellales bacterium] diamond 135 43.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
28179072 28179072 PRJNA168635_P_NODE_20406_length_181_cov_1.530303_g19990_i0 PRJNA168635 20406 181 1.530303 2.76984843 Desulfurellales bacterium 2482794 Bacteria Bacteria 70.5 1.6e-12   NR TXH46772.1 2482794 g19990 i0 91.7 0.596685082872928 36 3 59.7 0 113 6 1 36 TXH46772.1 MAG: hypothetical protein E6Q97_28745 [Desulfurellales bacterium] diamond 108 70.5 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
28400356 28400356 PRJNA168635_P_NODE_18826_length_186_cov_3.021898_g18410_i0 PRJNA168635 18826 186 3.021898 5.62073028 Sulfurospirillum halorespirans 194424 Bacteria Bacteria 108 6.75e-29   NR WP_069477120.1 194424 g18410 i0 88.1 0.951612903225806 59 7 95.2 0 178 2 1 59 WP_069477120.1 c-type cytochrome [Sulfurospirillum halorespirans] diamond 177 108 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum halorespirans
28589962 28589962 PRJNA168635_P_NODE_34367_length_155_cov_2.518868_g33951_i0 PRJNA168635 34367 155 2.518868 3.9042454 Campylobacterota bacterium 2026809 Bacteria Bacteria 47.4 6.76e-5   NR MEA3330616.1 2026809 g33951 i0 46.7 0.870967741935484 45 22 87.1 1 135 1 28 70 MEA3330616.1 hypothetical protein [Campylobacterota bacterium] diamond 135 47.4 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28873918 28873918 PRJNA168635_P_NODE_31028_length_163_cov_0.912281_g30612_i0 PRJNA168635 31028 163 0.912281 1.48701803 Desulfurellales bacterium 2482794 Bacteria Bacteria 44.3 0.0036   NR TXH57904.1 2482794 g30612 i0 68.6 0.644171779141104 35 11 64.4 0 55 159 1 35 TXH57904.1 MAG: hypothetical protein E6Q97_03460 [Desulfurellales bacterium] diamond 105 44.3 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
28937204 28937204 PRJNA168635_P_NODE_17408_length_192_cov_1.328671_g16992_i0 PRJNA168635 17408 192 1.328671 2.55104832 Desulfurellales bacterium 2482794 Bacteria Bacteria 59.7 5.11e-10   NR TXH55990.1 2482794 g16992 i0 69.8 0.671875 43 13 67.2 0 129 1 3 45 TXH55990.1 MAG: hypothetical protein E6Q97_07495 [Desulfurellales bacterium] diamond 129 59.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29221467 29221467 PRJNA168635_P_NODE_24409_length_170_cov_3.867769_g23993_i0 PRJNA168635 24409 170 3.867769 6.5752073 Sulfurospirillum cavolei 366522 Bacteria Bacteria 50.4 2.65e-5   NR WP_060824986.1 366522 g23993 i0 76.8 0.988235294117647 56 13 98.8 0 3 170 576 631 WP_060824986.1 flagellin [Sulfurospirillum cavolei] diamond 168 50.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum cavolei
29379178 29379178 PRJNA168635_P_NODE_12609_length_229_cov_2.094444_g12193_i0 PRJNA168635 12609 229 2.094444 4.79627676 Campylobacterales bacterium 2268180 Bacteria Bacteria 49.3 7.14e-6   NR MDD3466134.1 2268180 g12193 i0 58.2 0.720524017467249 55 15 68.1 2 204 49 1 50 MDD3466134.1 hypothetical protein [Campylobacterales bacterium] diamond 165 49.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
29617629 29617629 PRJNA168635_P_NODE_33050_length_159_cov_3.381818_g32634_i0 PRJNA168635 33050 159 3.381818 5.37709062 Sulfurospirillum 57665 Bacteria Bacteria 98.6 1.1200000000000001e-22   NR WP_014768443.1 44674 g32634 i0 96.2 1.9622641509434 52 2 98.1 0 2 157 337 388 WP_014768443.1 diaminopimelate decarboxylase [Sulfurospirillum barnesii] diamond 312 98.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum barnesii
30516223 30516223 PRJNA168635_P_NODE_30153_length_164_cov_0.904348_g29737_i0 PRJNA168635 30153 164 0.904348 1.48313072 Desulfurellales bacterium 2482794 Bacteria Bacteria 108 3.9899999999999997e-28   NR TXH52637.1 2482794 g29737 i0 85.2 0.98780487804878 54 8 98.8 0 1 162 105 158 TXH52637.1 MAG: hypothetical protein E6Q97_15300 [Desulfurellales bacterium] diamond 162 108 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
30769103 30769103 PRJNA168635_P_NODE_32234_length_162_cov_0.920354_g31818_i0 PRJNA168635 32234 162 0.920354 1.49097348 Aliarcobacter sp. 2321116 Bacteria Bacteria 41.2 0.029   NR MFA7087640.1 2321116 g31818 i0 45.8 0.888888888888889 48 26 88.9 0 160 17 56 103 MFA7087640.1 hypothetical protein [Aliarcobacter sp.] diamond 144 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter sp.
30800491 30800491 PRJNA168635_P_NODE_27394_length_167_cov_0.881356_g26978_i0 PRJNA168635 27394 167 0.881356 1.47186452 Campylobacterales bacterium 2268180 Bacteria Bacteria 72 6.16e-13   NR MDD3466111.1 2268180 g26978 i0 63.8 1.04191616766467 58 18 98.8 1 165 1 195 252 MDD3466111.1 hypothetical protein [Campylobacterales bacterium] diamond 174 72 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
30990329 30990329 PRJNA168635_P_NODE_22994_length_174_cov_1.464000_g22578_i0 PRJNA168635 22994 174 1.464 2.54736 Campylobacterales bacterium 2268180 Bacteria Bacteria 84.7 3.61e-18   NR HOI83285.1 2268180 g22578 i0 79.3 1 58 12 100 0 174 1 4 61 HOI83285.1 flagellin [Campylobacterales bacterium] diamond 174 84.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
30990332 30990332 PRJNA168635_P_NODE_26374_length_168_cov_0.873950_g25958_i0 PRJNA168635 26374 168 0.87395 1.468236 Desulfurellales bacterium 2482794 Bacteria Bacteria 59.7 2.14e-9   NR TXH59333.1 2482794 g25958 i0 57.7 0.928571428571429 52 21 92.9 1 2 157 16 66 TXH59333.1 MAG: RusA family crossover junction endodeoxyribonuclease [Desulfurellales bacterium] diamond 156 59.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
31147748 31147748 PRJNA168635_P_NODE_31975_length_162_cov_0.920354_g31559_i0 PRJNA168635 31975 162 0.920354 1.49097348 Desulfurellales bacterium 2482794 Bacteria Bacteria 72.8 1.73e-13   NR TXH52971.1 2482794 g31559 i0 68 0.925925925925926 50 16 92.6 0 11 160 220 269 TXH52971.1 MAG: hypothetical protein E6Q97_14190 [Desulfurellales bacterium] diamond 150 72.8 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
31323970 31323970 PRJNA168635_P_NODE_7935_length_300_cov_2.418327_g7522_i0 PRJNA168635 7935 300 2.418327 7.254981 Pseudomonadati 3379134 Bacteria Bacteria 71.2 4.6e-12   NR MFV0481888.1 2268179 g7522 i0 38.4 3.01 99 54 99 2 298 2 99 190 MFV0481888.1 bifunctional nicotinamide-nucleotide adenylyltransferase/Nudix hydroxylase [Campylobacteraceae bacterium] diamond 903 71.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
31401317 31401317 PRJNA168635_P_NODE_23196_length_173_cov_2.693548_g22780_i0 PRJNA168635 23196 173 2.693548 4.65983804 Desulfurellales bacterium 2482794 Bacteria Bacteria 63.9 4.79e-10   NR TXH52223.1 2482794 g22780 i0 52.7 0.953757225433526 55 26 95.4 0 4 168 371 425 TXH52223.1 MAG: phage portal protein [Desulfurellales bacterium] diamond 165 63.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
31653960 31653960 PRJNA168635_P_NODE_25597_length_169_cov_0.866667_g25181_i0 PRJNA168635 25597 169 0.866667 1.46466723 Desulfurellales bacterium 2482794 Bacteria Bacteria 50.8 5.05e-6   NR TXH58565.1 2482794 g25181 i0 49.1 1.84615384615385 55 28 97.6 0 167 3 32 86 TXH58565.1 MAG: hypothetical protein E6Q97_01930 [Desulfurellales bacterium] diamond 312 50.8 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
31653964 31653964 PRJNA168635_P_NODE_34537_length_154_cov_3.828571_g34121_i0 PRJNA168635 34537 154 3.828571 5.89599934 Desulfurellales bacterium 2482794 Bacteria Bacteria 66.2 5.68e-11   NR TXH51573.1 2482794 g34121 i0 62.7 0.993506493506494 51 19 99.4 0 2 154 53 103 TXH51573.1 MAG: hypothetical protein E6Q97_18130 [Desulfurellales bacterium] diamond 153 66.2 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
32540256 32540256 PRJNA168635_P_NODE_12179_length_234_cov_0.945946_g11763_i0 PRJNA168635 12179 234 0.945946 2.21351364 Desulfurellales bacterium 2482794 Bacteria Bacteria 159 3.01e-44   NR TXH46698.1 2482794 g11763 i0 100 0.987179487179487 77 0 98.7 0 232 2 224 300 TXH46698.1 MAG: hypothetical protein E6Q97_28965 [Desulfurellales bacterium] diamond 231 159 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
32729125 32729125 PRJNA168635_P_NODE_33720_length_157_cov_2.555556_g33304_i0 PRJNA168635 33720 157 2.555556 4.01222292 Sulfuricurvum sp. PD_MW2 2027917 Bacteria Bacteria 103 2.87e-25   NR WP_294918127.1 2027917 g33304 i0 92.2 0.974522292993631 51 4 97.5 0 155 3 221 271 WP_294918127.1 MBL fold metallo-hydrolase [Sulfuricurvum sp. PD_MW2] diamond 153 103 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfuricurvum Sulfuricurvum sp. PD_MW2
32809768 32809768 PRJNA168635_P_NODE_27980_length_166_cov_0.888889_g27564_i0 PRJNA168635 27980 166 0.888889 1.47555574 Sulfurospirillum 57665 Bacteria Bacteria 112 4.42e-29   NR WP_067175891.1 1581011 g27564 i0 94.5 1.98795180722892 55 3 99.4 0 165 1 165 219 WP_067175891.1 DUF1847 domain-containing protein [Sulfurospirillum sp. UCH001] diamond 330 112 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum sp. UCH001

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