RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA814235 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
2094373 2094373 PRJNA814235_P_NODE_89822_length_203_cov_3.451807_g88427_i0 PRJNA814235 89822 203 3.451807 7.00716821 Victivallales bacterium CCUG 44730 2094242 Bacteria Bacteria 135 1.71e-27   NTclustered gi|1359122976|gb|CP027227.1| 2094242 g88427 i0 98.684 49.1083743842365 76 1 74 0 1 76 2340784 2340859 Victivallales bacterium CCUG 44730 chromosome, complete genome blastn 9969 135 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium CCUG 44730
4643665 4643665 PRJNA814235_P_NODE_105164_length_203_cov_2.222892_g103769_i0 PRJNA814235 105164 203 2.222892 4.51247076 Victivallales bacterium CCUG 44730 2094242 Bacteria Bacteria 141 3.67e-29   NTclustered gi|1359122976|gb|CP027227.1| 2094242 g103769 i0 100 253.497536945813 76 0 74 0 1 76 2339999 2340074 Victivallales bacterium CCUG 44730 chromosome, complete genome blastn 51460 141 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium CCUG 44730
8879435 8879435 PRJNA814235_P_NODE_171267_length_158_cov_2.049587_g169872_i0 PRJNA814235 171267 158 2.049587 3.23834746 Bacteria 2 Bacteria Bacteria 259 7.17e-65   NTclustered gi|1995790976|gb|CP071032.1| 1932692 g169872 i0 96.203 23.0443037974684 158 6 100 0 1 158 1584974 1585131 Lentisphaerae bacterium strain zth2 chromosome, complete genome blastn 3641 259 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
21629514 21629514 PRJNA814235_P_NODE_76197_length_218_cov_1.845304_g74802_i0 PRJNA814235 76197 218 1.845304 4.02276272 Bacteria 2 Bacteria Bacteria 121 5.209999999999999e-23   NTclustered gi|2126063867|gb|CP085689.1| 2886196 g74802 i0 86.916 73.0779816513761 107 14 50 0 109 215 2383944 2384050 Lentisphaerae bacterium WC36 chromosome, complete genome blastn 15931 121 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium WC36
24179316 24179316 PRJNA814235_P_NODE_85039_length_206_cov_2.165680_g83644_i0 PRJNA814235 85039 206 2.16568 4.4613008 Bacteria 2 Bacteria Bacteria 185 1.7e-42   NTclustered gi|2126063867|gb|CP085689.1| 2886196 g83644 i0 87.117 436.339805825243 163 21 83 0 35 197 2382820 2382982 Lentisphaerae bacterium WC36 chromosome, complete genome blastn 89886 185 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium WC36

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