contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1199330" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6703029 | 6703029 | PRJNA1199330_P_NODE_17026_length_495_cov_3.023697_g16335_i0 | PRJNA1199330 | 17026 | 495 | 3.023697 | 14.96730015 | archaeon | 1906665 | Archaea | Archaea | 102 | 2.25e-23 | NR | RYH18247.1 | 1906665 | g16335 | i0 | 41.8 | 0.884848484848485 | 146 | 74 | 82.4 | 4 | 492 | 85 | 90 | 234 | RYH18247.1 MAG: glutathione S-transferase family protein [archaeon] | diamond | 438 | 102 | 1 | Archaea | archaeon | ||||||||
| 9254163 | 9254163 | PRJNA1199330_P_NODE_86128_length_267_cov_1.360825_g85429_i0 | PRJNA1199330 | 86128 | 267 | 1.360825 | 3.63340275 | Haloparvum sedimenti | 1678448 | Archaea | Archaea | 176 | 1.2899999999999997e-54 | NR | WP_058366244.1 | 1678448 | g85429 | i0 | 100 | 0.98876404494382 | 88 | 0 | 98.9 | 0 | 2 | 265 | 55 | 142 | WP_058366244.1 DUF7112 family protein [Haloparvum sedimenti] | diamond | 264 | 176 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloparvum | Haloparvum sedimenti | |
| 24551250 | 24551250 | PRJNA1199330_P_NODE_122680_length_227_cov_2.831169_g121981_i0 | PRJNA1199330 | 122680 | 227 | 2.831169 | 6.42675363 | Haloparvum sedimenti | 1678448 | Archaea | Archaea | 155 | 9.15e-45 | NR | WP_058367199.1 | 1678448 | g121981 | i0 | 97.3 | 0.991189427312775 | 75 | 2 | 99.1 | 0 | 1 | 225 | 168 | 242 | WP_058367199.1 alpha/beta fold hydrolase [Haloparvum sedimenti] | diamond | 225 | 155 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloparvum | Haloparvum sedimenti | |
| 26819574 | 26819574 | PRJNA1199330_P_NODE_8361_length_728_cov_2.538931_g7736_i0 | PRJNA1199330 | 8361 | 728 | 2.538931 | 18.48341768 | archaeon | 1906665 | Archaea | Archaea | 159 | 3.05e-44 | NR | RYH18247.1 | 1906665 | g7736 | i0 | 40.4 | 0.918956043956044 | 223 | 119 | 87.4 | 4 | 20 | 655 | 4 | 223 | RYH18247.1 MAG: glutathione S-transferase family protein [archaeon] | diamond | 669 | 159 | 1 | Archaea | archaeon | ||||||||
| 26851273 | 26851273 | PRJNA1199330_P_NODE_58281_length_292_cov_1.424658_g57582_i0 | PRJNA1199330 | 58281 | 292 | 1.424658 | 4.16000136 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 122 | 2.1999999999999994e-33 | NR | MDF2783317.1 | 2169593 | g57582 | i0 | 96.6 | 1.21232876712329 | 59 | 2 | 60.6 | 0 | 3 | 179 | 93 | 151 | MDF2783317.1 Flavin nucleotide binding protein [Nitrososphaeraceae archaeon] | diamond | 354 | 122 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 27009165 | 27009165 | PRJNA1199330_P_NODE_71362_length_280_cov_3.014493_g70663_i0 | PRJNA1199330 | 71362 | 280 | 3.014493 | 8.4405804 | archaeon | 1906665 | Archaea | Archaea | 62 | 4.61e-9 | NR | RYH18247.1 | 1906665 | g70663 | i0 | 52.6 | 0.610714285714286 | 57 | 26 | 61.1 | 1 | 88 | 258 | 168 | 223 | RYH18247.1 MAG: glutathione S-transferase family protein [archaeon] | diamond | 171 | 62 | 1 | Archaea | archaeon | ||||||||
| 27198738 | 27198738 | PRJNA1199330_P_NODE_19402_length_464_cov_4.457801_g18708_i0 | PRJNA1199330 | 19402 | 464 | 4.457801 | 20.68419664 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 209 | 6.71e-65 | NR | MCW4024581.1 | 2026714 | g18708 | i0 | 97.1 | 0.665948275862069 | 103 | 3 | 66.6 | 0 | 462 | 154 | 161 | 263 | MCW4024581.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 309 | 209 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27641433 | 27641433 | PRJNA1199330_P_NODE_82744_length_270_cov_1.583756_g82045_i0 | PRJNA1199330 | 82744 | 270 | 1.583756 | 4.2761412 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 81.6 | 9.43e-16 | NR | RYE83256.1 | 2250255 | g82045 | i0 | 44.8 | 0.966666666666667 | 87 | 47 | 96.7 | 1 | 270 | 10 | 214 | 299 | RYE83256.1 MAG: hypothetical protein EOO65_04255 [Methanosarcinales archaeon] | diamond | 261 | 81.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28304232 | 28304232 | PRJNA1199330_P_NODE_100326_length_253_cov_0.866667_g99627_i0 | PRJNA1199330 | 100326 | 253 | 0.866667 | 2.19266751 | Candidatus Altiarchaeota archaeon | 2599821 | Archaea | Archaea | 134 | 1.8e-37 | NR | MFH1055039.1 | 2599821 | g99627 | i0 | 75.3 | 1.00790513833992 | 85 | 20 | 99.6 | 1 | 1 | 252 | 33 | 117 | MFH1055039.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Candidatus Altiarchaeota archaeon] | diamond | 255 | 134 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeota archaeon | ||||||
| 28588609 | 28588609 | PRJNA1199330_P_NODE_29667_length_379_cov_2.895425_g28971_i0 | PRJNA1199330 | 29667 | 379 | 2.895425 | 10.97366075 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 112 | 2.31e-26 | NR | RYE83256.1 | 2250255 | g28971 | i0 | 44.3 | 0.965699208443272 | 122 | 67 | 95.8 | 1 | 376 | 14 | 171 | 292 | RYE83256.1 MAG: hypothetical protein EOO65_04255 [Methanosarcinales archaeon] | diamond | 366 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28702154 | 28702154 | PRJNA1199330_P_NODE_15707_length_516_cov_3.162528_g15018_i0 | PRJNA1199330 | 15707 | 516 | 3.162528 | 16.31864448 | root | 1 | Root_unresolved | Root_unresolved | 45.8 | 0.0385 | NR | MDD4162744.1 | 90426 | g15018 | i0 | 53.8 | 0.540697674418605 | 39 | 17 | 22.1 | 1 | 245 | 132 | 273 | 311 | MDD4162744.1 PAN domain-containing protein [Methanothrix sp.] | diamond | 279 | 46.2 | 0.991341991341991 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28828189 | 28828189 | PRJNA1199330_P_NODE_17888_length_483_cov_2.502439_g17194_i0 | PRJNA1199330 | 17888 | 483 | 2.502439 | 12.08678037 | root | 1 | Root_unresolved | Root_unresolved | 83.6 | 3.95e-17 | NR | MBU1976054.1 | 2026764 | g17194 | i0 | 58.3 | 1.11801242236025 | 60 | 25 | 37.3 | 0 | 482 | 303 | 81 | 140 | MBU1976054.1 nucleoside 2-deoxyribosyltransferase [Nanoarchaeota archaeon] | diamond | 540 | 84 | 0.995238095238095 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29049497 | 29049497 | PRJNA1199330_P_NODE_81508_length_271_cov_2.075758_g80809_i0 | PRJNA1199330 | 81508 | 271 | 2.075758 | 5.62530418 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.0108 | NR | MDD4162744.1 | 90426 | g80809 | i0 | 51.2 | 1.30627306273063 | 41 | 19 | 44.3 | 1 | 129 | 10 | 437 | 477 | MDD4162744.1 PAN domain-containing protein [Methanothrix sp.] | diamond | 354 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 30028420 | 30028420 | PRJNA1199330_P_NODE_45391_length_312_cov_2.991632_g44692_i0 | PRJNA1199330 | 45391 | 312 | 2.991632 | 9.33389184 | Methanobacteriati | 3366610 | Archaea | Archaea | 48.9 | 4.83e-4 | NR | MAK78478.1 | 2026739 | g44692 | i0 | 73.5 | 0.692307692307692 | 34 | 9 | 32.7 | 0 | 119 | 18 | 49 | 82 | MAK78478.1 50S ribosomal protein L32e [Methanobacteriota archaeon] | diamond | 216 | 49.3 | 0.991886409736308 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30072487 | 30072487 | PRJNA1199330_P_NODE_98532_length_254_cov_3.121547_g97833_i0 | PRJNA1199330 | 98532 | 254 | 3.121547 | 7.92872938 | archaeon | 1906665 | Archaea | Archaea | 77.8 | 4.2e-15 | NR | RYY32887.1 | 1906665 | g97833 | i0 | 53.6 | 0.992125984251969 | 84 | 31 | 94.5 | 3 | 241 | 2 | 49 | 128 | RYY32887.1 MAG: hypothetical protein EON62_04840 [archaeon] | diamond | 252 | 77.8 | 1 | Archaea | archaeon | ||||||||
| 30420467 | 30420467 | PRJNA1199330_P_NODE_89993_length_263_cov_2.010526_g89294_i0 | PRJNA1199330 | 89993 | 263 | 2.010526 | 5.28768338 | Natronomonas gomsonensis | 1046043 | Archaea | Archaea | 42.7 | 0.0465 | NR | WP_178915815.1 | 1046043 | g89294 | i0 | 45.2 | 0.479087452471483 | 42 | 23 | 47.9 | 0 | 168 | 43 | 438 | 479 | WP_178915815.1 MATE family efflux transporter [Natronomonas gomsonensis] | diamond | 126 | 42.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas gomsonensis | |
| 30609522 | 30609522 | PRJNA1199330_P_NODE_77373_length_275_cov_1.584158_g76674_i0 | PRJNA1199330 | 77373 | 275 | 1.584158 | 4.3564345 | Halomontanus rarus | 3034020 | Archaea | Archaea | 69.7 | 4.91e-12 | NR | WP_276255520.1 | 3034020 | g76674 | i0 | 75 | 0.436363636363636 | 40 | 10 | 43.6 | 0 | 120 | 1 | 1 | 40 | WP_276255520.1 DUF502 domain-containing protein [Halomontanus rarus] | diamond | 120 | 69.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halomontanus | Halomontanus rarus | |
| 30894207 | 30894207 | PRJNA1199330_P_NODE_62234_length_288_cov_3.381395_g61535_i0 | PRJNA1199330 | 62234 | 288 | 3.381395 | 9.7384176 | archaeon | 1906665 | Archaea | Archaea | 132 | 1.6399999999999999e-34 | NR | NCQ52224.1 | 1906665 | g61535 | i0 | 69.6 | 0.958333333333333 | 92 | 28 | 95.8 | 0 | 279 | 4 | 226 | 317 | NCQ52224.1 RNA ligase, T4 RnlA family [archaeon] | diamond | 276 | 132 | 1 | Archaea | archaeon | ||||||||
| 31810973 | 31810973 | PRJNA1199330_P_NODE_29957_length_377_cov_3.694079_g29261_i0 | PRJNA1199330 | 29957 | 377 | 3.694079 | 13.92667783 | archaeon | 1906665 | Archaea | Archaea | 62 | 2.87e-8 | NR | MCQ2821129.1 | 1906665 | g29261 | i0 | 36 | 0.684350132625995 | 86 | 55 | 68.4 | 0 | 1 | 258 | 226 | 311 | MCQ2821129.1 protein kinase [archaeon] | diamond | 258 | 62 | 1 | Archaea | archaeon | ||||||||
| 32000785 | 32000785 | PRJNA1199330_P_NODE_70398_length_281_cov_2.307692_g69699_i0 | PRJNA1199330 | 70398 | 281 | 2.307692 | 6.48461452 | archaeon | 1906665 | Archaea | Archaea | 97.1 | 2.08e-22 | NR | RYH18247.1 | 1906665 | g69699 | i0 | 47.3 | 0.99288256227758 | 93 | 49 | 99.3 | 0 | 3 | 281 | 32 | 124 | RYH18247.1 MAG: glutathione S-transferase family protein [archaeon] | diamond | 279 | 97.1 | 1 | Archaea | archaeon | ||||||||
| 32317484 | 32317484 | PRJNA1199330_P_NODE_105819_length_249_cov_1.772727_g105120_i0 | PRJNA1199330 | 105819 | 249 | 1.772727 | 4.41409023 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 67 | 1.07e-11 | NR | MEK6828920.1 | 2026764 | g105120 | i0 | 44 | 0.903614457831325 | 75 | 40 | 88 | 2 | 2 | 220 | 72 | 146 | MEK6828920.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 225 | 67 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32538908 | 32538908 | PRJNA1199330_P_NODE_77259_length_275_cov_2.000000_g76560_i0 | PRJNA1199330 | 77259 | 275 | 2 | 5.5 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 117 | 6.0399999999999995e-30 | NR | MCW4024581.1 | 2026714 | g76560 | i0 | 96.6 | 0.632727272727273 | 58 | 2 | 63.3 | 0 | 2 | 175 | 206 | 263 | MCW4024581.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 174 | 117 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon |
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);;