contig_metadata
8 rows where bioproject = "PRJNA1010780", tax_clade = "Methanomada group" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23107396 | 23107396 | PRJNA1010780_S_NODE_27799_length_285_cov_2.404000_g26510_i0 | PRJNA1010780 | 27799 | 285 | 2.404 | 6.8514 | Methanobrevibacter sp. TLL-48-HuF1 | 2870563 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2246976648|gb|CP081485.1| | 2870563 | g26510 | i0 | 100 | 0.4 | 30 | 0 | 11 | 0 | 86 | 115 | 73919 | 73890 | Methanobrevibacter sp. TLL-48-HuF1 chromosome, complete genome | blastn | 114 | 56.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. TLL-48-HuF1 | |
| 27160754 | 27160754 | PRJNA1010780_S_NODE_35162_length_230_cov_1.456410_g33873_i0 | PRJNA1010780 | 35162 | 230 | 1.45641 | 3.349743 | Methanobrevibacter millerae | 230361 | Archaea | Archaea | 44.3 | 0.00806 | NR | MBE6510136.1 | 230361 | g33873 | i0 | 30.5 | 0.769565217391304 | 59 | 41 | 77 | 0 | 24 | 200 | 139 | 197 | MBE6510136.1 4Fe-4S ferredoxin [Methanobrevibacter millerae] | diamond | 177 | 44.3 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter millerae | |
| 27911249 | 27911249 | PRJNA1010780_S_NODE_42145_length_199_cov_1.280488_g40856_i0 | PRJNA1010780 | 42145 | 199 | 1.280488 | 2.54817112 | root | 1 | Root_unresolved | Root_unresolved | 41.6 | 0.028 | NR | WP_345895079.1 | 66852 | g40856 | i0 | 37.3 | 1.89949748743719 | 67 | 40 | 98 | 2 | 195 | 1 | 56 | 122 | WP_345895079.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 378 | 42 | 0.990476190476191 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28708551 | 28708551 | PRJNA1010780_S_NODE_30007_length_265_cov_1.895652_g28718_i0 | PRJNA1010780 | 30007 | 265 | 1.895652 | 5.0234778 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 43.5 | 0.0266 | NR | WP_400223010.1 | 2173 | g28718 | i0 | 32.2 | 8.83018867924528 | 90 | 55 | 97.4 | 3 | 260 | 3 | 2052 | 2139 | WP_400223010.1 Ig-like domain repeat protein, partial [Methanobrevibacter smithii] | diamond | 2340 | 43.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 28802846 | 28802846 | PRJNA1010780_S_NODE_28408_length_279_cov_2.504098_g27119_i0 | PRJNA1010780 | 28408 | 279 | 2.504098 | 6.98643342 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 103 | 2.2399999999999998e-23 | NR | WP_406531486.1 | 66852 | g27119 | i0 | 57 | 2.82795698924731 | 86 | 37 | 92.5 | 0 | 263 | 6 | 443 | 528 | WP_406531486.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 789 | 103 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28961233 | 28961233 | PRJNA1010780_S_NODE_22008_length_362_cov_3.480122_g20719_i0 | PRJNA1010780 | 22008 | 362 | 3.480122 | 12.59804164 | Methanobrevibacter filiformis | 55758 | Archaea | Archaea | 43.9 | 0.043 | NR | WP_066970950.1 | 55758 | g20719 | i0 | 34.3 | 0.580110497237569 | 70 | 46 | 58 | 0 | 356 | 147 | 168 | 237 | WP_066970950.1 MIP/aquaporin family protein [Methanobrevibacter filiformis] | diamond | 210 | 43.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter filiformis | |
| 32721455 | 32721455 | PRJNA1010780_S_NODE_45940_length_186_cov_1.675497_g44651_i0 | PRJNA1010780 | 45940 | 186 | 1.675497 | 3.11642442 | Methanobrevibacter sp. A27 | 1860099 | Archaea | Archaea | 44.7 | 0.0034 | NR | WP_369815347.1 | 1860099 | g44651 | i0 | 45.9 | 0.983870967741935 | 61 | 32 | 96.8 | 1 | 185 | 6 | 156 | 216 | WP_369815347.1 tetratricopeptide repeat protein [Methanobrevibacter sp. A27] | diamond | 183 | 44.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. A27 | |
| 32878810 | 32878810 | PRJNA1010780_S_NODE_46640_length_184_cov_1.604027_g45351_i0 | PRJNA1010780 | 46640 | 184 | 1.604027 | 2.95140968 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 46.6 | 7.13e-4 | NR | MEE3419417.1 | 2666342 | g45351 | i0 | 33.3 | 1.95652173913043 | 60 | 40 | 97.8 | 0 | 3 | 182 | 56 | 115 | MEE3419417.1 PX and WD40 repeat domain-containing protein [Methanosphaera sp.] | diamond | 360 | 46.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. |
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);;