RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJDB4470" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 7 ✖

bioproject 1

  • PRJDB4470 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1283332 1283332 PRJDB4470_P_NODE_110942_length_165_cov_0.896552_g109787_i0 PRJDB4470 110942 165 0.896552 1.4793108 Halalkalicoccus salilacus 3117459 Archaea Archaea 152 1.3199999999999998e-32   NTclustered gi|2674869203|gb|CP144461.1| 3117459 g109787 i0 83.735 2.89090909090909 166 21 99 5 1 163 1178529 1178367 Halalkalicoccus salilacus strain FCH27 chromosome, complete genome blastn 477 152 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus salilacus
2558903 2558903 PRJDB4470_P_NODE_102483_length_168_cov_0.873950_g101328_i0 PRJDB4470 102483 168 0.87395 1.468236 Halalkalicoccus salilacus 3117459 Archaea Archaea 196 6.16e-46   NTclustered gi|2674869206|gb|CP144464.1| 3117459 g101328 i0 88.095 2 168 17 100 2 1 168 28823 28987 Halalkalicoccus salilacus strain FCH27 plasmid unnamed3, complete sequence blastn 336 196 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus salilacus
3531837 3531837 PRJDB4470_P_NODE_104683_length_167_cov_0.881356_g103528_i0 PRJDB4470 104683 167 0.881356 1.47186452 Halomarina 871740 Archaea Archaea 150 4.83e-32   NTclustered gi|2270305250|gb|CP100454.1| 2961599 g103528 i0 87.121 29.6347305389222 132 17 83 0 1 132 2795611 2795742 Halomarina pelagica strain BND7 chromosome, complete genome blastn 4949 150 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina pelagica
6084436 6084436 PRJDB4470_P_NODE_28365_length_435_cov_4.582902_g27225_i0 PRJDB4470 28365 435 4.582902 19.9356237 Methanolobus 2220 Archaea Archaea 54.7 0.012   NTclustered gi|2621717818|emb|OY776215.1| 218300 g27225 i0 96.875 2.13333333333333 32 1 7 0 378 409 1488584 1488553 MAG: uncultured Methanolobus sp. isolate 56865bd2-6141-42f0-955c-5236203a12ea genome assembly, chromosome: 1 blastn 928 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanolobus uncultured Methanolobus sp.
10212183 10212183 PRJDB4470_P_NODE_26029_length_460_cov_2.102190_g24893_i0 PRJDB4470 26029 460 2.10219 9.670074 Natrinema pellirubrum 69525 Archaea Archaea 52.8 0.045   NTclustered gi|433304139|gb|CP003372.1| 797303 g24893 i0 100 0.0608695652173913 28 0 6 0 65 92 2724862 2724835 Natrinema pellirubrum DSM 15624, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrinema Natrinema pellirubrum
19134554 19134554 PRJDB4470_P_NODE_102316_length_168_cov_0.873950_g101161_i0 PRJDB4470 102316 168 0.87395 1.468236 Natronorubrum daqingense 588898 Archaea Archaea 226 7.859999999999997e-55   NTclustered gi|1134983310|gb|CP019329.1| 588898 g101161 i0 91.018 0.994047619047619 167 15 99 0 1 167 17259 17093 Natronorubrum daqingense strain JX313T plasmid unnamed2, complete sequence blastn 167 226 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronorubrum Natronorubrum daqingense
19134565 19134565 PRJDB4470_P_NODE_104336_length_167_cov_0.881356_g103181_i0 PRJDB4470 104336 167 0.881356 1.47186452 Natronorubrum daqingense 588898 Archaea Archaea 268 1.28e-67   NTclustered gi|1134979927|gb|CP019327.1| 588898 g103181 i0 95.783 99.4311377245509 166 7 99 0 2 167 1189581 1189416 Natronorubrum daqingense strain JX313, complete sequence blastn 16605 268 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronorubrum Natronorubrum daqingense

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;