contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA473799" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 445747 | 445747 | PRJNA473799_P_NODE_34421_length_251_cov_1.500000_g34147_i0 | PRJNA473799 | 34421 | 251 | 1.5 | 3.765 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 326 | 1.21e-84 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g34147 | i0 | 90.04 | 12.0597609561753 | 251 | 25 | 100 | 0 | 1 | 251 | 577230 | 577480 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 3027 | 326 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 445948 | 445948 | PRJNA473799_P_NODE_47441_length_244_cov_1.444444_g47167_i0 | PRJNA473799 | 47441 | 244 | 1.444444 | 3.52444336 | Salinarchaeum laminariae | 869888 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2232746502|gb|CP096270.1| | 869888 | g47167 | i0 | 75.556 | 2.56147540983607 | 135 | 21 | 53 | 9 | 115 | 243 | 725028 | 724900 | Salinarchaeum laminariae strain R26 chromosome | blastn | 625 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Salinarchaeum | Salinarchaeum laminariae | |
| 1720505 | 1720505 | PRJNA473799_P_NODE_32602_length_254_cov_1.701657_g32328_i0 | PRJNA473799 | 32602 | 254 | 1.701657 | 4.32220878 | Halorubrum sp. CBA1229 | 1853699 | Archaea | Archaea | 425 | 1.18e-114 | NTclustered | gi|1861358827|gb|CP054585.1| | 1853699 | g32328 | i0 | 96.85 | 99.7755905511811 | 254 | 8 | 100 | 0 | 1 | 254 | 551534 | 551787 | Halorubrum sp. CBA1229 chromosome, complete genome | blastn | 25343 | 425 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. CBA1229 | |
| 2996170 | 2996170 | PRJNA473799_P_NODE_22643_length_273_cov_1.255000_g22369_i0 | PRJNA473799 | 22643 | 273 | 1.255 | 3.42615 | haloarchaeon 3A1-DGR | 1071085 | Archaea | Archaea | 132 | 3.1300000000000003e-26 | NTclustered | gi|1804090075|gb|CP048032.1| | 1071085 | g22369 | i0 | 95.181 | 0.608058608058608 | 83 | 4 | 30 | 0 | 191 | 273 | 2706754 | 2706672 | Haloarchaeon 3A1-DGR strain 3A1-DGR chromosome, complete genome | blastn | 166 | 132 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | haloarchaeon 3A1-DGR | |||
| 6823379 | 6823379 | PRJNA473799_P_NODE_36486_length_250_cov_0.870056_g36212_i0 | PRJNA473799 | 36486 | 250 | 0.870056 | 2.17514 | Candidatus Methanomassiliicoccus intestinalis | 1406512 | Archaea | Archaea | 171 | 5.99e-38 | NTclustered | gi|1721134172|emb|LR698974.1| | 1406512 | g36212 | i0 | 79.365 | 58.872 | 252 | 44 | 98 | 6 | 1 | 246 | 1455352 | 1455103 | Candidatus Methanomassiliicoccus intestinalis isolate MGYG-HGUT-02160 genome assembly, chromosome: 1 | blastn | 14718 | 171 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccus | Candidatus Methanomassiliicoccus intestinalis | ||
| 14474094 | 14474094 | PRJNA473799_P_NODE_20132_length_278_cov_1.302439_g19858_i0 | PRJNA473799 | 20132 | 278 | 1.302439 | 3.62078042 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 381 | 2.869999999999999e-101 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g19858 | i0 | 91.367 | 1 | 278 | 24 | 100 | 0 | 1 | 278 | 264859 | 265136 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 278 | 381 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 14474160 | 14474160 | PRJNA473799_P_NODE_25832_length_267_cov_1.036082_g25558_i0 | PRJNA473799 | 25832 | 267 | 1.036082 | 2.76633894 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 355 | 1.66e-93 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g25558 | i0 | 90.637 | 2.00374531835206 | 267 | 25 | 100 | 0 | 1 | 267 | 815560 | 815826 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 535 | 355 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 15748586 | 15748586 | PRJNA473799_P_NODE_49733_length_243_cov_0.905882_g49459_i0 | PRJNA473799 | 49733 | 243 | 0.905882 | 2.20129326 | Haloferacaceae archaeon 50 | 3384156 | Archaea | Archaea | 263 | 9.3e-66 | NTclustered | gi|2869714876|gb|CP175567.1| | 3384156 | g49459 | i0 | 86.42 | 42.7119341563786 | 243 | 29 | 99 | 4 | 3 | 243 | 716200 | 715960 | Haloferacaceae archaeon 50 chromosome, complete genome | blastn | 10379 | 263 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferacaceae archaeon 50 | ||
| 19571733 | 19571733 | PRJNA473799_P_NODE_55256_length_238_cov_3.490909_g54982_i0 | PRJNA473799 | 55256 | 238 | 3.490909 | 8.30836342 | Haloarcula regularis | 3033392 | Archaea | Archaea | 206 | 1.5499999999999998e-48 | NTclustered | gi|2463595545|gb|CP119794.1| | 3033392 | g54982 | i0 | 86.082 | 16.3655462184874 | 194 | 23 | 81 | 3 | 47 | 238 | 2100617 | 2100808 | Haloarcula regularis strain SYNS111 chromosome, complete genome | blastn | 3895 | 206 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 21497426 | 21497426 | PRJNA473799_P_NODE_17937_length_283_cov_1.000000_g17663_i0 | PRJNA473799 | 17937 | 283 | 1 | 2.83 | Halobaculum | 43927 | Archaea | Archaea | 150 | 8.999999999999999e-32 | NTclustered | gi|2087953847|gb|CP081958.1| | 1017351 | g17663 | i0 | 81.522 | 2.85512367491166 | 184 | 32 | 65 | 2 | 96 | 278 | 2132308 | 2132490 | Halobaculum magnesiiphilum strain NBRC 109044 chromosome, complete genome | blastn | 808 | 150 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum magnesiiphilum |
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);;