contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB66218" and tax_phylum = "Candidatus Falkowiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6512272 | 6512272 | PRJEB66218_P_NODE_69786_length_385_cov_2.395062_g67362_i0 | PRJEB66218 | 69786 | 385 | 2.395062 | 9.2209887 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 75.5 | 7.04e-13 | NR | QQG53011.1 | 2053554 | g67362 | i0 | 43 | 0.942857142857143 | 121 | 66 | 94.3 | 3 | 23 | 385 | 4532 | 4649 | QQG53011.1 MAG: fibronectin type III domain-containing protein [Candidatus Falkowbacteria bacterium] | diamond | 363 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 27760854 | 27760854 | PRJEB66218_P_NODE_10844_length_1320_cov_30.971406_g9355_i0 | PRJEB66218 | 10844 | 1320 | 30.971406000000002 | 408.8225592 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 338 | 1.1e-99 | NR | QQS60272.1 | 2053554 | g9355 | i0 | 53.7 | 2.96818181818182 | 432 | 187 | 98.2 | 4 | 1306 | 11 | 4873 | 5291 | QQS60272.1 MAG: fibronectin type III domain-containing protein [Candidatus Falkowbacteria bacterium] | diamond | 3918 | 338 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 27792328 | 27792328 | PRJEB66218_P_NODE_6384_length_1813_cov_8.107306_g5372_i0 | PRJEB66218 | 6384 | 1813 | 8.107306 | 146.98545778 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 289 | 1.8700000000000003e-80 | NR | QQS60272.1 | 2053554 | g5372 | i0 | 50.6 | 1.33370104798676 | 403 | 186 | 66.5 | 6 | 1810 | 605 | 4965 | 5355 | QQS60272.1 MAG: fibronectin type III domain-containing protein [Candidatus Falkowbacteria bacterium] | diamond | 2418 | 289 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 29118465 | 29118465 | PRJEB66218_P_NODE_12409_length_1209_cov_75.492160_g10786_i0 | PRJEB66218 | 12409 | 1209 | 75.49216 | 912.7002144 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 316 | 1.29e-92 | NR | QQG53011.1 | 2053554 | g10786 | i0 | 54.3 | 1.97022332506203 | 398 | 172 | 98.8 | 4 | 3 | 1196 | 4775 | 5162 | QQG53011.1 MAG: fibronectin type III domain-containing protein [Candidatus Falkowbacteria bacterium] | diamond | 2382 | 316 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 29276028 | 29276028 | PRJEB66218_P_NODE_234909_length_203_cov_0.915493_g232478_i0 | PRJEB66218 | 234909 | 203 | 0.915493 | 1.85845079 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 65.9 | 1.14e-10 | NR | MEI7497671.1 | 2053554 | g232478 | i0 | 47 | 0.975369458128079 | 66 | 32 | 97.5 | 1 | 5 | 202 | 174 | 236 | MEI7497671.1 hypothetical protein [Candidatus Falkowbacteria bacterium] | diamond | 198 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 30191924 | 30191924 | PRJEB66218_P_NODE_239272_length_202_cov_0.921986_g236841_i0 | PRJEB66218 | 239272 | 202 | 0.921986 | 1.86241172 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 64.7 | 3.98e-10 | NR | QQG53033.1 | 2053554 | g236841 | i0 | 40 | 0.965346534653465 | 65 | 39 | 96.5 | 0 | 4 | 198 | 231 | 295 | QQG53033.1 MAG: hypothetical protein HY931_02255 [Candidatus Falkowbacteria bacterium] | diamond | 195 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 30823897 | 30823897 | PRJEB66218_P_NODE_16334_length_1008_cov_104.812038_g14457_i0 | PRJEB66218 | 16334 | 1008 | 104.812038 | 1056.50534304 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 246 | 2.05e-69 | NR | QQG53011.1 | 2053554 | g14457 | i0 | 53.8 | 2.96130952380952 | 329 | 139 | 97.9 | 4 | 9 | 995 | 4847 | 5162 | QQG53011.1 MAG: fibronectin type III domain-containing protein [Candidatus Falkowbacteria bacterium] | diamond | 2985 | 246 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 31867109 | 31867109 | PRJEB66218_P_NODE_141237_length_250_cov_0.984127_g138808_i0 | PRJEB66218 | 141237 | 250 | 0.984127 | 2.4603175 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 43.5 | 0.0214 | NR | MCX6795620.1 | 2053554 | g138808 | i0 | 40.4 | 0.624 | 52 | 28 | 62.4 | 1 | 179 | 24 | 367 | 415 | MCX6795620.1 YCF48-related protein [Candidatus Falkowbacteria bacterium] | diamond | 156 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria bacterium | ||||||
| 32215446 | 32215446 | PRJEB66218_P_NODE_34778_length_609_cov_33.930657_g32402_i0 | PRJEB66218 | 34778 | 609 | 33.930657 | 206.63770113 | Candidatus Falkowbacteria bacterium | 2053554 | Bacteria | Bacteria | 163 | 2.2499999999999994e-42 | NR | QQS60272.1 | 2053554 | g32402 | i0 | 50.7 | 2.00492610837438 | 203 | 86 | 98.5 | 3 | 601 | 2 | 4921 | 5112 | QQS60272.1 MAG: fibronectin type III domain-containing protein [Candidatus Falkowbacteria bacterium] | diamond | 1221 | 163 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Falkowiibacteriota | Candidatus Falkowbacteria 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);;