contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA929924" and tax_phylum = "Bacteroidota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20380540 | 20380540 | PRJNA929924_P_NODE_15636_length_168_cov_0.873950_g15473_i0 | PRJNA929924 | 15636 | 168 | 0.87395 | 1.468236 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 109 | 3.21e-26 | NR | HZY80804.1 | 2099675 | g15473 | i0 | 96.4 | 2 | 56 | 2 | 100 | 0 | 1 | 168 | 7 | 62 | HZY80804.1 DNA-directed RNA polymerase subunit beta' [Cyclobacteriaceae bacterium] | diamond | 336 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 26930038 | 26930038 | PRJNA929924_P_NODE_17902_length_163_cov_0.912281_g17739_i0 | PRJNA929924 | 17902 | 163 | 0.912281 | 1.48701803 | Terrimonas sp. | 1914338 | Bacteria | Bacteria | 94.7 | 5.9e-21 | NR | WP_116874309.1 | 1914338 | g17739 | i0 | 100 | 1.91411042944785 | 52 | 0 | 95.7 | 0 | 3 | 158 | 335 | 386 | WP_116874309.1 efflux RND transporter permease subunit [Terrimonas sp.] | diamond | 312 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Terrimonas | Terrimonas sp. | |
| 28793320 | 28793320 | PRJNA929924_P_NODE_17127_length_164_cov_0.904348_g16964_i0 | PRJNA929924 | 17127 | 164 | 0.904348 | 1.48313072 | Ferruginibacter sp. | 1940288 | Bacteria | Bacteria | 94.4 | 8.42e-21 | NR | MBL7702677.1 | 1940288 | g16964 | i0 | 74.1 | 2.96341463414634 | 54 | 14 | 98.8 | 0 | 2 | 163 | 780 | 833 | MBL7702677.1 SusC/RagA family TonB-linked outer membrane protein [Ferruginibacter sp.] | diamond | 486 | 94.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Ferruginibacter | Ferruginibacter sp. | |
| 29077760 | 29077760 | PRJNA929924_P_NODE_17588_length_163_cov_0.912281_g17425_i0 | PRJNA929924 | 17588 | 163 | 0.912281 | 1.48701803 | Agriterribacter sp. | 2821509 | Bacteria | Bacteria | 74.7 | 6.46e-14 | NR | MFT3701858.1 | 2821509 | g17425 | i0 | 89.2 | 0.680981595092024 | 37 | 4 | 68.1 | 0 | 51 | 161 | 227 | 263 | MFT3701858.1 TonB-dependent receptor [Agriterribacter sp.] | diamond | 111 | 74.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Agriterribacter | Agriterribacter sp. | |
| 29204114 | 29204114 | PRJNA929924_P_NODE_15849_length_167_cov_0.881356_g15686_i0 | PRJNA929924 | 15849 | 167 | 0.881356 | 1.47186452 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 104 | 2.6699999999999998e-24 | NR | HMJ69558.1 | 2099675 | g15686 | i0 | 90.9 | 4.94011976047904 | 55 | 5 | 98.8 | 0 | 2 | 166 | 49 | 103 | HMJ69558.1 Rne/Rng family ribonuclease [Cyclobacteriaceae bacterium] | diamond | 825 | 104 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 29431723 | 29431723 | PRJNA929924_P_NODE_18049_length_162_cov_0.920354_g17886_i0 | PRJNA929924 | 18049 | 162 | 0.920354 | 1.49097348 | Cytophagales | 768507 | Bacteria | Bacteria | 90.1 | 5.3e-21 | NR | MDH4460711.1 | 50419 | g17886 | i0 | 97.8 | 11.6666666666667 | 45 | 1 | 83.3 | 0 | 135 | 1 | 1 | 45 | MDH4460711.1 30S ribosomal protein S16 [Flectobacillus sp.] | diamond | 1890 | 90.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Flectobacillus | Flectobacillus sp. | |
| 29810766 | 29810766 | PRJNA929924_P_NODE_15551_length_168_cov_0.873950_g15388_i0 | PRJNA929924 | 15551 | 168 | 0.87395 | 1.468236 | Cytophagales | 768507 | Bacteria | Bacteria | 105 | 7.72e-25 | NR | WP_305953286.1 | 312279 | g15388 | i0 | 90.9 | 3.92857142857143 | 55 | 5 | 98.2 | 0 | 166 | 2 | 738 | 792 | WP_305953286.1 TonB-dependent receptor [Emticicia oligotrophica] | diamond | 660 | 106 | 0.990566037735849 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Leadbetterellaceae | Emticicia | Emticicia oligotrophica | |
| 30056410 | 30056410 | PRJNA929924_P_NODE_17891_length_163_cov_0.912281_g17728_i0 | PRJNA929924 | 17891 | 163 | 0.912281 | 1.48701803 | Chitinophagales bacterium | 2448779 | Bacteria | Bacteria | 107 | 3.36e-26 | NR | MBN8671110.1 | 2448779 | g17728 | i0 | 90.7 | 0.993865030674847 | 54 | 5 | 99.4 | 0 | 162 | 1 | 215 | 268 | MBN8671110.1 FAD-binding oxidoreductase [Chitinophagales bacterium] | diamond | 162 | 107 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagales bacterium | |||
| 30182892 | 30182892 | PRJNA929924_P_NODE_16512_length_166_cov_0.888889_g16349_i0 | PRJNA929924 | 16512 | 166 | 0.888889 | 1.47555574 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 109 | 3.45e-26 | NR | MES2627940.1 | 1898104 | g16349 | i0 | 96.3 | 1.96987951807229 | 54 | 2 | 97.6 | 0 | 166 | 5 | 408 | 461 | MES2627940.1 peptide chain release factor 3 [Bacteroidota bacterium] | diamond | 327 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30625132 | 30625132 | PRJNA929924_P_NODE_15453_length_168_cov_0.873950_g15290_i0 | PRJNA929924 | 15453 | 168 | 0.87395 | 1.468236 | Flavobacteriia bacterium | 2044941 | Bacteria | Bacteria | 116 | 7.8e-29 | NR | MBH1960069.1 | 2044941 | g15290 | i0 | 94.6 | 1 | 56 | 3 | 100 | 0 | 168 | 1 | 462 | 517 | MBH1960069.1 calcineurin-like phosphoesterase C-terminal domain-containing protein [Flavobacteriia bacterium] | diamond | 168 | 116 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriia bacterium | ||||
| 31352188 | 31352188 | PRJNA929924_P_NODE_15056_length_169_cov_0.866667_g14893_i0 | PRJNA929924 | 15056 | 169 | 0.866667 | 1.46466723 | Ginsengibacter sp. | 2806034 | Bacteria | Bacteria | 76.6 | 1.45e-14 | NR | MEO6814235.1 | 2806034 | g14893 | i0 | 68.4 | 3.0887573964497 | 57 | 17 | 99.4 | 1 | 168 | 1 | 156 | 212 | MEO6814235.1 T9SS type A sorting domain-containing protein [Ginsengibacter sp.] | diamond | 522 | 76.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Ginsengibacter | Ginsengibacter sp. | |
| 31447047 | 31447047 | PRJNA929924_P_NODE_16936_length_165_cov_0.896552_g16773_i0 | PRJNA929924 | 16936 | 165 | 0.896552 | 1.4793108 | Cyclobacteriaceae bacterium | 2099675 | Bacteria | Bacteria | 101 | 2.9199999999999998e-24 | NR | HMJ71228.1 | 2099675 | g16773 | i0 | 85.5 | 1.98181818181818 | 55 | 8 | 100 | 0 | 165 | 1 | 195 | 249 | HMJ71228.1 transporter [Cyclobacteriaceae bacterium] | diamond | 327 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Cyclobacteriaceae | Cyclobacteriaceae bacterium | ||
| 32491176 | 32491176 | PRJNA929924_P_NODE_17159_length_164_cov_0.904348_g16996_i0 | PRJNA929924 | 17159 | 164 | 0.904348 | 1.48313072 | Agriterribacter sp. | 2821509 | Bacteria | Bacteria | 70.5 | 5.9e-13 | NR | MFT3704183.1 | 2821509 | g16996 | i0 | 78.9 | 1.04268292682927 | 57 | 7 | 98.8 | 2 | 162 | 1 | 73 | 127 | MFT3704183.1 hypothetical protein [Agriterribacter sp.] | diamond | 171 | 70.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Agriterribacter | Agriterribacter sp. |
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);;