contig_metadata
8 rows where bioproject = "PRJEB55122", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17569608 | 17569608 | PRJEB55122_P_NODE_32594_length_182_cov_1.563910_g32197_i0 | PRJEB55122 | 32594 | 182 | 1.56391 | 2.8463162 | Herpetosiphon | 64 | Bacteria | Bacteria | 326 | 8.260000000000001e-85 | NTclustered | gi|470482680|ref|NR_076546.1| | 65 | g32197 | i0 | 99.441 | 47.5054945054945 | 179 | 1 | 98 | 0 | 1 | 179 | 394 | 572 | Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence | blastn | 8646 | 326 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphon | Herpetosiphon aurantiacus | ||
| 27191487 | 27191487 | PRJEB55122_P_NODE_42222_length_163_cov_0.912281_g41825_i0 | PRJEB55122 | 42222 | 163 | 0.912281 | 1.48701803 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 62 | 7.54e-10 | NR | MBI3748492.1 | 2026724 | g41825 | i0 | 78.4 | 0.680981595092024 | 37 | 5 | 68.1 | 1 | 113 | 3 | 1 | 34 | MBI3748492.1 prepilin peptidase [Chloroflexota bacterium] | diamond | 111 | 62 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28139302 | 28139302 | PRJEB55122_P_NODE_7045_length_524_cov_2.589474_g6656_i0 | PRJEB55122 | 7045 | 524 | 2.589474 | 13.56884376 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 48.5 | 0.00514 | NR | MFL2650889.1 | 2073117 | g6656 | i0 | 31.8 | 0.629770992366412 | 110 | 68 | 63 | 3 | 471 | 142 | 251 | 353 | MFL2650889.1 ArnT family glycosyltransferase [Anaerolineales bacterium] | diamond | 330 | 48.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28928360 | 28928360 | PRJEB55122_P_NODE_16208_length_286_cov_1.316456_g15811_i0 | PRJEB55122 | 16208 | 286 | 1.316456 | 3.76506416 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 43.1 | 0.0435 | NR | MBL8097376.1 | 2073117 | g15811 | i0 | 35.8 | 0.555944055944056 | 53 | 31 | 54.5 | 2 | 82 | 237 | 32 | 82 | MBL8097376.1 polysulfide reductase NrfD [Anaerolineales bacterium] | diamond | 159 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29149811 | 29149811 | PRJEB55122_P_NODE_31309_length_187_cov_1.130435_g30912_i0 | PRJEB55122 | 31309 | 187 | 1.130435 | 2.11391345 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 59.7 | 1.85e-8 | NR | HNT74674.1 | 2052143 | g30912 | i0 | 48 | 3.68983957219251 | 50 | 26 | 80.2 | 0 | 10 | 159 | 441 | 490 | HNT74674.1 SDR family NAD(P)-dependent oxidoreductase [Anaerolineae bacterium] | diamond | 690 | 59.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29932274 | 29932274 | PRJEB55122_P_NODE_37651_length_168_cov_0.873950_g37254_i0 | PRJEB55122 | 37651 | 168 | 0.87395 | 1.468236 | Bacteria | 2 | Bacteria | Bacteria | 44.7 | 0.00286 | NR | MEO8437568.1 | 2026724 | g37254 | i0 | 54.5 | 2.66071428571429 | 55 | 18 | 91.1 | 3 | 16 | 168 | 85 | 136 | MEO8437568.1 MerR family transcriptional regulator [Chloroflexota bacterium] | diamond | 447 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31044972 | 31044972 | PRJEB55122_P_NODE_15375_length_297_cov_1.673387_g14978_i0 | PRJEB55122 | 15375 | 297 | 1.673387 | 4.96995939 | Candidatus Promineifilaceae bacterium | 3085104 | Bacteria | Bacteria | 43.9 | 0.0212 | NR | MDX1416048.1 | 3085104 | g14978 | i0 | 31.9 | 0.474747474747475 | 47 | 32 | 47.5 | 0 | 83 | 223 | 2 | 48 | MDX1416048.1 cytochrome c biogenesis protein CcdA [Candidatus Promineifilaceae bacterium] | diamond | 141 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilaceae bacterium | |||
| 32436660 | 32436660 | PRJEB55122_P_NODE_41899_length_163_cov_2.078947_g41502_i0 | PRJEB55122 | 41899 | 163 | 2.078947 | 3.38868361 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 42 | 0.0243 | NR | MDA8188059.1 | 2026733 | g41502 | i0 | 54.3 | 0.644171779141104 | 35 | 14 | 60.7 | 2 | 139 | 41 | 651 | 685 | MDA8188059.1 ATP-dependent DNA helicase [Dehalococcoidales bacterium] | diamond | 105 | 42 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales 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);;