contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA495917" and tax_phylum = "Abditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 477522 | 477522 | PRJNA495917_S_NODE_1561_length_382_cov_24.126801_g1367_i0 | PRJNA495917 | 1561 | 382 | 24.126801 | 92.16437982 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 401 | 3.139999999999999e-107 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g1367 | i0 | 85.825 | 637.994764397906 | 388 | 44 | 99 | 5 | 5 | 382 | 2852207 | 2851821 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 243714 | 401 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 1752491 | 1752491 | PRJNA495917_S_NODE_282_length_805_cov_41.559740_g54_i12 | PRJNA495917 | 282 | 805 | 41.55974 | 334.555907 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1109 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i12 | 91.584 | 240.211180124224 | 808 | 60 | 100 | 7 | 1 | 805 | 2852045 | 2851243 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 193370 | 1109 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 3028479 | 3028479 | PRJNA495917_S_NODE_4563_length_233_cov_23.833333_g4369_i0 | PRJNA495917 | 4563 | 233 | 23.833333 | 55.53166589 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 252 | 1.92e-62 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g4369 | i0 | 86.266 | 18.068669527897 | 233 | 31 | 100 | 1 | 1 | 233 | 2850957 | 2850726 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 4210 | 252 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 3028491 | 3028491 | PRJNA495917_S_NODE_523_length_632_cov_46.703518_g54_i16 | PRJNA495917 | 523 | 632 | 46.703518 | 295.16623376 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 926 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i16 | 93.103 | 234.776898734177 | 638 | 35 | 99 | 3 | 4 | 632 | 2851408 | 2852045 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 148379 | 926 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 4304282 | 4304282 | PRJNA495917_S_NODE_104_length_1197_cov_44.467298_g54_i2 | PRJNA495917 | 104 | 1197 | 44.467298 | 532.27355706 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1587 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i2 | 90.909 | 222.537176274018 | 1199 | 83 | 99 | 14 | 1 | 1196 | 2852045 | 2850870 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 266377 | 1587 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 4304399 | 4304399 | PRJNA495917_S_NODE_284_length_799_cov_39.443717_g54_i13 | PRJNA495917 | 284 | 799 | 39.443717 | 315.15529883 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1026 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i13 | 89.913 | 302.451814768461 | 803 | 72 | 100 | 8 | 1 | 799 | 2852045 | 2851248 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 241659 | 1026 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 4304401 | 4304401 | PRJNA495917_S_NODE_3044_length_281_cov_9.869919_g2850_i0 | PRJNA495917 | 3044 | 281 | 9.869919 | 27.73447239 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 219 | 2.41e-52 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g2850 | i0 | 81.55 | 86.846975088968 | 271 | 44 | 95 | 6 | 1 | 268 | 2850734 | 2851001 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 24404 | 219 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 5581081 | 5581081 | PRJNA495917_S_NODE_245_length_870_cov_135.741317_g54_i9 | PRJNA495917 | 245 | 870 | 135.741317 | 1180.9494579 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1142 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i9 | 90.493 | 298.188505747126 | 873 | 71 | 99 | 6 | 7 | 870 | 2851136 | 2852005 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 259424 | 1142 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 5581160 | 5581160 | PRJNA495917_S_NODE_865_length_502_cov_30.880086_g679_i0 | PRJNA495917 | 865 | 502 | 30.880086 | 155.01803172 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 462 | 1.91e-125 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g679 | i0 | 83.431 | 143.342629482072 | 513 | 69 | 100 | 10 | 1 | 502 | 2852328 | 2851821 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 71958 | 462 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 6855054 | 6855054 | PRJNA495917_S_NODE_12066_length_164_cov_114.023256_g11872_i0 | PRJNA495917 | 12066 | 164 | 114.023256 | 186.99813984 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 241 | 2.72e-59 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g11872 | i0 | 93.252 | 209.957317073171 | 163 | 11 | 99 | 0 | 2 | 164 | 2852935 | 2853097 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 34433 | 241 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 6855066 | 6855066 | PRJNA495917_S_NODE_126_length_1130_cov_42.921461_g54_i6 | PRJNA495917 | 126 | 1130 | 42.921461 | 485.0125093 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1659 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i6 | 93.146 | 239.065486725664 | 1138 | 67 | 99 | 5 | 2 | 1130 | 2850870 | 2852005 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 270144 | 1659 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 6855138 | 6855138 | PRJNA495917_S_NODE_206_length_919_cov_132.351810_g54_i8 | PRJNA495917 | 206 | 919 | 132.35181 | 1216.3131339 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1190 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i8 | 90.284 | 282.413492927095 | 916 | 80 | 99 | 8 | 1 | 913 | 2852045 | 2851136 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 259538 | 1190 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 8130489 | 8130489 | PRJNA495917_S_NODE_107_length_1179_cov_44.277972_g54_i3 | PRJNA495917 | 107 | 1179 | 44.277972 | 522.03728988 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1709 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i3 | 92.887 | 241.358778625954 | 1181 | 76 | 99 | 7 | 1 | 1178 | 2852045 | 2850870 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 284562 | 1709 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 9405464 | 9405464 | PRJNA495917_S_NODE_328_length_750_cov_37.034965_g54_i15 | PRJNA495917 | 328 | 750 | 37.034965 | 277.7622375 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 977 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i15 | 90.132 | 324.342666666667 | 760 | 63 | 100 | 6 | 1 | 750 | 2851248 | 2852005 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 243257 | 977 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 9405484 | 9405484 | PRJNA495917_S_NODE_4668_length_231_cov_31.734694_g4474_i0 | PRJNA495917 | 4668 | 231 | 31.734694 | 73.30714314 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 327 | 3.06e-85 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g4474 | i0 | 92.275 | 55.8268398268398 | 233 | 14 | 100 | 4 | 1 | 231 | 2850727 | 2850957 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 12896 | 327 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 14506230 | 14506230 | PRJNA495917_S_NODE_312_length_756_cov_39.314840_g54_i14 | PRJNA495917 | 312 | 756 | 39.31484 | 297.2201904 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1059 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i14 | 91.895 | 240.365079365079 | 765 | 51 | 100 | 5 | 1 | 756 | 2851243 | 2852005 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 181716 | 1059 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 14506289 | 14506289 | PRJNA495917_S_NODE_7872_length_189_cov_4.084416_g7678_i0 | PRJNA495917 | 7872 | 189 | 4.084416 | 7.71954624 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 250 | 5.36e-62 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g7678 | i0 | 90.476 | 131.566137566138 | 189 | 18 | 100 | 0 | 1 | 189 | 2852968 | 2853156 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 24866 | 250 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 15780107 | 15780107 | PRJNA495917_S_NODE_14713_length_155_cov_85.991667_g14519_i0 | PRJNA495917 | 14713 | 155 | 85.991667 | 133.28708385 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 259 | 7e-65 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g14519 | i0 | 96.774 | 188.096774193548 | 155 | 5 | 100 | 0 | 1 | 155 | 2853213 | 2853059 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 29155 | 259 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 19603358 | 19603358 | PRJNA495917_S_NODE_116_length_1154_cov_38.050045_g54_i4 | PRJNA495917 | 116 | 1154 | 38.050045 | 439.0975193 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1354 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i4 | 91.374 | 241.804159445407 | 997 | 75 | 86 | 10 | 1 | 993 | 2852045 | 2851056 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 279042 | 1354 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 20879297 | 20879297 | PRJNA495917_S_NODE_137_length_1105_cov_36.376636_g54_i7 | PRJNA495917 | 137 | 1105 | 36.376636 | 401.9618278 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1306 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i7 | 91.614 | 240.685067873303 | 954 | 66 | 85 | 8 | 162 | 1105 | 2851056 | 2852005 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 265957 | 1306 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 20879387 | 20879387 | PRJNA495917_S_NODE_4977_length_225_cov_38.036842_g4783_i0 | PRJNA495917 | 4977 | 225 | 38.036842 | 85.5828945 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 231 | 2.39e-56 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g4783 | i0 | 85.463 | 19.8177777777778 | 227 | 28 | 100 | 4 | 1 | 225 | 2850734 | 2850957 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 4459 | 231 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 23429837 | 23429837 | PRJNA495917_S_NODE_119_length_1148_cov_43.141060_g54_i5 | PRJNA495917 | 119 | 1148 | 43.14106 | 495.2593688 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1537 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i5 | 91.09 | 234.685540069686 | 1156 | 74 | 99 | 12 | 2 | 1148 | 2850870 | 2852005 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 269419 | 1537 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 23429918 | 23429918 | PRJNA495917_S_NODE_279_length_807_cov_42.316062_g54_i11 | PRJNA495917 | 279 | 807 | 42.316062 | 341.49062034 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1035 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g54 | i11 | 90.05 | 205.140024783147 | 804 | 72 | 99 | 7 | 5 | 804 | 2852207 | 2851408 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 165548 | 1035 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota 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);;