contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJEB28062" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1299188 | 1299188 | PRJEB28062_P_NODE_50802_length_499_cov_39.654930_g48453_i0 | PRJEB28062 | 50802 | 499 | 39.65493 | 197.8781007 | Halapricum desulfuricans | 2841257 | Archaea | Archaea | 95.3 | 7.99e-15 | NTclustered | gi|1995635729|gb|CP064789.1| | 2841257 | g48453 | i0 | 84.848 | 2.23847695390782 | 99 | 10 | 19 | 4 | 20 | 116 | 816264 | 816169 | Halapricum desulfuricans strain HSR-Bgl chromosome, complete genome | blastn | 1117 | 95.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halapricum | Halapricum desulfuricans | |
| 2575400 | 2575400 | PRJEB28062_P_NODE_79483_length_379_cov_1.447712_g77121_i0 | PRJEB28062 | 79483 | 379 | 1.447712 | 5.48682848 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 383 | 1.1299999999999995e-101 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g77121 | i0 | 91.135 | 0.744063324538259 | 282 | 25 | 74 | 0 | 17 | 298 | 1206256 | 1205975 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 282 | 383 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 3850093 | 3850093 | PRJEB28062_P_NODE_126184_length_248_cov_0.880000_g123820_i0 | PRJEB28062 | 126184 | 248 | 0.88 | 2.1824 | Methanomethylovorans hollandica | 101192 | Archaea | Archaea | 315 | 2.59e-81 | NTclustered | gi|433660872|gb|CP003362.1| | 867904 | g123820 | i0 | 100 | 158.987903225806 | 170 | 0 | 92 | 0 | 79 | 248 | 2361335 | 2361504 | Methanomethylovorans hollandica DSM 15978, complete genome | blastn | 39429 | 315 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanomethylovorans | Methanomethylovorans hollandica | |
| 3850482 | 3850482 | PRJEB28062_P_NODE_22164_length_794_cov_5.818308_g20010_i0 | PRJEB28062 | 22164 | 794 | 5.818308 | 46.19736552 | Halanaeroarchaeum sp. HSR-CO | 2866382 | Archaea | Archaea | 723 | 0 | NTclustered | gi|2295222443|gb|CP087724.1| | 2866382 | g20010 | i0 | 83.947 | 1.77078085642317 | 760 | 116 | 95 | 6 | 22 | 778 | 1624666 | 1625422 | Halanaeroarchaeum sp. HSR-CO chromosome, complete genome | blastn | 1406 | 723 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. HSR-CO | |
| 6403806 | 6403806 | PRJEB28062_P_NODE_84346_length_363_cov_2.800000_g81984_i0 | PRJEB28062 | 84346 | 363 | 2.8 | 10.164 | Methanoculleus palmolei | 72612 | Archaea | Archaea | 555 | 2.1499999999999998e-153 | NTclustered | gi|2618162486|gb|CP137641.1| | 72612 | g81984 | i0 | 97.538 | 1.44077134986226 | 325 | 7 | 89 | 1 | 19 | 342 | 556624 | 556300 | Methanoculleus palmolei strain DSM 4273 chromosome, complete genome | blastn | 523 | 555 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus palmolei | |
| 7675761 | 7675761 | PRJEB28062_P_NODE_103067_length_306_cov_1.150215_g100704_i0 | PRJEB28062 | 103067 | 306 | 1.150215 | 3.5196579 | Methanothrix soehngenii | 2223 | Archaea | Archaea | 514 | 3.03e-141 | NTclustered | gi|328927127|gb|CP002565.1| | 990316 | g100704 | i0 | 99.296 | 2.87581699346405 | 284 | 2 | 93 | 0 | 23 | 306 | 1597226 | 1597509 | Methanosaeta concilii GP-6, complete genome | blastn | 880 | 514 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 8951632 | 8951632 | PRJEB28062_P_NODE_37268_length_599_cov_1.644487_g34941_i0 | PRJEB28062 | 37268 | 599 | 1.644487 | 9.85047713 | Halorubrum salinarum | 2739057 | Archaea | Archaea | 556 | 1.0299999999999997e-153 | NTclustered | gi|1848526000|gb|CP053941.1| | 2739057 | g34941 | i0 | 89.087 | 22.5976627712855 | 449 | 47 | 75 | 2 | 152 | 599 | 2435622 | 2435175 | Halorubrum salinarum strain RHB-C chromosome, complete genome | blastn | 13536 | 556 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum salinarum | |
| 10228325 | 10228325 | PRJEB28062_P_NODE_82129_length_370_cov_3.653199_g79767_i0 | PRJEB28062 | 82129 | 370 | 3.653199 | 13.5168363 | uncultured Methanomicrobiales archaeon | 183760 | Archaea | Archaea | 527 | 4.7899999999999985e-145 | NTclustered | gi|2874253666|emb|OY969100.1| | 183760 | g79767 | i0 | 94.94 | 141.991891891892 | 336 | 17 | 91 | 0 | 9 | 344 | 1372521 | 1372186 | MAG: uncultured Methanomicrobiales archaeon isolate MFD10007.bin.c.6 genome assembly, chromosome: 1 | blastn | 52537 | 527 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | uncultured Methanomicrobiales archaeon | |||
| 11190370 | 11190370 | PRJEB28062_P_NODE_127729_length_245_cov_2.848837_g125365_i0 | PRJEB28062 | 127729 | 245 | 2.848837 | 6.97965065 | Methanomethylovorans | 101191 | Archaea | Archaea | 431 | 2.4299999999999996e-116 | NTclustered | gi|485099164|ref|NR_102558.1| | 101192 | g125365 | i0 | 99.167 | 231.142857142857 | 240 | 1 | 98 | 1 | 1 | 239 | 1259 | 1498 | Methanomethylovorans hollandica strain DMS1 23S ribosomal RNA gene, complete sequence | blastn | 56630 | 431 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanomethylovorans | Methanomethylovorans hollandica | |
| 11191173 | 11191173 | PRJEB28062_P_NODE_82389_length_369_cov_5.587838_g80027_i0 | PRJEB28062 | 82389 | 369 | 5.587838 | 20.61912222 | Methanothrix | 2222 | Archaea | Archaea | 610 | 4.6099999999999996e-170 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g80027 | i0 | 98.834 | 1.85907859078591 | 343 | 2 | 92 | 1 | 23 | 363 | 1065256 | 1065598 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 686 | 610 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 11191214 | 11191214 | PRJEB28062_P_NODE_86589_length_356_cov_2.558304_g84227_i0 | PRJEB28062 | 86589 | 356 | 2.558304 | 9.10756224 | Methanothrix | 2222 | Archaea | Archaea | 601 | 2.6699999999999993e-167 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g84227 | i0 | 99.396 | 1.85955056179775 | 331 | 2 | 93 | 0 | 10 | 340 | 1376228 | 1375898 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 662 | 601 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 13740375 | 13740375 | PRJEB28062_P_NODE_107751_length_292_cov_9.452055_g105388_i0 | PRJEB28062 | 107751 | 292 | 9.452055 | 27.6000006 | Methanosphaerula | 475087 | Archaea | Archaea | 344 | 3.9899999999999985e-90 | NTclustered | gi|470483922|ref|NR_076620.1| | 475088 | g105388 | i0 | 93.534 | 86.1027397260274 | 232 | 14 | 93 | 1 | 1 | 231 | 1845 | 1614 | Methanosphaerula palustris strain E1-9c 23S ribosomal RNA gene, complete sequence | blastn | 25142 | 344 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanosphaerula | Methanosphaerula palustris | |
| 15327725 | 15327725 | PRJEB28062_P_NODE_82073_length_370_cov_5.387205_g79711_i0 | PRJEB28062 | 82073 | 370 | 5.387205 | 19.9326585 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 398 | 3.9199999999999994e-106 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g79711 | i0 | 88.06 | 0.905405405405405 | 335 | 40 | 91 | 0 | 21 | 355 | 2864397 | 2864063 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 335 | 398 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 15327970 | 15327970 | PRJEB28062_P_NODE_94013_length_333_cov_1.365385_g91651_i0 | PRJEB28062 | 94013 | 333 | 1.365385 | 4.54673205 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 137 | 8.42e-28 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g91651 | i0 | 83.673 | 0.441441441441441 | 147 | 22 | 44 | 2 | 7 | 152 | 3165097 | 3164952 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 147 | 137 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 16289802 | 16289802 | PRJEB28062_P_NODE_138513_length_150_cov_7.946188_g136149_i0 | PRJEB28062 | 138513 | 150 | 7.946188 | 11.919282 | Methanosphaerula | 475087 | Archaea | Archaea | 180 | 5.37e-41 | NTclustered | gi|470483922|ref|NR_076620.1| | 475088 | g136149 | i0 | 97.17 | 26.4666666666667 | 106 | 3 | 98 | 0 | 45 | 150 | 1951 | 1846 | Methanosphaerula palustris strain E1-9c 23S ribosomal RNA gene, complete sequence | blastn | 3970 | 180 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanosphaerula | Methanosphaerula palustris | |
| 19149601 | 19149601 | PRJEB28062_P_NODE_13736_length_1035_cov_3.994802_g11919_i0 | PRJEB28062 | 13736 | 1035 | 3.994802 | 41.3462007 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 472 | 6.81e-128 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g11919 | i0 | 76.275 | 53.2425120772947 | 1020 | 164 | 94 | 59 | 31 | 1003 | 3095927 | 3096915 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 55106 | 472 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 19150766 | 19150766 | PRJEB28062_P_NODE_6516_length_1550_cov_2.781991_g5284_i0 | PRJEB28062 | 6516 | 1550 | 2.781991 | 43.1208605 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 1375 | 0 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g5284 | i0 | 82.548 | 89.4393548387097 | 1570 | 246 | 100 | 22 | 1 | 1550 | 3109920 | 3111481 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 138631 | 1375 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 20114073 | 20114073 | PRJEB28062_P_NODE_49356_length_508_cov_22.864368_g47008_i0 | PRJEB28062 | 49356 | 508 | 22.864368 | 116.15098944 | Methanothrix | 2222 | Archaea | Archaea | 852 | 0 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g47008 | i0 | 99.363 | 1.85433070866142 | 471 | 2 | 93 | 1 | 24 | 494 | 1831102 | 1831571 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 942 | 852 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 20426150 | 20426150 | PRJEB28062_P_NODE_76197_length_390_cov_1.990536_g73835_i0 | PRJEB28062 | 76197 | 390 | 1.990536 | 7.7630904 | Halomicrobium salinisoli | 2878391 | Archaea | Archaea | 416 | 1.15e-111 | NTclustered | gi|2110956525|gb|CP084463.1| | 2878391 | g73835 | i0 | 88.63 | 87.8153846153846 | 343 | 37 | 88 | 2 | 21 | 362 | 1116730 | 1116389 | Halomicrobium salinisoli strain LT50 chromosome, complete genome | blastn | 34248 | 416 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halomicrobium | Halomicrobium salinisoli | |
| 21700295 | 21700295 | PRJEB28062_P_NODE_107658_length_293_cov_1.359091_g105295_i0 | PRJEB28062 | 107658 | 293 | 1.359091 | 3.98213663 | Methanothrix soehngenii | 2223 | Archaea | Archaea | 520 | 6.2e-143 | NTclustered | gi|328927127|gb|CP002565.1| | 990316 | g105295 | i0 | 99.648 | 12.839590443686 | 284 | 1 | 97 | 0 | 10 | 293 | 932710 | 932993 | Methanosaeta concilii GP-6, complete genome | blastn | 3762 | 520 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 22664221 | 22664221 | PRJEB28062_P_NODE_25318_length_739_cov_4.953453_g23092_i0 | PRJEB28062 | 25318 | 739 | 4.953453 | 36.60601767 | Methanomicrobiales | 2191 | Archaea | Archaea | 1009 | 0 | NTclustered | gi|470483922|ref|NR_076620.1| | 475088 | g23092 | i0 | 92.714 | 161.966170500677 | 700 | 49 | 94 | 2 | 34 | 731 | 2853 | 2154 | Methanosphaerula palustris strain E1-9c 23S ribosomal RNA gene, complete sequence | blastn | 119693 | 1009 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanosphaerula | Methanosphaerula palustris | |
| 22976982 | 22976982 | PRJEB28062_P_NODE_51879_length_493_cov_12.102381_g49528_i0 | PRJEB28062 | 51879 | 493 | 12.102381 | 59.66473833 | Halorubrum sp. CBA1229 | 1853699 | Archaea | Archaea | 628 | 1.7499999999999994e-175 | NTclustered | gi|1861358827|gb|CP054585.1| | 1853699 | g49528 | i0 | 92.661 | 64.8803245436105 | 436 | 32 | 88 | 0 | 36 | 471 | 2598800 | 2599235 | Halorubrum sp. CBA1229 chromosome, complete genome | blastn | 31986 | 628 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. CBA1229 |
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);;