contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA283169" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2922427 | 2922427 | PRJNA283169_P_NODE_4403_length_201_cov_1.210526_g4340_i0 | PRJNA283169 | 4403 | 201 | 1.210526 | 2.43315726 | Luteolibacter sp. Populi | 3230487 | Bacteria | Bacteria | 355 | 1.19e-93 | NTclustered | gi|2774618348|gb|CP161812.1| | 3230487 | g4340 | i0 | 98.507 | 290.338308457711 | 201 | 3 | 100 | 0 | 1 | 201 | 1321144 | 1320944 | Luteolibacter sp. Populi chromosome, complete genome | blastn | 58358 | 355 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. Populi | |
| 3609536 | 3609536 | PRJNA283169_P_NODE_5463_length_183_cov_1.141791_g5400_i0 | PRJNA283169 | 5463 | 183 | 1.141791 | 2.08947753 | Methylacidiphilum (ex Ratnadevi et al. 2023) | 511745 | Bacteria | Bacteria | 209 | 8.74e-50 | NTclustered | gi|189184875|gb|CP000975.1| | 481448 | g5400 | i0 | 87.845 | 112.595628415301 | 181 | 18 | 98 | 4 | 1 | 179 | 894475 | 894297 | Methylacidiphilum infernorum V4, complete genome | blastn | 20605 | 209 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Methylacidiphilae | Methylacidiphilales | Methylacidiphilaceae | Methylacidiphilum (ex Ratnadevi et al. 2023) | Candidatus Methylacidiphilum infernorum | |
| 6749435 | 6749435 | PRJNA283169_P_NODE_1666_length_314_cov_1.132075_g1604_i0 | PRJNA283169 | 1666 | 314 | 1.132075 | 3.5547155 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 348 | 3.35e-91 | NTclustered | gi|226525339|gb|FJ872375.1| | 156588 | g1604 | i0 | 86.901 | 315.433121019108 | 313 | 38 | 99 | 2 | 2 | 314 | 27876 | 28185 | Uncultured Verrucomicrobia bacterium clone 286 genomic sequence | blastn | 99046 | 348 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 10575707 | 10575707 | PRJNA283169_P_NODE_269_length_801_cov_4.973404_g217_i0 | PRJNA283169 | 269 | 801 | 4.973404 | 39.83696604 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 898 | 0 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g217 | i0 | 88.073 | 279.205992509363 | 763 | 84 | 95 | 6 | 2 | 762 | 4718743 | 4717986 | Luteolibacter sp. SL250 chromosome | blastn | 223644 | 898 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 13125622 | 13125622 | PRJNA283169_P_NODE_5491_length_182_cov_1.563910_g5428_i0 | PRJNA283169 | 5491 | 182 | 1.56391 | 2.8463162 | Luteolibacter sp. AS25 | 3135776 | Bacteria | Bacteria | 335 | 1.3699999999999997e-87 | NTclustered | gi|2889346039|gb|CP151837.1| | 3135776 | g5428 | i0 | 100 | 274.56043956044 | 181 | 0 | 99 | 0 | 1 | 181 | 456786 | 456606 | Luteolibacter sp. AS25 chromosome, complete genome | blastn | 49970 | 335 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. AS25 | |
| 14400807 | 14400807 | PRJNA283169_P_NODE_7052_length_166_cov_0.880342_g6989_i0 | PRJNA283169 | 7052 | 166 | 0.880342 | 1.46136772 | Luteolibacter sp. LG18 | 2819286 | Bacteria | Bacteria | 219 | 1.3e-52 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g6989 | i0 | 90.419 | 47.3493975903614 | 167 | 14 | 100 | 2 | 1 | 166 | 2216675 | 2216840 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 7860 | 219 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 16361484 | 16361484 | PRJNA283169_P_NODE_5773_length_178_cov_1.310078_g5710_i0 | PRJNA283169 | 5773 | 178 | 1.310078 | 2.33193884 | root | 1 | Root_unresolved | Root_unresolved | 329 | 6.21e-86 | NTclustered | gi|1774728408|gb|MN684281.1| | 2736 | g5710 | i0 | 100 | 99.9550561797753 | 178 | 0 | 100 | 0 | 1 | 178 | 716 | 539 | Verrucomicrobium spinosum strain MT_SG_E_24_27F.27F 16S ribosomal RNA gene, partial sequence | blastn | 17792 | 329 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 18910419 | 18910419 | PRJNA283169_P_NODE_2495_length_261_cov_2.066038_g2433_i0 | PRJNA283169 | 2495 | 261 | 2.066038 | 5.39235918 | Verrucomicrobiales | 48461 | Bacteria | Bacteria | 200 | 8.029999999999999e-47 | NTclustered | gi|2240218473|gb|CP097283.1| | 239935 | g2433 | i0 | 82.609 | 264.275862068966 | 230 | 37 | 88 | 3 | 33 | 261 | 339980 | 339753 | Akkermansia muciniphila strain NB2A-8-WC chromosome | blastn | 68976 | 200 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia muciniphila |
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);;