contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA758088" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3755432 | 3755432 | PRJNA758088_P_NODE_306023_length_248_cov_0.880000_g299052_i0 | PRJNA758088 | 306023 | 248 | 0.88 | 2.1824 | Methanoregula | 395331 | Archaea | Archaea | 459 | 1.13e-124 | NTclustered | gi|432136161|gb|CP003167.1| | 593750 | g299052 | i0 | 100 | 113.229838709677 | 248 | 0 | 100 | 0 | 1 | 248 | 548781 | 549028 | Methanoregula formicica SMSP, complete genome | blastn | 28081 | 459 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula formicica | |
| 5032091 | 5032091 | PRJNA758088_P_NODE_342584_length_244_cov_0.900585_g335613_i0 | PRJNA758088 | 342584 | 244 | 0.900585 | 2.1974274 | Methanothrix | 2222 | Archaea | Archaea | 296 | 9.21e-76 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g335613 | i0 | 92.019 | 3.68852459016393 | 213 | 14 | 86 | 2 | 1 | 211 | 416226 | 416437 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 900 | 296 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 7116224 | 7116224 | PRJNA758088_P_NODE_328246_length_245_cov_1.331395_g321275_i0 | PRJNA758088 | 328246 | 245 | 1.331395 | 3.26191775 | Methanothrix sp. | 90426 | Archaea | Archaea | 409 | 1.1399999999999998e-109 | NTclustered | gi|2626216449|emb|OY821645.1| | 90426 | g321275 | i0 | 96.748 | 25.5183673469388 | 246 | 6 | 100 | 2 | 1 | 245 | 826893 | 827137 | MAG: Methanothrix sp. isolate d1628e35-7b52-4540-a147-c2ca1342adce genome assembly, chromosome: 1 | blastn | 6252 | 409 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 8389244 | 8389244 | PRJNA758088_P_NODE_224267_length_284_cov_2.075829_g217296_i0 | PRJNA758088 | 224267 | 284 | 2.075829 | 5.89535436 | Methanosarcina horonobensis | 418008 | Archaea | Archaea | 486 | 6.069999999999999e-133 | NTclustered | gi|805380606|gb|CP009516.1| | 1434110 | g217296 | i0 | 97.865 | 196.334507042254 | 281 | 6 | 99 | 0 | 4 | 284 | 47831 | 48111 | Methanosarcina horonobensis HB-1, complete genome | blastn | 55759 | 486 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina horonobensis | |
| 8391026 | 8391026 | PRJNA758088_P_NODE_345727_length_243_cov_0.905882_g338756_i0 | PRJNA758088 | 345727 | 243 | 0.905882 | 2.20129326 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 147 | 9.77e-31 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g338756 | i0 | 80.978 | 0.757201646090535 | 184 | 35 | 76 | 0 | 60 | 243 | 1153198 | 1153015 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 184 | 147 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 9663652 | 9663652 | PRJNA758088_P_NODE_171208_length_324_cov_1.135458_g164237_i0 | PRJNA758088 | 171208 | 324 | 1.135458 | 3.67888392 | Methanothrix sp. | 90426 | Archaea | Archaea | 588 | 1.88e-163 | NTclustered | gi|2626216449|emb|OY821645.1| | 90426 | g164237 | i0 | 99.383 | 232.04012345679 | 324 | 2 | 100 | 0 | 1 | 324 | 826179 | 825856 | MAG: Methanothrix sp. isolate d1628e35-7b52-4540-a147-c2ca1342adce genome assembly, chromosome: 1 | blastn | 75181 | 588 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 12216946 | 12216946 | PRJNA758088_P_NODE_318770_length_247_cov_0.873563_g311799_i0 | PRJNA758088 | 318770 | 247 | 0.873563 | 2.15770061 | Methanoregula formicica | 882104 | Archaea | Archaea | 329 | 9.21e-86 | NTclustered | gi|432136161|gb|CP003167.1| | 593750 | g311799 | i0 | 90.688 | 9.95141700404858 | 247 | 23 | 100 | 0 | 1 | 247 | 2798639 | 2798885 | Methanoregula formicica SMSP, complete genome | blastn | 2458 | 329 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula formicica | |
| 16506729 | 16506729 | PRJNA758088_P_NODE_347073_length_243_cov_0.905882_g340102_i0 | PRJNA758088 | 347073 | 243 | 0.905882 | 2.20129326 | Methanothrix | 2222 | Archaea | Archaea | 438 | 1.4399999999999996e-118 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g340102 | i0 | 99.177 | 3.88477366255144 | 243 | 2 | 100 | 0 | 1 | 243 | 781951 | 782193 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 944 | 438 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 22881104 | 22881104 | PRJNA758088_P_NODE_24798_length_987_cov_2.513129_g19738_i0 | PRJNA758088 | 24798 | 987 | 2.513129 | 24.80458323 | Methanoregula | 395331 | Archaea | Archaea | 1659 | 0 | NTclustered | gi|432136161|gb|CP003167.1| | 593750 | g19738 | i0 | 96.967 | 210.716312056738 | 989 | 28 | 100 | 2 | 1 | 987 | 547170 | 548158 | Methanoregula formicica SMSP, complete genome | blastn | 207977 | 1659 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula formicica |
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);;