RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 7 ✖

bioproject 1

  • PRJEB10140 · 7 ✖

analysis 1

  • blastn · 7 ✖

tax_kingdom 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
3838178 3838178 PRJEB10140_P_NODE_199764_length_195_cov_2.089041_g182455_i0 PRJEB10140 199764 195 2.089041 4.07362995 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 52.8 0.017   NTclustered gi|2258829869|gb|CP060224.1| 2053688 g182455 i0 100 0.143589743589744 28 0 14 0 105 132 1298757 1298784 MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-8 chromosome blastn 28 52.8 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria bacterium
5115045 5115045 PRJEB10140_P_NODE_269005_length_165_cov_0.896552_g251696_i0 PRJEB10140 269005 165 0.896552 1.4793108 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 69.4 1.37e-7   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g251696 i0 93.617 0.284848484848485 47 2 28 1 26 71 664951 664905 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 47 69.4 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
7664937 7664937 PRJEB10140_P_NODE_26827_length_1234_cov_12.195781_g12114_i1 PRJEB10140 26827 1234 12.195781 150.49593754 uncultured Microgenomates bacterium Rifle_16ft_4_minimus_37633 1665114 Bacteria Bacteria 56.5 0.01   NTclustered gi|874575139|gb|KT006999.1| 1665114 g12114 i1 100 0.0243111831442464 30 0 2 0 863 892 6987 7016 Uncultured Microgenomates bacterium Rifle_16ft_4_minimus_37633 genomic sequence blastn 30 56.5 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         uncultured Microgenomates bacterium Rifle_16ft_4_minimus_37633
8938658 8938658 PRJEB10140_P_NODE_149768_length_247_cov_4.429293_g132460_i0 PRJEB10140 149768 247 4.429293 10.94035371 uncultured Poribacteria bacterium 265321 Bacteria Bacteria 52.8 0.022   NTclustered gi|2518596601|emb|OX639973.1| 265321 g132460 i0 100 0.11336032388664 28 0 11 0 73 100 5229843 5229816 MAG: uncultured Poribacteria bacterium isolate a51c2dcd-0bc8-4832-ac43-f95c9d639ad7 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria Bacteria candidate phyla   Candidatus Poribacteria         uncultured Poribacteria bacterium
8940050 8940050 PRJEB10140_P_NODE_32028_length_1073_cov_13.693359_g12114_i2 PRJEB10140 32028 1073 13.693359 146.92974207 uncultured Microgenomates bacterium Rifle_16ft_4_minimus_37633 1665114 Bacteria Bacteria 56.5 0.008   NTclustered gi|874575139|gb|KT006999.1| 1665114 g12114 i2 100 0.0279589934762349 30 0 3 0 702 731 6987 7016 Uncultured Microgenomates bacterium Rifle_16ft_4_minimus_37633 genomic sequence blastn 30 56.5 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         uncultured Microgenomates bacterium Rifle_16ft_4_minimus_37633
24237553 24237553 PRJEB10140_P_NODE_140700_length_262_cov_1.436620_g123393_i0 PRJEB10140 140700 262 1.43662 3.7639444 uncultured Candidatus Saccharibacteria bacterium 179883 Bacteria Bacteria 52.8 0.024   NTclustered gi|2874254068|emb|OY970151.1| 179883 g123393 i0 100 0.106870229007634 28 0 11 0 206 233 294597 294624 MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         uncultured Candidatus Saccharibacteria bacterium
24238028 24238028 PRJEB10140_P_NODE_20820_length_1470_cov_12.080225_g12114_i0 PRJEB10140 20820 1470 12.080225 177.5793075 uncultured Microgenomates bacterium Rifle_16ft_4_minimus_37633 1665114 Bacteria Bacteria 56.5 0.012   NTclustered gi|874575139|gb|KT006999.1| 1665114 g12114 i0 100 0.0204081632653061 30 0 2 0 1099 1128 6987 7016 Uncultured Microgenomates bacterium Rifle_16ft_4_minimus_37633 genomic sequence blastn 30 56.5 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         uncultured Microgenomates bacterium Rifle_16ft_4_minimus_37633

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