RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA556992 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
20934767 20934767 PRJNA556992_P_NODE_764857_length_248_cov_0.880000_g762668_i0 PRJNA556992 764857 248 0.88 2.1824 Aminivibrio sp. 1872489 Bacteria Bacteria 136 2.48e-36   NR WP_367338016.1 1872489 g762668 i0 80.5 0.991935483870968 82 16 99.2 0 246 1 33 114 WP_367338016.1 M20 metallopeptidase family protein [Aminivibrio sp.] diamond 246 136 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminivibrio Aminivibrio sp.
27552101 27552101 PRJNA556992_P_NODE_194004_length_330_cov_3.867704_g191816_i0 PRJNA556992 194004 330 3.867704 12.7634232 Pyramidobacter sp. C12-8 1943580 Bacteria Bacteria 139 8.96e-41   NR WP_168170145.1 1943580 g191816 i0 91.3 0.727272727272727 80 7 72.7 0 254 15 1 80 WP_168170145.1 hypothetical protein, partial [Pyramidobacter sp. C12-8] diamond 240 139 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter sp. C12-8
27756570 27756570 PRJNA556992_P_NODE_901564_length_240_cov_6.976048_g899374_i0 PRJNA556992 901564 240 6.976048 16.7425152 Fretibacterium 1434006 Bacteria Bacteria 119 4.17e-31   NR WP_124887097.1 2491047 g899374 i0 74.7 2.925 79 20 98.8 0 3 239 67 145 WP_124887097.1 aminotransferase class IV [Fretibacterium sp. OH1220_COT-178] diamond 702 119 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium sp. OH1220_COT-178
28120942 28120942 PRJNA556992_P_NODE_733045_length_249_cov_3.017045_g730856_i0 PRJNA556992 733045 249 3.017045 7.51244205 Synergistaceae bacterium 2053624 Bacteria Bacteria 47.8 6.78e-4   NR MFA7221055.1 2053624 g730856 i0 36.8 1.53012048192771 76 35 75.9 2 232 44 11 86 MFA7221055.1 HD domain-containing protein [Synergistaceae bacterium] diamond 381 47.8 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
28562693 28562693 PRJNA556992_P_NODE_1055347_length_223_cov_6.433333_g1053157_i0 PRJNA556992 1055347 223 6.433333 14.34633259 Dethiosulfovibrio sp. 2944751 Bacteria Bacteria 51.6 1.44e-5   NR MDD4837027.1 2944751 g1053157 i0 58.5 0.551569506726457 41 17 55.2 0 101 223 7 47 MDD4837027.1 ABC transporter permease [Dethiosulfovibrio sp.] diamond 123 51.6 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Dethiosulfovibrio Dethiosulfovibrio sp.
29036875 29036875 PRJNA556992_P_NODE_819968_length_245_cov_0.895349_g817778_i0 PRJNA556992 819968 245 0.895349 2.19360505 Synergistaceae bacterium 2053624 Bacteria Bacteria 49.3 3.13e-5   NR MBQ7262096.1 2053624 g817778 i0 43.8 1.56734693877551 64 33 78.4 2 204 13 8 68 MBQ7262096.1 MobB mobilization protein [Synergistaceae bacterium] diamond 384 49.3 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
29067921 29067921 PRJNA556992_P_NODE_1059468_length_222_cov_6.355705_g1057278_i0 PRJNA556992 1059468 222 6.355705 14.1096651 Aminobacterium 81466 Bacteria Bacteria 46.2 0.00115   NR WP_286952878.1 81466 g1057278 i0 33.3 0.972972972972973 72 46 94.6 2 221 12 49 120 WP_286952878.1 MULTISPECIES: hypothetical protein [Aminobacterium] diamond 216 46.2 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminobacterium  
29099481 29099481 PRJNA556992_P_NODE_1124088_length_207_cov_5.432836_g1121897_i0 PRJNA556992 1124088 207 5.432836 11.24597052 Jonquetella anthropi 428712 Bacteria Bacteria 141 1.77e-40   NR WP_276956555.1 428712 g1121897 i0 100 1 69 0 100 0 207 1 89 157 WP_276956555.1 ComF family protein [Jonquetella anthropi] diamond 207 141 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Jonquetella Jonquetella anthropi
29952372 29952372 PRJNA556992_P_NODE_836511_length_244_cov_1.444444_g834321_i0 PRJNA556992 836511 244 1.444444 3.52444336 Synergistetes bacterium ADurb.BinA166 1852916 Bacteria Bacteria 61.6 8.3e-10   NR OPZ35531.1 1852916 g834321 i0 55.9 0.725409836065574 59 22 71.3 2 59 232 39 94 OPZ35531.1 MAG: CTP pyrophosphohydrolase [Synergistetes bacterium ADurb.BinA166] diamond 177 61.6 1 Bacteria   Thermotogati Synergistota         Synergistetes bacterium ADurb.BinA166
30584088 30584088 PRJNA556992_P_NODE_871213_length_242_cov_2.147929_g869023_i0 PRJNA556992 871213 242 2.147929 5.19798818 Aminiphilus circumscriptus 290732 Bacteria Bacteria 128 3.1699999999999993e-34   NR WP_157367220.1 290732 g869023 i0 78.8 1.98347107438017 80 17 99.2 0 241 2 154 233 WP_157367220.1 hypothetical protein [Aminiphilus circumscriptus] diamond 480 128 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminiphilaceae Aminiphilus Aminiphilus circumscriptus
30868267 30868267 PRJNA556992_P_NODE_341854_length_283_cov_1.747619_g339665_i0 PRJNA556992 341854 283 1.747619 4.94576177 Thermanaerovibrio acidaminovorans 81462 Bacteria Bacteria 97.4 2.2099999999999994e-23   NR WP_333645022.1 81462 g339665 i0 59 0.826855123674912 78 31 81.6 1 53 283 1 78 WP_333645022.1 hypothetical protein [Thermanaerovibrio acidaminovorans] diamond 234 97.4 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Thermanaerovibrio Thermanaerovibrio acidaminovorans
31911983 31911983 PRJNA556992_P_NODE_67137_length_460_cov_6.855297_g64964_i0 PRJNA556992 67137 460 6.855297 31.5343662 Dethiosulfovibrio salsuginis 561720 Bacteria Bacteria 186 7.419999999999999e-57   NR WP_085545710.1 561720 g64964 i0 65.4 0.997826086956522 153 53 99.8 0 459 1 2 154 WP_085545710.1 terminase small subunit [Dethiosulfovibrio salsuginis] diamond 459 186 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Dethiosulfovibrio Dethiosulfovibrio salsuginis
32038273 32038273 PRJNA556992_P_NODE_1153698_length_200_cov_10.889764_g1151507_i0 PRJNA556992 1153698 200 10.889764 21.779528 Jonquetella 428711 Bacteria Bacteria 130 2.04e-33   NR WP_008522452.1 428711 g1151507 i0 100 0.99 66 0 99 0 199 2 408 473 WP_008522452.1 MULTISPECIES: excinuclease ABC subunit A [Jonquetella] diamond 198 130 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Jonquetella  
32228555 32228555 PRJNA556992_P_NODE_689618_length_251_cov_18.393258_g687429_i0 PRJNA556992 689618 251 18.393258 46.16707758 Jonquetella anthropi 428712 Bacteria Bacteria 169 3.8e-49   NR WP_008522558.1 428712 g687429 i0 100 0.99203187250996006 83 0 99.2 0 249 1 113 195 WP_008522558.1 ATP synthase F1 subunit alpha [Jonquetella anthropi] diamond 249 169 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Jonquetella Jonquetella anthropi
32323534 32323534 PRJNA556992_P_NODE_454419_length_271_cov_2.409091_g452230_i0 PRJNA556992 454419 271 2.409091 6.52863661 Synergistaceae bacterium 2053624 Bacteria Bacteria 44.7 0.00133   NR MBQ4402001.1 2053624 g452230 i0 35.3 0.752767527675277 68 38 73.1 2 259 62 6 69 MBQ4402001.1 AmmeMemoRadiSam system radical SAM enzyme [Synergistaceae bacterium] diamond 204 44.7 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae 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);;