contig_metadata
17 rows where bioproject = "PRJNA1120586" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2303765 | 2303765 | PRJNA1120586_P_NODE_41162_length_234_cov_0.872727_g40971_i0 | PRJNA1120586 | 41162 | 234 | 0.872727 | 2.04218118 | Halobacteriales | 2235 | Archaea | Archaea | 355 | 1.43e-93 | NTclustered | gi|1279136099|gb|CP024845.1| | 1073996 | g40971 | i0 | 94.017 | 40.3418803418803 | 234 | 14 | 100 | 0 | 1 | 234 | 1938723 | 1938490 | Halohasta litchfieldiae strain tADL chromosome, complete genome | blastn | 9440 | 355 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halohasta | Halohasta litchfieldiae | |
| 4103245 | 4103245 | PRJNA1120586_P_NODE_40844_length_234_cov_1.551515_g40653_i0 | PRJNA1120586 | 40844 | 234 | 1.551515 | 3.6305451 | Halopiger xanaduensis | 387343 | Archaea | Archaea | 322 | 1.45e-83 | NTclustered | gi|335336085|gb|CP002839.1| | 797210 | g40653 | i0 | 91.453 | 48.4273504273504 | 234 | 20 | 100 | 0 | 1 | 234 | 527546 | 527779 | Halopiger xanaduensis SH-6, complete genome | blastn | 11332 | 322 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halopiger | Halopiger xanaduensis | |
| 8681616 | 8681616 | PRJNA1120586_P_NODE_39807_length_235_cov_0.867470_g39616_i0 | PRJNA1120586 | 39807 | 235 | 0.86747 | 2.0385545 | Halobacteriales | 2235 | Archaea | Archaea | 390 | 3.93e-104 | NTclustered | gi|1657695474|gb|CP040331.1| | 88724 | g39616 | i0 | 96.596 | 21.9659574468085 | 235 | 8 | 100 | 0 | 1 | 235 | 22708 | 22942 | Natrinema versiforme strain BOL5-4 plasmid pNVE500 | blastn | 5162 | 390 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema versiforme | |
| 14305199 | 14305199 | PRJNA1120586_P_NODE_48152_length_229_cov_0.900000_g47961_i0 | PRJNA1120586 | 48152 | 229 | 0.9 | 2.061 | Halorubrum sp. DM2 | 2527867 | Archaea | Archaea | 128 | 3.3e-25 | NTclustered | gi|2474087799|emb|LR594487.1| | 2527867 | g47961 | i0 | 77.928 | 9.20524017467249 | 222 | 37 | 92 | 9 | 19 | 229 | 100860 | 100640 | Halorubrum sp. DM2 isolate Halorubrum diamantensis DM21 genome assembly, chromosome: 1 | blastn | 2108 | 128 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. DM2 | |
| 15579106 | 15579106 | PRJNA1120586_P_NODE_44453_length_232_cov_0.883436_g44262_i0 | PRJNA1120586 | 44453 | 232 | 0.883436 | 2.04957152 | Nitrosotalea devaniterrae | 1078905 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|1003583480|emb|LN890280.1| | 1078905 | g44262 | i0 | 100 | 0.125 | 29 | 0 | 13 | 0 | 107 | 135 | 61532 | 61504 | Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Nitrosotalea devaniterrae | ||
| 18127541 | 18127541 | PRJNA1120586_P_NODE_19315_length_303_cov_1.230769_g19124_i0 | PRJNA1120586 | 19315 | 303 | 1.230769 | 3.72923007 | Halorubrum sp. JWXQ-INN 858 | 2690782 | Archaea | Archaea | 93.6 | 9.56e-20 | NR | WP_159487179.1 | 2690782 | g19124 | i0 | 62.2 | 0.97029702970297 | 98 | 37 | 97 | 0 | 294 | 1 | 193 | 290 | WP_159487179.1 stage II sporulation protein M [Halorubrum sp. JWXQ-INN 858] | diamond | 294 | 93.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. JWXQ-INN 858 | |
| 21952552 | 21952552 | PRJNA1120586_P_NODE_13518_length_342_cov_1.318681_g13327_i0 | PRJNA1120586 | 13518 | 342 | 1.318681 | 4.50988902 | archaeon | 1906665 | Archaea | Archaea | 223 | 4.649999999999999e-72 | NR | RYH25290.1 | 1906665 | g13327 | i0 | 95.6 | 1 | 114 | 5 | 100 | 0 | 1 | 342 | 61 | 174 | RYH25290.1 MAG: 50S ribosomal protein L16 [archaeon] | diamond | 342 | 223 | 1 | Archaea | archaeon | ||||||||
| 21953100 | 21953100 | PRJNA1120586_P_NODE_46858_length_230_cov_0.894410_g46667_i0 | PRJNA1120586 | 46858 | 230 | 0.89441 | 2.057143 | Haloarcula marina | 2961574 | Archaea | Archaea | 91.6 | 4.35e-14 | NTclustered | gi|2269702775|gb|CP100404.1| | 2961574 | g46667 | i0 | 92.188 | 2.15217391304348 | 64 | 5 | 28 | 0 | 167 | 230 | 1649096 | 1649159 | Haloarcula marina strain DT1 chromosome, complete genome | blastn | 495 | 91.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula marina | |
| 26848755 | 26848755 | PRJNA1120586_P_NODE_32041_length_255_cov_0.924731_g31850_i0 | PRJNA1120586 | 32041 | 255 | 0.924731 | 2.35806405 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 43.1 | 0.0308 | NR | MED6346029.1 | 2806419 | g31850 | i0 | 35.4 | 0.564705882352941 | 48 | 31 | 56.5 | 0 | 180 | 37 | 231 | 278 | MED6346029.1 PQQ-binding-like beta-propeller repeat protein [Thermoplasmatota archaeon] | diamond | 144 | 43.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28301784 | 28301784 | PRJNA1120586_P_NODE_44946_length_231_cov_1.333333_g44755_i0 | PRJNA1120586 | 44946 | 231 | 1.333333 | 3.07999923 | archaeon | 1906665 | Archaea | Archaea | 70.9 | 2.44e-12 | NR | RYG65019.1 | 1906665 | g44755 | i0 | 43.4 | 0.987012987012987 | 76 | 43 | 98.7 | 0 | 230 | 3 | 168 | 243 | RYG65019.1 MAG: hypothetical protein EON64_12790 [archaeon] | diamond | 228 | 70.9 | 1 | Archaea | archaeon | ||||||||
| 29533231 | 29533231 | PRJNA1120586_P_NODE_54990_length_206_cov_4.204380_g54799_i0 | PRJNA1120586 | 54990 | 206 | 4.20438 | 8.6610228 | archaeon | 1906665 | Archaea | Archaea | 77.4 | 1.36e-16 | NR | RYH00022.1 | 1906665 | g54799 | i0 | 60.3 | 0.844660194174757 | 58 | 23 | 84.5 | 0 | 31 | 204 | 14 | 71 | RYH00022.1 MAG: hypothetical protein EON65_49750 [archaeon] | diamond | 174 | 77.4 | 1 | Archaea | archaeon | ||||||||
| 29912314 | 29912314 | PRJNA1120586_P_NODE_44451_length_232_cov_0.883436_g44260_i0 | PRJNA1120586 | 44451 | 232 | 0.883436 | 2.04957152 | Halobacteriales archaeon | 1904752 | Archaea | Archaea | 46.2 | 0.00161 | NR | MFP4590188.1 | 1904752 | g44260 | i0 | 62.5 | 1.25431034482759 | 32 | 12 | 41.4 | 0 | 1 | 96 | 200 | 231 | MFP4590188.1 sugar phosphate nucleotidyltransferase [Halobacteriales archaeon] | diamond | 291 | 46.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon | |||
| 31049846 | 31049846 | PRJNA1120586_P_NODE_41295_length_234_cov_0.872727_g41104_i0 | PRJNA1120586 | 41295 | 234 | 0.872727 | 2.04218118 | archaeon | 1906665 | Archaea | Archaea | 86.7 | 2.97e-18 | NR | RYH11026.1 | 1906665 | g41104 | i0 | 54.7 | 0.961538461538462 | 75 | 34 | 96.2 | 0 | 9 | 233 | 98 | 172 | RYH11026.1 MAG: hypothetical protein EON65_39105 [archaeon] | diamond | 225 | 86.7 | 1 | Archaea | archaeon | ||||||||
| 31397452 | 31397452 | PRJNA1120586_P_NODE_45076_length_231_cov_0.888889_g44885_i0 | PRJNA1120586 | 45076 | 231 | 0.888889 | 2.05333359 | archaeon | 1906665 | Archaea | Archaea | 97.4 | 1.5799999999999998e-23 | NR | RYG69081.1 | 1906665 | g44885 | i0 | 54.3 | 0.909090909090909 | 70 | 32 | 90.9 | 0 | 210 | 1 | 7 | 76 | RYG69081.1 MAG: hypothetical protein EON64_03635, partial [archaeon] | diamond | 210 | 97.4 | 1 | Archaea | archaeon | ||||||||
| 31839964 | 31839964 | PRJNA1120586_P_NODE_33237_length_251_cov_1.824176_g33046_i0 | PRJNA1120586 | 33237 | 251 | 1.824176 | 4.57868176 | archaeon | 1906665 | Archaea | Archaea | 115 | 7.700000000000001e-28 | NR | RYH23131.1 | 1906665 | g33046 | i0 | 65.1 | 0.99203187250996006 | 83 | 29 | 99.2 | 0 | 1 | 249 | 352 | 434 | RYH23131.1 MAG: hypothetical protein EON65_18260 [archaeon] | diamond | 249 | 115 | 1 | Archaea | archaeon | ||||||||
| 32409734 | 32409734 | PRJNA1120586_P_NODE_40239_length_235_cov_0.867470_g40048_i0 | PRJNA1120586 | 40239 | 235 | 0.86747 | 2.0385545 | archaeon | 1906665 | Archaea | Archaea | 60.1 | 2.58e-8 | NR | RYH13809.1 | 1906665 | g40048 | i0 | 43.2 | 0.94468085106383 | 74 | 40 | 94.5 | 2 | 229 | 8 | 55 | 126 | RYH13809.1 MAG: VWA domain-containing protein [archaeon] | diamond | 222 | 60.1 | 1 | Archaea | archaeon | ||||||||
| 32568077 | 32568077 | PRJNA1120586_P_NODE_40119_length_235_cov_0.867470_g39928_i0 | PRJNA1120586 | 40119 | 235 | 0.86747 | 2.0385545 | Halolamina sp. | 1940283 | Archaea | Archaea | 131 | 1.56e-33 | NR | WP_332326263.1 | 1940283 | g39928 | i0 | 78.7 | 0.957446808510638 | 75 | 16 | 95.7 | 0 | 4 | 228 | 437 | 511 | WP_332326263.1 S9 family peptidase [Halolamina sp.] | diamond | 225 | 131 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina 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);;