contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA575566" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4387678 | 4387678 | PRJNA575566_P_NODE_524_length_1322_cov_3.300555_g437_i0 | PRJNA575566 | 524 | 1322 | 3.300555 | 43.6333371 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 488 | 1.6299999999999995e-166 | NR | MBX7076496.1 | 2099680 | g437 | i0 | 58.6 | 0.953101361573374 | 420 | 173 | 95.3 | 1 | 1262 | 3 | 27 | 445 | MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon] | diamond | 1260 | 488 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 8212953 | 8212953 | PRJNA575566_P_NODE_10627_length_321_cov_1.042308_g10430_i0 | PRJNA575566 | 10627 | 321 | 1.042308 | 3.34580868 | root | 1 | Root_unresolved | Root_unresolved | 108 | 1.4e-25 | NR | UCG90470.1 | 2026747 | g10430 | i0 | 74.6 | 16.3738317757009 | 63 | 16 | 58.9 | 0 | 189 | 1 | 19 | 81 | UCG90470.1 MAG: glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Candidatus Heimdallarchaeota archaeon] | diamond | 5256 | 109 | 0.990825688073395 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 10764194 | 10764194 | PRJNA575566_P_NODE_1389_length_870_cov_1.688504_g1229_i0 | PRJNA575566 | 1389 | 870 | 1.688504 | 14.6899848 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 532 | 5.59e-188 | NR | RYE83110.1 | 2250255 | g1229 | i0 | 92.1 | 0.96551724137931 | 280 | 22 | 96.6 | 0 | 3 | 842 | 137 | 416 | RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon] | diamond | 840 | 532 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 13314124 | 13314124 | PRJNA575566_P_NODE_27111_length_205_cov_0.888889_g26914_i0 | PRJNA575566 | 27111 | 205 | 0.888889 | 1.82222245 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 126 | 3.01e-34 | NR | RYE83291.1 | 2250255 | g26914 | i0 | 86.8 | 0.995121951219512 | 68 | 9 | 99.5 | 0 | 1 | 204 | 122 | 189 | RYE83291.1 MAG: hypothetical protein EOO65_04195, partial [Methanosarcinales archaeon] | diamond | 204 | 126 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 27142392 | 27142392 | PRJNA575566_P_NODE_28202_length_203_cov_1.338028_g28005_i0 | PRJNA575566 | 28202 | 203 | 1.338028 | 2.71619684 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 42 | 0.0061 | NR | MEK6857865.1 | 2026764 | g28005 | i0 | 54.3 | 0.517241379310345 | 35 | 15 | 50.2 | 1 | 141 | 40 | 29 | 63 | MEK6857865.1 Kazal-type serine protease inhibitor domain-containing protein [Nanoarchaeota archaeon] | diamond | 105 | 42 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 27427413 | 27427413 | PRJNA575566_P_NODE_27103_length_205_cov_0.888889_g26906_i0 | PRJNA575566 | 27103 | 205 | 0.888889 | 1.82222245 | archaeon | 1906665 | Archaea | Archaea | 58.9 | 4.48e-8 | NR | RYG70422.1 | 1906665 | g26906 | i0 | 44.4 | 0.790243902439024 | 54 | 29 | 77.6 | 1 | 193 | 35 | 94 | 147 | RYG70422.1 MAG: hypothetical protein EON64_00215 [archaeon] | diamond | 162 | 58.9 | 1 | Archaea | archaeon | ||||||||
| 27521815 | 27521815 | PRJNA575566_P_NODE_29583_length_201_cov_1.371429_g29386_i0 | PRJNA575566 | 29583 | 201 | 1.371429 | 2.75657229 | archaeon | 1906665 | Archaea | Archaea | 61.2 | 2.54e-9 | NR | RYY34548.1 | 1906665 | g29386 | i0 | 51.5 | 0.985074626865672 | 66 | 24 | 98.5 | 1 | 200 | 3 | 102 | 159 | RYY34548.1 MAG: 50S ribosomal protein L3, partial [archaeon] | diamond | 198 | 61.2 | 1 | Archaea | archaeon | ||||||||
| 27680106 | 27680106 | PRJNA575566_P_NODE_24264_length_209_cov_0.864865_g24067_i0 | PRJNA575566 | 24264 | 209 | 0.864865 | 1.80756785 | archaeon | 1906665 | Archaea | Archaea | 72.4 | 5.57e-13 | NR | RYY81965.1 | 1906665 | g24067 | i0 | 52.4 | 0.904306220095694 | 63 | 29 | 90.4 | 1 | 19 | 207 | 108 | 169 | RYY81965.1 MAG: hypothetical protein EON63_14340 [archaeon] | diamond | 189 | 72.4 | 1 | Archaea | archaeon | ||||||||
| 27711808 | 27711808 | PRJNA575566_P_NODE_29384_length_202_cov_0.907801_g29187_i0 | PRJNA575566 | 29384 | 202 | 0.907801 | 1.83375802 | archaeon | 1906665 | Archaea | Archaea | 102 | 8.789999999999999e-25 | NR | RYG66265.1 | 1906665 | g29187 | i0 | 73.8 | 0.965346534653465 | 65 | 15 | 96.5 | 1 | 3 | 197 | 159 | 221 | RYG66265.1 MAG: hypothetical protein EON64_10150 [archaeon] | diamond | 195 | 102 | 1 | Archaea | archaeon | ||||||||
| 27743212 | 27743212 | PRJNA575566_P_NODE_25704_length_207_cov_0.876712_g25507_i0 | PRJNA575566 | 25704 | 207 | 0.876712 | 1.81479384 | archaeon | 1906665 | Archaea | Archaea | 94.7 | 7.3e-21 | NR | RYY32916.1 | 1906665 | g25507 | i0 | 62.3 | 1 | 69 | 26 | 100 | 0 | 1 | 207 | 69 | 137 | RYY32916.1 MAG: hypothetical protein EON62_04805, partial [archaeon] | diamond | 207 | 94.7 | 1 | Archaea | archaeon | ||||||||
| 28690375 | 28690375 | PRJNA575566_P_NODE_3807_length_535_cov_0.917722_g3611_i0 | PRJNA575566 | 3807 | 535 | 0.917722 | 4.9098127 | Candidatus Undinarchaeales archaeon | 3042728 | Archaea | Archaea | 63.5 | 4.04e-8 | NR | MDP7078847.1 | 3042728 | g3611 | i0 | 30.1 | 5.41121495327103 | 206 | 97 | 98.1 | 11 | 9 | 533 | 509 | 698 | MDP7078847.1 hypothetical protein [Candidatus Undinarchaeales archaeon] | diamond | 2895 | 63.5 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon | ||||
| 29650508 | 29650508 | PRJNA575566_P_NODE_19450_length_238_cov_1.446328_g19253_i0 | PRJNA575566 | 19450 | 238 | 1.446328 | 3.44226064 | Nanobdellati | 1783276 | Archaea | Archaea | 99.8 | 2.1e-22 | NR | MDP6845833.1 | 2910166 | g19253 | i0 | 61 | 4.91596638655462 | 77 | 30 | 97.1 | 0 | 238 | 8 | 45 | 121 | MDP6845833.1 IMP dehydrogenase [Candidatus Nanoarchaeia archaeon] | diamond | 1170 | 99.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 30016453 | 30016453 | PRJNA575566_P_NODE_27651_length_204_cov_0.895105_g27454_i0 | PRJNA575566 | 27651 | 204 | 0.895105 | 1.8260142 | archaeon | 1906665 | Archaea | Archaea | 97.8 | 6.09e-22 | NR | RYH11025.1 | 1906665 | g27454 | i0 | 67.6 | 1 | 68 | 22 | 100 | 0 | 204 | 1 | 6 | 73 | RYH11025.1 MAG: ATP-binding cassette domain-containing protein, partial [archaeon] | diamond | 204 | 97.8 | 1 | Archaea | archaeon | ||||||||
| 30459105 | 30459105 | PRJNA575566_P_NODE_27753_length_204_cov_0.895105_g27556_i0 | PRJNA575566 | 27753 | 204 | 0.895105 | 1.8260142 | archaeon | 1906665 | Archaea | Archaea | 114 | 6.15e-30 | NR | MCQ2821492.1 | 1906665 | g27556 | i0 | 80.6 | 3.94117647058824 | 67 | 13 | 98.5 | 0 | 2 | 202 | 2 | 68 | MCQ2821492.1 50S ribosomal protein L15e [archaeon] | diamond | 804 | 114 | 1 | Archaea | archaeon | ||||||||
| 30711426 | 30711426 | PRJNA575566_P_NODE_22714_length_217_cov_1.641026_g22517_i0 | PRJNA575566 | 22714 | 217 | 1.641026 | 3.56102642 | archaeon | 1906665 | Archaea | Archaea | 49.7 | 1.03e-5 | NR | RYG44663.1 | 1906665 | g22517 | i0 | 66.7 | 0.497695852534562 | 36 | 12 | 49.8 | 0 | 112 | 5 | 42 | 77 | RYG44663.1 MAG: hypothetical protein EON67_11510, partial [archaeon] | diamond | 108 | 49.7 | 1 | Archaea | archaeon | ||||||||
| 31059312 | 31059312 | PRJNA575566_P_NODE_12415_length_298_cov_1.075949_g12218_i0 | PRJNA575566 | 12415 | 298 | 1.075949 | 3.20632802 | archaeon | 1906665 | Archaea | Archaea | 170 | 8.52e-47 | NR | RYY34978.1 | 1906665 | g12218 | i0 | 81.8 | 0.996644295302013 | 99 | 18 | 99.7 | 0 | 298 | 2 | 555 | 653 | RYY34978.1 MAG: sodium-translocating pyrophosphatase, partial [archaeon] | diamond | 297 | 170 | 1 | Archaea | archaeon | ||||||||
| 31470188 | 31470188 | PRJNA575566_P_NODE_9936_length_332_cov_1.169742_g9739_i0 | PRJNA575566 | 9936 | 332 | 1.169742 | 3.88354344 | uncultured archaeon | 115547 | Archaea | Archaea | 66.2 | 3.84e-11 | NR | VVB83612.1 | 115547 | g9739 | i0 | 61.7 | 0.903614457831325 | 47 | 18 | 42.5 | 0 | 13 | 153 | 69 | 115 | VVB83612.1 30S ribosomal protein S19 [uncultured archaeon] | diamond | 300 | 66.2 | 1 | Archaea | uncultured archaeon | ||||||||
| 31501841 | 31501841 | PRJNA575566_P_NODE_26976_length_205_cov_0.888889_g26779_i0 | PRJNA575566 | 26976 | 205 | 0.888889 | 1.82222245 | archaeon | 1906665 | Archaea | Archaea | 73.6 | 1.74e-13 | NR | RYH16394.1 | 1906665 | g26779 | i0 | 58 | 0.731707317073171 | 50 | 21 | 73.2 | 0 | 2 | 151 | 6 | 55 | RYH16394.1 MAG: hypothetical protein EON65_30180 [archaeon] | diamond | 150 | 73.6 | 1 | Archaea | archaeon | ||||||||
| 31817854 | 31817854 | PRJNA575566_P_NODE_25717_length_207_cov_0.876712_g25520_i0 | PRJNA575566 | 25717 | 207 | 0.876712 | 1.81479384 | archaeon | 1906665 | Archaea | Archaea | 105 | 2.9200000000000003e-26 | NR | RYH05596.1 | 1906665 | g25520 | i0 | 70.1 | 0.971014492753623 | 67 | 20 | 97.1 | 0 | 1 | 201 | 85 | 151 | RYH05596.1 MAG: hypothetical protein EON65_44255 [archaeon] | diamond | 201 | 105 | 1 | Archaea | archaeon | ||||||||
| 31849501 | 31849501 | PRJNA575566_P_NODE_17457_length_252_cov_1.178010_g17260_i0 | PRJNA575566 | 17457 | 252 | 1.17801 | 2.9685852 | archaeon | 1906665 | Archaea | Archaea | 67 | 3.83e-12 | NR | RYG53486.1 | 1906665 | g17260 | i0 | 44.6 | 0.880952380952381 | 74 | 39 | 85.7 | 2 | 248 | 33 | 29 | 102 | RYG53486.1 MAG: hypothetical protein EON66_08470 [archaeon] | diamond | 222 | 67 | 1 | Archaea | archaeon | ||||||||
| 32261211 | 32261211 | PRJNA575566_P_NODE_10218_length_327_cov_1.736842_g10021_i0 | PRJNA575566 | 10218 | 327 | 1.736842 | 5.67947334 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 91.3 | 8.74e-19 | NR | MBR4685556.1 | 2517205 | g10021 | i0 | 47.3 | 1.6605504587156 | 91 | 48 | 83.5 | 0 | 32 | 304 | 189 | 279 | MBR4685556.1 AAA family ATPase [Candidatus Methanomethylophilaceae archaeon] | diamond | 543 | 91.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae 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);;