contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA929922" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 905581 | 905581 | PRJNA929922_P_NODE_111521_length_250_cov_0.870056_g110981_i0 | PRJNA929922 | 111521 | 250 | 0.870056 | 2.17514 | Akkermansia massiliensis | 2927224 | Bacteria | Bacteria | 457 | 4.1099999999999985e-124 | NTclustered | gi|1805957841|gb|CP029701.1| | 2927224 | g110981 | i0 | 99.6 | 99.832 | 250 | 1 | 100 | 0 | 1 | 250 | 946433 | 946682 | Akkermansia massiliensis strain EB-AMDK-40 chromosome, complete genome | blastn | 24958 | 457 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia massiliensis | |
| 2181346 | 2181346 | PRJNA929922_P_NODE_130362_length_247_cov_0.885057_g129822_i0 | PRJNA929922 | 130362 | 247 | 0.885057 | 2.18609079 | Opitutus terrae | 107709 | Bacteria | Bacteria | 207 | 4.4999999999999994e-49 | NTclustered | gi|177839040|gb|CP001032.1| | 452637 | g129822 | i0 | 82.553 | 0.951417004048583 | 235 | 41 | 95 | 0 | 13 | 247 | 1725396 | 1725162 | Opitutus terrae PB90-1, complete genome | blastn | 235 | 207 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 3805513 | 3805513 | PRJNA929922_P_NODE_122783_length_248_cov_0.880000_g122243_i0 | PRJNA929922 | 122783 | 248 | 0.88 | 2.1824 | Akkermansia | 239934 | Bacteria | Bacteria | 459 | 1.13e-124 | NTclustered | gi|2051350654|gb|CP072036.1| | 2927224 | g122243 | i0 | 100 | 99.6532258064516 | 248 | 0 | 100 | 0 | 1 | 248 | 1678452 | 1678699 | Akkermansia massiliensis strain Akk1573 chromosome, complete genome | blastn | 24714 | 459 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia massiliensis | |
| 7283587 | 7283587 | PRJNA929922_P_NODE_107646_length_251_cov_0.865169_g107106_i0 | PRJNA929922 | 107646 | 251 | 0.865169 | 2.17157419 | Akkermansia muciniphila | 239935 | Bacteria | Bacteria | 464 | 2.47e-126 | NTclustered | gi|1805906055|gb|CP027004.1| | 239935 | g107106 | i0 | 100 | 142.509960159363 | 251 | 0 | 100 | 0 | 1 | 251 | 1594854 | 1594604 | Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome | blastn | 35770 | 464 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia muciniphila | |
| 11109218 | 11109218 | PRJNA929922_P_NODE_113649_length_250_cov_0.870056_g113109_i0 | PRJNA929922 | 113649 | 250 | 0.870056 | 2.17514 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 159 | 1.3e-34 | NTclustered | gi|2874253974|emb|OY970299.1| | 412056 | g113109 | i0 | 84.81 | 1.048 | 158 | 24 | 63 | 0 | 92 | 249 | 3088179 | 3088336 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1 | blastn | 262 | 159 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 11109889 | 11109889 | PRJNA929922_P_NODE_146049_length_244_cov_0.900585_g145509_i0 | PRJNA929922 | 146049 | 244 | 0.900585 | 2.1974274 | Akkermansia massiliensis | 2927224 | Bacteria | Bacteria | 451 | 1.86e-122 | NTclustered | gi|1805957841|gb|CP029701.1| | 2927224 | g145509 | i0 | 100 | 49.5819672131148 | 244 | 0 | 100 | 0 | 1 | 244 | 1017972 | 1017729 | Akkermansia massiliensis strain EB-AMDK-40 chromosome, complete genome | blastn | 12098 | 451 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia massiliensis | |
| 12384617 | 12384617 | PRJNA929922_P_NODE_108170_length_251_cov_0.865169_g107630_i0 | PRJNA929922 | 108170 | 251 | 0.865169 | 2.17157419 | Nibricoccus sp. IMCC34717 | 3034021 | Bacteria | Bacteria | 178 | 3.6e-40 | NTclustered | gi|2850969968|gb|CP119759.1| | 3034021 | g107630 | i0 | 81.905 | 50.9402390438247 | 210 | 38 | 84 | 0 | 42 | 251 | 3211703 | 3211494 | Nibricoccus sp. IMCC34717 chromosome, complete genome | blastn | 12786 | 178 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Nibricoccus | Nibricoccus sp. IMCC34717 | |
| 17483834 | 17483834 | PRJNA929922_P_NODE_112194_length_250_cov_0.870056_g111654_i0 | PRJNA929922 | 112194 | 250 | 0.870056 | 2.17514 | Lacunisphaera limnophila | 1838286 | Bacteria | Bacteria | 351 | 1.99e-92 | NTclustered | gi|1070531674|gb|CP016094.1| | 1838286 | g111654 | i0 | 92 | 32.452 | 250 | 20 | 100 | 0 | 1 | 250 | 893305 | 893056 | Lacunisphaera limnophila strain IG16b, complete genome | blastn | 8113 | 351 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera limnophila | |
| 17485927 | 17485927 | PRJNA929922_P_NODE_91134_length_266_cov_1.595855_g90594_i0 | PRJNA929922 | 91134 | 266 | 1.595855 | 4.2449743 | Verrucomicrobia bacterium IMCC26134 | 1637999 | Bacteria | Bacteria | 298 | 2.8299999999999997e-76 | NTclustered | gi|807238858|gb|CP011265.1| | 1637999 | g90594 | i0 | 86.891 | 1.00375939849624 | 267 | 33 | 100 | 2 | 1 | 266 | 3439945 | 3440210 | Verrucomicrobia bacterium IMCC26134, complete genome | blastn | 267 | 298 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium IMCC26134 | |||||
| 20033144 | 20033144 | PRJNA929922_P_NODE_155336_length_242_cov_0.911243_g154796_i0 | PRJNA929922 | 155336 | 242 | 0.911243 | 2.20520806 | Akkermansia muciniphila | 239935 | Bacteria | Bacteria | 448 | 2.3799999999999995e-121 | NTclustered | gi|1554502134|gb|CP025835.1| | 239935 | g154796 | i0 | 100 | 99.8099173553719 | 242 | 0 | 100 | 0 | 1 | 242 | 2458307 | 2458066 | Akkermansia muciniphila strain EB-AMDK-20 chromosome, complete genome | blastn | 24154 | 448 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia muciniphila | |
| 22582968 | 22582968 | PRJNA929922_P_NODE_125498_length_248_cov_0.880000_g124958_i0 | PRJNA929922 | 125498 | 248 | 0.88 | 2.1824 | Lacunisphaera limnophila | 1838286 | Bacteria | Bacteria | 183 | 7.62e-42 | NTclustered | gi|1070531674|gb|CP016094.1| | 1838286 | g124958 | i0 | 81.333 | 0.907258064516129 | 225 | 42 | 91 | 0 | 7 | 231 | 4003631 | 4003407 | Lacunisphaera limnophila strain IG16b, complete genome | blastn | 225 | 183 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera limnophila | |
| 23858437 | 23858437 | PRJNA929922_P_NODE_133999_length_246_cov_0.890173_g133459_i0 | PRJNA929922 | 133999 | 246 | 0.890173 | 2.18982558 | Opitutus sp. GAS368 | 1882749 | Bacteria | Bacteria | 219 | 2.07e-52 | NTclustered | gi|1085764882|emb|LT629735.1| | 1882749 | g133459 | i0 | 82.857 | 75.4024390243902 | 245 | 40 | 99 | 2 | 1 | 244 | 522624 | 522381 | Opitutus sp. GAS368 genome assembly, chromosome: I | blastn | 18549 | 219 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. GAS368 | |
| 23858586 | 23858586 | PRJNA929922_P_NODE_141019_length_245_cov_0.895349_g140479_i0 | PRJNA929922 | 141019 | 245 | 0.895349 | 2.19360505 | Nibricoccus aquaticus | 2576891 | Bacteria | Bacteria | 207 | 4.46e-49 | NTclustered | gi|1243404978|gb|CP023344.1| | 2576891 | g140479 | i0 | 82.305 | 0.991836734693878 | 243 | 39 | 98 | 3 | 5 | 245 | 410576 | 410336 | Nibricoccus aquaticus strain HZ-65 chromosome, complete genome | blastn | 243 | 207 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Nibricoccus | Nibricoccus aquaticus | |
| 25132446 | 25132446 | PRJNA929922_P_NODE_144220_length_244_cov_0.900585_g143680_i0 | PRJNA929922 | 144220 | 244 | 0.900585 | 2.1974274 | Opitutia bacterium KCR 482 | 3034326 | Bacteria | Bacteria | 215 | 2.65e-51 | NTclustered | gi|2707273910|gb|CP149973.1| | 3034326 | g143680 | i0 | 82.731 | 2.11065573770492 | 249 | 35 | 100 | 6 | 1 | 244 | 1508250 | 1508005 | Opitutia bacterium KCR 482 chromosome, complete genome | blastn | 515 | 215 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium KCR 482 |
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);;