RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA827593" and tax_phylum = "Vulcanimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Vulcanimicrobiota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA827593 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
7199149 7199149 PRJNA827593_P_NODE_27246_length_399_cov_2.242331_g26947_i0 PRJNA827593 27246 399 2.242331 8.94690069 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 221 5.189999999999999e-68   NR HEV7180708.1 2952909 g26947 i0 84.1 1.98496240601504 132 21 99.2 0 398 3 17 148 HEV7180708.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Candidatus Baltobacteraceae bacterium] diamond 792 221 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
26936493 26936493 PRJNA827593_P_NODE_42142_length_312_cov_1.288703_g41843_i0 PRJNA827593 42142 312 1.288703 4.02075336 Bacteria 2 Bacteria Bacteria 117 3.79e-28   NR HTA60217.1 2952909 g41843 i0 76.9 1.875 65 15 62.5 0 311 117 459 523 HTA60217.1 glycosyltransferase family 39 protein [Candidatus Baltobacteraceae bacterium] diamond 585 117 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
27465476 27465476 PRJNA827593_P_NODE_37163_length_335_cov_0.786260_g36864_i0 PRJNA827593 37163 335 0.78626 2.633971 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 120 8.61e-33   NR HTA58393.1 2952909 g36864 i0 90.5 1.12835820895522 63 6 56.4 0 146 334 1 63 HTA58393.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] diamond 378 120 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
27844035 27844035 PRJNA827593_P_NODE_34464_length_349_cov_1.971014_g34165_i0 PRJNA827593 34464 349 1.971014 6.87883886 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 110 2.96e-25   NR HEV7180243.1 2952909 g34165 i0 49 0.893982808022923 104 53 89.4 0 1 312 211 314 HEV7180243.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] diamond 312 110 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
28665238 28665238 PRJNA827593_P_NODE_29207_length_384_cov_1.135048_g28908_i0 PRJNA827593 29207 384 1.135048 4.35858432 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 47.8 0.00105   NR HLX25567.1 2952917 g28908 i0 62.9 0.2734375 35 13 27.3 0 376 272 68 102 HLX25567.1 tetratricopeptide repeat protein [Candidatus Cybelea sp.] diamond 105 47.8 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
28886068 28886068 PRJNA827593_P_NODE_65008_length_245_cov_1.343023_g64709_i0 PRJNA827593 65008 245 1.343023 3.29040635 Candidatus Eremiobacteraceae bacterium 3069296 Bacteria Bacteria 135 4.3e-37   NR HXM15486.1 3069296 g64709 i0 87 4.71428571428571 77 10 94.3 0 232 2 1 77 HXM15486.1 flagellar motor stator protein MotA family protein [Candidatus Eremiobacteraceae bacterium] diamond 1155 135 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Candidatus Eremiobacterales Candidatus Eremiobacteraceae   Candidatus Eremiobacteraceae bacterium
29012791 29012791 PRJNA827593_P_NODE_5088_length_1005_cov_2.345494_g4850_i0 PRJNA827593 5088 1005 2.345494 23.5722147 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 72.8 2.95e-12   NR HTA58290.1 2952909 g4850 i0 84.2 0.113432835820896 38 6 11.3 0 421 308 36 73 HTA58290.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] diamond 114 72.8 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
29084316 29084316 PRJNA827593_P_NODE_18428_length_499_cov_1.084507_g18130_i0 PRJNA827593 18428 499 1.084507 5.41168993 Bacteria 2 Bacteria Bacteria 100 3.0500000000000003e-22   NR HVA27374.1 2952909 g18130 i0 58.8 1.59318637274549 97 27 57.7 2 298 11 81 165 HVA27374.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] diamond 795 100 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
29170426 29170426 PRJNA827593_P_NODE_12509_length_618_cov_1.807339_g12217_i0 PRJNA827593 12509 618 1.807339 11.16935502 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 290 1.7899999999999998e-95   NR HUC52434.1 2952917 g12217 i0 84.9 4.03398058252427 166 23 79.6 1 1 492 127 292 HUC52434.1 flagellar motor stator protein MotA [Candidatus Cybelea sp.] diamond 2493 290 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
29485830 29485830 PRJNA827593_P_NODE_45250_length_300_cov_1.017621_g44951_i0 PRJNA827593 45250 300 1.017621 3.052863 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 109 1.07e-28   NR HTU70734.1 2952909 g44951 i0 82.5 0.63 63 11 63 0 20 208 1 63 HTU70734.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] diamond 189 109 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
29485875 29485875 PRJNA827593_P_NODE_8070_length_786_cov_2.701262_g7789_i0 PRJNA827593 8070 786 2.701262 21.23191932 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 139 2.19e-38   NR HTU69645.1 2952909 g7789 i0 88.3 0.293893129770992 77 9 29.4 0 161 391 1 77 HTU69645.1 type II toxin-antitoxin system HicB family antitoxin [Candidatus Baltobacteraceae bacterium] diamond 231 139 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
30086054 30086054 PRJNA827593_P_NODE_60192_length_253_cov_1.777778_g59893_i0 PRJNA827593 60192 253 1.777778 4.49777834 Candidatus Xenobia bacterium 3036772 Bacteria Bacteria 73.2 6.3e-13   NR HEY3998473.1 3036772 g59893 i0 47.1 2.40711462450593 68 35 79.4 1 2 202 243 310 HEY3998473.1 hypothetical protein [Candidatus Xenobia bacterium] diamond 609 73.2 1 Bacteria   Bacillati Vulcanimicrobiota Candidatus Xenobia       Candidatus Xenobia bacterium
30212332 30212332 PRJNA827593_P_NODE_38592_length_327_cov_2.393701_g38293_i0 PRJNA827593 38592 327 2.393701 7.82740227 Candidatus Aquilonibacter sp. 2952903 Bacteria Bacteria 91.3 3.33e-19   NR HEY5340489.1 2952903 g38293 i0 83 1.47706422018349 53 9 48.6 0 325 167 292 344 HEY5340489.1 hypothetical protein [Candidatus Aquilonibacter sp.] diamond 483 91.3 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Aquilonibacter Candidatus Aquilonibacter sp.
30244240 30244240 PRJNA827593_P_NODE_57012_length_262_cov_1.507937_g56713_i0 PRJNA827593 57012 262 1.507937 3.95079494 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 58.9 2.16e-8   NR HEV7179904.1 2952909 g56713 i0 90 0.343511450381679 30 3 34.4 0 261 172 138 167 HEV7179904.1 3-isopropylmalate dehydratase small subunit [Candidatus Baltobacteraceae bacterium] diamond 90 58.9 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
30316427 30316427 PRJNA827593_P_NODE_49712_length_284_cov_1.417062_g49413_i0 PRJNA827593 49712 284 1.417062 4.02445608 Bacteria 2 Bacteria Bacteria 103 1.4399999999999994e-23   NR HTA59375.1 2952909 g49413 i0 80.3 2.75704225352113 61 12 64.4 0 39 221 320 380 HTA59375.1 tRNA lysidine(34) synthetase TilS [Candidatus Baltobacteraceae bacterium] diamond 783 103 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
30812754 30812754 PRJNA827593_P_NODE_3194_length_1306_cov_1.971614_g2989_i0 PRJNA827593 3194 1306 1.971614 25.74927884 Candidatus Elarobacter sp. 3047550 Bacteria Bacteria 202 1.1999999999999999e-54   NR HEV2737389.1 3047550 g2989 i0 33.5 1.87901990811639 409 230 92.8 13 90 1301 172 543 HEV2737389.1 alpha/beta hydrolase [Candidatus Elarobacter sp.] diamond 2454 202 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Elarobacter Candidatus Elarobacter sp.
31548737 31548737 PRJNA827593_P_NODE_25076_length_419_cov_1.367052_g24777_i0 PRJNA827593 25076 419 1.367052 5.72794788 Bacteria 2 Bacteria Bacteria 137 3.93e-36   NR HXC87787.1 2952917 g24777 i0 80.2 4.30310262529833 86 15 61.6 1 2 259 288 371 HXC87787.1 site-2 protease family protein [Candidatus Cybelea sp.] diamond 1803 137 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
32552564 32552564 PRJNA827593_P_NODE_44579_length_302_cov_1.960699_g44280_i0 PRJNA827593 44579 302 1.960699 5.92131098 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 126 5.08e-34   NR HTA57935.1 2952909 g44280 i0 66 0.933774834437086 94 32 93.4 0 20 301 47 140 HTA57935.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] diamond 282 126 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium

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