contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA326068" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 389421 | 389421 | PRJNA326068_P_NODE_12401_length_262_cov_680.416309_g11438_i0 | PRJNA326068 | 12401 | 262 | 680.416309 | 1782.69072958 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 374 | 4.49e-99 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g11438 | i0 | 92.366 | 143.202290076336 | 262 | 20 | 100 | 0 | 1 | 262 | 2852955 | 2853216 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 37519 | 374 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 389448 | 389448 | PRJNA326068_P_NODE_2921_length_644_cov_15.495935_g656_i4 | PRJNA326068 | 2921 | 644 | 15.495935 | 99.7938214 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1040 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g656 | i4 | 95.82 | 280.299689440994 | 646 | 23 | 100 | 4 | 1 | 644 | 2851177 | 2851820 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 180513 | 1040 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 1664116 | 1664116 | PRJNA326068_P_NODE_10582_length_302_cov_46.604396_g9621_i0 | PRJNA326068 | 10582 | 302 | 46.604396 | 140.74527592 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 492 | 1.4e-134 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g9621 | i0 | 96.026 | 588.990066225166 | 302 | 12 | 100 | 0 | 1 | 302 | 2853593 | 2853292 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 177875 | 492 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 1664149 | 1664149 | PRJNA326068_P_NODE_2702_length_668_cov_59.143975_g2105_i0 | PRJNA326068 | 2702 | 668 | 59.143975 | 395.081753 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 795 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g2105 | i0 | 89.871 | 241.47005988024 | 622 | 58 | 93 | 4 | 2 | 621 | 2851786 | 2852404 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 161302 | 795 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 4216743 | 4216743 | PRJNA326068_P_NODE_4504_length_520_cov_19.054990_g3721_i0 | PRJNA326068 | 4504 | 520 | 19.05499 | 99.085948 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 390 | 9.51e-104 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g3721 | i0 | 81.992 | 179.692307692308 | 472 | 73 | 90 | 11 | 48 | 516 | 2851016 | 2851478 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 93440 | 390 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 15692143 | 15692143 | PRJNA326068_P_NODE_993_length_1031_cov_14.017964_g656_i1 | PRJNA326068 | 993 | 1031 | 14.017964 | 144.52520884 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1561 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g656 | i1 | 94.01 | 436.74684772066 | 1035 | 54 | 100 | 8 | 1 | 1031 | 2850723 | 2851753 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 450286 | 1561 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 18241060 | 18241060 | PRJNA326068_P_NODE_1875_length_788_cov_10.330698_g656_i3 | PRJNA326068 | 1875 | 788 | 10.330698 | 81.40590024 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1002 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g656 | i3 | 94.351 | 380.166243654822 | 655 | 33 | 83 | 4 | 1 | 653 | 2851753 | 2851101 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 299571 | 1002 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 18241078 | 18241078 | PRJNA326068_P_NODE_6655_length_419_cov_23.035897_g5740_i0 | PRJNA326068 | 6655 | 419 | 23.035897 | 96.52040843 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 370 | 9.8e-98 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g5740 | i0 | 84.375 | 177.90692124105 | 384 | 52 | 91 | 7 | 5 | 386 | 2851478 | 2851101 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 74543 | 370 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 22065904 | 22065904 | PRJNA326068_P_NODE_938_length_1053_cov_12.531250_g656_i0 | PRJNA326068 | 938 | 1053 | 12.53125 | 131.9540625 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1506 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g656 | i0 | 92.519 | 455.194681861349 | 1056 | 72 | 100 | 7 | 1 | 1053 | 2850702 | 2851753 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 479320 | 1506 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 23341318 | 23341318 | PRJNA326068_P_NODE_1199_length_959_cov_33.246237_g656_i2 | PRJNA326068 | 1199 | 959 | 33.246237 | 318.83141283 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 1175 | 0 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g656 | i2 | 95.405 | 326.502606882169 | 740 | 30 | 77 | 4 | 222 | 959 | 2851016 | 2851753 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 313116 | 1175 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 24615527 | 24615527 | PRJNA326068_P_NODE_17940_length_181_cov_25.078947_g16977_i0 | PRJNA326068 | 17940 | 181 | 25.078947 | 45.39289407 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 230 | 6.62e-56 | NTclustered | gi|2215576334|dbj|AP024152.1| | 2783868 | g16977 | i0 | 90.055 | 256.005524861878 | 181 | 12 | 100 | 2 | 1 | 181 | 2853524 | 2853350 | Abditibacteriota bacterium IAD-21 DNA, complete genome | blastn | 46337 | 230 | 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);;