contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB39269" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1331397 | 1331397 | PRJEB39269_P_NODE_88062_length_152_cov_2.469027_g87657_i0 | PRJEB39269 | 88062 | 152 | 2.469027 | 3.75292104 | Haloferax volcanii | 2246 | Archaea | Archaea | 148 | 1.54e-31 | NTclustered | gi|2460998611|gb|CP106970.1| | 2246 | g87657 | i0 | 100 | 24.5855263157895 | 80 | 0 | 53 | 0 | 73 | 152 | 42883 | 42962 | Haloferax volcanii strain BNX82 plasmid pBNX82-4, complete sequence | blastn | 3737 | 148 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 7709428 | 7709428 | PRJEB39269_P_NODE_35727_length_231_cov_1.223958_g35322_i0 | PRJEB39269 | 35727 | 231 | 1.223958 | 2.82734298 | uncultured Methanosaeta sp. | 183756 | Archaea | Archaea | 377 | 3e-100 | NTclustered | gi|62512344|gb|AY899830.1| | 183756 | g35322 | i0 | 96.104 | 99.0822510822511 | 231 | 9 | 100 | 0 | 1 | 231 | 679 | 449 | Uncultured Methanosaeta sp. clone Gran2M12 16S ribosomal RNA gene, partial sequence | blastn | 22888 | 377 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | uncultured Methanosaeta sp. | |
| 9917438 | 9917438 | PRJEB39269_P_NODE_66868_length_170_cov_2.992366_g66463_i0 | PRJEB39269 | 66868 | 170 | 2.992366 | 5.0870222 | Halobacterium | 2239 | Archaea | Archaea | 54.7 | 0.004 | NTclustered | gi|966204314|emb|LN831302.1| | 1407499 | g66463 | i0 | 86 | 0.588235294117647 | 50 | 7 | 29 | 0 | 92 | 141 | 2134551 | 2134600 | Halobacterium hubeiense strain JI20-1 genome assembly, chromosome: I | blastn | 100 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium hubeiense | |
| 9917466 | 9917466 | PRJEB39269_P_NODE_80588_length_158_cov_2.747899_g80183_i0 | PRJEB39269 | 80588 | 158 | 2.747899 | 4.34168042 | Halobacteriales | 2235 | Archaea | Archaea | 76.8 | 7.75e-10 | NTclustered | gi|2006040148|gb|CP071463.1| | 370324 | g80183 | i0 | 97.778 | 3.93670886075949 | 45 | 0 | 28 | 1 | 19 | 63 | 407676 | 407633 | Natrinema longum strain ABH32 chromosome, complete genome | blastn | 622 | 76.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema longum | |
| 10259852 | 10259852 | PRJEB39269_P_NODE_66309_length_170_cov_3.870229_g65904_i0 | PRJEB39269 | 66309 | 170 | 3.870229 | 6.5793893 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 110 | 8.32e-20 | NTclustered | gi|933677909|gb|CP011564.1| | 1604004 | g65904 | i0 | 91.358 | 0.952941176470588 | 81 | 5 | 47 | 2 | 1 | 80 | 1584436 | 1584357 | Halanaeroarchaeum sulfurireducens strain M27-SA2, complete genome | blastn | 162 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 12468387 | 12468387 | PRJEB39269_P_NODE_80530_length_158_cov_2.966387_g80125_i0 | PRJEB39269 | 80530 | 158 | 2.966387 | 4.68689146 | Natribaculum | 1699375 | Archaea | Archaea | 93.5 | 7.69e-15 | NTclustered | gi|2224381021|gb|CP095390.1| | 1419050 | g80125 | i0 | 87.5 | 1.48101265822785 | 80 | 10 | 51 | 0 | 2 | 81 | 399201 | 399280 | Natribaculum breve strain TRM20010 chromosome, complete genome | blastn | 234 | 93.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natribaculum | Natribaculum breve | |
| 20457860 | 20457860 | PRJEB39269_P_NODE_38077_length_223_cov_1.483696_g37672_i0 | PRJEB39269 | 38077 | 223 | 1.483696 | 3.30864208 | Methanothrix sp. | 90426 | Archaea | Archaea | 407 | 3.67e-109 | NTclustered | gi|2626216449|emb|OY821645.1| | 90426 | g37672 | i0 | 99.552 | 55.3408071748879 | 223 | 1 | 100 | 0 | 1 | 223 | 824871 | 825093 | MAG: Methanothrix sp. isolate d1628e35-7b52-4540-a147-c2ca1342adce genome assembly, chromosome: 1 | blastn | 12341 | 407 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 23941568 | 23941568 | PRJEB39269_P_NODE_66419_length_170_cov_3.618321_g66014_i0 | PRJEB39269 | 66419 | 170 | 3.618321 | 6.1511457 | Halobacterium | 2239 | Archaea | Archaea | 119 | 1.3800000000000001e-22 | NTclustered | gi|573484043|gb|CP007060.1| | 751944 | g66014 | i0 | 94.737 | 0.894117647058824 | 76 | 4 | 45 | 0 | 1 | 76 | 2141689 | 2141614 | Halobacterium sp. DL1, complete genome | blastn | 152 | 119 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. DL1 |
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);;