contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax_phylum = "Candidatus Absconditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26952103 | 26952103 | PRJNA557436_S_NODE_8922_length_153_cov_1.186441_g8874_i0 | PRJNA557436 | 8922 | 153 | 1.186441 | 1.81525473 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 46.6 | 1.54e-4 | NR | HNG96751.1 | 2927939 | g8874 | i0 | 80.8 | 0.509803921568627 | 26 | 5 | 51 | 0 | 34 | 111 | 83 | 108 | HNG96751.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 78 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 27173442 | 27173442 | PRJNA557436_S_NODE_4782_length_187_cov_1.381579_g4734_i0 | PRJNA557436 | 4782 | 187 | 1.381579 | 2.58355273 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 105 | 1.5500000000000002e-26 | NR | HNG96690.1 | 2927939 | g4734 | i0 | 90.2 | 0.978609625668449 | 61 | 6 | 97.9 | 0 | 3 | 185 | 100 | 160 | HNG96690.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 183 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 27899901 | 27899901 | PRJNA557436_S_NODE_7225_length_163_cov_0.984375_g7177_i0 | PRJNA557436 | 7225 | 163 | 0.984375 | 1.60453125 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 105 | 6.8e-25 | NR | HNG96687.1 | 2927939 | g7177 | i0 | 94.1 | 0.938650306748466 | 51 | 3 | 93.9 | 0 | 161 | 9 | 523 | 573 | HNG96687.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 153 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 27963234 | 27963234 | PRJNA557436_S_NODE_8905_length_153_cov_1.254237_g8857_i0 | PRJNA557436 | 8905 | 153 | 1.254237 | 1.91898261 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 43.1 | 8.35e-4 | NR | HNG96874.1 | 2927939 | g8857 | i0 | 62.1 | 0.568627450980392 | 29 | 11 | 56.9 | 0 | 89 | 3 | 5 | 33 | HNG96874.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 87 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 28026477 | 28026477 | PRJNA557436_S_NODE_3425_length_212_cov_1.112994_g3377_i0 | PRJNA557436 | 3425 | 212 | 1.112994 | 2.35954728 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 101 | 1.23e-24 | NR | HNG96692.1 | 2927939 | g3377 | i0 | 92.5 | 0.75 | 53 | 4 | 75 | 0 | 43 | 201 | 42 | 94 | HNG96692.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 159 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 28310663 | 28310663 | PRJNA557436_S_NODE_8586_length_154_cov_2.042017_g8538_i0 | PRJNA557436 | 8586 | 154 | 2.042017 | 3.14470618 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 50.8 | 1.5e-5 | NR | HNG96691.1 | 2927939 | g8538 | i0 | 82.1 | 0.545454545454545 | 28 | 5 | 54.5 | 0 | 19 | 102 | 285 | 312 | HNG96691.1 N4-gp56 family major capsid protein [Candidatus Absconditabacterales bacterium] | diamond | 84 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 29573326 | 29573326 | PRJNA557436_S_NODE_4130_length_197_cov_2.259259_g4082_i0 | PRJNA557436 | 4130 | 197 | 2.259259 | 4.45074023 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 70.9 | 1.79e-13 | NR | HNG97152.1 | 2927939 | g4082 | i0 | 55.4 | 0.989847715736041 | 65 | 29 | 99 | 0 | 1 | 195 | 47 | 111 | HNG97152.1 phage holin family protein [Candidatus Absconditabacterales bacterium] | diamond | 195 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 29825961 | 29825961 | PRJNA557436_S_NODE_6371_length_169_cov_2.141791_g6323_i0 | PRJNA557436 | 6371 | 169 | 2.141791 | 3.61962679 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 46.6 | 6.08e-4 | NR | HNG96687.1 | 2927939 | g6323 | i0 | 95.8 | 0.42603550295858 | 24 | 1 | 42.6 | 0 | 34 | 105 | 610 | 633 | HNG96687.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 72 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 31311064 | 31311064 | PRJNA557436_S_NODE_4635_length_189_cov_1.324675_g4587_i0 | PRJNA557436 | 4635 | 189 | 1.324675 | 2.50363575 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 84.7 | 2.86e-17 | NR | HNG97011.1 | 2927939 | g4587 | i0 | 78.8 | 0.825396825396825 | 52 | 11 | 82.5 | 0 | 164 | 9 | 477 | 528 | HNG97011.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 156 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 31406206 | 31406206 | PRJNA557436_S_NODE_8856_length_153_cov_1.500000_g8808_i0 | PRJNA557436 | 8856 | 153 | 1.5 | 2.295 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 59.7 | 1.1e-8 | NR | HNG96693.1 | 2927939 | g8808 | i0 | 100 | 0.549019607843137 | 28 | 0 | 54.9 | 0 | 3 | 86 | 467 | 494 | HNG96693.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 84 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 31469487 | 31469487 | PRJNA557436_S_NODE_5116_length_183_cov_1.486486_g5068_i0 | PRJNA557436 | 5116 | 183 | 1.486486 | 2.72026938 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 106 | 3.25e-25 | NR | HNG97205.1 | 2927939 | g5068 | i0 | 86.7 | 0.983606557377049 | 60 | 8 | 98.4 | 0 | 181 | 2 | 116 | 175 | HNG97205.1 phage terminase large subunit [Candidatus Absconditabacterales bacterium] | diamond | 180 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 32292216 | 32292216 | PRJNA557436_S_NODE_2899_length_226_cov_1.172775_g2851_i0 | PRJNA557436 | 2899 | 226 | 1.172775 | 2.6504715 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 51.2 | 3.08e-5 | NR | HNG97011.1 | 2927939 | g2851 | i0 | 88 | 0.331858407079646 | 25 | 3 | 33.2 | 0 | 76 | 2 | 569 | 593 | HNG97011.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 75 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 32513634 | 32513634 | PRJNA557436_S_NODE_8199_length_156_cov_2.115702_g8151_i0 | PRJNA557436 | 8199 | 156 | 2.115702 | 3.30049512 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 60.5 | 6.46e-9 | NR | HNG97011.1 | 2927939 | g8151 | i0 | 78.6 | 0.807692307692308 | 42 | 9 | 80.8 | 0 | 1 | 126 | 88 | 129 | HNG97011.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 126 | 60.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 32576730 | 32576730 | PRJNA557436_S_NODE_9079_length_152_cov_1.547009_g9031_i0 | PRJNA557436 | 9079 | 152 | 1.547009 | 2.35145368 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 65.9 | 7.44e-11 | NR | HNG96695.1 | 2927939 | g9031 | i0 | 94.6 | 0.730263157894737 | 37 | 2 | 73 | 0 | 152 | 42 | 360 | 396 | HNG96695.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 111 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales 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);;