contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA758088" and tax_clade = "Methanomada 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2012065 | 2012065 | PRJNA758088_P_NODE_231602_length_280_cov_1.115942_g224631_i0 | PRJNA758088 | 231602 | 280 | 1.115942 | 3.1246376 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 518 | 2.12e-142 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g224631 | i0 | 100 | 6.99642857142857 | 280 | 0 | 100 | 0 | 1 | 280 | 1472708 | 1472429 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 1959 | 518 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 2013904 | 2013904 | PRJNA758088_P_NODE_356462_length_242_cov_0.911243_g349491_i0 | PRJNA758088 | 356462 | 242 | 0.911243 | 2.20520806 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 448 | 2.3799999999999995e-121 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g349491 | i0 | 100 | 7 | 242 | 0 | 100 | 0 | 1 | 242 | 1019200 | 1018959 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1694 | 448 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 5840801 | 5840801 | PRJNA758088_P_NODE_315205_length_247_cov_0.885057_g308234_i0 | PRJNA758088 | 315205 | 247 | 0.885057 | 2.18609079 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 448 | 2.4399999999999993e-121 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g308234 | i0 | 99.592 | 6.94331983805668 | 245 | 1 | 99 | 0 | 3 | 247 | 588222 | 588466 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 1715 | 448 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 6307819 | 6307819 | PRJNA758088_P_NODE_323425_length_246_cov_0.890173_g316454_i0 | PRJNA758088 | 323425 | 246 | 0.890173 | 2.18982558 | Methanobrevibacter | 2172 | Archaea | Archaea | 444 | 3.14e-120 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g316454 | i0 | 99.187 | 6 | 246 | 2 | 100 | 0 | 1 | 246 | 9950 | 10195 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1476 | 444 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 7116649 | 7116649 | PRJNA758088_P_NODE_355686_length_242_cov_0.911243_g348715_i0 | PRJNA758088 | 355686 | 242 | 0.911243 | 2.20520806 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 442 | 1.1099999999999995e-119 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g348715 | i0 | 99.587 | 6.97933884297521 | 242 | 1 | 100 | 0 | 1 | 242 | 910922 | 910681 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1689 | 442 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 8390033 | 8390033 | PRJNA758088_P_NODE_280287_length_251_cov_1.106742_g273316_i0 | PRJNA758088 | 280287 | 251 | 1.106742 | 2.77792242 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 459 | 1.1499999999999996e-124 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g273316 | i0 | 99.602 | 7.17131474103586 | 251 | 1 | 100 | 0 | 1 | 251 | 885003 | 884753 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 1800 | 459 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 8857266 | 8857266 | PRJNA758088_P_NODE_94387_length_433_cov_1.261111_g87417_i0 | PRJNA758088 | 94387 | 433 | 1.261111 | 5.46061063 | Methanobrevibacter | 2172 | Archaea | Archaea | 800 | 0 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g87417 | i0 | 100 | 9.98845265588915 | 433 | 0 | 100 | 0 | 1 | 433 | 1684911 | 1684479 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 4325 | 800 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 9665724 | 9665724 | PRJNA758088_P_NODE_315188_length_247_cov_0.885057_g308217_i0 | PRJNA758088 | 315188 | 247 | 0.885057 | 2.18609079 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 457 | 4.05e-124 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g308217 | i0 | 100 | 8.24696356275304 | 247 | 0 | 100 | 0 | 1 | 247 | 1778980 | 1778734 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 2037 | 457 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 10132408 | 10132408 | PRJNA758088_P_NODE_314288_length_247_cov_0.885057_g307317_i0 | PRJNA758088 | 314288 | 247 | 0.885057 | 2.18609079 | Methanococcus | 2184 | Archaea | Archaea | 457 | 4.05e-124 | NTclustered | gi|2891706660|gb|CP178162.1| | 39152 | g307317 | i0 | 100 | 8.98380566801619 | 247 | 0 | 100 | 0 | 1 | 247 | 644024 | 644270 | Methanococcus maripaludis strain LL chromosome, complete genome | blastn | 2219 | 457 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus maripaludis | |
| 12214871 | 12214871 | PRJNA758088_P_NODE_182070_length_315_cov_0.896694_g175099_i0 | PRJNA758088 | 182070 | 315 | 0.896694 | 2.8245861 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 582 | 8.459999999999998e-162 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g175099 | i0 | 100 | 1 | 315 | 0 | 100 | 0 | 1 | 315 | 274779 | 274465 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 315 | 582 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 12215338 | 12215338 | PRJNA758088_P_NODE_212730_length_292_cov_1.127854_g205759_i0 | PRJNA758088 | 212730 | 292 | 1.127854 | 3.29333368 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 529 | 1.0299999999999996e-145 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g205759 | i0 | 99.315 | 2 | 292 | 2 | 100 | 0 | 1 | 292 | 1366363 | 1366654 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 584 | 529 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 12216999 | 12216999 | PRJNA758088_P_NODE_321550_length_246_cov_0.890173_g314579_i0 | PRJNA758088 | 321550 | 246 | 0.890173 | 2.18982558 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 455 | 1.4500000000000002e-123 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g314579 | i0 | 100 | 7.98373983739837 | 246 | 0 | 100 | 0 | 1 | 246 | 421492 | 421247 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1964 | 455 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 13490758 | 13490758 | PRJNA758088_P_NODE_294431_length_250_cov_0.870056_g287460_i0 | PRJNA758088 | 294431 | 250 | 0.870056 | 2.17514 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 353 | 5.54e-93 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g287460 | i0 | 92.339 | 5.92 | 248 | 19 | 99 | 0 | 3 | 250 | 1774562 | 1774809 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 1480 | 353 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 16039591 | 16039591 | PRJNA758088_P_NODE_292153_length_250_cov_0.870056_g285182_i0 | PRJNA758088 | 292153 | 250 | 0.870056 | 2.17514 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 462 | 8.83e-126 | NTclustered | gi|148551077|gb|CP000678.1| | 420247 | g285182 | i0 | 100 | 7 | 250 | 0 | 100 | 0 | 1 | 250 | 356734 | 356983 | Methanobrevibacter smithii ATCC 35061, complete genome | blastn | 1750 | 462 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 16040683 | 16040683 | PRJNA758088_P_NODE_364253_length_241_cov_0.916667_g357282_i0 | PRJNA758088 | 364253 | 241 | 0.916667 | 2.20916747 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 446 | 8.519999999999999e-121 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g357282 | i0 | 100 | 4.98755186721992 | 241 | 0 | 100 | 0 | 1 | 241 | 736443 | 736203 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1202 | 446 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 16506547 | 16506547 | PRJNA758088_P_NODE_292933_length_250_cov_0.870056_g285962_i0 | PRJNA758088 | 292933 | 250 | 0.870056 | 2.17514 | Methanobrevibacter | 2172 | Archaea | Archaea | 462 | 8.83e-126 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g285962 | i0 | 100 | 11.216 | 250 | 0 | 100 | 0 | 1 | 250 | 385136 | 384887 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 2804 | 462 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 18586010 | 18586010 | PRJNA758088_P_NODE_110215_length_399_cov_1.417178_g103245_i0 | PRJNA758088 | 110215 | 399 | 1.417178 | 5.65454022 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 732 | 0 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g103245 | i0 | 99.749 | 7 | 399 | 1 | 100 | 0 | 1 | 399 | 1581846 | 1581448 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 2793 | 732 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 19055503 | 19055503 | PRJNA758088_P_NODE_317415_length_247_cov_0.885057_g310444_i0 | PRJNA758088 | 317415 | 247 | 0.885057 | 2.18609079 | Methanobrevibacter | 2172 | Archaea | Archaea | 451 | 1.88e-122 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g310444 | i0 | 99.595 | 7 | 247 | 1 | 100 | 0 | 1 | 247 | 38934 | 39180 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 1729 | 451 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 21606065 | 21606065 | PRJNA758088_P_NODE_355157_length_242_cov_0.911243_g348186_i0 | PRJNA758088 | 355157 | 242 | 0.911243 | 2.20520806 | Methanobrevibacter | 2172 | Archaea | Archaea | 448 | 2.3799999999999995e-121 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g348186 | i0 | 100 | 7.34710743801653 | 242 | 0 | 100 | 0 | 1 | 242 | 419514 | 419755 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1778 | 448 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 24154767 | 24154767 | PRJNA758088_P_NODE_155239_length_339_cov_0.868421_g148268_i0 | PRJNA758088 | 155239 | 339 | 0.868421 | 2.94394719 | Methanobrevibacter | 2172 | Archaea | Archaea | 627 | 4.1799999999999996e-175 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g148268 | i0 | 100 | 8.84660766961652 | 339 | 0 | 100 | 0 | 1 | 339 | 591825 | 591487 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 2999 | 627 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii |
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);;