contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA738523" and tax_clade = "FCB group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17297643 | 17297643 | PRJNA738523_P_NODE_6634_length_288_cov_0.930233_g6563_i0 | PRJNA738523 | 6634 | 288 | 0.930233 | 2.67907104 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 95.5 | 1.9e-20 | NR | MCB0501685.1 | 1898104 | g6563 | i0 | 73.4 | 11.7083333333333 | 64 | 17 | 66.7 | 0 | 4 | 195 | 701 | 764 | MCB0501685.1 ribonucleoside-diphosphate reductase subunit alpha [Bacteroidota bacterium] | diamond | 3372 | 95.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 26704067 | 26704067 | PRJNA738523_P_NODE_12901_length_247_cov_0.885057_g12830_i0 | PRJNA738523 | 12901 | 247 | 0.885057 | 2.18609079 | Profundicola chukchiensis | 2961959 | Bacteria | Bacteria | 149 | 2.45e-41 | NR | WP_304420871.1 | 2961959 | g12830 | i0 | 92.6 | 0.983805668016194 | 81 | 6 | 98.4 | 0 | 3 | 245 | 245 | 325 | WP_304420871.1 exonuclease subunit SbcD [Profundicola chukchiensis] | diamond | 243 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Profundicola | Profundicola chukchiensis | |
| 26957395 | 26957395 | PRJNA738523_P_NODE_16002_length_241_cov_0.916667_g15931_i0 | PRJNA738523 | 16002 | 241 | 0.916667 | 2.20916747 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 48.5 | 3.04e-4 | NR | MFN9109787.1 | 1898104 | g15931 | i0 | 45.7 | 0.572614107883817 | 46 | 25 | 57.3 | 0 | 140 | 3 | 180 | 225 | MFN9109787.1 hypothetical protein [Bacteroidota bacterium] | diamond | 138 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 27684670 | 27684670 | PRJNA738523_P_NODE_9664_length_258_cov_1.664865_g9593_i0 | PRJNA738523 | 9664 | 258 | 1.664865 | 4.2953517 | Flavobacteriales bacterium | 2021391 | Bacteria | Bacteria | 81.6 | 2.48e-16 | NR | TXI78812.1 | 2021391 | g9593 | i0 | 100 | 0.930232558139535 | 42 | 0 | 48.8 | 0 | 2 | 127 | 239 | 280 | TXI78812.1 MAG: AraC family transcriptional regulator [Flavobacteriales bacterium] | diamond | 240 | 81.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriales bacterium | |||
| 27757924 | 27757924 | PRJNA738523_P_NODE_3544_length_361_cov_1.055556_g3473_i0 | PRJNA738523 | 3544 | 361 | 1.055556 | 3.81055716 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 92.4 | 6.960000000000001e-21 | NR | WP_128546087.1 | 1770527 | g3473 | i0 | 51.7 | 2.8005540166205 | 89 | 41 | 74 | 1 | 6 | 272 | 80 | 166 | WP_128546087.1 DUF2231 domain-containing protein [Larkinella soli] | diamond | 1011 | 92.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Larkinella | Larkinella soli | |
| 28073270 | 28073270 | PRJNA738523_P_NODE_14945_length_243_cov_0.905882_g14874_i0 | PRJNA738523 | 14945 | 243 | 0.905882 | 2.20129326 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.9 | 0.0129 | NR | PTM08205.1 | 1898104 | g14874 | i0 | 40.8 | 2.19753086419753 | 49 | 27 | 59.3 | 2 | 100 | 243 | 94 | 141 | PTM08205.1 MAG: sterol desaturase [Bacteroidota bacterium] | diamond | 534 | 44.3 | 0.99097065462754 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 28347354 | 28347354 | PRJNA738523_P_NODE_6586_length_288_cov_1.432558_g6515_i0 | PRJNA738523 | 6586 | 288 | 1.432558 | 4.12576704 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 69.3 | 2.9e-11 | NR | MCF8381789.1 | 2030927 | g6515 | i0 | 39.8 | 0.96875 | 93 | 51 | 96.9 | 1 | 6 | 284 | 974 | 1061 | MCF8381789.1 CotH kinase family protein [Bacteroidales bacterium] | diamond | 279 | 69.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 28442252 | 28442252 | PRJNA738523_P_NODE_16026_length_241_cov_0.916667_g15955_i0 | PRJNA738523 | 16026 | 241 | 0.916667 | 2.20916747 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 62.4 | 3.8e-9 | NR | MBO4768131.1 | 2030927 | g15955 | i0 | 60 | 3.78423236514523 | 50 | 18 | 62.2 | 1 | 2 | 151 | 287 | 334 | MBO4768131.1 multidrug DMT transporter permease [Bacteroidales bacterium] | diamond | 912 | 62.4 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 28673330 | 28673330 | PRJNA738523_P_NODE_16627_length_226_cov_2.013072_g16556_i0 | PRJNA738523 | 16627 | 226 | 2.013072 | 4.54954272 | Flavobacterium | 237 | Bacteria | Bacteria | 50.1 | 8.17e-5 | NR | RZJ34209.1 | 239 | g16556 | i0 | 49 | 1.76548672566372 | 49 | 25 | 65 | 0 | 151 | 5 | 2789 | 2837 | RZJ34209.1 MAG: T9SS type A sorting domain-containing protein [Flavobacterium sp.] | diamond | 399 | 50.4 | 0.994047619047619 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. | |
| 28894137 | 28894137 | PRJNA738523_P_NODE_7468_length_279_cov_1.495146_g7397_i0 | PRJNA738523 | 7468 | 279 | 1.495146 | 4.17145734 | FCB group | 1783270 | Bacteria | Bacteria | 43.1 | 0.0388 | NR | WP_294537875.1 | 162156 | g7397 | i0 | 25.8 | 2.70967741935484 | 97 | 57 | 88.2 | 3 | 263 | 18 | 7 | 103 | WP_294537875.1 cyclically-permuted mutarotase family protein [uncultured Bacteroides sp.] | diamond | 756 | 43.5 | 0.990804597701149 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | uncultured Bacteroides sp. | |
| 29262807 | 29262807 | PRJNA738523_P_NODE_7189_length_282_cov_1.248804_g7118_i0 | PRJNA738523 | 7189 | 282 | 1.248804 | 3.52162728 | Winogradskyella psychrotolerans | 1344585 | Bacteria | Bacteria | 43.1 | 0.0414 | NR | WP_215935802.1 | 1344585 | g7118 | i0 | 81.8 | 0.234042553191489 | 22 | 4 | 23.4 | 0 | 88 | 23 | 302 | 323 | WP_215935802.1 TlpA family protein disulfide reductase [Winogradskyella psychrotolerans] | diamond | 66 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Winogradskyella | Winogradskyella psychrotolerans | |
| 29389463 | 29389463 | PRJNA738523_P_NODE_6749_length_286_cov_2.103286_g6678_i0 | PRJNA738523 | 6749 | 286 | 2.103286 | 6.01539796 | Aureispira sp. | 1872660 | Bacteria | Bacteria | 43.5 | 0.0333 | NR | MCP4441406.1 | 1872660 | g6678 | i0 | 32.5 | 0.870629370629371 | 83 | 53 | 86 | 2 | 31 | 276 | 74 | 154 | MCP4441406.1 PQQ-binding-like beta-propeller repeat protein [Aureispira sp.] | diamond | 249 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Aureispira | Aureispira sp. | |
| 30599614 | 30599614 | PRJNA738523_P_NODE_15573_length_242_cov_0.911243_g15502_i0 | PRJNA738523 | 15573 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.0141 | NR | MAR20450.1 | 2021391 | g15502 | i0 | 36.4 | 3.17355371900826 | 66 | 26 | 81.8 | 1 | 220 | 23 | 27 | 76 | MAR20450.1 hypothetical protein [Flavobacteriales bacterium] | diamond | 768 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriales bacterium | |||
| 31063786 | 31063786 | PRJNA738523_P_NODE_4435_length_333_cov_1.184615_g4364_i0 | PRJNA738523 | 4435 | 333 | 1.184615 | 3.94476795 | Candidatus Aegiribacteria sp. | 2528271 | Bacteria | Bacteria | 89.4 | 8.860000000000001e-21 | NR | MFO8183585.1 | 2528271 | g4364 | i0 | 56.8 | 1.38738738738739 | 74 | 32 | 66.7 | 0 | 2 | 223 | 6 | 79 | MFO8183585.1 RNA-binding protein [Candidatus Aegiribacteria sp.] | diamond | 462 | 89.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Aegiribacteria | Candidatus Aegiribacteria sp. | |||||
| 31221289 | 31221289 | PRJNA738523_P_NODE_11075_length_250_cov_0.870056_g11004_i0 | PRJNA738523 | 11075 | 250 | 0.870056 | 2.17514 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 42 | 0.0139 | NR | MEW5925833.1 | 2053527 | g11004 | i0 | 47.1 | 1.2 | 51 | 27 | 61.2 | 0 | 8 | 160 | 26 | 76 | MEW5925833.1 ankyrin repeat domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 300 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31379792 | 31379792 | PRJNA738523_P_NODE_15496_length_242_cov_0.911243_g15425_i0 | PRJNA738523 | 15496 | 242 | 0.911243 | 2.20520806 | Hymenobacter caeli | 2735894 | Bacteria | Bacteria | 63.2 | 2.35e-9 | NR | WP_173809383.1 | 2735894 | g15425 | i0 | 41.1 | 0.90495867768595 | 73 | 41 | 88 | 1 | 215 | 3 | 1 | 73 | WP_173809383.1 4-alpha-glucanotransferase [Hymenobacter caeli] | diamond | 219 | 63.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter caeli | |
| 32170754 | 32170754 | PRJNA738523_P_NODE_16318_length_241_cov_0.916667_g16247_i0 | PRJNA738523 | 16318 | 241 | 0.916667 | 2.20916747 | Paludibacteraceae bacterium | 2748031 | Bacteria | Bacteria | 70.1 | 3.63e-12 | NR | MBO4531769.1 | 2748031 | g16247 | i0 | 43.2 | 2.00414937759336 | 81 | 44 | 98.3 | 1 | 238 | 2 | 173 | 253 | MBO4531769.1 AAA family ATPase [Paludibacteraceae bacterium] | diamond | 483 | 70.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Paludibacteraceae | Paludibacteraceae bacterium | ||
| 32360661 | 32360661 | PRJNA738523_P_NODE_9379_length_261_cov_1.398936_g9308_i0 | PRJNA738523 | 9379 | 261 | 1.398936 | 3.65122296 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 43.1 | 0.0312 | NR | HMK37779.1 | 1898104 | g9308 | i0 | 38.1 | 0.724137931034483 | 63 | 38 | 71.3 | 1 | 190 | 5 | 18 | 80 | HMK37779.1 XdhC family protein [Bacteroidota bacterium] | diamond | 189 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 32802104 | 32802104 | PRJNA738523_P_NODE_13040_length_247_cov_0.885057_g12969_i0 | PRJNA738523 | 13040 | 247 | 0.885057 | 2.18609079 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 44.3 | 0.00999 | NR | MBN2610868.1 | 2030927 | g12969 | i0 | 44.9 | 0.595141700404858 | 49 | 27 | 59.5 | 0 | 181 | 35 | 162 | 210 | MBN2610868.1 hypothetical protein [Bacteroidales bacterium] | diamond | 147 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 32875253 | 32875253 | PRJNA738523_P_NODE_15140_length_243_cov_0.905882_g15069_i0 | PRJNA738523 | 15140 | 243 | 0.905882 | 2.20129326 | Puia | 2045098 | Bacteria | Bacteria | 143 | 8.21e-38 | NR | WP_188935130.1 | 1792502 | g15069 | i0 | 83.8 | 1.96296296296296 | 80 | 13 | 98.8 | 0 | 2 | 241 | 411 | 490 | WP_188935130.1 DUF7619 domain-containing protein [Puia dinghuensis] | diamond | 477 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Puia | Puia dinghuensis |
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);;