contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA716463" and tax_phylum = "Armatimonadota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 707803 | 707803 | PRJNA716463_P_NODE_35201_length_299_cov_3.668142_g34784_i0 | PRJNA716463 | 35201 | 299 | 3.668142 | 10.96774458 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 152 | 2.66e-32 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g34784 | i0 | 88.8 | 0.418060200668896 | 125 | 12 | 41 | 2 | 163 | 286 | 405687 | 405564 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 125 | 152 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 3258970 | 3258970 | PRJNA716463_P_NODE_22883_length_310_cov_3.248945_g22466_i0 | PRJNA716463 | 22883 | 310 | 3.248945 | 10.0717295 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 147 | 1.29e-30 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g22466 | i0 | 86.466 | 0.429032258064516 | 133 | 18 | 43 | 0 | 6 | 138 | 1289523 | 1289655 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 133 | 147 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 3260029 | 3260029 | PRJNA716463_P_NODE_90183_length_260_cov_2.165775_g89766_i0 | PRJNA716463 | 90183 | 260 | 2.165775 | 5.631015 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 331 | 2.72e-86 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g89766 | i0 | 89.615 | 4.51153846153846 | 260 | 27 | 100 | 0 | 1 | 260 | 2099457 | 2099198 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 1173 | 331 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 4536080 | 4536080 | PRJNA716463_P_NODE_28244_length_310_cov_2.704641_g27827_i0 | PRJNA716463 | 28244 | 310 | 2.704641 | 8.3843871 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 178 | 4.58e-40 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g27827 | i0 | 88 | 1.87096774193548 | 150 | 18 | 67 | 0 | 1 | 150 | 434484 | 434633 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 580 | 178 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 5811356 | 5811356 | PRJNA716463_P_NODE_29585_length_310_cov_2.527426_g29168_i0 | PRJNA716463 | 29585 | 310 | 2.527426 | 7.8350206 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 150 | 9.98e-32 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g29168 | i0 | 84.667 | 1.20645161290323 | 150 | 23 | 48 | 0 | 1 | 150 | 2020849 | 2020998 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 374 | 150 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 5811934 | 5811934 | PRJNA716463_P_NODE_66745_length_279_cov_1.179612_g66328_i0 | PRJNA716463 | 66745 | 279 | 1.179612 | 3.29111748 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 108 | 5.41e-19 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g66328 | i0 | 88.764 | 0.602150537634409 | 89 | 8 | 32 | 1 | 141 | 229 | 168171 | 168085 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 168 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 7087274 | 7087274 | PRJNA716463_P_NODE_8046_length_402_cov_1.671733_g7633_i0 | PRJNA716463 | 8046 | 402 | 1.671733 | 6.72036666 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 364 | 4.36e-96 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g7633 | i0 | 83.166 | 0.990049751243781 | 398 | 67 | 99 | 0 | 5 | 402 | 542844 | 542447 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 398 | 364 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 8361904 | 8361904 | PRJNA716463_P_NODE_8267_length_398_cov_2.704615_g7854_i0 | PRJNA716463 | 8267 | 398 | 2.704615 | 10.7643677 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 296 | 1.59e-75 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g7854 | i0 | 81.843 | 0.92713567839196 | 369 | 51 | 91 | 10 | 1 | 362 | 376855 | 377214 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 369 | 296 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 9636125 | 9636125 | PRJNA716463_P_NODE_22028_length_310_cov_3.371308_g21611_i0 | PRJNA716463 | 22028 | 310 | 3.371308 | 10.4510548 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 183 | 9.84e-42 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g21611 | i0 | 89.189 | 1.6193548387096799 | 148 | 15 | 47 | 1 | 1 | 147 | 1163480 | 1163627 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 502 | 183 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 10911727 | 10911727 | PRJNA716463_P_NODE_23489_length_310_cov_3.164557_g23072_i0 | PRJNA716463 | 23489 | 310 | 3.164557 | 9.8101267 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 259 | 1.5900000000000002e-64 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g23072 | i0 | 81.09 | 4.17741935483871 | 312 | 51 | 99 | 7 | 2 | 310 | 530029 | 530335 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 1295 | 259 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 10912190 | 10912190 | PRJNA716463_P_NODE_54949_length_287_cov_2.186916_g54532_i0 | PRJNA716463 | 54949 | 287 | 2.186916 | 6.27644892 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 180 | 1.17e-40 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g54532 | i0 | 83.77 | 0.665505226480836 | 191 | 29 | 66 | 2 | 10 | 199 | 2378982 | 2379171 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 191 | 180 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 12187395 | 12187395 | PRJNA716463_P_NODE_51850_length_289_cov_2.467593_g51433_i0 | PRJNA716463 | 51850 | 289 | 2.467593 | 7.13134377 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 62.1 | 4.44e-5 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g51433 | i0 | 92.857 | 0.273356401384083 | 42 | 3 | 17 | 0 | 63 | 104 | 752488 | 752447 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 79 | 62.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 13462201 | 13462201 | PRJNA716463_P_NODE_79131_length_269_cov_2.290816_g78714_i0 | PRJNA716463 | 79131 | 269 | 2.290816 | 6.16229504 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 243 | 1.36e-59 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g78714 | i0 | 83.088 | 1.78810408921933 | 272 | 40 | 100 | 6 | 1 | 269 | 851375 | 851643 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 481 | 243 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 14737877 | 14737877 | PRJNA716463_P_NODE_9992_length_370_cov_4.791246_g9578_i0 | PRJNA716463 | 9992 | 370 | 4.791246 | 17.7276102 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 285 | 3.1899999999999997e-72 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g9578 | i0 | 84.175 | 18.4945945945946 | 297 | 43 | 80 | 3 | 74 | 368 | 600363 | 600069 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 6843 | 285 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 16009796 | 16009796 | PRJNA716463_P_NODE_107673_length_245_cov_0.895349_g107255_i0 | PRJNA716463 | 107673 | 245 | 0.895349 | 2.19360505 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 309 | 1.19e-79 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g107255 | i0 | 89.388 | 1.57551020408163 | 245 | 26 | 100 | 0 | 1 | 245 | 375964 | 376208 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 386 | 309 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 17286086 | 17286086 | PRJNA716463_P_NODE_48414_length_291_cov_4.922018_g47997_i0 | PRJNA716463 | 48414 | 291 | 4.922018 | 14.32307238 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 172 | 1.98e-38 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g47997 | i0 | 87.333 | 0.515463917525773 | 150 | 19 | 52 | 0 | 1 | 150 | 1003270 | 1003121 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 150 | 172 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 17286113 | 17286113 | PRJNA716463_P_NODE_50594_length_290_cov_1.921659_g50177_i0 | PRJNA716463 | 50594 | 290 | 1.921659 | 5.5728111 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 239 | 1.92e-58 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g50177 | i0 | 90.96 | 0.610344827586207 | 177 | 16 | 61 | 0 | 96 | 272 | 706701 | 706525 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 177 | 239 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 17286870 | 17286870 | PRJNA716463_P_NODE_98574_length_252_cov_3.201117_g98157_i0 | PRJNA716463 | 98574 | 252 | 3.201117 | 8.06681484 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 167 | 7.819999999999999e-37 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g98157 | i0 | 78.74 | 1.00793650793651 | 254 | 50 | 100 | 4 | 1 | 252 | 1500437 | 1500186 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 254 | 167 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 18559619 | 18559619 | PRJNA716463_P_NODE_30375_length_309_cov_5.381356_g29958_i0 | PRJNA716463 | 30375 | 309 | 5.381356 | 16.62839004 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 196 | 1.26e-45 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g29958 | i0 | 80.147 | 0.880258899676375 | 272 | 43 | 87 | 4 | 39 | 308 | 1044815 | 1044553 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 272 | 196 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 19834135 | 19834135 | PRJNA716463_P_NODE_107836_length_244_cov_4.321637_g107418_i0 | PRJNA716463 | 107836 | 244 | 4.321637 | 10.54479428 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 235 | 2.0399999999999997e-57 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g107418 | i0 | 84.082 | 1.00409836065574 | 245 | 37 | 100 | 2 | 1 | 244 | 143504 | 143261 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 245 | 235 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 22385587 | 22385587 | PRJNA716463_P_NODE_54198_length_288_cov_1.097674_g53781_i0 | PRJNA716463 | 54198 | 288 | 1.097674 | 3.16130112 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 289 | 1.87e-73 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g53781 | i0 | 84.722 | 138.388888888889 | 288 | 44 | 100 | 0 | 1 | 288 | 2462895 | 2463182 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 39856 | 289 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 22386210 | 22386210 | PRJNA716463_P_NODE_94238_length_256_cov_3.590164_g93821_i0 | PRJNA716463 | 94238 | 256 | 3.590164 | 9.19081984 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 291 | 4.529999999999999e-74 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g93821 | i0 | 87.109 | 1 | 256 | 33 | 100 | 0 | 1 | 256 | 530641 | 530386 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 256 | 291 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 23661688 | 23661688 | PRJNA716463_P_NODE_86939_length_263_cov_1.621053_g86522_i0 | PRJNA716463 | 86939 | 263 | 1.621053 | 4.26336939 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 224 | 4.809999999999999e-54 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g86522 | i0 | 82.692 | 1.16349809885932 | 260 | 38 | 98 | 6 | 6 | 263 | 1248550 | 1248296 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 306 | 224 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 24933780 | 24933780 | PRJNA716463_P_NODE_108800_length_244_cov_0.900585_g108382_i0 | PRJNA716463 | 108800 | 244 | 0.900585 | 2.1974274 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 412 | 8.759999999999998e-111 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g108382 | i0 | 97.131 | 2 | 244 | 7 | 100 | 0 | 1 | 244 | 1424147 | 1424390 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 488 | 412 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 24933922 | 24933922 | PRJNA716463_P_NODE_118520_length_231_cov_2.575949_g118102_i0 | PRJNA716463 | 118520 | 231 | 2.575949 | 5.95044219 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 213 | 8.95e-51 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g118102 | i0 | 83.406 | 0.991341991341991 | 229 | 38 | 99 | 0 | 3 | 231 | 2815846 | 2816074 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 229 | 213 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;