RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA560932" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA560932 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
27205190 27205190 PRJNA560932_P_NODE_27982_length_339_cov_1.447368_g27626_i0 PRJNA560932 27982 339 1.447368 4.90657752 Candidatus Methanoprimaticola sp. MG2 3228838 Archaea Archaea 42.4 0.0329   NR WP_414595740.1 3228838 g27626 i0 35 0.530973451327434 60 39 53.1 0 243 64 1 60 WP_414595740.1 DUF357 domain-containing protein [Candidatus Methanoprimaticola sp. MG2] diamond 180 42.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Candidatus Methanoprimaticola Candidatus Methanoprimaticola sp. MG2
27489894 27489894 PRJNA560932_P_NODE_34583_length_309_cov_1.165254_g34227_i0 PRJNA560932 34583 309 1.165254 3.60063486 Thermoplasmatota archaeon 2806419 Archaea Archaea 51.6 4.6e-5   NR MCL4342537.1 2806419 g34227 i0 32 1 103 67 100 1 1 309 137 236 MCL4342537.1 proteasome assembly chaperone family protein [Thermoplasmatota archaeon] diamond 309 51.6 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
27805754 27805754 PRJNA560932_P_NODE_4244_length_828_cov_2.735099_g3942_i0 PRJNA560932 4244 828 2.735099 22.64661972 Candidatus Aciduliprofundum boonei 379547 Archaea Archaea 49.7 0.00247   NR WP_008083872.1 379547 g3942 i0 31.6 0.355072463768116 98 62 35.5 2 443 736 17 109 WP_008083872.1 RNA 2',3'-cyclic phosphodiesterase [Candidatus Aciduliprofundum boonei] diamond 294 49.7 1 Archaea DHVE2 group Methanobacteriati Thermoplasmatota       Candidatus Aciduliprofundum Candidatus Aciduliprofundum boonei
28058098 28058098 PRJNA560932_P_NODE_33405_length_314_cov_1.066390_g33049_i0 PRJNA560932 33405 314 1.06639 3.3484646 Candidatus Poseidoniales archaeon 2163009 Archaea Archaea 43.5 0.0436   NR MFL2940038.1 2163009 g33049 i0 46.9 0.468152866242038 49 24 45.9 2 10 153 366 413 MFL2940038.1 purple acid phosphatase family protein [Candidatus Poseidoniales archaeon] diamond 147 43.5 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
28153082 28153082 PRJNA560932_P_NODE_34145_length_311_cov_0.970588_g33789_i0 PRJNA560932 34145 311 0.970588 3.01852868 Candidatus Sysuiplasma superficiale 2823368 Archaea Archaea 46.6 0.00311   NR MBX8644967.1 2823368 g33789 i0 34.4 0.897106109324759 93 60 89.7 1 310 32 174 265 MBX8644967.1 hypothetical protein [Candidatus Sysuiplasma superficiale] diamond 279 46.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Candidatus Sysuiplasmatales Candidatus Sysuiplasmataceae Candidatus Sysuiplasma Candidatus Sysuiplasma superficiale
29555924 29555924 PRJNA560932_P_NODE_34370_length_310_cov_0.974684_g34014_i0 PRJNA560932 34370 310 0.974684 3.0215204 Thermoplasmatota 2283796 Archaea Archaea 89 4.1e-18   NR OIR23119.1 1888996 g34014 i0 47.2 8.64193548387097 89 43 85.2 2 1 264 200 285 OIR23119.1 MAG: hypothetical protein BET99_00210 [Marine Group III euryarchaeote CG-Epi2] diamond 2679 89.7 0.992196209587514 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Candidatus Thermoprofundales     Marine Group III euryarchaeote CG-Epi2
29573531 29573531 PRJNA560932_P_NODE_59370_length_246_cov_0.890173_g59014_i0 PRJNA560932 59370 246 0.890173 2.18982558 Candidatus Poseidoniaceae archaeon 2666346 Archaea Archaea 45.1 0.00571   NR MDC0556926.1 2666346 g59014 i0 44.7 0.463414634146341 38 21 46.3 0 2 115 427 464 MDC0556926.1 zinc-ribbon domain-containing protein [Candidatus Poseidoniaceae archaeon] diamond 114 45.1 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae   Candidatus Poseidoniaceae archaeon
29794582 29794582 PRJNA560932_P_NODE_46131_length_269_cov_1.362245_g45775_i0 PRJNA560932 46131 269 1.362245 3.66443905 Candidatus Thalassarchaeaceae archaeon 2670411 Archaea Archaea 103 4.57e-26   NR MDP6899819.1 2670411 g45775 i0 60.5 0.95910780669145 86 32 95.9 1 267 10 50 133 MDP6899819.1 NUDIX hydrolase [Candidatus Thalassarchaeaceae archaeon] diamond 258 103 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Thalassarchaeaceae   Candidatus Thalassarchaeaceae archaeon
29903546 29903546 PRJNA560932_P_NODE_26991_length_345_cov_1.018382_g26635_i0 PRJNA560932 26991 345 1.018382 3.5134179 Archaea 2157 Archaea Archaea 94 1.36e-19   NR UCE39290.1 1906666 g26635 i0 46 1.96521739130435 113 57 98.3 2 340 2 429 537 UCE39290.1 MAG: metallophosphoesterase [Thermoplasmata archaeon] diamond 678 94.7 0.992608236536431 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29984294 29984294 PRJNA560932_P_NODE_45811_length_270_cov_1.365482_g45455_i0 PRJNA560932 45811 270 1.365482 3.6868014 Thermoplasmata archaeon 1906666 Archaea Archaea 63.5 2.4e-9   NR MCD6371011.1 1906666 g45455 i0 34.4 1 90 59 100 0 270 1 261 350 MCD6371011.1 serpin family protein [Thermoplasmata archaeon] diamond 270 63.5 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30078849 30078849 PRJNA560932_P_NODE_10432_length_540_cov_1.473233_g10078_i0 PRJNA560932 10432 540 1.473233 7.9554582 Marine Group III euryarchaeote 2173149 Archaea Archaea 136 2.3199999999999993e-34   NR HIA98159.1 2173149 g10078 i0 40.3 2.01111111111111 181 102 97.2 4 8 532 216 396 HIA98159.1 hypothetical protein [Marine Group III euryarchaeote] diamond 1086 136 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Candidatus Thermoprofundales     Marine Group III euryarchaeote
30395354 30395354 PRJNA560932_P_NODE_17833_length_416_cov_2.244898_g17477_i0 PRJNA560932 17833 416 2.244898 9.33877568 Thermoplasmatota archaeon 2806419 Archaea Archaea 44.7 0.0295   NR MDX1612303.1 2806419 g17477 i0 25.9 0.836538461538462 116 76 76.4 2 94 411 6 121 MDX1612303.1 hypothetical protein [Thermoplasmatota archaeon] diamond 348 44.7 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
31152903 31152903 PRJNA560932_P_NODE_53935_length_250_cov_0.870056_g53579_i0 PRJNA560932 53935 250 0.870056 2.17514 Candidatus Thalassarchaeaceae archaeon 2670411 Archaea Archaea 80.1 2.75e-15   NR HJM13006.1 2670411 g53579 i0 60.3 1.632 68 26 81.6 1 224 21 554 620 HJM13006.1 AAA domain-containing protein [Candidatus Thalassarchaeaceae archaeon] diamond 408 80.1 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Thalassarchaeaceae   Candidatus Thalassarchaeaceae archaeon
32084487 32084487 PRJNA560932_P_NODE_27798_length_340_cov_1.730337_g27442_i0 PRJNA560932 27798 340 1.730337 5.8831458 Methanobacteriati 3366610 Archaea Archaea 153 7.07e-42   NR MEM2891424.1 1906666 g27442 i0 67.6 6.66176470588235 108 35 95.3 0 324 1 321 428 MEM2891424.1 aspartate aminotransferase family protein [Thermoplasmata archaeon] diamond 2265 154 0.993506493506494 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;