contig_metadata
13 rows where bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10382653 | 10382653 | PRJNA1063685_S_NODE_1549_length_980_cov_17.334068_g1258_i0 | PRJNA1063685 | 1549 | 980 | 17.334068 | 169.8738664 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 280 | 3.419999999999999e-89 | NR | RYE82365.1 | 2250255 | g1258 | i0 | 47.2 | 0.91530612244898 | 299 | 155 | 90.9 | 2 | 935 | 45 | 24 | 321 | RYE82365.1 MAG: fatty acid desaturase, partial [Methanosarcinales archaeon] | diamond | 897 | 280 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 11215627 | 11215627 | PRJNA1063685_S_NODE_9789_length_632_cov_3.652952_g9277_i0 | PRJNA1063685 | 9789 | 632 | 3.652952 | 23.08665664 | Halalkalicoccus | 332246 | Archaea | Archaea | 1092 | 0 | NTclustered | gi|507148368|ref|NR_103171.1| | 413810 | g9277 | i0 | 99.015 | 177.92246835443 | 609 | 6 | 96 | 0 | 24 | 632 | 631 | 1239 | Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence | blastn | 112447 | 1092 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 11657963 | 11657963 | PRJNA1063685_S_NODE_1970_length_909_cov_12.052632_g1640_i0 | PRJNA1063685 | 1970 | 909 | 12.052632 | 109.55842488 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 1513 | 0 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g1640 | i0 | 97.216 | 133.832783278328 | 898 | 18 | 98 | 5 | 17 | 909 | 2644652 | 2645547 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 121654 | 1513 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 14208136 | 14208136 | PRJNA1063685_S_NODE_24652_length_468_cov_29.486076_g24112_i0 | PRJNA1063685 | 24652 | 468 | 29.486076 | 137.99483568 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 797 | 0 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g24112 | i0 | 98.879 | 138.655982905983 | 446 | 5 | 95 | 0 | 1 | 446 | 2647109 | 2646664 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 64891 | 797 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 18031490 | 18031490 | PRJNA1063685_S_NODE_62595_length_271_cov_4.242424_g62052_i0 | PRJNA1063685 | 62595 | 271 | 4.242424 | 11.49696904 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g62052 | i0 | 100 | 0.103321033210332 | 28 | 0 | 10 | 0 | 166 | 193 | 1215031 | 1215058 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 21413968 | 21413968 | PRJNA1063685_S_NODE_33677_length_404_cov_6.117825_g33135_i0 | PRJNA1063685 | 33677 | 404 | 6.117825 | 24.716013 | Halalkalicoccus | 332246 | Archaea | Archaea | 638 | 2.3399999999999996e-178 | NTclustered | gi|507148368|ref|NR_103171.1| | 413810 | g33135 | i0 | 96.85 | 134.920792079208 | 381 | 12 | 94 | 0 | 1 | 381 | 383 | 3 | Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence | blastn | 54508 | 641 | 0.995319812792512 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 22689008 | 22689008 | PRJNA1063685_S_NODE_75158_length_238_cov_4.096970_g74615_i0 | PRJNA1063685 | 75158 | 238 | 4.09697 | 9.7507886 | Halococcus | 2249 | Archaea | Archaea | 440 | 3.899999999999999e-119 | NTclustered | gi|43626|emb|X05481.1| | 2250 | g74615 | i0 | 100 | 161.852941176471 | 238 | 0 | 100 | 0 | 1 | 238 | 2859 | 2622 | Halococcus morrhuae 23S ribosomal RNA | blastn | 38521 | 440 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus morrhuae | |
| 26814052 | 26814052 | PRJNA1063685_S_NODE_9741_length_633_cov_1.787500_g9229_i0 | PRJNA1063685 | 9741 | 633 | 1.7875 | 11.314875 | Halorussus halophilus | 2650975 | Archaea | Archaea | 64.3 | 8.47e-9 | NR | WP_158056415.1 | 2650975 | g9229 | i0 | 36.4 | 1.35545023696682 | 140 | 68 | 57.8 | 7 | 68 | 433 | 36 | 172 | WP_158056415.1 CHRD domain-containing protein [Halorussus halophilus] | diamond | 858 | 64.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus halophilus | |
| 26972128 | 26972128 | PRJNA1063685_S_NODE_8162_length_660_cov_3.415673_g7662_i0 | PRJNA1063685 | 8162 | 660 | 3.415673 | 22.5434418 | Halosimplex aquaticum | 3026162 | Archaea | Archaea | 112 | 1.66e-24 | NR | WP_274325319.1 | 3026162 | g7662 | i0 | 30.3 | 1.91818181818182 | 211 | 136 | 92.7 | 2 | 648 | 37 | 281 | 487 | WP_274325319.1 PAS domain-containing sensor histidine kinase [Halosimplex aquaticum] | diamond | 1266 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex aquaticum | |
| 29656095 | 29656095 | PRJNA1063685_S_NODE_35230_length_395_cov_2.537267_g34687_i0 | PRJNA1063685 | 35230 | 395 | 2.537267 | 10.02220465 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 64.3 | 3.56e-10 | NR | MCZ7358185.1 | 2032688 | g34687 | i0 | 34 | 3.91139240506329 | 103 | 66 | 78.2 | 1 | 7 | 315 | 17 | 117 | MCZ7358185.1 SRPBCC family protein [Candidatus Methanoperedens sp.] | diamond | 1545 | 64.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 30161661 | 30161661 | PRJNA1063685_S_NODE_33692_length_404_cov_5.057402_g33150_i0 | PRJNA1063685 | 33692 | 404 | 5.057402 | 20.43190408 | Candidatus Methanogaster sp. ANME-2c ERB4 | 2759911 | Archaea | Archaea | 96.3 | 2.62e-20 | NR | AAU82580.1 | 2759911 | g33150 | i0 | 39.1 | 3.8168316831683202 | 138 | 73 | 98.8 | 5 | 402 | 4 | 191 | 322 | AAU82580.1 hypothetical protein GZ18F2_10 [Candidatus Methanogaster sp. ANME-2c ERB4] | diamond | 1542 | 96.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanogasteraceae | Candidatus Methanogaster | Candidatus Methanogaster sp. ANME-2c ERB4 | |
| 30257055 | 30257055 | PRJNA1063685_S_NODE_51212_length_314_cov_1.278008_g50669_i0 | PRJNA1063685 | 51212 | 314 | 1.278008 | 4.01294512 | Methanofollis sp. | 2052835 | Archaea | Archaea | 44.7 | 0.0187 | NR | MDK2974386.1 | 2052835 | g50669 | i0 | 34.8 | 0.85031847133758 | 89 | 53 | 82.2 | 3 | 5 | 262 | 904 | 990 | MDK2974386.1 hypothetical protein [Methanofollis sp.] | diamond | 267 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanofollis | Methanofollis sp. | |
| 30446435 | 30446435 | PRJNA1063685_S_NODE_4893_length_735_cov_24.883686_g4463_i0 | PRJNA1063685 | 4893 | 735 | 24.883686 | 182.8950921 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 58.5 | 4.63e-6 | NR | MCI4343664.1 | 1906666 | g4463 | i0 | 28.3 | 0.763265306122449 | 187 | 109 | 68.2 | 6 | 718 | 218 | 68 | 249 | MCI4343664.1 MBL fold metallo-hydrolase [Thermoplasmata archaeon] | diamond | 561 | 58.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata 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);;