contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA917598" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2171911 | 2171911 | PRJNA917598_P_NODE_62_length_7680_cov_5.048639_g49_i0 | PRJNA917598 | 62 | 7680 | 5.048639 | 387.7354752 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 1982 | 0 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g49 | i0 | 76.228 | 8.23619791666667 | 3929 | 826 | 93 | 89 | 150 | 4024 | 883440 | 887314 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 63254 | 1982 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 8548231 | 8548231 | PRJNA917598_P_NODE_12867_length_659_cov_2.848123_g11940_i0 | PRJNA917598 | 12867 | 659 | 2.848123 | 18.76913057 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 470 | 1.53e-127 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g11940 | i0 | 79.784 | 0.983308042488619 | 648 | 129 | 98 | 2 | 12 | 658 | 1202326 | 1201680 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 648 | 470 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 8549186 | 8549186 | PRJNA917598_P_NODE_51267_length_320_cov_0.935223_g50323_i0 | PRJNA917598 | 51267 | 320 | 0.935223 | 2.9927136 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 137 | 8.05e-28 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g50323 | i0 | 75.704 | 1.0625 | 284 | 63 | 88 | 6 | 16 | 296 | 706509 | 706789 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 340 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 9824023 | 9824023 | PRJNA917598_P_NODE_4748_length_1132_cov_37.713881_g4081_i0 | PRJNA917598 | 4748 | 1132 | 37.713881 | 426.92113292 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 316 | 3.7e-81 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g4081 | i0 | 75.61 | 13.1757950530035 | 697 | 138 | 60 | 25 | 53 | 733 | 1294764 | 1294084 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 14915 | 316 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 11099233 | 11099233 | PRJNA917598_P_NODE_3089_length_1426_cov_3.756098_g2558_i0 | PRJNA917598 | 3089 | 1426 | 3.756098 | 53.56195748 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 857 | 0 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g2558 | i0 | 80.363 | 13.4502103786816 | 1156 | 205 | 80 | 17 | 281 | 1425 | 1126809 | 1127953 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 19180 | 857 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 12374785 | 12374785 | PRJNA917598_P_NODE_26950_length_444_cov_24.897574_g26006_i0 | PRJNA917598 | 26950 | 444 | 24.897574 | 110.54522856 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 219 | 4e-52 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g26006 | i0 | 78.426 | 0.837837837837838 | 343 | 68 | 77 | 6 | 15 | 354 | 70367 | 70028 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 372 | 219 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 12375061 | 12375061 | PRJNA917598_P_NODE_3830_length_1265_cov_2.104866_g3235_i0 | PRJNA917598 | 3830 | 1265 | 2.104866 | 26.6265549 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 279 | 5.45e-70 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g3235 | i0 | 71.452 | 0.980237154150198 | 1240 | 301 | 96 | 45 | 47 | 1264 | 183872 | 182664 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 1240 | 279 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 20022512 | 20022512 | PRJNA917598_P_NODE_34616_length_390_cov_1.943218_g33672_i0 | PRJNA917598 | 34616 | 390 | 1.943218 | 7.5785502 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 145 | 5.98e-30 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g33672 | i0 | 83.019 | 1.71538461538462 | 159 | 27 | 41 | 0 | 56 | 214 | 1256508 | 1256666 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 669 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 20022569 | 20022569 | PRJNA917598_P_NODE_36_length_8899_cov_55.450600_g25_i0 | PRJNA917598 | 36 | 8899 | 55.4506 | 4934.548894 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 1646 | 0 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g25 | i0 | 76.242 | 1.5863580177548 | 3321 | 663 | 37 | 101 | 2075 | 5323 | 861545 | 858279 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 14117 | 1646 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 21297557 | 21297557 | PRJNA917598_P_NODE_2397_length_1625_cov_4.304768_g1970_i0 | PRJNA917598 | 2397 | 1625 | 4.304768 | 69.95248 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 658 | 0 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g1970 | i0 | 78.827 | 0.619076923076923 | 1006 | 191 | 61 | 16 | 10 | 1007 | 1195827 | 1196818 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 1006 | 658 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 22573163 | 22573163 | PRJNA917598_P_NODE_46478_length_336_cov_2.893536_g45534_i0 | PRJNA917598 | 46478 | 336 | 2.893536 | 9.72228096 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 233 | 1.0499999999999998e-56 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g45534 | i0 | 83.088 | 104.482142857143 | 272 | 30 | 80 | 14 | 17 | 284 | 892916 | 893175 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 35106 | 233 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 |
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);;