contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1088787 | 1088787 | PRJNA432257_S_NODE_58061_length_218_cov_99.546961_g57680_i0 | PRJNA432257 | 58061 | 218 | 99.546961 | 217.01237498 | Bacteria | 2 | Bacteria | Bacteria | 200 | 6.4999999999999985e-47 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g57680 | i0 | 86.885 | 54.1651376146789 | 183 | 19 | 83 | 3 | 1 | 182 | 1315121 | 1314943 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 11808 | 202 | 0.99009900990099 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 5533761 | 5533761 | PRJNA432257_S_NODE_70945_length_202_cov_27.854545_g70564_i0 | PRJNA432257 | 70945 | 202 | 27.854545 | 56.2661809 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 62.1 | 2.92e-5 | NTclustered | gi|2874254020|emb|OY970345.1| | 412056 | g70564 | i0 | 97.222 | 0.534653465346535 | 36 | 1 | 18 | 0 | 46 | 81 | 2784658 | 2784693 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1 | blastn | 108 | 62.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 10016958 | 10016958 | PRJNA432257_S_NODE_73128_length_200_cov_1.914110_g72747_i0 | PRJNA432257 | 73128 | 200 | 1.91411 | 3.82822 | Luteolibacter | 518753 | Bacteria | Bacteria | 148 | 2.15e-31 | NTclustered | gi|256692927|gb|GQ406199.1| | 100234 | g72747 | i0 | 100 | 91.355 | 80 | 0 | 40 | 0 | 121 | 200 | 2011 | 1932 | Uncultured Verrucomicrobiales bacterium clone BK-45-28 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 18271 | 148 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | uncultured Verrucomicrobiales bacterium | |||
| 10633146 | 10633146 | PRJNA432257_S_NODE_14249_length_361_cov_15.978395_g13868_i0 | PRJNA432257 | 14249 | 361 | 15.978395 | 57.68200595 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 459 | 1.7299999999999999e-124 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g13868 | i0 | 91.818 | 154.382271468144 | 330 | 25 | 91 | 2 | 1 | 329 | 4718684 | 4719012 | Luteolibacter sp. SL250 chromosome | blastn | 55732 | 459 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 14458657 | 14458657 | PRJNA432257_S_NODE_51892_length_228_cov_1.680628_g51511_i0 | PRJNA432257 | 51892 | 228 | 1.680628 | 3.83183184 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 383 | 6.35e-102 | NTclustered | gi|226525288|gb|FJ872373.1| | 156588 | g51511 | i0 | 97.333 | 524.19298245614 | 225 | 6 | 99 | 0 | 4 | 228 | 16814 | 16590 | Uncultured Verrucomicrobia bacterium clone 118 genomic sequence | blastn | 119516 | 383 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 17666421 | 17666421 | PRJNA432257_S_NODE_67054_length_207_cov_1.147059_g66673_i0 | PRJNA432257 | 67054 | 207 | 1.147059 | 2.37441213 | Verrucomicrobium | 2735 | Bacteria | Bacteria | 206 | 1.3099999999999999e-48 | NTclustered | gi|2874253793|emb|OY969777.1| | 412056 | g66673 | i0 | 85.641 | 87.1159420289855 | 195 | 28 | 94 | 0 | 12 | 206 | 315958 | 315764 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1 | blastn | 18033 | 206 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 19556267 | 19556267 | PRJNA432257_S_NODE_96596_length_179_cov_1.880282_g96215_i0 | PRJNA432257 | 96596 | 179 | 1.880282 | 3.36570478 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 111 | 2.47e-20 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g96215 | i0 | 94.521 | 2.49162011173184 | 73 | 3 | 41 | 1 | 1 | 73 | 5510 | 5581 | Luteolibacter sp. SL250 chromosome | blastn | 446 | 111 | 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);;