RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA946307 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
26835630 26835630 PRJNA946307_P_NODE_112261_length_178_cov_4.100775_g111387_i0 PRJNA946307 112261 178 4.100775 7.2993795 Lentisphaeria bacterium 2053569 Bacteria Bacteria 58.9 2.95e-8   NR MBR2426237.1 2053569 g111387 i0 49 0.825842696629214 49 25 82.6 0 174 28 320 368 MBR2426237.1 SDR family oxidoreductase [Lentisphaeria bacterium] diamond 147 58.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
27341644 27341644 PRJNA946307_P_NODE_147923_length_165_cov_1.698276_g147049_i0 PRJNA946307 147923 165 1.698276 2.8021554 Lentisphaeria bacterium 2053569 Bacteria Bacteria 90.1 2.1e-20   NR HBJ97292.1 2053569 g147049 i0 88 0.909090909090909 50 6 90.9 0 164 15 33 82 HBJ97292.1 hypothetical protein [Lentisphaeria bacterium] diamond 150 90.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
27373392 27373392 PRJNA946307_P_NODE_28823_length_241_cov_3.692708_g27949_i0 PRJNA946307 28823 241 3.692708 8.89942628 Victivallaceae bacterium 2793042 Bacteria Bacteria 70.1 6.05e-13   NR MEA4863315.1 2793042 g27949 i0 78 0.510373443983402 41 8 49.8 1 121 240 13 53 MEA4863315.1 superoxide dismutase [Ni] [Victivallaceae bacterium] diamond 123 70.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales Victivallaceae   Victivallaceae bacterium
27594228 27594228 PRJNA946307_P_NODE_123564_length_173_cov_3.790323_g122690_i0 PRJNA946307 123564 173 3.790323 6.55725879 Lentisphaera araneosa 256847 Bacteria Bacteria 57.4 9.76e-8   NR WP_157473653.1 256847 g122690 i0 78.1 1.10982658959538 32 7 55.5 0 17 112 296 327 WP_157473653.1 sulfatase [Lentisphaera araneosa] diamond 192 57.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales Lentisphaeraceae Lentisphaera Lentisphaera araneosa
27625889 27625889 PRJNA946307_P_NODE_40024_length_212_cov_8.484663_g39150_i0 PRJNA946307 40024 212 8.484663 17.98748556 Lentisphaeria bacterium 2053569 Bacteria Bacteria 67.4 5.02e-11   NR HCN07913.1 2053569 g39150 i0 84.4 0.452830188679245 32 5 45.3 0 101 6 528 559 HCN07913.1 hypothetical protein [Lentisphaeria bacterium] diamond 96 67.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
27720872 27720872 PRJNA946307_P_NODE_127244_length_172_cov_1.577236_g126370_i0 PRJNA946307 127244 172 1.577236 2.71284592 Lentisphaerota bacterium 1932692 Bacteria Bacteria 60.8 5.1e-9   NR NLF17882.1 1932692 g126370 i0 51 0.854651162790698 49 24 85.5 0 158 12 23 71 NLF17882.1 AAA domain-containing protein [Lentisphaerota bacterium] diamond 147 60.8 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
28067758 28067758 PRJNA946307_P_NODE_79265_length_194_cov_4.427586_g78391_i0 PRJNA946307 79265 194 4.427586 8.58951684 Lentisphaerota bacterium 1932692 Bacteria Bacteria 100 8.469999999999999e-23   NR MBE6381064.1 1932692 g78391 i0 74.2 0.958762886597938 62 16 95.9 0 189 4 218 279 MBE6381064.1 phosphoenolpyruvate--protein phosphotransferase [Lentisphaerota bacterium] diamond 186 100 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
28288631 28288631 PRJNA946307_P_NODE_52646_length_210_cov_3.012422_g51772_i0 PRJNA946307 52646 210 3.012422 6.3260862 Lentisphaeria bacterium 2053569 Bacteria Bacteria 84 7.15e-17   NR HCG48348.1 2053569 g51772 i0 42.9 1.9 133 7 91.4 1 194 3 226 358 HCG48348.1 oxidoreductase [Lentisphaeria bacterium] diamond 399 84 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
29078227 29078227 PRJNA946307_P_NODE_115208_length_177_cov_2.234375_g114334_i0 PRJNA946307 115208 177 2.234375 3.95484375 Victivallaceae bacterium 2793042 Bacteria Bacteria 100 3.37e-23   NR MEA4862426.1 2793042 g114334 i0 90.6 0.898305084745763 53 5 89.8 0 173 15 365 417 MEA4862426.1 SpoIIE family protein phosphatase [Victivallaceae bacterium] diamond 159 100 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales Victivallaceae   Victivallaceae bacterium
29299123 29299123 PRJNA946307_P_NODE_124389_length_173_cov_2.193548_g123515_i0 PRJNA946307 124389 173 2.193548 3.79483804 Lentisphaerota bacterium 1932692 Bacteria Bacteria 76.3 2.21e-14   NR MEI6422007.1 1932692 g123515 i0 61.5 2.70520231213873 52 20 90.2 0 171 16 278 329 MEI6422007.1 DUF4838 domain-containing protein [Lentisphaerota bacterium] diamond 468 76.3 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
29709213 29709213 PRJNA946307_P_NODE_47890_length_210_cov_3.987578_g47016_i0 PRJNA946307 47890 210 3.987578 8.3739138 Victivallales bacterium 2212475 Bacteria Bacteria 43.1 0.017   NR MFA6569407.1 2212475 g47016 i0 54.8 1.2 42 18 60 1 133 8 217 257 MFA6569407.1 UDP-N-acetylglucosamine 4,6-dehydratase (inverting) [Victivallales bacterium] diamond 252 43.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
29804239 29804239 PRJNA946307_P_NODE_168691_length_157_cov_2.666667_g167817_i0 PRJNA946307 168691 157 2.666667 4.18666719 Lentisphaerota bacterium 1932692 Bacteria Bacteria 57 4.13e-8   NR MBE6368323.1 1932692 g167817 i0 66.7 0.802547770700637 42 14 80.3 0 26 151 79 120 MBE6368323.1 hypothetical protein [Lentisphaerota bacterium] diamond 126 57 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
31447545 31447545 PRJNA946307_P_NODE_61076_length_205_cov_2.852564_g60202_i0 PRJNA946307 61076 205 2.852564 5.8477562 Lentisphaerota bacterium 1932692 Bacteria Bacteria 80.5 9e-16   NR MBE6391566.1 1932692 g60202 i0 67.3 5.64878048780488 49 16 71.7 0 9 155 70 118 MBE6391566.1 DNA cytosine methyltransferase [Lentisphaerota bacterium] diamond 1158 80.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
32238717 32238717 PRJNA946307_P_NODE_98118_length_185_cov_1.500000_g97244_i0 PRJNA946307 98118 185 1.5 2.775 Lentisphaerota bacterium 1932692 Bacteria Bacteria 81.6 3.34e-16   NR MBM4154593.1 1932692 g97244 i0 66.7 1.84864864864865 57 19 92.4 0 172 2 405 461 MBM4154593.1 hypothetical protein [Lentisphaerota bacterium] diamond 342 81.6 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
32624354 32624354 PRJNA946307_P_NODE_65140_length_200_cov_3.165563_g64266_i0 PRJNA946307 65140 200 3.165563 6.331126 Bacteria 2 Bacteria Bacteria 95.5 4.02e-21   NR NMA19645.1 1932692 g64266 i0 72.1 3.66 61 17 91.5 0 17 199 143 203 NMA19645.1 hypothetical protein [Lentisphaerota bacterium] diamond 732 95.9 0.995828988529718 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium

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