contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 595631 | 595631 | PRJNA615351_P_NODE_168141_length_167_cov_1.818182_g154041_i0 | PRJNA615351 | 168141 | 167 | 1.818182 | 3.03636394 | uncultured Ruficoccus sp. | 2175960 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|2907625958|emb|OZ223518.1| | 2175960 | g154041 | i0 | 100 | 0.173652694610778 | 29 | 0 | 17 | 0 | 28 | 56 | 38626 | 38654 | MAG: uncultured Ruficoccus sp. isolate b2a3d85c-2e17-47e2-9e32-7ac6437316b9 genome assembly, chromosome: 47 | blastn | 29 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Cerasicoccaceae | Ruficoccus | uncultured Ruficoccus sp. | |
| 595981 | 595981 | PRJNA615351_P_NODE_88521_length_373_cov_3.195266_g74444_i0 | PRJNA615351 | 88521 | 373 | 3.195266 | 11.91834218 | Verrucomicrobium spinosum | 2736 | Bacteria | Bacteria | 379 | 1.43e-100 | NTclustered | gi|12583973|gb|AF245377.1| | 240016 | g74444 | i0 | 85.955 | 467.02144772118 | 356 | 48 | 95 | 2 | 18 | 373 | 1473 | 1120 | Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence | blastn | 174199 | 379 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 1149929 | 1149929 | PRJNA615351_P_NODE_122961_length_242_cov_3.400966_g108861_i0 | PRJNA615351 | 122961 | 242 | 3.400966 | 8.23033772 | Verrucomicrobiaceae | 203557 | Bacteria | Bacteria | 300 | 7.05e-77 | NTclustered | gi|183579826|emb|AM905423.1| | 48465 | g108861 | i0 | 90.749 | 260.487603305785 | 227 | 18 | 93 | 2 | 9 | 234 | 876 | 1100 | Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251 | blastn | 63038 | 300 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter dejongeii | |
| 8248759 | 8248759 | PRJNA615351_P_NODE_158567_length_178_cov_2.307692_g144467_i0 | PRJNA615351 | 158567 | 178 | 2.307692 | 4.10769176 | Luteolibacter sp. AS25 | 3135776 | Bacteria | Bacteria | 278 | 2.28e-70 | NTclustered | gi|2889346039|gb|CP151837.1| | 3135776 | g144467 | i0 | 94.915 | 139.23595505618 | 177 | 9 | 99 | 0 | 2 | 178 | 454480 | 454656 | Luteolibacter sp. AS25 chromosome, complete genome | blastn | 24784 | 278 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. AS25 | |
| 8248837 | 8248837 | PRJNA615351_P_NODE_183827_length_153_cov_1.016949_g169727_i0 | PRJNA615351 | 183827 | 153 | 1.016949 | 1.55593197 | Verrucomicrobia bacterium IMCC26134 | 1637999 | Bacteria | Bacteria | 141 | 2.6e-29 | NTclustered | gi|807238858|gb|CP011265.1| | 1637999 | g169727 | i0 | 83.553 | 6.52287581699346 | 152 | 23 | 99 | 2 | 3 | 153 | 1902875 | 1903025 | Verrucomicrobia bacterium IMCC26134, complete genome | blastn | 998 | 141 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium IMCC26134 | |||||
| 8802888 | 8802888 | PRJNA615351_P_NODE_184747_length_152_cov_1.367521_g170647_i0 | PRJNA615351 | 184747 | 152 | 1.367521 | 2.07863192 | Prosthecobacter | 48463 | Bacteria | Bacteria | 204 | 3.2399999999999996e-48 | NTclustered | gi|12583974|gb|AF245378.1|AF245378 | 48464 | g170647 | i0 | 90.789 | 20.9342105263158 | 152 | 14 | 100 | 0 | 1 | 152 | 1266 | 1417 | Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence | blastn | 3182 | 204 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter fusiformis | |
| 12074834 | 12074834 | PRJNA615351_P_NODE_129490_length_227_cov_1.656250_g115390_i0 | PRJNA615351 | 129490 | 227 | 1.65625 | 3.7596875 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 364 | 2.289999999999999e-96 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g115390 | i0 | 95.595 | 85.1189427312775 | 227 | 10 | 100 | 0 | 1 | 227 | 5153589 | 5153363 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 19322 | 364 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 12074985 | 12074985 | PRJNA615351_P_NODE_183510_length_153_cov_1.355932_g169410_i0 | PRJNA615351 | 183510 | 153 | 1.355932 | 2.07457596 | Prosthecobacter fusiformis | 48464 | Bacteria | Bacteria | 219 | 1.1699999999999999e-52 | NTclustered | gi|12583974|gb|AF245378.1|AF245378 | 48464 | g169410 | i0 | 92.763 | 31.3725490196078 | 152 | 9 | 99 | 2 | 1 | 151 | 494 | 344 | Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence | blastn | 4800 | 219 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter fusiformis | |
| 13350157 | 13350157 | PRJNA615351_P_NODE_92271_length_353_cov_10.512579_g78186_i0 | PRJNA615351 | 92271 | 353 | 10.512579 | 37.10940387 | Luteolibacter ambystomatis | 2824561 | Bacteria | Bacteria | 316 | 1.0699999999999999e-81 | NTclustered | gi|2029343589|gb|CP073100.1| | 2824561 | g78186 | i0 | 83.918 | 268.818696883853 | 342 | 44 | 96 | 9 | 15 | 353 | 276757 | 276424 | Luteolibacter ambystomatis strain 32A chromosome, complete genome | blastn | 94893 | 316 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter ambystomatis | |
| 13903944 | 13903944 | PRJNA615351_P_NODE_68211_length_517_cov_2.417012_g54405_i0 | PRJNA615351 | 68211 | 517 | 2.417012 | 12.49595204 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 856 | 0 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g54405 | i0 | 96.518 | 43.9555125725338 | 517 | 18 | 100 | 0 | 1 | 517 | 5153352 | 5152836 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 22725 | 856 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 14624397 | 14624397 | PRJNA615351_P_NODE_125632_length_236_cov_1.432836_g111532_i0 | PRJNA615351 | 125632 | 236 | 1.432836 | 3.38149296 | Verrucomicrobium spinosum | 2736 | Bacteria | Bacteria | 320 | 5.26e-83 | NTclustered | gi|12583973|gb|AF245377.1| | 240016 | g111532 | i0 | 91.102 | 111.088983050847 | 236 | 19 | 99 | 2 | 1 | 235 | 644 | 878 | Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence | blastn | 26217 | 320 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 14624412 | 14624412 | PRJNA615351_P_NODE_129512_length_227_cov_1.609375_g115412_i0 | PRJNA615351 | 129512 | 227 | 1.609375 | 3.65328125 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 379 | 8.169999999999999e-101 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g115412 | i0 | 96.903 | 286.74449339207 | 226 | 7 | 99 | 0 | 1 | 226 | 2201 | 1976 | Luteolibacter sp. SL250 chromosome | blastn | 65091 | 379 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 22272791 | 22272791 | PRJNA615351_P_NODE_160578_length_176_cov_1.404255_g146478_i0 | PRJNA615351 | 160578 | 176 | 1.404255 | 2.4714888 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 268 | 1.3499999999999999e-67 | NTclustered | gi|2836248208|gb|CP121322.1| | 1962973 | g146478 | i0 | 94.767 | 265.869318181818 | 172 | 9 | 98 | 0 | 5 | 176 | 1008811 | 1008982 | MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome | blastn | 46793 | 268 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 23548001 | 23548001 | PRJNA615351_P_NODE_110719_length_278_cov_1.292181_g96620_i0 | PRJNA615351 | 110719 | 278 | 1.292181 | 3.5922631799999998 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 243 | 1.41e-59 | NTclustered | gi|2874253952|emb|OY970277.1| | 412056 | g96620 | i0 | 85.714 | 43.3705035971223 | 238 | 25 | 84 | 9 | 12 | 244 | 2749626 | 2749859 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 | blastn | 12057 | 243 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae 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);;