RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB64798 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_clade 0

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
128301 128301 PRJEB64798_P_NODE_236521_length_156_cov_5.971963_g234755_i0 PRJEB64798 236521 156 5.971963 9.31626228 Thermoplasmata archaeon 1906666 Archaea Archaea 139 9.59e-29   NTclustered gi|2108430933|gb|CP070629.1| 1906666 g234755 i0 88.696 232.410256410256 115 11 73 2 39 152 286833 286946 MAG: Thermoplasmata archaeon isolate bin983 chromosome blastn 36256 139 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
6507560 6507560 PRJEB64798_P_NODE_63466_length_244_cov_4.276923_g61701_i0 PRJEB64798 63466 244 4.276923 10.43569212 Candidatus Methanomassiliicoccus intestinalis 1406512 Archaea Archaea 80.5 1.01e-10   NTclustered gi|1721134172|emb|LR698974.1| 1406512 g61701 i0 81.915 0.385245901639344 94 17 39 0 80 173 1457425 1457518 Candidatus Methanomassiliicoccus intestinalis isolate MGYG-HGUT-02160 genome assembly, chromosome: 1 blastn 94 80.5 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Methanomassiliicoccus Candidatus Methanomassiliicoccus intestinalis
7780120 7780120 PRJEB64798_P_NODE_189127_length_170_cov_18.305785_g187361_i0 PRJEB64798 189127 170 18.305785 31.1198345 Cuniculiplasma divulgatum 1673428 Archaea Archaea 62.1 2.36e-5   NTclustered gi|2573965583|gb|CP133595.1| 1673428 g187361 i0 88.462 7.9 52 4 31 2 78 129 1045094 1045045 MAG: Cuniculiplasma divulgatum isolate BR_06 chromosome, complete genome blastn 1343 62.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales Cuniculiplasmataceae Cuniculiplasma Cuniculiplasma divulgatum
20527920 20527920 PRJEB64798_P_NODE_141797_length_192_cov_8.636364_g140031_i0 PRJEB64798 141797 192 8.636364 16.58181888 Methanomassiliicoccaceae archaeon DOK 1535962 Archaea Archaea 283 5.39e-72   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g140031 i0 93.229 13.578125 192 13 100 0 1 192 1502999 1502808 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 2607 283 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
22670499 22670499 PRJEB64798_P_NODE_54758_length_264_cov_2.893023_g52993_i0 PRJEB64798 54758 264 2.893023 7.63758072 Methanobacteriati 3366610 Archaea Archaea 54.7 0.007   NTclustered gi|193084194|gb|EU686634.1| 526664 g52993 i0 100 0.21969696969697 29 0 11 0 236 264 5603 5631 Uncultured marine group II euryarchaeote KM3-136-D10 genomic sequence blastn 58 54.7 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     uncultured marine group II euryarchaeote KM3-136-D10

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