contig_metadata
16 rows where bioproject = "PRJNA781427" and tax_phylum = "Candidatus Aerophobota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7590277 | 7590277 | PRJNA781427_P_NODE_96586_length_241_cov_0.916667_g95702_i0 | PRJNA781427 | 96586 | 241 | 0.916667 | 2.20916747 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 152 | 5.459999999999998e-42 | NR | TKJ46967.1 | 2012485 | g95702 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 240 | 1 | 321 | 400 | TKJ46967.1 MAG: cysteine--tRNA ligase [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 240 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 27496051 | 27496051 | PRJNA781427_P_NODE_91483_length_243_cov_0.905882_g90599_i0 | PRJNA781427 | 91483 | 243 | 0.905882 | 2.20129326 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 81.3 | 4.86e-16 | NR | TKJ46723.1 | 2012485 | g90599 | i0 | 100 | 0.938271604938272 | 38 | 0 | 46.9 | 0 | 116 | 3 | 1 | 38 | TKJ46723.1 MAG: GTP-binding protein HSR1 [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 228 | 81.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 28474835 | 28474835 | PRJNA781427_P_NODE_83446_length_247_cov_0.885057_g82562_i0 | PRJNA781427 | 83446 | 247 | 0.885057 | 2.18609079 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 170 | 4.41e-49 | NR | TKJ46628.1 | 2012485 | g82562 | i0 | 97.6 | 0.995951417004049 | 82 | 2 | 99.6 | 0 | 247 | 2 | 171 | 252 | TKJ46628.1 MAG: hypothetical protein CEE34_07960 [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 246 | 170 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 28695968 | 28695968 | PRJNA781427_P_NODE_89407_length_244_cov_0.900585_g88523_i0 | PRJNA781427 | 89407 | 244 | 0.900585 | 2.1974274 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 81.6 | 9.94e-18 | NR | TKJ48007.1 | 2012485 | g88523 | i0 | 100 | 0.479508196721311 | 39 | 0 | 48 | 0 | 128 | 244 | 1 | 39 | TKJ48007.1 MAG: hypothetical protein CEE34_00830 [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 117 | 81.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 29263918 | 29263918 | PRJNA781427_P_NODE_75569_length_251_cov_0.865169_g74685_i0 | PRJNA781427 | 75569 | 251 | 0.865169 | 2.17157419 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 164 | 2.67e-47 | NR | TKJ48145.1 | 2012485 | g74685 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 3 | 251 | 146 | 228 | TKJ48145.1 MAG: peptide ABC transporter permease [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 249 | 164 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 29484854 | 29484854 | PRJNA781427_P_NODE_87890_length_245_cov_0.895349_g87006_i0 | PRJNA781427 | 87890 | 245 | 0.895349 | 2.19360505 | Candidatus Aerophobota bacterium | 2030807 | Bacteria | Bacteria | 177 | 8.85e-51 | NR | MCK4418767.1 | 2030807 | g87006 | i0 | 98.8 | 0.991836734693878 | 81 | 1 | 99.2 | 0 | 3 | 245 | 333 | 413 | MCK4418767.1 gamma-glutamyltransferase [Candidatus Aerophobetes bacterium] | diamond | 243 | 177 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 30622173 | 30622173 | PRJNA781427_P_NODE_88573_length_245_cov_0.895349_g87689_i0 | PRJNA781427 | 88573 | 245 | 0.895349 | 2.19360505 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 95.1 | 3.15e-21 | NR | TKJ46433.1 | 2012485 | g87689 | i0 | 98 | 0.6 | 49 | 1 | 60 | 0 | 244 | 98 | 276 | 324 | TKJ46433.1 MAG: delta-aminolevulinic acid dehydratase [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 147 | 95.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 30653746 | 30653746 | PRJNA781427_P_NODE_79813_length_249_cov_0.875000_g78929_i0 | PRJNA781427 | 79813 | 249 | 0.875 | 2.17875 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 159 | 2.3e-44 | NR | TKJ47296.1 | 2012485 | g78929 | i0 | 100 | 0.987951807228916 | 82 | 0 | 98.8 | 0 | 248 | 3 | 85 | 166 | TKJ47296.1 MAG: CTP synthetase [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 246 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 30653757 | 30653757 | PRJNA781427_P_NODE_94333_length_242_cov_0.911243_g93449_i0 | PRJNA781427 | 94333 | 242 | 0.911243 | 2.20520806 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 152 | 5.3099999999999984e-43 | NR | TKJ47178.1 | 2012485 | g93449 | i0 | 95 | 0.991735537190083 | 80 | 4 | 99.2 | 0 | 3 | 242 | 175 | 254 | TKJ47178.1 MAG: thiamine-phosphate kinase [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 240 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 31254218 | 31254218 | PRJNA781427_P_NODE_77395_length_250_cov_0.870056_g76511_i0 | PRJNA781427 | 77395 | 250 | 0.870056 | 2.17514 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 161 | 9e-46 | NR | TKJ47101.1 | 2012485 | g76511 | i0 | 98.8 | 0.984 | 82 | 1 | 98.4 | 0 | 248 | 3 | 215 | 296 | TKJ47101.1 MAG: UDP-glucose 6-dehydrogenase [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 246 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 31317492 | 31317492 | PRJNA781427_P_NODE_77015_length_250_cov_0.870056_g76131_i0 | PRJNA781427 | 77015 | 250 | 0.870056 | 2.17514 | Candidatus Aerophobota bacterium | 2030807 | Bacteria | Bacteria | 156 | 1.11e-44 | NR | HDZ49701.1 | 2030807 | g76131 | i0 | 94 | 0.996 | 83 | 5 | 99.6 | 0 | 1 | 249 | 228 | 310 | HDZ49701.1 phospho-N-acetylmuramoyl-pentapeptide-transferase [Candidatus Aerophobetes bacterium] | diamond | 249 | 156 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 31570770 | 31570770 | PRJNA781427_P_NODE_64236_length_276_cov_1.467980_g63352_i0 | PRJNA781427 | 64236 | 276 | 1.46798 | 4.0516248 | Candidatus Aerophobetes bacterium | 2030807 | Bacteria | Bacteria | 174 | 2.98e-49 | NR | TET85174.1 | 2030807 | g63352 | i0 | 95.7 | 1 | 92 | 4 | 100 | 0 | 276 | 1 | 61 | 152 | TET85174.1 MAG: hypothetical protein E3J32_02085, partial [Candidatus Aerophobetes bacterium] | diamond | 276 | 174 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 31855164 | 31855164 | PRJNA781427_P_NODE_86497_length_246_cov_0.890173_g85613_i0 | PRJNA781427 | 86497 | 246 | 0.890173 | 2.18982558 | Candidatus Aerophobota bacterium | 2030807 | Bacteria | Bacteria | 163 | 1.8e-44 | NR | MCK4418348.1 | 2030807 | g85613 | i0 | 97.5 | 0.98780487804878 | 81 | 2 | 98.8 | 0 | 244 | 2 | 544 | 624 | MCK4418348.1 hypothetical protein [Candidatus Aerophobetes bacterium] | diamond | 243 | 163 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 32456598 | 32456598 | PRJNA781427_P_NODE_74099_length_251_cov_0.865169_g73215_i0 | PRJNA781427 | 74099 | 251 | 0.865169 | 2.17157419 | Candidatus Aerophobetes bacterium | 2030807 | Bacteria | Bacteria | 47.8 | 3.45e-4 | NR | TET07251.1 | 2030807 | g73215 | i0 | 56.8 | 0.442231075697211 | 37 | 16 | 44.2 | 0 | 251 | 141 | 134 | 170 | TET07251.1 MAG: hypothetical protein E3J84_07640 [Candidatus Aerophobetes bacterium] | diamond | 111 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 32583044 | 32583044 | PRJNA781427_P_NODE_45639_length_336_cov_0.859316_g44756_i0 | PRJNA781427 | 45639 | 336 | 0.859316 | 2.88730176 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 105 | 2.1599999999999998e-24 | NR | TKJ45048.1 | 2012485 | g44756 | i0 | 97.9 | 0.982142857142857 | 48 | 1 | 42.9 | 0 | 3 | 146 | 319 | 366 | TKJ45048.1 MAG: hydrogenase formation protein HypD [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 330 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 32614380 | 32614380 | PRJNA781427_P_NODE_85280_length_246_cov_0.890173_g84396_i0 | PRJNA781427 | 85280 | 246 | 0.890173 | 2.18982558 | Candidatus Aerophobetes bacterium | 2030807 | Bacteria | Bacteria | 150 | 2.37e-41 | NR | TEU03872.1 | 2030807 | g84396 | i0 | 95.1 | 0.98780487804878 | 81 | 4 | 98.8 | 0 | 244 | 2 | 320 | 400 | TEU03872.1 MAG: argininosuccinate lyase, partial [Candidatus Aerophobetes bacterium] | diamond | 243 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota 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);;