contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4730583 | 4730583 | PRJNA928559_P_NODE_117564_length_328_cov_6.160784_g115995_i0 | PRJNA928559 | 117564 | 328 | 6.160784 | 20.20737152 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 111 | 5.02e-20 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g115995 | i0 | 93.421 | 28.2378048780488 | 76 | 3 | 23 | 1 | 253 | 328 | 774545 | 774618 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 9262 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 6005311 | 6005311 | PRJNA928559_P_NODE_117405_length_329_cov_1.335938_g115836_i0 | PRJNA928559 | 117405 | 329 | 1.335938 | 4.39523602 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 182 | 3.78e-41 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g115836 | i0 | 81.532 | 0.674772036474164 | 222 | 40 | 67 | 1 | 1 | 222 | 70248 | 70028 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 222 | 182 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 6006217 | 6006217 | PRJNA928559_P_NODE_17645_length_748_cov_7.417778_g16219_i0 | PRJNA928559 | 17645 | 748 | 7.417778 | 55.48497944 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 298 | 8.72e-76 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g16219 | i0 | 82.319 | 1.4024064171123 | 345 | 59 | 46 | 2 | 9 | 352 | 989554 | 989897 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 1049 | 298 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 8556138 | 8556138 | PRJNA928559_P_NODE_198267_length_248_cov_9.348571_g196698_i0 | PRJNA928559 | 198267 | 248 | 9.348571 | 23.18445608 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 167 | 7.679999999999999e-37 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g196698 | i0 | 86.275 | 2.65322580645161 | 153 | 21 | 62 | 0 | 77 | 229 | 995558 | 995406 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 658 | 167 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 9830926 | 9830926 | PRJNA928559_P_NODE_185868_length_254_cov_1.723757_g184299_i0 | PRJNA928559 | 185868 | 254 | 1.723757 | 4.37834278 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 207 | 4.6500000000000004e-49 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g184299 | i0 | 84.018 | 78.492125984252 | 219 | 32 | 85 | 1 | 37 | 252 | 776530 | 776312 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 19937 | 207 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 12382029 | 12382029 | PRJNA928559_P_NODE_169490_length_268_cov_2.676923_g167921_i0 | PRJNA928559 | 169490 | 268 | 2.676923 | 7.17415364 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 313 | 1.02e-80 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g167921 | i0 | 87.732 | 74.4776119402985 | 269 | 31 | 100 | 2 | 1 | 268 | 1146953 | 1147220 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 19960 | 313 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 12383570 | 12383570 | PRJNA928559_P_NODE_77330_length_402_cov_3.382979_g75761_i0 | PRJNA928559 | 77330 | 402 | 3.382979 | 13.59957558 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 217 | 1.29e-51 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g75761 | i0 | 85.507 | 0.514925373134328 | 207 | 30 | 51 | 0 | 54 | 260 | 240119 | 239913 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 207 | 217 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 13656152 | 13656152 | PRJNA928559_P_NODE_138571_length_300_cov_18.013216_g137002_i0 | PRJNA928559 | 138571 | 300 | 18.013216 | 54.039648 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 196 | 1.22e-45 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g137002 | i0 | 79.139 | 1.00666666666667 | 302 | 49 | 97 | 9 | 1 | 290 | 33763 | 33464 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 302 | 196 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 14931679 | 14931679 | PRJNA928559_P_NODE_226892_length_204_cov_5.122137_g225323_i0 | PRJNA928559 | 226892 | 204 | 5.122137 | 10.44915948 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 93.5 | 1.05e-14 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g225323 | i0 | 83.333 | 0.5 | 102 | 15 | 50 | 2 | 36 | 136 | 93295 | 93195 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 102 | 93.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 17480166 | 17480166 | PRJNA928559_P_NODE_111634_length_337_cov_4.863636_g110065_i0 | PRJNA928559 | 111634 | 337 | 4.863636 | 16.39045332 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 374 | 5.979999999999998e-99 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g110065 | i0 | 87.385 | 12.6409495548961 | 325 | 41 | 96 | 0 | 13 | 337 | 1127782 | 1127458 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 4260 | 374 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 17480686 | 17480686 | PRJNA928559_P_NODE_147774_length_290_cov_1.732719_g146205_i0 | PRJNA928559 | 147774 | 290 | 1.732719 | 5.0248851 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 228 | 4.1599999999999985e-55 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g146205 | i0 | 81.685 | 0.941379310344828 | 273 | 50 | 94 | 0 | 18 | 290 | 759672 | 759400 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 273 | 228 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 17482138 | 17482138 | PRJNA928559_P_NODE_38354_length_538_cov_9.148387_g36800_i0 | PRJNA928559 | 38354 | 538 | 9.148387 | 49.21832206 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 407 | 9.79e-109 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g36800 | i0 | 82.672 | 9.48327137546468 | 479 | 63 | 87 | 15 | 70 | 538 | 89691 | 89223 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 5102 | 407 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 18754574 | 18754574 | PRJNA928559_P_NODE_17975_length_742_cov_9.997010_g16538_i0 | PRJNA928559 | 17975 | 742 | 9.99701 | 74.1778142 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 374 | 1.3999999999999998e-98 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g16538 | i0 | 77.444 | 1.75202156334232 | 665 | 124 | 87 | 24 | 31 | 679 | 997517 | 998171 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 1300 | 374 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 18755572 | 18755572 | PRJNA928559_P_NODE_42195_length_518_cov_5.519101_g40638_i0 | PRJNA928559 | 42195 | 518 | 5.519101 | 28.58894318 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 412 | 2.0199999999999994e-110 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g40638 | i0 | 81.409 | 6.78185328185328 | 511 | 89 | 98 | 5 | 2 | 509 | 889872 | 889365 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 3513 | 412 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 20030717 | 20030717 | PRJNA928559_P_NODE_5216_length_1305_cov_28.816558_g4381_i0 | PRJNA928559 | 5216 | 1305 | 28.816558 | 376.0560819 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 388 | 8.96e-103 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g4381 | i0 | 76.22 | 1.52413793103448 | 799 | 153 | 61 | 28 | 346 | 1139 | 862608 | 863374 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 1989 | 388 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 22580345 | 22580345 | PRJNA928559_P_NODE_189898_length_252_cov_1.307263_g188329_i0 | PRJNA928559 | 189898 | 252 | 1.307263 | 3.29430276 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 187 | 6e-43 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g188329 | i0 | 81.696 | 26.7142857142857 | 224 | 41 | 89 | 0 | 2 | 225 | 1254783 | 1255006 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 6732 | 187 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 25128836 | 25128836 | PRJNA928559_P_NODE_160420_length_277_cov_1.534314_g158851_i0 | PRJNA928559 | 160420 | 277 | 1.534314 | 4.25004978 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 206 | 1.85e-48 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g158851 | i0 | 82.979 | 2.65342960288809 | 235 | 32 | 83 | 6 | 47 | 277 | 89692 | 89462 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 735 | 206 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 |
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);;