contig_metadata
13 rows where bioproject = "PRJEB64798" and tax_phylum = "Balneolota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12880830 | 12880830 | PRJEB64798_P_NODE_156231_length_185_cov_4.433824_g154465_i0 | PRJEB64798 | 156231 | 185 | 4.433824 | 8.2025744 | Cyclonatronum proteinivorum | 1457365 | Bacteria | Bacteria | 78.7 | 2.61e-10 | NTclustered | gi|1440892538|gb|CP027806.1| | 1457365 | g154465 | i0 | 76.506 | 48.4810810810811 | 166 | 25 | 86 | 12 | 2 | 160 | 1020559 | 1020717 | Candidatus Cyclonatronum proteinivorum strain Omega chromosome, complete genome | blastn | 8969 | 78.7 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Cyclonatronaceae | Cyclonatronum | Cyclonatronum proteinivorum | |
| 16704391 | 16704391 | PRJEB64798_P_NODE_189434_length_170_cov_9.297521_g187668_i0 | PRJEB64798 | 189434 | 170 | 9.297521 | 15.8057857 | Bacteria | 2 | Bacteria | Bacteria | 63.5 | 5.61e-10 | NR | WP_095605952.1 | 2032627 | g187668 | i0 | 75 | 14.8411764705882 | 40 | 10 | 70.6 | 0 | 2 | 121 | 43 | 82 | WP_095605952.1 DnaJ C-terminal domain-containing protein [Aliifodinibius salipaludis] | diamond | 2523 | 63.5 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Fodinibius | Fodinibius salipaludis | |
| 28928695 | 28928695 | PRJEB64798_P_NODE_79188_length_216_cov_3.467066_g77422_i0 | PRJEB64798 | 79188 | 216 | 3.467066 | 7.48886256 | Gracilimonas mengyeensis | 1302730 | Bacteria | Bacteria | 47.4 | 1.88e-4 | NR | WP_142454234.1 | 1302730 | g77422 | i0 | 57.6 | 2.26388888888889 | 33 | 14 | 45.8 | 0 | 101 | 3 | 54 | 86 | WP_142454234.1 VOC family protein [Gracilimonas mengyeensis] | diamond | 489 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas mengyeensis | |
| 29332165 | 29332165 | PRJEB64798_P_NODE_36089_length_328_cov_19.129032_g34330_i0 | PRJEB64798 | 36089 | 328 | 19.129032 | 62.74322496 | Bacteria | 2 | Bacteria | Bacteria | 100 | 2.0399999999999994e-24 | NR | MDX1619131.1 | 2053516 | g34330 | i0 | 48.3 | 1.63719512195122 | 89 | 46 | 81.4 | 0 | 272 | 6 | 43 | 131 | MDX1619131.1 Hsp20/alpha crystallin family protein [Balneolaceae bacterium] | diamond | 537 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 30216312 | 30216312 | PRJEB64798_P_NODE_243832_length_154_cov_2.428571_g242066_i0 | PRJEB64798 | 243832 | 154 | 2.428571 | 3.73999934 | Bacteria | 2 | Bacteria | Bacteria | 45.4 | 0.00121 | NR | WP_350213967.1 | 1974203 | g242066 | i0 | 47.4 | 3.85714285714286 | 38 | 20 | 74 | 0 | 25 | 138 | 118 | 155 | WP_350213967.1 hypothetical protein, partial [Gracilimonas sp.] | diamond | 594 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas sp. | |
| 30318822 | 30318822 | PRJEB64798_P_NODE_98492_length_212_cov_3.417178_g96726_i0 | PRJEB64798 | 98492 | 212 | 3.417178 | 7.24441736 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 104 | 4.17e-26 | NR | MEX0609417.1 | 2053516 | g96726 | i0 | 75.7 | 0.990566037735849 | 70 | 15 | 96.2 | 1 | 207 | 4 | 24 | 93 | MEX0609417.1 tetratricopeptide repeat protein [Balneolaceae bacterium] | diamond | 210 | 104 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 30539241 | 30539241 | PRJEB64798_P_NODE_176113_length_176_cov_2.692913_g174347_i0 | PRJEB64798 | 176113 | 176 | 2.692913 | 4.73952688 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 54.3 | 1.25e-6 | NR | TVQ66043.1 | 2053516 | g174347 | i0 | 82.1 | 0.477272727272727 | 28 | 5 | 47.7 | 0 | 86 | 169 | 33 | 60 | TVQ66043.1 MAG: phosphoenolpyruvate carboxykinase (GTP) [Balneolaceae bacterium] | diamond | 84 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 30879905 | 30879905 | PRJEB64798_P_NODE_87774_length_212_cov_10.773006_g86008_i0 | PRJEB64798 | 87774 | 212 | 10.773006 | 22.83877272 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62.4 | 3.65e-10 | NR | MBL6826167.1 | 2053516 | g86008 | i0 | 84.4 | 1.81132075471698 | 32 | 5 | 45.3 | 0 | 112 | 207 | 19 | 50 | MBL6826167.1 ribonuclease HI [Balneolaceae bacterium] | diamond | 384 | 62.8 | 0.993630573248408 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 31100957 | 31100957 | PRJEB64798_P_NODE_254035_length_150_cov_4.277228_g252269_i0 | PRJEB64798 | 254035 | 150 | 4.277228 | 6.415842 | Balneola | 455358 | Bacteria | Bacteria | 62.4 | 1.15e-9 | NR | WP_066221225.1 | 1849360 | g252269 | i0 | 60.4 | 4.8 | 48 | 17 | 96 | 1 | 6 | 149 | 263 | 308 | WP_066221225.1 FAD-dependent monooxygenase [Balneola sp. EhC07] | diamond | 720 | 62.8 | 0.993630573248408 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneola | Balneola sp. EhC07 | |
| 31265965 | 31265965 | PRJEB64798_P_NODE_107855_length_210_cov_14.714286_g106089_i0 | PRJEB64798 | 107855 | 210 | 14.714286 | 30.9000006 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 91.3 | 2.02e-19 | NR | MEX0906168.1 | 2053516 | g106089 | i0 | 67.2 | 0.957142857142857 | 67 | 20 | 95.7 | 1 | 201 | 1 | 395 | 459 | MEX0906168.1 site-specific DNA-methyltransferase [Balneolaceae bacterium] | diamond | 201 | 91.3 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 31385804 | 31385804 | PRJEB64798_P_NODE_185296_length_172_cov_3.715447_g183530_i0 | PRJEB64798 | 185296 | 172 | 3.715447 | 6.39056884 | Gracilimonas | 649462 | Bacteria | Bacteria | 87 | 3.54e-18 | NR | HKK25568.1 | 1974203 | g183530 | i0 | 66.1 | 1.95348837209302 | 56 | 19 | 97.7 | 0 | 2 | 169 | 285 | 340 | HKK25568.1 putative LPS assembly protein LptD [Gracilimonas sp.] | diamond | 336 | 87 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas sp. | |
| 31645364 | 31645364 | PRJEB64798_P_NODE_122717_length_204_cov_7.103226_g120951_i0 | PRJEB64798 | 122717 | 204 | 7.103226 | 14.49058104 | Balneolales bacterium | 2497613 | Bacteria | Bacteria | 44.3 | 5.87e-4 | NR | HKJ46406.1 | 2497613 | g120951 | i0 | 77.4 | 0.897058823529412 | 31 | 7 | 45.6 | 0 | 1 | 93 | 27 | 57 | HKJ46406.1 hypothetical protein [Balneolales bacterium] | diamond | 183 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolales bacterium | |||
| 32902494 | 32902494 | PRJEB64798_P_NODE_92840_length_212_cov_5.184049_g91074_i0 | PRJEB64798 | 92840 | 212 | 5.184049 | 10.99018388 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.5 | 0.0129 | NR | HLR90144.1 | 2053516 | g91074 | i0 | 54.8 | 2.09433962264151 | 31 | 14 | 43.9 | 0 | 8 | 100 | 197 | 227 | HLR90144.1 Fe(3+) ABC transporter substrate-binding protein [Balneolaceae bacterium] | diamond | 444 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae 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);;