contig_metadata
11 rows where bioproject = "PRJNA459724", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26917964 | 26917964 | PRJNA459724_P_NODE_422_length_889_cov_2.350000_g70_i2 | PRJNA459724 | 422 | 889 | 2.35 | 20.8915 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 326 | 6.139999999999999e-110 | NR | MBV6513999.1 | 2651163 | g70 | i2 | 81.1 | 0.641169853768279 | 190 | 36 | 64.1 | 0 | 723 | 154 | 1 | 190 | MBV6513999.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 570 | 326 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28244541 | 28244541 | PRJNA459724_P_NODE_1106_length_557_cov_3.579545_g812_i0 | PRJNA459724 | 1106 | 557 | 3.579545 | 19.93806565 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 224 | 5.28e-69 | NR | MBV6514003.1 | 2651163 | g812 | i0 | 98.3 | 0.619389587073609 | 115 | 2 | 61.9 | 0 | 212 | 556 | 1 | 115 | MBV6514003.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 345 | 224 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28497444 | 28497444 | PRJNA459724_P_NODE_67_length_1857_cov_2.579869_g33_i0 | PRJNA459724 | 67 | 1857 | 2.579869 | 47.90816733 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 484 | 2.1299999999999993e-164 | NR | MBV6514003.1 | 2651163 | g33 | i0 | 97.5 | 0.382875605815832 | 237 | 6 | 38.3 | 0 | 1855 | 1145 | 126 | 362 | MBV6514003.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 711 | 484 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28560590 | 28560590 | PRJNA459724_P_NODE_2067_length_372_cov_2.011662_g1681_i0 | PRJNA459724 | 2067 | 372 | 2.011662 | 7.48338264 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 130 | 4.87e-36 | NR | MFA5405010.1 | 2053306 | g1681 | i0 | 52.9 | 0.959677419354839 | 119 | 34 | 96 | 1 | 1 | 357 | 36 | 132 | MFA5405010.1 D-Ala-D-Ala carboxypeptidase family metallohydrolase [Ignavibacteria bacterium] | diamond | 357 | 130 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28623812 | 28623812 | PRJNA459724_P_NODE_387_length_919_cov_2.501124_g246_i0 | PRJNA459724 | 387 | 919 | 2.501124 | 22.98532956 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 249 | 4.49e-78 | NR | MBV6514002.1 | 2651163 | g246 | i0 | 93.6 | 0.509249183895539 | 156 | 10 | 50.9 | 0 | 403 | 870 | 1 | 156 | MBV6514002.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 468 | 249 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28844445 | 28844445 | PRJNA459724_P_NODE_408_length_902_cov_2.315006_g70_i1 | PRJNA459724 | 408 | 902 | 2.315006 | 20.88135412 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 326 | 7.129999999999999e-110 | NR | MBV6513999.1 | 2651163 | g70 | i1 | 81.1 | 0.631929046563193 | 190 | 36 | 63.2 | 0 | 712 | 143 | 1 | 190 | MBV6513999.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 570 | 326 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 30266020 | 30266020 | PRJNA459724_P_NODE_4932_length_181_cov_1.546053_g4540_i0 | PRJNA459724 | 4932 | 181 | 1.546053 | 2.79835593 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 43.1 | 0.0037 | NR | MFA7287610.1 | 2614255 | g4540 | i0 | 33.3 | 0.895027624309392 | 54 | 35 | 87.8 | 1 | 23 | 181 | 38 | 91 | MFA7287610.1 hypothetical protein [Melioribacteraceae bacterium] | diamond | 162 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 31751175 | 31751175 | PRJNA459724_P_NODE_5777_length_154_cov_3.992000_g5385_i0 | PRJNA459724 | 5777 | 154 | 3.992 | 6.14768 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 112 | 1.91e-28 | NR | MBV6514005.1 | 2651163 | g5385 | i0 | 98 | 0.993506493506494 | 51 | 1 | 99.4 | 0 | 154 | 2 | 277 | 327 | MBV6514005.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 153 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 31972730 | 31972730 | PRJNA459724_P_NODE_138_length_1458_cov_2.183345_g70_i0 | PRJNA459724 | 138 | 1458 | 2.183345 | 31.8331701 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 326 | 4.229999999999999e-107 | NR | MBV6513999.1 | 2651163 | g70 | i0 | 81.1 | 0.390946502057613 | 190 | 36 | 39.1 | 0 | 167 | 736 | 1 | 190 | MBV6513999.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 570 | 326 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 32194309 | 32194309 | PRJNA459724_P_NODE_2658_length_306_cov_2.350181_g2267_i0 | PRJNA459724 | 2658 | 306 | 2.350181 | 7.19155386 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 143 | 1.39e-41 | NR | MFA5405010.1 | 2053306 | g2267 | i0 | 64.9 | 0.950980392156863 | 97 | 34 | 95.1 | 0 | 1 | 291 | 36 | 132 | MFA5405010.1 D-Ala-D-Ala carboxypeptidase family metallohydrolase [Ignavibacteria bacterium] | diamond | 291 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32257890 | 32257890 | PRJNA459724_P_NODE_78_length_1681_cov_2.555085_g33_i1 | PRJNA459724 | 78 | 1681 | 2.555085 | 42.95097885 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 331 | 1.68e-105 | NR | MBV6514003.1 | 2651163 | g33 | i1 | 100 | 0.274836406900654 | 154 | 0 | 27.5 | 0 | 1681 | 1220 | 209 | 362 | MBV6514003.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 462 | 331 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae 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);;