RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA703759", tax_clade = "ac1 cluster" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Bacillati · 7 ✖

tax_clade 1

  • ac1 cluster · 7 ✖

bioproject 1

  • PRJNA703759 · 7 ✖

analysis 1

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
17262039 17262039 PRJNA703759_P_NODE_17814_length_324_cov_2.824701_g17338_i0 PRJNA703759 17814 324 2.824701 9.15203124 Actinomycetes 1760 Bacteria Bacteria 220 4.16e-66   NR KRO36079.1 1655562 g17338 i0 94.4 33.6851851851852 107 6 99.1 0 322 2 256 362 KRO36079.1 MAG: acetyl-CoA synthetase [Actinobacteria bacterium BACL15 MAG-120619-bin91] diamond 10914 221 0.995475113122172 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL15 MAG-120619-bin91
17762644 17762644 PRJNA703759_P_NODE_21954_length_298_cov_2.724444_g21478_i0 PRJNA703759 21954 298 2.724444 8.11884312 Bacteria 2 Bacteria Bacteria 102 7.28e-25   NR KRO35178.1 1655562 g21478 i0 79 6.2013422818792 62 13 62.4 0 111 296 1 62 KRO35178.1 MAG: oligoribonuclease [Actinobacteria bacterium BACL15 MAG-120619-bin91] diamond 1848 103 0.990291262135922 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL15 MAG-120619-bin91
26904232 26904232 PRJNA703759_P_NODE_41621_length_248_cov_0.891429_g41145_i0 PRJNA703759 41621 248 0.891429 2.21074392 Bacteria 2 Bacteria Bacteria 163 4.3399999999999996e-47   NR KRO37248.1 1655563 g41145 i0 90.2 4.95967741935484 82 8 99.2 0 3 248 238 319 KRO37248.1 MAG: hypothetical protein ABR55_01865, partial [Actinobacteria bacterium BACL15 MAG-120823-bin78] diamond 1230 164 0.99390243902439 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL15 MAG-120823-bin78
29714555 29714555 PRJNA703759_P_NODE_21690_length_300_cov_1.374449_g21214_i0 PRJNA703759 21690 300 1.374449 4.123347 Candidatus Planktophila 622681 Bacteria Bacteria 127 3.04e-33   NR KRO35693.1 1655562 g21214 i0 85.5 1.52 76 11 76 0 230 3 1 76 KRO35693.1 MAG: ABC transporter permease [Actinobacteria bacterium BACL15 MAG-120619-bin91] diamond 456 127 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL15 MAG-120619-bin91
29904507 29904507 PRJNA703759_P_NODE_12011_length_387_cov_1.652866_g11535_i0 PRJNA703759 12011 387 1.652866 6.39659142 Candidatus Planktophila 622681 Bacteria Bacteria 229 1.04e-67   NR KRO36551.1 1655562 g11535 i0 77.5 8 129 29 100 0 1 387 383 511 KRO36551.1 MAG: hypothetical protein ABR54_03320 [Actinobacteria bacterium BACL15 MAG-120619-bin91] diamond 3096 231 0.991341991341991 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL15 MAG-120619-bin91
30630887 30630887 PRJNA703759_P_NODE_26733_length_278_cov_1.482927_g26257_i0 PRJNA703759 26733 278 1.482927 4.12253706 Bacteria 2 Bacteria Bacteria 150 1.29e-41   NR KRO36558.1 1655562 g26257 i0 82.6 2.97841726618705 92 16 99.3 0 277 2 53 144 KRO36558.1 MAG: hypothetical protein ABR54_03355 [Actinobacteria bacterium BACL15 MAG-120619-bin91] diamond 828 150 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL15 MAG-120619-bin91
31705835 31705835 PRJNA703759_P_NODE_18697_length_318_cov_1.461224_g18221_i0 PRJNA703759 18697 318 1.461224 4.64669232 ac1 cluster 1655545 Bacteria Bacteria 152 1.4699999999999999e-43   NR KRO36003.1 1655562 g18221 i0 87.7 1.5377358490566 81 10 76.4 0 1 243 191 271 KRO36003.1 MAG: sugar phosphate isomerase [Actinobacteria bacterium BACL15 MAG-120619-bin91] diamond 489 152 1 Bacteria ac1 cluster Bacillati Actinomycetota Actinomycetes       Actinobacteria bacterium BACL15 MAG-120619-bin91

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