contig_metadata
20 rows where bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2547232 | 2547232 | PRJNA983848_P_NODE_55222_length_451_cov_3.878307_g49343_i0 | PRJNA983848 | 55222 | 451 | 3.878307 | 17.49116457 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 388 | 2.93e-103 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g49343 | i0 | 83.765 | 2.81152993348115 | 425 | 54 | 92 | 13 | 1 | 413 | 1683841 | 1683420 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 1268 | 388 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 8623314 | 8623314 | PRJNA983848_P_NODE_68027_length_385_cov_4.695513_g62144_i0 | PRJNA983848 | 68027 | 385 | 4.695513 | 18.07772505 | Horticoccus luteus | 2862869 | Bacteria | Bacteria | 235 | 3.3999999999999996e-57 | NTclustered | gi|2077391884|gb|CP080507.1| | 2862869 | g62144 | i0 | 82.131 | 3.64935064935065 | 291 | 37 | 74 | 11 | 28 | 311 | 2448360 | 2448642 | Horticoccus luteus strain KSB-15 chromosome, complete genome | blastn | 1405 | 235 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Horticoccus | Horticoccus luteus | |
| 9899558 | 9899558 | PRJNA983848_P_NODE_96288_length_309_cov_4.470339_g90405_i0 | PRJNA983848 | 96288 | 309 | 4.470339 | 13.81334751 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 409 | 1.4899999999999998e-109 | NTclustered | gi|2836248208|gb|CP121322.1| | 1962973 | g90405 | i0 | 90.615 | 283.313915857605 | 309 | 28 | 100 | 1 | 1 | 309 | 1010648 | 1010955 | MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome | blastn | 87544 | 409 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 11171837 | 11171837 | PRJNA983848_P_NODE_167269_length_207_cov_6.641791_g161386_i0 | PRJNA983848 | 167269 | 207 | 6.6417909999999996 | 13.74850737 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 209 | 1.02e-49 | NTclustered | gi|2836248208|gb|CP121322.1| | 1962973 | g161386 | i0 | 87.027 | 387.666666666667 | 185 | 24 | 89 | 0 | 18 | 202 | 1010122 | 1010306 | MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome | blastn | 80247 | 209 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 12445648 | 12445648 | PRJNA983848_P_NODE_110310_length_286_cov_2.201878_g104427_i0 | PRJNA983848 | 110310 | 286 | 2.201878 | 6.29737108 | Oceaniferula spumae | 2979115 | Bacteria | Bacteria | 339 | 1.8099999999999997e-88 | NTclustered | gi|2753272999|dbj|AP026866.1| | 2979115 | g104427 | i0 | 88.194 | 289.038461538462 | 288 | 29 | 100 | 5 | 1 | 286 | 831118 | 831402 | Verrucomicrobiaceae bacterium NT6N DNA, complete genome | blastn | 82665 | 339 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Oceaniferula | Oceaniferula spumae | |
| 13721490 | 13721490 | PRJNA983848_P_NODE_150951_length_246_cov_1.699422_g145068_i0 | PRJNA983848 | 150951 | 246 | 1.699422 | 4.18057812 | Sulfuriroseicoccus oceanibius | 2707525 | Bacteria | Bacteria | 202 | 2.08e-47 | NTclustered | gi|1953472588|gb|CP066776.1| | 2707525 | g145068 | i0 | 85.864 | 158.642276422764 | 191 | 25 | 81 | 2 | 41 | 230 | 632567 | 632378 | Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome | blastn | 39026 | 202 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Sulfuriroseicoccus | Sulfuriroseicoccus oceanibius | |
| 14999271 | 14999271 | PRJNA983848_P_NODE_95752_length_310_cov_3.928270_g89869_i0 | PRJNA983848 | 95752 | 310 | 3.92827 | 12.177637 | Roseibacillus persicicus | 454148 | Bacteria | Bacteria | 425 | 1.48e-114 | NTclustered | gi|2889362999|gb|CP151838.1| | 454148 | g89869 | i0 | 92.079 | 277.387096774194 | 303 | 22 | 97 | 2 | 9 | 310 | 781229 | 780928 | Roseibacillus persicicus strain AS69 chromosome, complete genome | blastn | 85990 | 425 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseibacillus | Roseibacillus persicicus | |
| 15299401 | 15299401 | PRJNA983848_P_NODE_16992_length_1451_cov_2.474601_g12995_i0 | PRJNA983848 | 16992 | 1451 | 2.474601 | 35.90646051 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 1463 | 0 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g12995 | i0 | 85.237 | 141.075809786354 | 1436 | 196 | 98 | 15 | 26 | 1451 | 1452 | 23 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 204701 | 1463 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 17546362 | 17546362 | PRJNA983848_P_NODE_167714_length_199_cov_5.666667_g161831_i0 | PRJNA983848 | 167714 | 199 | 5.666667 | 11.27666733 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 351 | 1.52e-92 | NTclustered | gi|511202471|gb|KC994702.1| | 156588 | g161831 | i0 | 98.492 | 100.226130653266 | 199 | 3 | 100 | 0 | 1 | 199 | 1227 | 1425 | Uncultured Verrucomicrobia bacterium clone BF 022 16S ribosomal RNA gene, partial sequence | blastn | 19945 | 351 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 20097752 | 20097752 | PRJNA983848_P_NODE_95216_length_311_cov_4.726891_g89333_i0 | PRJNA983848 | 95216 | 311 | 4.726891 | 14.70063101 | Horticoccus luteus | 2862869 | Bacteria | Bacteria | 222 | 2.09e-53 | NTclustered | gi|2077391884|gb|CP080507.1| | 2862869 | g89333 | i0 | 79.936 | 1.0096463022508 | 314 | 54 | 99 | 7 | 1 | 309 | 221150 | 221459 | Horticoccus luteus strain KSB-15 chromosome, complete genome | blastn | 314 | 222 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Horticoccus | Horticoccus luteus | |
| 21371166 | 21371166 | PRJNA983848_P_NODE_33097_length_729_cov_2.963415_g27409_i0 | PRJNA983848 | 33097 | 729 | 2.963415 | 21.60329535 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 1214 | 0 | NTclustered | gi|511202471|gb|KC994702.1| | 156588 | g27409 | i0 | 96.712 | 98.4156378600823 | 730 | 22 | 100 | 2 | 1 | 729 | 31 | 759 | Uncultured Verrucomicrobia bacterium clone BF 022 16S ribosomal RNA gene, partial sequence | blastn | 71745 | 1214 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 23921435 | 23921435 | PRJNA983848_P_NODE_29619_length_818_cov_32.923490_g24105_i0 | PRJNA983848 | 29619 | 818 | 32.92349 | 269.3141482 | Opitutus terrae | 107709 | Bacteria | Bacteria | 802 | 0 | NTclustered | gi|177839040|gb|CP001032.1| | 452637 | g24105 | i0 | 84.643 | 6.01222493887531 | 827 | 104 | 99 | 18 | 2 | 818 | 4393741 | 4392928 | Opitutus terrae PB90-1, complete genome | blastn | 4918 | 802 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 27531923 | 27531923 | PRJNA983848_P_NODE_96923_length_308_cov_2.119149_g91040_i0 | PRJNA983848 | 96923 | 308 | 2.119149 | 6.52697892 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 42.7 | 0.0212 | NR | HXT83479.1 | 2499141 | g91040 | i0 | 47.5 | 0.38961038961039 | 40 | 21 | 39 | 0 | 150 | 31 | 55 | 94 | HXT83479.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 120 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 28194778 | 28194778 | PRJNA983848_P_NODE_155366_length_244_cov_1.309942_g149483_i0 | PRJNA983848 | 155366 | 244 | 1.309942 | 3.19625848 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 47.8 | 6.2e-4 | NR | MEO0454925.1 | 2026799 | g149483 | i0 | 47.8 | 0.565573770491803 | 46 | 23 | 56.6 | 1 | 173 | 36 | 175 | 219 | MEO0454925.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 138 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28289525 | 28289525 | PRJNA983848_P_NODE_160106_length_242_cov_0.923077_g154223_i0 | PRJNA983848 | 160106 | 242 | 0.923077 | 2.23384634 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 123 | 6.2e-33 | NR | NDF17446.1 | 2026799 | g154223 | i0 | 69.1 | 1.00413223140496 | 81 | 24 | 99.2 | 1 | 3 | 242 | 91 | 171 | NDF17446.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 243 | 123 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28605430 | 28605430 | PRJNA983848_P_NODE_60167_length_421_cov_1.979885_g54285_i0 | PRJNA983848 | 60167 | 421 | 1.979885 | 8.33531585 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 45.1 | 0.0284 | NR | TMP98142.1 | 2026799 | g54285 | i0 | 51.3 | 0.27790973871734 | 39 | 18 | 27.8 | 1 | 114 | 230 | 183 | 220 | TMP98142.1 MAG: prepilin-type N-terminal cleavage/methylation domain-containing protein [Verrucomicrobiota bacterium] | diamond | 117 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28763175 | 28763175 | PRJNA983848_P_NODE_145067_length_249_cov_1.534091_g139184_i0 | PRJNA983848 | 145067 | 249 | 1.534091 | 3.81988659 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 43.9 | 0.015 | NR | HTX58466.1 | 2499141 | g139184 | i0 | 54.1 | 0.44578313253012 | 37 | 14 | 41 | 1 | 63 | 164 | 311 | 347 | HTX58466.1 DUF1565 domain-containing protein [Verrucomicrobiia bacterium] | diamond | 111 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29931764 | 29931764 | PRJNA983848_P_NODE_159711_length_242_cov_0.923077_g153828_i0 | PRJNA983848 | 159711 | 242 | 0.923077 | 2.23384634 | Candidatus Didemnitutus sp. | 2814259 | Bacteria | Bacteria | 130 | 3.18e-33 | NR | HET7535355.1 | 2814259 | g153828 | i0 | 76.3 | 0.991735537190083 | 80 | 19 | 99.2 | 0 | 2 | 241 | 126 | 205 | HET7535355.1 SulP family inorganic anion transporter [Candidatus Didemnitutus sp.] | diamond | 240 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Candidatus Didemnitutus | Candidatus Didemnitutus sp. | |
| 30342830 | 30342830 | PRJNA983848_P_NODE_143632_length_250_cov_0.881356_g137749_i0 | PRJNA983848 | 143632 | 250 | 0.881356 | 2.20339 | Opitutus terrae | 107709 | Bacteria | Bacteria | 58.2 | 1.53e-7 | NR | WP_012374816.1 | 107709 | g137749 | i0 | 49.3 | 0.804 | 67 | 34 | 80.4 | 0 | 222 | 22 | 718 | 784 | WP_012374816.1 hypothetical protein [Opitutus terrae] | diamond | 201 | 58.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 31353558 | 31353558 | PRJNA983848_P_NODE_114356_length_281_cov_1.307692_g108473_i0 | PRJNA983848 | 114356 | 281 | 1.307692 | 3.67461452 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 46.2 | 0.00362 | NR | MBI4661175.1 | 2026799 | g108473 | i0 | 36.2 | 0.736654804270463 | 69 | 39 | 68.3 | 2 | 202 | 11 | 704 | 772 | MBI4661175.1 TonB-dependent receptor [Verrucomicrobiota bacterium] | diamond | 207 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota 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);;