RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1020854" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1020854 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
160800 160800 PRJNA1020854_S_NODE_21661_length_233_cov_2514.656863_g18897_i0 PRJNA1020854 21661 233 2514.656863 5859.15049079 Gemmataceae bacterium 2052164 Bacteria Bacteria 120 1.58e-31   NR MBY0523881.1 2052164 g18897 i0 93.3 0.772532188841202 60 4 77.3 0 233 54 160 219 MBY0523881.1 TIGR03032 family protein [Gemmataceae bacterium] diamond 180 120 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
1435406 1435406 PRJNA1020854_S_NODE_10322_length_404_cov_3.645333_g7583_i0 PRJNA1020854 10322 404 3.645333 14.72714532 Gemmataceae bacterium 2052164 Bacteria Bacteria 218 4.28e-70   NR HMC65290.1 2052164 g7583 i0 76.7 1.9752475247524801 133 31 98.8 0 402 4 53 185 HMC65290.1 cupin domain-containing protein [Gemmataceae bacterium] diamond 798 218 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
3553739 3553739 PRJNA1020854_S_NODE_20783_length_240_cov_1451.208531_g18019_i0 PRJNA1020854 20783 240 1451.208531 3482.9004744 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 72.4 1e-12   NR MEO6808610.1 2691532 g18019 i0 59 0.7625 61 25 76.3 0 57 239 1 61 MEO6808610.1 Xaa-Pro peptidase family protein [Isosphaeraceae bacterium] diamond 183 72.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
3987965 3987965 PRJNA1020854_S_NODE_8444_length_483_cov_1167.570485_g5770_i0 PRJNA1020854 8444 483 1167.570485 5639.36544255 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 90.5 1.04e-17   NR HEX7009068.1 2026777 g5770 i0 37.2 1.4472049689441 113 64 70.2 3 451 113 305 410 HEX7009068.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 699 90.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
8656502 8656502 PRJNA1020854_S_NODE_32827_length_178_cov_3.281879_g30063_i0 PRJNA1020854 32827 178 3.281879 5.84174462 Planctomycetia bacterium 2052181 Bacteria Bacteria 92.4 4.99e-20   NR MCI0705108.1 2052181 g30063 i0 71.2 1.90449438202247 59 17 99.4 0 177 1 158 216 MCI0705108.1 protein kinase [Planctomycetia bacterium] diamond 339 92.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
14189932 14189932 PRJNA1020854_S_NODE_6212_length_695_cov_803.510511_g3744_i0 PRJNA1020854 6212 695 803.510511 5584.39805145 Planctomycetota bacterium 2026780 Bacteria Bacteria 122 4.98e-28   NR MBK7878710.1 2026780 g3744 i0 42.2 1.38992805755396 161 90 69.1 2 182 661 422 580 MBK7878710.1 right-handed parallel beta-helix repeat-containing protein [Planctomycetota bacterium] diamond 966 122 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
14189988 14189988 PRJNA1020854_S_NODE_7912_length_518_cov_2192.764826_g5266_i0 PRJNA1020854 7912 518 2192.764826 11358.52179868 Sedimentisphaerales bacterium 2813034 Bacteria Bacteria 198 2.3899999999999996e-55   NR MBN1507229.1 2813034 g5266 i0 64.2 0.793436293436293 137 49 79.3 0 464 54 506 642 MBN1507229.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Sedimentisphaerales bacterium] diamond 411 198 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Sedimentisphaerales     Sedimentisphaerales bacterium
26591433 26591433 PRJNA1020854_S_NODE_9041_length_452_cov_14.929078_g6341_i0 PRJNA1020854 9041 452 14.929078 67.47943256 Planctomycetota bacterium 2026780 Bacteria Bacteria 111 8.84e-26   NR RIK84561.1 2026780 g6341 i0 52 0.676991150442478 102 47 67.7 1 450 145 324 423 RIK84561.1 MAG: hypothetical protein DCC68_00965 [Planctomycetota bacterium] diamond 306 111 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27446008 27446008 PRJNA1020854_S_NODE_22783_length_226_cov_2.203046_g20019_i0 PRJNA1020854 22783 226 2.203046 4.97888396 Planctomycetota bacterium 2026780 Bacteria Bacteria 149 7.44e-40   NR MBN8601304.1 2026780 g20019 i0 98.6 0.982300884955752 74 1 98.2 0 2 223 734 807 MBN8601304.1 discoidin domain-containing protein [Planctomycetota bacterium] diamond 222 149 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27856121 27856121 PRJNA1020854_S_NODE_31425_length_183_cov_3.324675_g28661_i0 PRJNA1020854 31425 183 3.324675 6.08415525 Phycisphaerales bacterium 2052180 Bacteria Bacteria 50.8 1.41e-5   NR HIB63803.1 2052180 g28661 i0 51.1 0.770491803278688 47 23 77 0 143 3 67 113 HIB63803.1 hypothetical protein [Phycisphaerales bacterium] diamond 141 50.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28897988 28897988 PRJNA1020854_S_NODE_24708_length_214_cov_3.508108_g21944_i0 PRJNA1020854 24708 214 3.508108 7.50735112 Pirellulales bacterium 2715253 Bacteria Bacteria 43.1 0.0186   NR HVX60454.1 2715253 g21944 i0 57.5 1.07943925233645 40 17 56.1 0 93 212 1052 1091 HVX60454.1 SdrD B-like domain-containing protein [Pirellulales bacterium] diamond 231 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
28897991 28897991 PRJNA1020854_S_NODE_36628_length_166_cov_3.598540_g33864_i0 PRJNA1020854 36628 166 3.59854 5.9735764 Phycisphaerales bacterium 2052180 Bacteria Bacteria 59.7 5.41e-9   NR HIB63803.1 2052180 g33864 i0 50 1.01204819277108 56 25 99.4 2 2 166 122 175 HIB63803.1 hypothetical protein [Phycisphaerales bacterium] diamond 168 59.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30919750 30919750 PRJNA1020854_S_NODE_43394_length_150_cov_3.008264_g40630_i0 PRJNA1020854 43394 150 3.008264 4.512396 Gemmataceae bacterium 2052164 Bacteria Bacteria 45.4 0.0012   NR MFO0844493.1 2052164 g40630 i0 42.6 0.94 47 27 94 0 7 147 310 356 MFO0844493.1 tetratricopeptide repeat-containing protein kinase family protein [Gemmataceae bacterium] diamond 141 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
30982945 30982945 PRJNA1020854_S_NODE_30474_length_187_cov_1.854430_g27710_i0 PRJNA1020854 30474 187 1.85443 3.4677841 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 118 1.03e-30   NR MBL8871739.1 2026779 g27710 i0 100 0.978609625668449 61 0 97.9 0 3 185 50 110 MBL8871739.1 acetylglutamate kinase [Planctomycetaceae bacterium] diamond 183 118 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32437943 32437943 PRJNA1020854_S_NODE_35259_length_170_cov_3.397163_g32495_i0 PRJNA1020854 35259 170 3.397163 5.7751771 Planctomycetales bacterium 2053591 Bacteria Bacteria 108 2.78e-27   NR MCA9199412.1 2053591 g32495 i0 98.2 0.988235294117647 56 1 98.8 0 169 2 161 216 MCA9199412.1 ParA family protein [Planctomycetales bacterium] diamond 168 108 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
32564523 32564523 PRJNA1020854_S_NODE_21359_length_236_cov_1.961353_g18595_i0 PRJNA1020854 21359 236 1.961353 4.62879308 Pirellula sp. 117 Bacteria Bacteria 127 3.81e-33   NR MCF7963791.1 117 g18595 i0 75.6 0.991525423728814 78 19 99.2 0 234 1 102 179 MCF7963791.1 transglutaminase-like domain-containing protein [Pirellula sp.] diamond 234 127 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
32713870 32713870 PRJNA1020854_S_NODE_11420_length_372_cov_6.664723_g8665_i0 PRJNA1020854 11420 372 6.664723 24.79276956 Bacteria 2 Bacteria Bacteria 48.5 0.00137   NR MCZ6688040.1 2026780 g8665 i0 45 2.50806451612903 60 29 48.4 1 26 205 132 187 MCZ6688040.1 VWA domain-containing protein [Planctomycetota bacterium] diamond 933 48.9 0.991820040899796 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;