contig_metadata
6 rows where bioproject = "PRJNA558770", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5645685 | 5645685 | PRJNA558770_P_NODE_397005_length_152_cov_16.076923_g395000_i0 | PRJNA558770 | 397005 | 152 | 16.076923 | 24.43692296 | Rubrivirga sp. IMCC43871 | 3391575 | Bacteria | Bacteria | 211 | 1.94e-50 | NTclustered | gi|2890853429|gb|CP177355.1| | 3391575 | g395000 | i0 | 92.053 | 3.92105263157895 | 151 | 10 | 99 | 2 | 3 | 152 | 806560 | 806709 | Rubrivirga sp. IMCC43871 chromosome, complete genome | blastn | 596 | 211 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC43871 | |
| 8191600 | 8191600 | PRJNA558770_P_NODE_179007_length_234_cov_4.693467_g177002_i0 | PRJNA558770 | 179007 | 234 | 4.693467 | 10.98271278 | Rhodothermus marinus | 29549 | Bacteria | Bacteria | 86.1 | 2.07e-12 | NTclustered | gi|345113873|gb|CP003030.1| | 762570 | g177002 | i0 | 94.545 | 3.17521367521368 | 55 | 3 | 24 | 0 | 1 | 55 | 27825 | 27771 | Rhodothermus marinus SG0.5JP17-172 plasmid pRHOM17201, complete sequence | blastn | 743 | 86.1 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermus | Rhodothermus marinus | |
| 9466910 | 9466910 | PRJNA558770_P_NODE_156128_length_234_cov_6.005025_g154123_i0 | PRJNA558770 | 156128 | 234 | 6.005025 | 14.0517585 | Rhodocaloribacter litoris | 2558931 | Bacteria | Bacteria | 86.1 | 2.07e-12 | NTclustered | gi|2076465437|gb|CP076718.1| | 2558931 | g154123 | i0 | 88.571 | 0.299145299145299 | 70 | 8 | 30 | 0 | 6 | 75 | 35339 | 35270 | Rhodocaloribacter litoris strain ISCAR-4553 chromosome | blastn | 70 | 86.1 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodocaloribacter | Rhodocaloribacter litoris | |
| 12021001 | 12021001 | PRJNA558770_P_NODE_41690_length_329_cov_9.336735_g39692_i0 | PRJNA558770 | 41690 | 329 | 9.336735 | 30.71785815 | Rubricoccaceae bacterium | 2838334 | Bacteria | Bacteria | 169 | 2.95e-37 | NTclustered | gi|2874254104|emb|OY970187.1| | 2838334 | g39692 | i0 | 84.615 | 34.4711246200608 | 169 | 26 | 51 | 0 | 160 | 328 | 1309241 | 1309409 | MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1 | blastn | 11341 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubricoccaceae bacterium | ||
| 13883331 | 13883331 | PRJNA558770_P_NODE_267191_length_234_cov_1.959799_g265186_i0 | PRJNA558770 | 267191 | 234 | 1.959799 | 4.58592966 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 99 | 2.65e-16 | NTclustered | gi|2076465437|gb|CP076718.1| | 2558931 | g265186 | i0 | 90.541 | 24.8504273504273 | 74 | 7 | 32 | 0 | 3 | 76 | 2065488 | 2065415 | Rhodocaloribacter litoris strain ISCAR-4553 chromosome | blastn | 5815 | 99 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodocaloribacter | Rhodocaloribacter litoris | |
| 20942376 | 20942376 | PRJNA558770_P_NODE_26337_length_409_cov_8.489305_g24389_i0 | PRJNA558770 | 26337 | 409 | 8.489305 | 34.72125745 | Rubrivirga sp. IMCC43871 | 3391575 | Bacteria | Bacteria | 451 | 3.31e-122 | NTclustered | gi|2890853429|gb|CP177355.1| | 3391575 | g24389 | i0 | 87.692 | 447.486552567237 | 390 | 45 | 95 | 3 | 22 | 408 | 806715 | 807104 | Rubrivirga sp. IMCC43871 chromosome, complete genome | blastn | 183022 | 451 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | Rubrivirga sp. IMCC43871 |
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);;