contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3157879 | 3157879 | PRJNA635874_P_NODE_21583_length_343_cov_0.855556_g21436_i0 | PRJNA635874 | 21583 | 343 | 0.855556 | 2.93455708 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 263 | 1.3800000000000001e-65 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g21436 | i0 | 82.781 | 0.880466472303207 | 302 | 44 | 87 | 8 | 46 | 343 | 485341 | 485638 | Luteolibacter sp. SL250 chromosome | blastn | 302 | 263 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 3159115 | 3159115 | PRJNA635874_P_NODE_68623_length_243_cov_0.864706_g68476_i0 | PRJNA635874 | 68623 | 243 | 0.864706 | 2.10123558 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 250 | 7.2399999999999995e-62 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g68476 | i0 | 85.185 | 1.76543209876543 | 243 | 36 | 100 | 0 | 1 | 243 | 2500034 | 2500276 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 429 | 250 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 5711593 | 5711593 | PRJNA635874_P_NODE_56565_length_247_cov_0.885057_g56418_i0 | PRJNA635874 | 56565 | 247 | 0.885057 | 2.18609079 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 374 | 4.189999999999998e-99 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g56418 | i0 | 93.927 | 91.6761133603239 | 247 | 15 | 100 | 0 | 1 | 247 | 2448460 | 2448706 | Luteolibacter sp. SL250 chromosome | blastn | 22644 | 374 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 8260774 | 8260774 | PRJNA635874_P_NODE_41547_length_264_cov_1.549738_g41400_i0 | PRJNA635874 | 41547 | 264 | 1.549738 | 4.0913083200000004 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 207 | 4.86e-49 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g41400 | i0 | 81.226 | 0.988636363636364 | 261 | 45 | 98 | 3 | 1 | 259 | 4498856 | 4499114 | Luteolibacter sp. SL250 chromosome | blastn | 261 | 207 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 8261409 | 8261409 | PRJNA635874_P_NODE_67867_length_243_cov_0.905882_g67720_i0 | PRJNA635874 | 67867 | 243 | 0.905882 | 2.20129326 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 300 | 7.08e-77 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g67720 | i0 | 88.98 | 1.16049382716049 | 245 | 23 | 100 | 4 | 1 | 243 | 672582 | 672824 | Luteolibacter sp. SL250 chromosome | blastn | 282 | 300 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 10812024 | 10812024 | PRJNA635874_P_NODE_51269_length_249_cov_0.875000_g51122_i0 | PRJNA635874 | 51269 | 249 | 0.875 | 2.17875 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 379 | 9.1e-101 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g51122 | i0 | 94.672 | 0.979919678714859 | 244 | 13 | 98 | 0 | 6 | 249 | 2583217 | 2583460 | Luteolibacter sp. SL250 chromosome | blastn | 244 | 379 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 10812381 | 10812381 | PRJNA635874_P_NODE_67029_length_243_cov_0.905882_g66882_i0 | PRJNA635874 | 67029 | 243 | 0.905882 | 2.20129326 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 322 | 1.51e-83 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g66882 | i0 | 90.535 | 40.4485596707819 | 243 | 23 | 100 | 0 | 1 | 243 | 1317258 | 1317016 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 9829 | 322 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 13361895 | 13361895 | PRJNA635874_P_NODE_48411_length_250_cov_1.644068_g48264_i0 | PRJNA635874 | 48411 | 250 | 1.644068 | 4.11017 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 252 | 2.08e-62 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g48264 | i0 | 84.8 | 1 | 250 | 38 | 100 | 0 | 1 | 250 | 1755538 | 1755289 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 250 | 252 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 13362188 | 13362188 | PRJNA635874_P_NODE_61471_length_245_cov_0.895349_g61324_i0 | PRJNA635874 | 61471 | 245 | 0.895349 | 2.19360505 | Opitutus sp. GAS368 | 1882749 | Bacteria | Bacteria | 250 | 7.31e-62 | NTclustered | gi|1085764882|emb|LT629735.1| | 1882749 | g61324 | i0 | 85.714 | 0.971428571428571 | 238 | 32 | 97 | 2 | 9 | 245 | 2302924 | 2303160 | Opitutus sp. GAS368 genome assembly, chromosome: I | blastn | 238 | 250 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. GAS368 | |
| 13362233 | 13362233 | PRJNA635874_P_NODE_63271_length_245_cov_0.889535_g63124_i0 | PRJNA635874 | 63271 | 245 | 0.889535 | 2.17936075 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 95.3 | 3.62e-15 | NTclustered | gi|2874253952|emb|OY970277.1| | 412056 | g63124 | i0 | 89.474 | 0.310204081632653 | 76 | 6 | 31 | 2 | 23 | 97 | 1085158 | 1085084 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 | blastn | 76 | 95.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 21009755 | 21009755 | PRJNA635874_P_NODE_35777_length_282_cov_1.368421_g35630_i0 | PRJNA635874 | 35777 | 282 | 1.368421 | 3.85894722 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 322 | 1.8e-83 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g35630 | i0 | 90.535 | 1.62765957446809 | 243 | 23 | 86 | 0 | 39 | 281 | 37929 | 38171 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 459 | 322 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 21010344 | 21010344 | PRJNA635874_P_NODE_57737_length_247_cov_0.885057_g57590_i0 | PRJNA635874 | 57737 | 247 | 0.885057 | 2.18609079 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 350 | 7.07e-92 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g57590 | i0 | 92.276 | 71.0404858299595 | 246 | 19 | 99 | 0 | 1 | 246 | 4573390 | 4573635 | Luteolibacter sp. SL250 chromosome | blastn | 17547 | 350 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 22284978 | 22284978 | PRJNA635874_P_NODE_55718_length_248_cov_0.874286_g55571_i0 | PRJNA635874 | 55718 | 248 | 0.874286 | 2.16822928 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 337 | 5.53e-88 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g55571 | i0 | 91.429 | 1.12903225806452 | 245 | 21 | 99 | 0 | 4 | 248 | 1086390 | 1086146 | Luteolibacter sp. SL250 chromosome | blastn | 280 | 337 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 |
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);;