contig_metadata
16 rows where bioproject = "PRJNA340009", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26758101 | 26758101 | PRJNA340009_P_NODE_69201_length_164_cov_0.886957_g68894_i0 | PRJNA340009 | 69201 | 164 | 0.886957 | 1.45460948 | Armatimonadia bacterium | 2663015 | Bacteria | Bacteria | 52.8 | 3.69e-6 | NR | MEN6345652.1 | 2663015 | g68894 | i0 | 57.4 | 0.859756097560976 | 47 | 20 | 86 | 0 | 164 | 24 | 103 | 149 | MEN6345652.1 DNA polymerase [Armatimonadia bacterium] | diamond | 141 | 52.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadia bacterium | |||||
| 27200936 | 27200936 | PRJNA340009_P_NODE_30102_length_227_cov_1.089888_g29795_i0 | PRJNA340009 | 30102 | 227 | 1.089888 | 2.47404576 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 60.8 | 1.23e-8 | NR | HMS54623.1 | 2682144 | g29795 | i0 | 45.1 | 0.9383259911894268 | 71 | 39 | 93.8 | 0 | 13 | 225 | 178 | 248 | HMS54623.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 213 | 60.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28022434 | 28022434 | PRJNA340009_P_NODE_57545_length_172_cov_3.235772_g57238_i0 | PRJNA340009 | 57545 | 172 | 3.235772 | 5.56552784 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 71.2 | 1.28e-12 | NR | MCL5103234.1 | 2033014 | g57238 | i0 | 59.6 | 0.906976744186046 | 52 | 21 | 90.7 | 0 | 162 | 7 | 53 | 104 | MCL5103234.1 YCF48-related protein [Armatimonadota bacterium] | diamond | 156 | 71.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28102499 | 28102499 | PRJNA340009_P_NODE_62785_length_167_cov_0.864407_g62478_i0 | PRJNA340009 | 62785 | 167 | 0.864407 | 1.44355969 | PVC group | 1783257 | Bacteria | Bacteria | 58.9 | 2.59e-8 | NR | HET6455087.1 | 2033014 | g62478 | i0 | 50.9 | 1.94011976047904 | 55 | 27 | 98.8 | 0 | 166 | 2 | 897 | 951 | HET6455087.1 LAGLIDADG family homing endonuclease [Armatimonadota bacterium] | diamond | 324 | 59.3 | 0.993254637436762 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28116877 | 28116877 | PRJNA340009_P_NODE_45305_length_191_cov_1.091549_g44998_i0 | PRJNA340009 | 45305 | 191 | 1.091549 | 2.08485859 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 92.4 | 2.28e-20 | NR | MEI7986571.1 | 2033014 | g44998 | i0 | 84.3 | 0.801047120418848 | 51 | 8 | 80.1 | 0 | 33 | 185 | 206 | 256 | MEI7986571.1 hypothetical protein [Armatimonadota bacterium] | diamond | 153 | 92.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28432809 | 28432809 | PRJNA340009_P_NODE_68646_length_164_cov_1.295652_g68339_i0 | PRJNA340009 | 68646 | 164 | 1.295652 | 2.12486928 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 107 | 1.44e-26 | NR | HZP80981.1 | 2739509 | g68339 | i0 | 87 | 2.96341463414634 | 54 | 7 | 98.8 | 0 | 164 | 3 | 108 | 161 | HZP80981.1 site-specific DNA-methyltransferase [Chthonomonadaceae bacterium] | diamond | 486 | 107 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 28559173 | 28559173 | PRJNA340009_P_NODE_20627_length_266_cov_4.230415_g20320_i0 | PRJNA340009 | 20627 | 266 | 4.230415 | 11.2529039 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 104 | 2.7300000000000003e-26 | NR | RJP46390.1 | 2033014 | g20320 | i0 | 69.2 | 1.7593984962406 | 78 | 24 | 88 | 0 | 1 | 234 | 70 | 147 | RJP46390.1 MAG: transcriptional repressor NrdR [Armatimonadota bacterium] | diamond | 468 | 104 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29348461 | 29348461 | PRJNA340009_P_NODE_29829_length_228_cov_0.949721_g29522_i0 | PRJNA340009 | 29829 | 228 | 0.949721 | 2.16536388 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 95.9 | 1.39e-21 | NR | MFN8218924.1 | 2682145 | g29522 | i0 | 60 | 0.986842105263158 | 75 | 30 | 98.7 | 0 | 226 | 2 | 159 | 233 | MFN8218924.1 PKD domain-containing protein [Fimbriimonadales bacterium] | diamond | 225 | 95.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 29821696 | 29821696 | PRJNA340009_P_NODE_10511_length_355_cov_0.941176_g10204_i0 | PRJNA340009 | 10511 | 355 | 0.941176 | 3.3411748 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 108 | 4.93e-25 | NR | MCC6728777.1 | 2282151 | g10204 | i0 | 40.5 | 1.96056338028169 | 116 | 69 | 98 | 0 | 351 | 4 | 91 | 206 | MCC6728777.1 beta-galactosidase [Chthonomonadales bacterium] | diamond | 696 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 29885349 | 29885349 | PRJNA340009_P_NODE_76311_length_161_cov_0.910714_g76004_i0 | PRJNA340009 | 76311 | 161 | 0.910714 | 1.46624954 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 109 | 6.1500000000000005e-27 | NR | MFI5387856.1 | 2682145 | g76004 | i0 | 88.7 | 5.92546583850932 | 53 | 6 | 98.8 | 0 | 2 | 160 | 91 | 143 | MFI5387856.1 M14 family zinc carboxypeptidase [Fimbriimonadales bacterium] | diamond | 954 | 109 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 30106223 | 30106223 | PRJNA340009_P_NODE_65252_length_166_cov_0.871795_g64945_i0 | PRJNA340009 | 65252 | 166 | 0.871795 | 1.4471797 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 96.3 | 1.5600000000000002e-21 | NR | WP_309714263.1 | 1872638 | g64945 | i0 | 88.5 | 0.939759036144578 | 52 | 6 | 94 | 0 | 1 | 156 | 164 | 215 | WP_309714263.1 nucleoside triphosphate pyrophosphohydrolase [Armatimonas sp.] | diamond | 156 | 96.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 30896372 | 30896372 | PRJNA340009_P_NODE_70614_length_163_cov_1.789474_g70307_i0 | PRJNA340009 | 70614 | 163 | 1.789474 | 2.91684262 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 51.2 | 9.45e-6 | NR | GIV03791.1 | 2682145 | g70307 | i0 | 54.7 | 0.975460122699387 | 53 | 19 | 97.5 | 2 | 163 | 5 | 131 | 178 | GIV03791.1 MAG: hypothetical protein KatS3mg015_2621 [Fimbriimonadales bacterium] | diamond | 159 | 51.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 31148518 | 31148518 | PRJNA340009_P_NODE_45995_length_189_cov_8.464286_g45688_i0 | PRJNA340009 | 45995 | 189 | 8.464286 | 15.99750054 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 91.3 | 3.9e-21 | NR | MBC8103923.1 | 2033014 | g45688 | i0 | 64.8 | 0.857142857142857 | 54 | 19 | 85.7 | 0 | 1 | 162 | 134 | 187 | MBC8103923.1 metallophosphoesterase family protein [Armatimonadota bacterium] | diamond | 162 | 91.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32161350 | 32161350 | PRJNA340009_P_NODE_62998_length_167_cov_0.864407_g62691_i0 | PRJNA340009 | 62998 | 167 | 0.864407 | 1.44355969 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 50.8 | 1.27e-6 | NR | MCL6531725.1 | 2033014 | g62691 | i0 | 50 | 1.56287425149701 | 46 | 23 | 82.6 | 0 | 160 | 23 | 19 | 64 | MCL6531725.1 hypothetical protein [Armatimonadota bacterium] | diamond | 261 | 50.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32382608 | 32382608 | PRJNA340009_P_NODE_12319_length_332_cov_2.551237_g12012_i0 | PRJNA340009 | 12319 | 332 | 2.551237 | 8.47010684 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 90.9 | 2e-19 | NR | MBI3926410.1 | 2033014 | g12012 | i0 | 47.5 | 0.72289156626506 | 80 | 42 | 72.3 | 0 | 92 | 331 | 129 | 208 | MBI3926410.1 rhomboid family intramembrane serine protease [Armatimonadota bacterium] | diamond | 240 | 90.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32761320 | 32761320 | PRJNA340009_P_NODE_32860_length_218_cov_46.461538_g32553_i0 | PRJNA340009 | 32860 | 218 | 46.461538 | 101.28615284 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 80.9 | 9.11e-16 | NR | WP_395091519.1 | 1872638 | g32553 | i0 | 57.4 | 0.935779816513762 | 68 | 29 | 93.6 | 0 | 208 | 5 | 56 | 123 | WP_395091519.1 hypothetical protein [Armatimonas sp.] | diamond | 204 | 80.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas 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);;