contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1123436" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2304467 | 2304467 | PRJNA1123436_P_NODE_107742_length_247_cov_0.885057_g106528_i0 | PRJNA1123436 | 107742 | 247 | 0.885057 | 2.18609079 | Methanothrix | 2222 | Archaea | Archaea | 446 | 8.759999999999998e-121 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g106528 | i0 | 99.19 | 2 | 247 | 2 | 100 | 0 | 1 | 247 | 2144540 | 2144786 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 494 | 446 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 2830724 | 2830724 | PRJNA1123436_P_NODE_60503_length_321_cov_0.911290_g59289_i0 | PRJNA1123436 | 60503 | 321 | 0.91129 | 2.9252409 | Methanocella conradii | 1175444 | Archaea | Archaea | 226 | 1.6799999999999995e-54 | NTclustered | gi|379319823|gb|CP003243.1| | 1041930 | g59289 | i0 | 81.455 | 80.5576323987539 | 275 | 51 | 86 | 0 | 37 | 311 | 208566 | 208292 | Methanocella conradii HZ254, complete genome | blastn | 25859 | 226 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella conradii | |
| 4105907 | 4105907 | PRJNA1123436_P_NODE_108384_length_247_cov_0.885057_g107170_i0 | PRJNA1123436 | 108384 | 247 | 0.885057 | 2.18609079 | Methanocella paludicola | 570267 | Archaea | Archaea | 368 | 1.95e-97 | NTclustered | gi|282154984|dbj|AP011532.1| | 304371 | g107170 | i0 | 93.522 | 3.93117408906883 | 247 | 16 | 100 | 0 | 1 | 247 | 399441 | 399687 | Methanocella paludicola SANAE DNA, complete genome | blastn | 971 | 368 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella paludicola | |
| 4106084 | 4106084 | PRJNA1123436_P_NODE_117244_length_244_cov_0.900585_g116030_i0 | PRJNA1123436 | 117244 | 244 | 0.900585 | 2.1974274 | Methanoregula sp. | 2052170 | Archaea | Archaea | 272 | 1.55e-68 | NTclustered | gi|2381065543|gb|CP112999.1| | 2052170 | g116030 | i0 | 87.083 | 0.983606557377049 | 240 | 31 | 98 | 0 | 1 | 240 | 1057020 | 1057259 | MAG: Methanoregula sp. isolate DGG0 chromosome, complete genome | blastn | 240 | 272 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 6658152 | 6658152 | PRJNA1123436_P_NODE_74006_length_289_cov_1.282407_g72792_i0 | PRJNA1123436 | 74006 | 289 | 1.282407 | 3.70615623 | Methanoregula sp. | 2052170 | Archaea | Archaea | 385 | 2.32e-102 | NTclustered | gi|2381065543|gb|CP112999.1| | 2052170 | g72792 | i0 | 90.657 | 1 | 289 | 27 | 100 | 0 | 1 | 289 | 1791082 | 1790794 | MAG: Methanoregula sp. isolate DGG0 chromosome, complete genome | blastn | 289 | 385 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 8682766 | 8682766 | PRJNA1123436_P_NODE_48747_length_359_cov_0.898601_g47533_i0 | PRJNA1123436 | 48747 | 359 | 0.898601 | 3.22597759 | root | 1 | Root_unresolved | Root_unresolved | 496 | 1.31e-135 | NTclustered | gi|2626216449|emb|OY821645.1| | 90426 | g47533 | i0 | 91.667 | 27.0222841225627 | 360 | 26 | 100 | 4 | 1 | 359 | 827174 | 826818 | MAG: Methanothrix sp. isolate d1628e35-7b52-4540-a147-c2ca1342adce genome assembly, chromosome: 1 | blastn | 9701 | 496 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 9206849 | 9206849 | PRJNA1123436_P_NODE_111668_length_246_cov_0.890173_g110454_i0 | PRJNA1123436 | 111668 | 246 | 0.890173 | 2.18982558 | Candidatus Methanophaga sp. ANME-1 ERB7 | 2759913 | Archaea | Archaea | 257 | 4.39e-64 | NTclustered | gi|1899286742|gb|MT631710.1| | 2759913 | g110454 | i0 | 85.714 | 34.2276422764228 | 245 | 33 | 99 | 2 | 1 | 244 | 15747 | 15504 | Candidatus Methanophaga sp. ANME-1 ERB7 clone GZfos13G2 seq_00001 genomic sequence | blastn | 8420 | 257 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagaceae | Candidatus Methanophaga | Candidatus Methanophaga sp. ANME-1 ERB7 | |
| 9208368 | 9208368 | PRJNA1123436_P_NODE_76708_length_284_cov_1.417062_g75494_i0 | PRJNA1123436 | 76708 | 284 | 1.417062 | 4.02445608 | Natrinema sp. SYSU A 869 | 2871694 | Archaea | Archaea | 99 | 3.32e-16 | NTclustered | gi|2089988103|gb|CP082249.1| | 2871694 | g75494 | i0 | 89.61 | 6.73239436619718 | 77 | 8 | 27 | 0 | 2 | 78 | 2562179 | 2562255 | Natrinema sp. SYSU A 869 chromosome, complete genome | blastn | 1912 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema sp. SYSU A 869 | |
| 9208822 | 9208822 | PRJNA1123436_P_NODE_98948_length_250_cov_0.870056_g97734_i0 | PRJNA1123436 | 98948 | 250 | 0.870056 | 2.17514 | Halorubrum salinarum | 2739057 | Archaea | Archaea | 457 | 4.1099999999999985e-124 | NTclustered | gi|1848529114|gb|CP053943.1| | 2739057 | g97734 | i0 | 99.6 | 28.6 | 250 | 1 | 100 | 0 | 1 | 250 | 34424 | 34673 | Halorubrum salinarum strain RHB-C plasmid pHAR02, complete sequence | blastn | 7150 | 457 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum salinarum | |
| 10482692 | 10482692 | PRJNA1123436_P_NODE_122069_length_243_cov_0.858824_g120855_i0 | PRJNA1123436 | 122069 | 243 | 0.858824 | 2.08694232 | Methanoregula sp. | 2052170 | Archaea | Archaea | 294 | 3.3e-75 | NTclustered | gi|2381065543|gb|CP112999.1| | 2052170 | g120855 | i0 | 89.03 | 0.975308641975309 | 237 | 26 | 98 | 0 | 7 | 243 | 2105580 | 2105344 | MAG: Methanoregula sp. isolate DGG0 chromosome, complete genome | blastn | 237 | 294 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 11759102 | 11759102 | PRJNA1123436_P_NODE_83270_length_272_cov_1.160804_g82056_i0 | PRJNA1123436 | 83270 | 272 | 1.160804 | 3.15738688 | Natrarchaeobaculum aegyptiacum | 745377 | Archaea | Archaea | 195 | 3.92e-45 | NTclustered | gi|1196598842|gb|CP019893.1| | 745377 | g82056 | i0 | 82.667 | 84.9007352941177 | 225 | 33 | 82 | 6 | 5 | 226 | 3274533 | 3274754 | Natrarchaeobaculum aegyptiacum strain JW/NM-HA 15 chromosome, complete genome | blastn | 23093 | 195 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrarchaeobaculum | Natrarchaeobaculum aegyptiacum | |
| 14308007 | 14308007 | PRJNA1123436_P_NODE_122192_length_242_cov_1.816568_g120978_i0 | PRJNA1123436 | 122192 | 242 | 1.816568 | 4.39609456 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 315 | 2.52e-81 | NTclustered | gi|805398754|gb|CP009526.1| | 1434109 | g120978 | i0 | 90.678 | 1.95454545454545 | 236 | 22 | 98 | 0 | 3 | 238 | 1287705 | 1287470 | Methanosarcina barkeri str. Wiesmoor, complete genome | blastn | 473 | 315 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 15581573 | 15581573 | PRJNA1123436_P_NODE_102733_length_249_cov_0.875000_g101519_i0 | PRJNA1123436 | 102733 | 249 | 0.875 | 2.17875 | Halobacterium salinarum | 2242 | Archaea | Archaea | 449 | 6.840000000000001e-122 | NTclustered | gi|2696630377|gb|CP146627.1| | 2242 | g101519 | i0 | 99.197 | 2 | 249 | 2 | 100 | 0 | 1 | 249 | 38185 | 37937 | Halobacterium salinarum strain KBTZ03 plasmid pKBTZ03_58, complete sequence | blastn | 498 | 449 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium salinarum | |
| 18130439 | 18130439 | PRJNA1123436_P_NODE_100515_length_249_cov_1.687500_g99301_i0 | PRJNA1123436 | 100515 | 249 | 1.6875 | 4.201875 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 305 | 1.57e-78 | NTclustered | gi|805398754|gb|CP009526.1| | 1434109 | g99301 | i0 | 91.48 | 4.44979919678715 | 223 | 18 | 89 | 1 | 1 | 222 | 4071039 | 4071261 | Methanosarcina barkeri str. Wiesmoor, complete genome | blastn | 1108 | 305 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 19404805 | 19404805 | PRJNA1123436_P_NODE_111756_length_246_cov_0.890173_g110542_i0 | PRJNA1123436 | 111756 | 246 | 0.890173 | 2.18982558 | Methanoregula sp. | 2052170 | Archaea | Archaea | 322 | 1.53e-83 | NTclustered | gi|2381065543|gb|CP112999.1| | 2052170 | g110542 | i0 | 90.244 | 1 | 246 | 24 | 100 | 0 | 1 | 246 | 1223014 | 1222769 | MAG: Methanoregula sp. isolate DGG0 chromosome, complete genome | blastn | 246 | 322 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 20680134 | 20680134 | PRJNA1123436_P_NODE_100377_length_250_cov_0.864407_g99163_i0 | PRJNA1123436 | 100377 | 250 | 0.864407 | 2.1610175 | Methanoregula sp. | 2052170 | Archaea | Archaea | 292 | 1.2299999999999999e-74 | NTclustered | gi|2381065543|gb|CP112999.1| | 2052170 | g99163 | i0 | 87.903 | 1.112 | 248 | 30 | 99 | 0 | 1 | 248 | 1655601 | 1655354 | MAG: Methanoregula sp. isolate DGG0 chromosome, complete genome | blastn | 278 | 292 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 23231980 | 23231980 | PRJNA1123436_P_NODE_40939_length_394_cov_1.127726_g39725_i0 | PRJNA1123436 | 40939 | 394 | 1.127726 | 4.44324044 | Methanothrix sp. | 90426 | Archaea | Archaea | 640 | 6.319999999999999e-179 | NTclustered | gi|2626216449|emb|OY821645.1| | 90426 | g39725 | i0 | 95.939 | 121.639593908629 | 394 | 16 | 100 | 0 | 1 | 394 | 824695 | 825088 | MAG: Methanothrix sp. isolate d1628e35-7b52-4540-a147-c2ca1342adce genome assembly, chromosome: 1 | blastn | 47926 | 640 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. |
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);;