contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27390174 | 27390174 | PRJNA168635_P_NODE_24303_length_171_cov_1.303279_g23887_i0 | PRJNA168635 | 24303 | 171 | 1.303279 | 2.22860709 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 95.5 | 3.56e-21 | NR | HMS91176.1 | 2927939 | g23887 | i0 | 81.8 | 1.92982456140351 | 55 | 10 | 96.5 | 0 | 3 | 167 | 444 | 498 | HMS91176.1 portal protein [Candidatus Absconditabacterales bacterium] | diamond | 330 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 27958336 | 27958336 | PRJNA168635_P_NODE_29425_length_164_cov_3.730435_g29009_i0 | PRJNA168635 | 29425 | 164 | 3.730435 | 6.1179134 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 102 | 3.03e-25 | NR | HNG97599.1 | 2927939 | g29009 | i0 | 100 | 0.969512195121951 | 53 | 0 | 97 | 0 | 163 | 5 | 130 | 182 | HNG97599.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 159 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 30073763 | 30073763 | PRJNA168635_P_NODE_18032_length_189_cov_2.378571_g17616_i0 | PRJNA168635 | 18032 | 189 | 2.378571 | 4.49549919 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 90.1 | 3.79e-19 | NR | HNG96687.1 | 2927939 | g17616 | i0 | 83.9 | 0.888888888888889 | 56 | 9 | 88.9 | 0 | 1 | 168 | 578 | 633 | HNG96687.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 168 | 90.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 30136729 | 30136729 | PRJNA168635_P_NODE_33112_length_159_cov_2.763636_g32696_i0 | PRJNA168635 | 33112 | 159 | 2.763636 | 4.39418124 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 59.7 | 4.36e-9 | NR | AKH32956.1 | 1643353 | g32696 | i0 | 78.8 | 0.622641509433962 | 33 | 7 | 62.3 | 0 | 159 | 61 | 110 | 142 | AKH32956.1 Ribosomal RNA small subunit methyltransferase G [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 99 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 | ||||||
| 30610909 | 30610909 | PRJNA168635_P_NODE_18153_length_189_cov_1.257143_g17737_i0 | PRJNA168635 | 18153 | 189 | 1.257143 | 2.37600027 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 51.2 | 1.81e-5 | NR | AKH33351.1 | 1643353 | g17737 | i0 | 51.2 | 0.682539682539683 | 43 | 21 | 68.3 | 0 | 188 | 60 | 328 | 370 | AKH33351.1 DNA primase [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 129 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 | ||||||
| 31274568 | 31274568 | PRJNA168635_P_NODE_25895_length_168_cov_2.000000_g25479_i0 | PRJNA168635 | 25895 | 168 | 2 | 3.36 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 94.7 | 3.39e-22 | NR | HNG96755.1 | 2927939 | g25479 | i0 | 94 | 0.892857142857143 | 50 | 3 | 89.3 | 0 | 158 | 9 | 186 | 235 | HNG96755.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 150 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 31464613 | 31464613 | PRJNA168635_P_NODE_23256_length_173_cov_2.104839_g22840_i0 | PRJNA168635 | 23256 | 173 | 2.104839 | 3.64137147 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 93.2 | 9.62e-22 | NR | HNG97599.1 | 2927939 | g22840 | i0 | 87 | 0.936416184971098 | 54 | 7 | 93.6 | 0 | 3 | 164 | 26 | 79 | HNG97599.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 162 | 93.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 32192077 | 32192077 | PRJNA168635_P_NODE_23298_length_173_cov_1.669355_g22882_i0 | PRJNA168635 | 23298 | 173 | 1.669355 | 2.88798415 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 89 | 3.61e-19 | NR | AKH32493.1 | 1643353 | g22882 | i0 | 75.4 | 0.988439306358382 | 57 | 14 | 98.8 | 0 | 1 | 171 | 95 | 151 | AKH32493.1 Putative type II secretion system protein F [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 171 | 89 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 | ||||||
| 32381895 | 32381895 | PRJNA168635_P_NODE_33399_length_158_cov_2.623853_g32983_i0 | PRJNA168635 | 33399 | 158 | 2.623853 | 4.14568774 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 100 | 1.11e-24 | NR | HNG97599.1 | 2927939 | g32983 | i0 | 100 | 0.987341772151899 | 52 | 0 | 98.7 | 0 | 158 | 3 | 127 | 178 | HNG97599.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 156 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 32540274 | 32540274 | PRJNA168635_P_NODE_32819_length_160_cov_2.765766_g32403_i0 | PRJNA168635 | 32819 | 160 | 2.765766 | 4.4252256 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 71.6 | 7.19e-14 | NR | HNG97243.1 | 2927939 | g32403 | i0 | 100 | 0.6375 | 34 | 0 | 63.8 | 0 | 2 | 103 | 116 | 149 | HNG97243.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 102 | 71.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 32886333 | 32886333 | PRJNA168635_P_NODE_24200_length_171_cov_1.680328_g23784_i0 | PRJNA168635 | 24200 | 171 | 1.680328 | 2.87336088 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 105 | 1.49e-24 | NR | AKH33109.1 | 1643353 | g23784 | i0 | 87.5 | 0.982456140350877 | 56 | 7 | 98.2 | 0 | 170 | 3 | 83 | 138 | AKH33109.1 Polyribonucleotide nucleotidyltransferase [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 168 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 |
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);;