contig_metadata
14 rows where bioproject = "PRJNA944150", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8576635 | 8576635 | PRJNA944150_P_NODE_35627_length_167_cov_1.567797_g35376_i0 | PRJNA944150 | 35627 | 167 | 1.567797 | 2.61822099 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 167 | 4.79e-37 | NTclustered | gi|2893358456|emb|OZ220748.1| | 2026734 | g35376 | i0 | 86.755 | 4.39520958083832 | 151 | 18 | 90 | 2 | 18 | 167 | 1723276 | 1723425 | MAG: Dehalococcoidia bacterium isolate 6c7b36c8-b3ab-4b4c-a352-7e98d29eb5d7 genome assembly, chromosome: 1 | blastn | 734 | 167 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 25485698 | 25485698 | PRJNA944150_P_NODE_33360_length_171_cov_1.549180_g33109_i0 | PRJNA944150 | 33360 | 171 | 1.54918 | 2.6490978 | Chloroflexota | 200795 | Bacteria | Bacteria | 217 | 4.8e-52 | NTclustered | gi|297181775|gb|GU474878.1| | 710736 | g33109 | i0 | 92.157 | 188.432748538012 | 153 | 12 | 89 | 0 | 1 | 153 | 9324 | 9172 | Uncultured Chloroflexi bacterium HF0200_09I09 genomic sequence | blastn | 32222 | 217 | 1 | Bacteria | Bacillati | Chloroflexota | uncultured Chloroflexi bacterium HF0200_09I09 | ||||||
| 27088610 | 27088610 | PRJNA944150_P_NODE_20442_length_198_cov_2.872483_g20191_i0 | PRJNA944150 | 20442 | 198 | 2.872483 | 5.68751634 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 47.4 | 4.71e-4 | NR | TME53214.1 | 2026724 | g20191 | i0 | 65.6 | 0.484848484848485 | 32 | 11 | 48.5 | 0 | 103 | 198 | 79 | 110 | TME53214.1 MAG: proline dehydrogenase [Chloroflexota bacterium] | diamond | 96 | 47.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28288434 | 28288434 | PRJNA944150_P_NODE_19606_length_199_cov_5.073333_g19355_i0 | PRJNA944150 | 19606 | 199 | 5.073333 | 10.09593267 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.1 | 0.0153 | NR | MFC1993110.1 | 2026724 | g19355 | i0 | 56.3 | 0.482412060301508 | 32 | 14 | 48.2 | 0 | 96 | 1 | 23 | 54 | MFC1993110.1 hypothetical protein [Chloroflexota bacterium] | diamond | 96 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28351707 | 28351707 | PRJNA944150_P_NODE_17766_length_209_cov_4.712500_g17515_i0 | PRJNA944150 | 17766 | 209 | 4.7125 | 9.849125 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 64.3 | 1.17e-10 | NR | RLT37757.1 | 2026724 | g17515 | i0 | 56.5 | 1.73684210526316 | 62 | 23 | 83.3 | 1 | 23 | 196 | 43 | 104 | RLT37757.1 MAG: NUDIX domain-containing protein [Chloroflexota bacterium] | diamond | 363 | 64.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28604379 | 28604379 | PRJNA944150_P_NODE_36407_length_167_cov_0.864407_g36156_i0 | PRJNA944150 | 36407 | 167 | 0.864407 | 1.44355969 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 73.9 | 1.28e-13 | NR | MCL4879293.1 | 2052143 | g36156 | i0 | 69.1 | 0.988023952095808 | 55 | 17 | 98.8 | 0 | 166 | 2 | 371 | 425 | MCL4879293.1 hypothetical protein [Anaerolineae bacterium] | diamond | 165 | 73.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28667665 | 28667665 | PRJNA944150_P_NODE_43387_length_162_cov_0.902655_g43136_i0 | PRJNA944150 | 43387 | 162 | 0.902655 | 1.4623011 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.6 | 0.0312 | NR | HEV7665077.1 | 2026724 | g43136 | i0 | 53.3 | 0.555555555555556 | 30 | 14 | 55.6 | 0 | 53 | 142 | 197 | 226 | HEV7665077.1 MBL fold metallo-hydrolase [Chloroflexota bacterium] | diamond | 90 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28737500 | 28737500 | PRJNA944150_P_NODE_6067_length_348_cov_2.809365_g5816_i0 | PRJNA944150 | 6067 | 348 | 2.809365 | 9.7765902 | Bacillati | 1783272 | Bacteria | Bacteria | 43.9 | 0.00568 | NR | MBE2237467.1 | 2614250 | g5816 | i0 | 35.5 | 1.33620689655172 | 62 | 39 | 52.6 | 1 | 346 | 164 | 14 | 75 | MBE2237467.1 efflux RND transporter permease subunit [Caldilineaceae bacterium] | diamond | 465 | 44.3 | 0.99097065462754 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 30056723 | 30056723 | PRJNA944150_P_NODE_25871_length_185_cov_1.404412_g25620_i0 | PRJNA944150 | 25871 | 185 | 1.404412 | 2.5981622 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 42.4 | 0.0127 | NR | HEX7594447.1 | 2052143 | g25620 | i0 | 58.1 | 1.44324324324324 | 31 | 13 | 50.3 | 0 | 2 | 94 | 114 | 144 | HEX7594447.1 aminotransferase [Anaerolineae bacterium] | diamond | 267 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30506093 | 30506093 | PRJNA944150_P_NODE_46733_length_156_cov_4.196262_g46482_i0 | PRJNA944150 | 46733 | 156 | 4.196262 | 6.54616872 | Bacillati | 1783272 | Bacteria | Bacteria | 48.1 | 1.38e-4 | NR | HEU4325948.1 | 2762507 | g46482 | i0 | 62.2 | 1.42307692307692 | 37 | 13 | 69.2 | 1 | 152 | 45 | 342 | 378 | HEU4325948.1 S1 family peptidase [Roseiflexaceae bacterium] | diamond | 222 | 48.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 31510792 | 31510792 | PRJNA944150_P_NODE_43956_length_162_cov_0.902655_g43705_i0 | PRJNA944150 | 43956 | 162 | 0.902655 | 1.4623011 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 74.3 | 8.07e-15 | NR | MAU09591.1 | 2024896 | g43705 | i0 | 59.6 | 6.64814814814815 | 52 | 21 | 96.3 | 0 | 5 | 160 | 19 | 70 | MAU09591.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 1077 | 74.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 32023583 | 32023583 | PRJNA944150_P_NODE_11378_length_254_cov_1.804878_g11127_i0 | PRJNA944150 | 11378 | 254 | 1.804878 | 4.58439012 | FCB group | 1783270 | Bacteria | Bacteria | 119 | 4.69e-32 | NR | MBN1680764.1 | 2052143 | g11127 | i0 | 68.7 | 6.90944881889764 | 83 | 26 | 98 | 0 | 1 | 249 | 61 | 143 | MBN1680764.1 N-acetyltransferase [Anaerolineae bacterium] | diamond | 1755 | 120 | 0.991666666666667 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32680357 | 32680357 | PRJNA944150_P_NODE_41180_length_163_cov_2.894737_g40929_i0 | PRJNA944150 | 41180 | 163 | 2.894737 | 4.71842131 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 56.2 | 1.63e-7 | NR | MDA0269848.1 | 2026724 | g40929 | i0 | 51.9 | 1.96932515337423 | 54 | 24 | 97.5 | 2 | 5 | 163 | 53 | 105 | MDA0269848.1 Ig-like domain-containing protein [Chloroflexota bacterium] | diamond | 321 | 56.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32837970 | 32837970 | PRJNA944150_P_NODE_20240_length_198_cov_10.221477_g19989_i0 | PRJNA944150 | 20240 | 198 | 10.221477 | 20.23852446 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 113 | 4.9999999999999993e-29 | NR | MEY3990551.1 | 2026724 | g19989 | i0 | 94.9 | 1.78787878787879 | 59 | 3 | 89.4 | 0 | 198 | 22 | 207 | 265 | MEY3990551.1 hypothetical protein [Chloroflexota bacterium] | diamond | 354 | 113 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota 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);;