RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "blastn", bioproject = "PRJNA603943" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 30 ✖

bioproject 1

  • PRJNA603943 · 30 ✖

analysis 1

  • blastn · 30 ✖
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
577557 577557 PRJNA603943_P_NODE_52661_length_251_cov_0.865169_g52469_i0 PRJNA603943 52661 251 0.865169 2.17157419 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 459 1.1499999999999996e-124   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g52469 i0 99.602 1 251 1 100 0 1 251 1789554 1789304 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 251 459 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
1852483 1852483 PRJNA603943_P_NODE_2262_length_935_cov_3.018561_g2119_i0 PRJNA603943 2262 935 3.018561 28.22354535 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 955 0   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g2119 i0 85.338 139.470588235294 948 112 99 24 1 932 3681724 3682660 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 130405 955 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
3129061 3129061 PRJNA603943_P_NODE_70043_length_241_cov_0.916667_g69851_i0 PRJNA603943 70043 241 0.916667 2.20916747 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 84.2 7.69e-12   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g69851 i0 78.378 1.2448132780083 148 18 59 11 98 239 864274 864135 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 300 84.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
4405515 4405515 PRJNA603943_P_NODE_62064_length_246_cov_0.890173_g61872_i0 PRJNA603943 62064 246 0.890173 2.18982558 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g61872 i0 100 1 246 0 100 0 1 246 1216557 1216802 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 246 455 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
4405633 4405633 PRJNA603943_P_NODE_66164_length_243_cov_0.905882_g65972_i0 PRJNA603943 66164 243 0.905882 2.20129326 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 283 7.14e-72   NTclustered gi|2189472572|gb|CP091731.1| 2052166 g65972 i0 87.654 1 243 30 100 0 1 243 1833851 1834093 MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome blastn 243 283 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
4971465 4971465 PRJNA603943_P_NODE_67744_length_242_cov_0.911243_g67552_i0 PRJNA603943 67744 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 435 1.85e-117   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g67552 i0 99.17 2.12396694214876 241 2 99 0 1 241 1252790 1252550 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 514 435 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
6956116 6956116 PRJNA603943_P_NODE_58686_length_248_cov_0.880000_g58494_i0 PRJNA603943 58686 248 0.88 2.1824 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 459 1.13e-124   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g58494 i0 100 1 248 0 100 0 1 248 770120 770367 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 248 459 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
8231196 8231196 PRJNA603943_P_NODE_64747_length_244_cov_0.900585_g64555_i0 PRJNA603943 64747 244 0.900585 2.1974274 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 318 1.9699999999999998e-82   NTclustered gi|2189472572|gb|CP091731.1| 2052166 g64555 i0 97.838 1.03688524590164 185 3 100 1 1 184 834650 834466 MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome blastn 253 318 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
9505285 9505285 PRJNA603943_P_NODE_29308_length_332_cov_1.169884_g29116_i0 PRJNA603943 29308 332 1.169884 3.88401488 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 586 6.929999999999998e-163   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g29116 i0 98.494 10.1024096385542 332 5 100 0 1 332 1011720 1011389 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 3354 586 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
9505375 9505375 PRJNA603943_P_NODE_32568_length_319_cov_1.121951_g32376_i0 PRJNA603943 32568 319 1.121951 3.57902369 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 573 5.159999999999998e-159   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g32376 i0 99.06 12.7335423197492 319 3 100 0 1 319 139522 139204 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 4062 573 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
9506341 9506341 PRJNA603943_P_NODE_65248_length_244_cov_0.900585_g65056_i0 PRJNA603943 65248 244 0.900585 2.1974274 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 440 4.019999999999999e-119   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g65056 i0 99.18 1 244 2 100 0 1 244 488640 488397 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 244 440 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
12055944 12055944 PRJNA603943_P_NODE_22290_length_368_cov_1.044068_g22098_i0 PRJNA603943 22290 368 1.044068 3.84217024 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 165 4.2999999999999995e-36   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g22098 i0 78.947 0.671195652173913 247 49 67 3 1 246 1703161 1702917 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 247 165 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
12056998 12056998 PRJNA603943_P_NODE_58850_length_248_cov_0.880000_g58658_i0 PRJNA603943 58850 248 0.88 2.1824 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 436 5.3e-118   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g58658 i0 98.387 1 248 4 100 0 1 248 1311164 1311411 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 248 436 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
13331711 13331711 PRJNA603943_P_NODE_55151_length_250_cov_0.870056_g54959_i0 PRJNA603943 55151 250 0.870056 2.17514 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 451 1.91e-122   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g54959 i0 99.2 1 250 2 100 0 1 250 465657 465408 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 250 451 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
14606987 14606987 PRJNA603943_P_NODE_67852_length_242_cov_0.911243_g67660_i0 PRJNA603943 67852 242 0.911243 2.20520806 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 429 8.619999999999998e-116   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g67660 i0 98.755 0.995867768595041 241 3 99 0 1 241 888793 888553 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 241 429 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
15880270 15880270 PRJNA603943_P_NODE_46353_length_271_cov_1.479798_g46161_i0 PRJNA603943 46353 271 1.479798 4.01025258 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 490 4.44e-134   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g46161 i0 99.262 1 271 2 100 0 1 271 1332462 1332192 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 271 490 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
17155382 17155382 PRJNA603943_P_NODE_55414_length_250_cov_0.870056_g55222_i0 PRJNA603943 55414 250 0.870056 2.17514 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 324 4.35e-84   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g55222 i0 90 1 250 25 100 0 1 250 271136 270887 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 250 324 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
17721189 17721189 PRJNA603943_P_NODE_60754_length_247_cov_0.879310_g60562_i0 PRJNA603943 60754 247 0.87931 2.1718957 root 1 Root_unresolved Root_unresolved 62.1 3.71e-5   NTclustered gi|2080647037|gb|CP080598.1| 984208 g60562 i0 100 11.834008097166 33 0 13 0 191 223 3423134 3423102 Sphaerospermopsis torques-reginae ITEP-024 chromosome blastn 2923 62.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Sphaerospermopsis Sphaerospermopsis torques-reginae
18428493 18428493 PRJNA603943_P_NODE_14735_length_432_cov_0.857939_g14543_i0 PRJNA603943 14735 432 0.857939 3.70629648 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 165 5.13e-36   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g14543 i0 96.97 24.587962962963 99 2 23 1 1 99 1568235 1568332 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 10622 165 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
18429969 18429969 PRJNA603943_P_NODE_64935_length_244_cov_0.900585_g64743_i0 PRJNA603943 64935 244 0.900585 2.1974274 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 440 4.019999999999999e-119   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g64743 i0 99.18 1 244 2 100 0 1 244 833705 833948 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 244 440 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
18430112 18430112 PRJNA603943_P_NODE_69635_length_241_cov_0.916667_g69443_i0 PRJNA603943 69635 241 0.916667 2.20916747 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 374 4.079999999999998e-99   NTclustered gi|2189472572|gb|CP091731.1| 2052166 g69443 i0 94.628 1.00414937759336 242 12 100 1 1 241 887467 887708 MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome blastn 242 374 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
19704379 19704379 PRJNA603943_P_NODE_59896_length_247_cov_0.885057_g59704_i0 PRJNA603943 59896 247 0.885057 2.18609079 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 435 1.9e-117   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g59704 i0 98.381 1 247 4 100 0 1 247 1326940 1326694 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 247 435 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
19704666 19704666 PRJNA603943_P_NODE_70156_length_241_cov_0.916667_g69964_i0 PRJNA603943 70156 241 0.916667 2.20916747 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 435 1.84e-117   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g69964 i0 99.17 1.60995850622407 241 2 100 0 1 241 434106 433866 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 388 435 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
20979415 20979415 PRJNA603943_P_NODE_37937_length_299_cov_1.022124_g37745_i0 PRJNA603943 37937 299 1.022124 3.05615076 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 459 1.4000000000000002e-124   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g37745 i0 94.983 1 299 3 100 2 1 299 1034827 1035113 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 299 459 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
20980028 20980028 PRJNA603943_P_NODE_58737_length_248_cov_0.880000_g58545_i0 PRJNA603943 58737 248 0.88 2.1824 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 442 1.1399999999999995e-119   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g58545 i0 98.79 1 248 3 100 0 1 248 558927 559174 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 248 442 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
22254999 22254999 PRJNA603943_P_NODE_65078_length_244_cov_0.900585_g64886_i0 PRJNA603943 65078 244 0.900585 2.1974274 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 248 2.6199999999999997e-61   NTclustered gi|2189472572|gb|CP091731.1| 2052166 g64886 i0 94.969 5.15983606557377 159 7 100 1 1 159 412572 412729 MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome blastn 1259 248 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
23530446 23530446 PRJNA603943_P_NODE_64499_length_244_cov_0.900585_g64307_i0 PRJNA603943 64499 244 0.900585 2.1974274 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 156 1.63e-33   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g64307 i0 80.597 0.823770491803279 201 39 82 0 11 211 1184907 1185107 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 201 156 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
23530460 23530460 PRJNA603943_P_NODE_65059_length_244_cov_0.900585_g64867_i0 PRJNA603943 65059 244 0.900585 2.1974274 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 446 8.639999999999999e-121   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g64867 i0 99.59 1 244 1 100 0 1 244 389785 389542 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 244 446 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
24803923 24803923 PRJNA603943_P_NODE_57220_length_249_cov_0.875000_g57028_i0 PRJNA603943 57220 249 0.875 2.17875 Candidatus Melainabacteria bacterium MEL.A1 1899017 Bacteria Bacteria 455 1.47e-123   NTclustered gi|1079475020|gb|CP017245.1| 1899017 g57028 i0 99.598 1 249 1 100 0 1 249 1594233 1593985 Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome blastn 249 455 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium MEL.A1
25369626 25369626 PRJNA603943_P_NODE_68280_length_242_cov_0.911243_g68088_i0 PRJNA603943 68280 242 0.911243 2.20520806 Gloeocapsopsis 693222 Bacteria Bacteria 348 2.48e-91   NTclustered gi|1142095202|gb|KU847399.1| 1433147 g68088 i0 92.562 299.057851239669 242 18 100 0 1 242 5075 4834 Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence blastn 72372 348 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsopsis Gloeocapsopsis dulcis

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