RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA854078" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA854078 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
25067772 25067772 PRJNA854078_P_NODE_14040_length_251_cov_0.921348_g13828_i0 PRJNA854078 14040 251 0.921348 2.31258348 Winogradskyella eximia 262006 Bacteria Bacteria 73.9 5.58e-15   NR WP_115817787.1 262006 g13828 i0 41.6 3.70517928286853 77 44 92 1 20 250 5 80 WP_115817787.1 thioredoxin [Winogradskyella eximia] diamond 930 73.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Winogradskyella Winogradskyella eximia
27181299 27181299 PRJNA854078_P_NODE_322_length_1612_cov_6.115660_g251_i0 PRJNA854078 322 1612 6.11566 98.5844392 Emticicia sp. 17c 3127704 Bacteria Bacteria 388 5.17e-122   NR WP_337045214.1 3127704 g251 i0 53.5 0.660669975186104 355 157 65 4 22 1068 27 379 WP_337045214.1 hypothetical protein [Emticicia sp. 17c] diamond 1065 388 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Leadbetterellaceae Emticicia Emticicia sp. 17c
27727068 27727068 PRJNA854078_P_NODE_6444_length_371_cov_2.080537_g6232_i0 PRJNA854078 6444 371 2.080537 7.71879227 Bacteria 2 Bacteria Bacteria 55.8 4.15e-6   NR MES2811807.1 1898104 g6232 i0 41.6 3.41239892183288 101 54 78.4 3 305 15 329 428 MES2811807.1 endonuclease [Bacteroidota bacterium] diamond 1266 56.2 0.99288256227758 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28034333 28034333 PRJNA854078_P_NODE_12125_length_270_cov_2.106599_g11913_i0 PRJNA854078 12125 270 2.106599 5.6878173 Saprospiraceae bacterium 2202734 Bacteria Bacteria 53.1 1.14e-5   NR MBL0293990.1 2202734 g11913 i0 40.8 1.74444444444444 76 40 82.2 2 235 14 1158 1230 MBL0293990.1 fibronectin type III domain-containing protein [Saprospiraceae bacterium] diamond 471 53.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
28507863 28507863 PRJNA854078_P_NODE_5567_length_401_cov_1.426829_g5355_i0 PRJNA854078 5567 401 1.426829 5.72158429 Bacteroidales bacterium 2030927 Bacteria Bacteria 58.5 6.8e-7   NR MBQ4442661.1 2030927 g5355 i0 32.8 2.00498753117207 134 80 95.8 2 10 393 1607 1736 MBQ4442661.1 fibronectin type III domain-containing protein [Bacteroidales bacterium] diamond 804 58.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
28728856 28728856 PRJNA854078_P_NODE_307_length_1642_cov_3.745061_g241_i0 PRJNA854078 307 1642 3.745061 61.49390162 Emticicia sp. 17c 3127704 Bacteria Bacteria 394 2.09e-124   NR WP_337045214.1 3127704 g241 i0 55.9 1.52740560292326 345 144 61.9 4 1640 624 37 379 WP_337045214.1 hypothetical protein [Emticicia sp. 17c] diamond 2508 394 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Leadbetterellaceae Emticicia Emticicia sp. 17c
28950049 28950049 PRJNA854078_P_NODE_4608_length_442_cov_2.959350_g4396_i0 PRJNA854078 4608 442 2.95935 13.080327 Bacteroidota bacterium 1898104 Bacteria Bacteria 50.4 6.26e-4   NR GDX51860.1 1898104 g4396 i0 27 0.855203619909502 126 78 76 4 338 3 996 1121 GDX51860.1 hypothetical protein LBMAG27_09070 [Bacteroidota bacterium] diamond 378 50.4 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28981608 28981608 PRJNA854078_P_NODE_368_length_1512_cov_2.676859_g282_i0 PRJNA854078 368 1512 2.676859 40.47410808 Emticicia sp. 17c 3127704 Bacteria Bacteria 354 1.31e-109   NR WP_337045214.1 3127704 g282 i0 51 3.55952380952381 357 167 69.6 4 19 1071 27 381 WP_337045214.1 hypothetical protein [Emticicia sp. 17c] diamond 5382 354 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Leadbetterellaceae Emticicia Emticicia sp. 17c
29013289 29013289 PRJNA854078_P_NODE_2628_length_588_cov_2.638835_g2422_i0 PRJNA854078 2628 588 2.638835 15.5163498 Bacteroidales bacterium 2030927 Bacteria Bacteria 59.3 1.95e-6   NR MDF1546861.1 2030927 g2422 i0 37.4 1.41836734693878 155 89 77 5 43 495 766 916 MDF1546861.1 M4 family metallopeptidase [Bacteroidales bacterium] diamond 834 59.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
29454634 29454634 PRJNA854078_P_NODE_4390_length_453_cov_2.234211_g4178_i0 PRJNA854078 4390 453 2.234211 10.12097583 Bacteroidota bacterium 1898104 Bacteria Bacteria 48.5 0.00191   NR HRS02609.1 1898104 g4178 i0 36.7 0.52317880794702 79 49 51.7 1 236 3 100 178 HRS02609.1 fibronectin type III domain-containing protein [Bacteroidota bacterium] diamond 237 48.5 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29897200 29897200 PRJNA854078_P_NODE_4271_length_459_cov_4.766839_g4059_i0 PRJNA854078 4271 459 4.766839 21.87979101 Chryseobacterium gambrini 373672 Bacteria Bacteria 50.8 5.21e-4   NR WP_084196507.1 373672 g4059 i0 34.5 0.928104575163399 142 87 90.8 4 459 43 291 429 WP_084196507.1 endonuclease [Chryseobacterium gambrini] diamond 426 50.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium gambrini
29897201 29897201 PRJNA854078_P_NODE_651_length_1181_cov_2.787004_g523_i0 PRJNA854078 651 1181 2.787004 32.91451724 Fibrella sp. WM1 3242485 Bacteria Bacteria 231 1.93e-65   NR WP_370701424.1 3242485 g523 i0 41.7 0.906858594411516 357 185 85.6 7 4 1014 200 553 WP_370701424.1 hypothetical protein [Fibrella sp. WM1] diamond 1071 231 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Fibrella Fibrella musci
29936938 29936938 PRJNA854078_P_NODE_7271_length_349_cov_2.369565_g7059_i0 PRJNA854078 7271 349 2.369565 8.26978185 Polaribacter 52959 Bacteria Bacteria 56.6 1.72e-6   NR WP_068364217.1 996801 g7059 i0 35.6 1.71919770773639 90 53 73.9 3 70 327 316 404 WP_068364217.1 endonuclease [Polaribacter reichenbachii] diamond 600 56.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Polaribacter Polaribacter reichenbachii
31128951 31128951 PRJNA854078_P_NODE_6315_length_375_cov_1.715232_g6103_i0 PRJNA854078 6315 375 1.715232 6.43212 Winogradskyella sp. PE311 3366943 Bacteria Bacteria 47 0.00442   NR WP_411125040.1 3366943 g6103 i0 34.9 0.664 83 51 64 2 366 127 41 123 WP_411125040.1 hypothetical protein [Winogradskyella sp. PE311] diamond 249 47 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Winogradskyella Winogradskyella sp. PE311
31508928 31508928 PRJNA854078_P_NODE_3216_length_529_cov_104.701754_g3004_i0 PRJNA854078 3216 529 104.701754 553.87227866 Flavobacteriales bacterium 2021391 Bacteria Bacteria 54.3 5.68e-5   NR PIE50853.1 2021391 g3004 i0 38.7 0.958412098298677 75 42 40.3 1 351 139 293 367 PIE50853.1 MAG: endonuclease I [Flavobacteriales bacterium] diamond 507 54.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales bacterium
31833087 31833087 PRJNA854078_P_NODE_377_length_1492_cov_8.241015_g289_i0 PRJNA854078 377 1492 8.241015 122.9559438 Bacteroidota 976 Bacteria Bacteria 417 1.0599999999999999e-136   NR WP_052598397.1 1313421 g289 i0 44.2 3.85053619302949 525 227 97.1 10 1450 2 19 519 WP_052598397.1 glycosyl hydrolase family 18 protein [Aureispira sp. CCB-QB1] diamond 5745 418 0.997607655502392 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae Aureispira Aureispira sp. CCB-QB1
32458027 32458027 PRJNA854078_P_NODE_239_length_1877_cov_4.303215_g187_i0 PRJNA854078 239 1877 4.303215 80.77134555 Flammeovirga sp. EKP2 1978526 Bacteria Bacteria 107 4.96e-20   NR WP_188171209.1 2770592 g187 i0 29.8 0.847096430474161 530 320 82.6 22 95 1645 738 1228 WP_188171209.1 fibronectin type III domain-containing protein [Flammeovirga sp. EKP202] diamond 1590 107 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flammeovirgaceae Flammeovirga Flammeovirga sp. EKP202
32529547 32529547 PRJNA854078_P_NODE_3179_length_533_cov_0.995652_g2967_i0 PRJNA854078 3179 533 0.995652 5.30682516 Alistipes 239759 Bacteria Bacteria 163 5.52e-44   NR MBP3482326.1 1872444 g2967 i0 51.4 11.8480300187617 175 79 96.2 3 523 11 91 263 MBP3482326.1 C69 family dipeptidase [Alistipes sp.] diamond 6315 164 0.99390243902439 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Rikenellaceae Alistipes Alistipes sp.
32907282 32907282 PRJNA854078_P_NODE_9120_length_312_cov_1.158996_g8908_i0 PRJNA854078 9120 312 1.158996 3.61606752 Bacteria 2 Bacteria Bacteria 121 4.6399999999999994e-30   NR WP_185877965.1 1653831 g8908 i0 56.3 13.4519230769231 103 45 99 0 311 3 149 251 WP_185877965.1 class II fumarate hydratase [Blattabacterium cuenoti] diamond 4197 121 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Blattabacteriaceae Blattabacterium Blattabacterium cuenoti

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