contig_metadata
7 rows where bioproject = "PRJNA763243" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14772801 | 14772801 | PRJNA763243_P_NODE_652_length_1444_cov_19.588621_g531_i0 | PRJNA763243 | 652 | 1444 | 19.588621 | 282.85968724 | Methanimicrococcus stummii | 3028294 | Archaea | Archaea | 2617 | 0 | NTclustered | gi|2444509770|gb|OQ442332.1| | 3028294 | g531 | i0 | 99.445 | 101.673822714681 | 1441 | 8 | 99 | 0 | 1 | 1441 | 1441 | 1 | Methanimicrococcus stummii strain Es2 16S ribosomal RNA gene, partial sequence | blastn | 146817 | 2617 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanimicrococcus | Methanimicrococcus stummii | |
| 19057103 | 19057103 | PRJNA763243_P_NODE_70435_length_218_cov_7.544828_g70089_i0 | PRJNA763243 | 70435 | 218 | 7.544828 | 16.44772504 | Methanosarcina | 2207 | Archaea | Archaea | 327 | 2.86e-85 | NTclustered | gi|2047643091|dbj|AP019780.1| | 2209 | g70089 | i0 | 93.981 | 18.7522935779816 | 216 | 13 | 99 | 0 | 2 | 217 | 3147944 | 3147729 | Methanosarcina mazei TMA DNA, complete genome | blastn | 4088 | 327 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina mazei | |
| 21607572 | 21607572 | PRJNA763243_P_NODE_97_length_2954_cov_21.114891_g70_i0 | PRJNA763243 | 97 | 2954 | 21.114891 | 623.73388014 | Methanimicrococcus | 91559 | Archaea | Archaea | 4649 | 0 | NTclustered | gi|2591779694|gb|CP131062.1| | 3028294 | g70 | i0 | 98.484 | 229.692620176033 | 2638 | 38 | 99 | 2 | 4 | 2640 | 1479504 | 1482140 | Methanimicrococcus stummii strain Es2 chromosome, complete genome | blastn | 678512 | 4662 | 0.997211497211497 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanimicrococcus | Methanimicrococcus stummii | |
| 29326760 | 29326760 | PRJNA763243_P_NODE_8149_length_515_cov_2.871041_g7808_i0 | PRJNA763243 | 8149 | 515 | 2.871041 | 14.78586115 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 59.3 | 1.07e-6 | NR | WP_292800363.1 | 66852 | g7808 | i0 | 48.9 | 0.547572815533981 | 47 | 24 | 27.4 | 0 | 24 | 164 | 942 | 988 | WP_292800363.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 282 | 59.3 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30432678 | 30432678 | PRJNA763243_P_NODE_43813_length_267_cov_43.788660_g43467_i0 | PRJNA763243 | 43813 | 267 | 43.78866 | 116.9157222 | Methanosarcina sp. | 2213 | Archaea | Archaea | 53.5 | 5.62e-6 | NR | HET8686942.1 | 2213 | g43467 | i0 | 56.3 | 0.539325842696629 | 48 | 20 | 53.9 | 1 | 247 | 104 | 58 | 104 | HET8686942.1 portal protein [Methanosarcina sp.] | diamond | 144 | 53.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30979257 | 30979257 | PRJNA763243_P_NODE_20174_length_352_cov_4.161290_g19828_i0 | PRJNA763243 | 20174 | 352 | 4.16129 | 14.6477408 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 1.28e-6 | NR | MFA5398780.1 | 2196 | g19828 | i0 | 40 | 2.59943181818182 | 60 | 33 | 51.1 | 1 | 348 | 169 | 34 | 90 | MFA5398780.1 6-carboxytetrahydropterin synthase [Methanogenium sp.] | diamond | 915 | 56.2 | 0.99288256227758 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 32519533 | 32519533 | PRJNA763243_P_NODE_56499_length_247_cov_0.885057_g56153_i0 | PRJNA763243 | 56499 | 247 | 0.885057 | 2.18609079 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 83.6 | 1.67e-16 | NR | MDP6900288.1 | 2670411 | g56153 | i0 | 61.6 | 4.4331983805668 | 73 | 26 | 86.2 | 2 | 243 | 31 | 501 | 573 | MDP6900288.1 AAA domain-containing protein [Candidatus Thalassarchaeaceae archaeon] | diamond | 1095 | 83.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae 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);;