contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_clade = "delta/epsilon subdivisions"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25503039 | 25503039 | PRJEB14175_P_NODE_143953_length_284_cov_4.085202_g141686_i0 | PRJEB14175 | 143953 | 284 | 4.085202 | 11.60197368 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 196 | 1.14e-45 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g141686 | i0 | 82.684 | 234.799295774648 | 231 | 31 | 80 | 9 | 1 | 227 | 83419 | 83644 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 66683 | 196 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25506001 | 25506001 | PRJEB14175_P_NODE_209873_length_221_cov_1.100000_g207606_i0 | PRJEB14175 | 209873 | 221 | 1.1 | 2.431 | Dissulfurimicrobium hydrothermale | 1750598 | Bacteria | Bacteria | 150 | 6.749999999999999e-32 | NTclustered | gi|2190143862|gb|CP085041.1| | 1750598 | g207606 | i0 | 90.435 | 109.004524886878 | 115 | 10 | 52 | 1 | 53 | 167 | 693431 | 693544 | Dissulfurimicrobium hydrothermale strain Sh68 chromosome, complete genome | blastn | 24090 | 150 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Dissulfurimicrobium | Dissulfurimicrobium hydrothermale | |||||
| 25508109 | 25508109 | PRJEB14175_P_NODE_261353_length_200_cov_8.971223_g259085_i0 | PRJEB14175 | 261353 | 200 | 8.971223 | 17.942446 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 241 | 3.46e-59 | NTclustered | gi|2874253674|emb|OY969108.1| | 34034 | g259085 | i0 | 91.111 | 132.62 | 180 | 13 | 89 | 3 | 1 | 177 | 1542212 | 1542033 | MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1 | blastn | 26524 | 241 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25508645 | 25508645 | PRJEB14175_P_NODE_277857_length_173_cov_11.401786_g275589_i0 | PRJEB14175 | 277857 | 173 | 11.401786 | 19.72508978 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 287 | 3.6600000000000005e-73 | NTclustered | gi|197360286|gb|EU979074.1| | 34034 | g275589 | i0 | 96.532 | 102.982658959538 | 173 | 6 | 100 | 0 | 1 | 173 | 1289 | 1117 | Uncultured delta proteobacterium clone g65 16S ribosomal RNA gene, partial sequence | blastn | 17816 | 287 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25510404 | 25510404 | PRJEB14175_P_NODE_57329_length_491_cov_2.674419_g55079_i0 | PRJEB14175 | 57329 | 491 | 2.674419 | 13.13139729 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 191 | 9.73e-44 | NTclustered | gi|1695542189|gb|CP041186.1| | 2292766 | g55079 | i0 | 82.432 | 143.403258655804 | 222 | 36 | 45 | 3 | 31 | 250 | 2652898 | 2652678 | Persicimonas caeni strain YN101 chromosome | blastn | 70411 | 191 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 25511084 | 25511084 | PRJEB14175_P_NODE_69569_length_442_cov_6.414698_g67311_i0 | PRJEB14175 | 69569 | 442 | 6.414698 | 28.35296516 | Deltaproteobacteria bacterium Smac51 | 2946587 | Bacteria | Bacteria | 187 | 1.12e-42 | NTclustered | gi|2242725236|gb|CP026657.1| | 2946587 | g67311 | i0 | 78.571 | 42.2239819004525 | 308 | 48 | 68 | 18 | 140 | 439 | 2066954 | 2066657 | Deltaproteobacteria bacterium Smac51 chromosome, complete genome | blastn | 18663 | 187 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium Smac51 | ||||||
| 25644047 | 25644047 | PRJEB14175_P_NODE_261610_length_200_cov_3.424460_g259342_i0 | PRJEB14175 | 261610 | 200 | 3.42446 | 6.84892 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 141 | 3.6e-29 | NTclustered | gi|2874254016|emb|OY970341.1| | 34034 | g259342 | i0 | 84.459 | 168.755 | 148 | 18 | 73 | 5 | 22 | 166 | 592426 | 592571 | MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1 | blastn | 33751 | 141 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25776375 | 25776375 | PRJEB14175_P_NODE_169275_length_255_cov_2.829897_g167008_i0 | PRJEB14175 | 169275 | 255 | 2.829897 | 7.21623735 | uncultured delta proteobacterium DeepAnt-1F12 | 357894 | Bacteria | Bacteria | 303 | 5.79e-78 | NTclustered | gi|82617822|gb|DQ267495.1| | 357894 | g167008 | i0 | 90.476 | 219.674509803922 | 231 | 21 | 90 | 1 | 4 | 233 | 3854 | 3624 | Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence | blastn | 56017 | 303 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium DeepAnt-1F12 | ||||||
| 25777903 | 25777903 | PRJEB14175_P_NODE_203355_length_225_cov_24.676829_g201088_i0 | PRJEB14175 | 203355 | 225 | 24.676829 | 55.52286525 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 110 | 1.17e-19 | NTclustered | gi|283463608|gb|GU230389.1| | 34034 | g201088 | i0 | 88.764 | 27.04 | 89 | 10 | 40 | 0 | 79 | 167 | 539 | 627 | Uncultured delta proteobacterium clone ARTE12_215 16S ribosomal RNA gene, partial sequence | blastn | 6084 | 110 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25778622 | 25778622 | PRJEB14175_P_NODE_221515_length_212_cov_9.496689_g219247_i0 | PRJEB14175 | 221515 | 212 | 9.496689 | 20.13298068 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 141 | 3.87e-29 | NTclustered | gi|1722470586|gb|CP042467.1| | 2600177 | g219247 | i0 | 92.784 | 101.495283018868 | 97 | 7 | 46 | 0 | 116 | 212 | 702857 | 702761 | Microvenator marinus strain V1718 chromosome, complete genome | blastn | 21517 | 141 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 25880914 | 25880914 | PRJEB14175_P_NODE_204819_length_224_cov_6.000000_g202552_i0 | PRJEB14175 | 204819 | 224 | 6 | 13.44 | Bacteria | 2 | Bacteria | Bacteria | 348 | 2.27e-91 | NTclustered | gi|148749607|gb|EF636480.1| | 34034 | g202552 | i0 | 97.537 | 90.5714285714286 | 203 | 5 | 91 | 0 | 22 | 224 | 235 | 437 | Uncultured delta proteobacterium isolate DGGE gel band 9 16S ribosomal RNA gene, partial sequence | blastn | 20288 | 348 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25920409 | 25920409 | PRJEB14175_P_NODE_89564_length_382_cov_13.146417_g87298_i0 | PRJEB14175 | 89564 | 382 | 13.146417 | 50.21931294 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 573 | 6.289999999999999e-159 | NTclustered | gi|451917297|gb|KC451161.1| | 34034 | g87298 | i0 | 94.865 | 94.303664921466 | 370 | 14 | 96 | 4 | 1 | 368 | 441 | 75 | Uncultured delta proteobacterium clone RLBp1698 16S ribosomal RNA gene, partial sequence | blastn | 36024 | 573 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26185179 | 26185179 | PRJEB14175_P_NODE_179358_length_245_cov_4.994565_g177091_i0 | PRJEB14175 | 179358 | 245 | 4.994565 | 12.23668425 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 342 | 1.17e-89 | NTclustered | gi|151505533|gb|EF650863.1| | 34034 | g177091 | i0 | 92.531 | 108.69387755102 | 241 | 14 | 97 | 3 | 1 | 237 | 361 | 121 | Uncultured delta proteobacterium clone AUVE_01H11 16S ribosomal RNA gene, partial sequence | blastn | 26630 | 342 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26187363 | 26187363 | PRJEB14175_P_NODE_231182_length_208_cov_0.870748_g228914_i0 | PRJEB14175 | 231182 | 208 | 0.870748 | 1.81115584 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 115 | 2.29e-21 | NTclustered | gi|2874253659|emb|OY969087.1| | 34034 | g228914 | i0 | 91.566 | 44.9663461538462 | 83 | 7 | 40 | 0 | 81 | 163 | 1075083 | 1075001 | MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 | blastn | 9353 | 115 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26187788 | 26187788 | PRJEB14175_P_NODE_241646_length_205_cov_2.597222_g239378_i0 | PRJEB14175 | 241646 | 205 | 2.597222 | 5.3243051 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 255 | 1.27e-63 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g239378 | i0 | 92.222 | 46.5219512195122 | 180 | 14 | 88 | 0 | 26 | 205 | 14251 | 14430 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 9537 | 255 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26190282 | 26190282 | PRJEB14175_P_NODE_47230_length_543_cov_5.163900_g45004_i0 | PRJEB14175 | 47230 | 543 | 5.1639 | 28.039977 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 152 | 5.12e-32 | NTclustered | gi|2874253674|emb|OY969108.1| | 34034 | g45004 | i0 | 76.895 | 15.7458563535912 | 277 | 58 | 50 | 5 | 248 | 521 | 1541379 | 1541106 | MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1 | blastn | 8550 | 152 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26288335 | 26288335 | PRJEB14175_P_NODE_151478_length_275_cov_1.864486_g149211_i0 | PRJEB14175 | 151478 | 275 | 1.864486 | 5.1273365 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 353 | 6.19e-93 | NTclustered | gi|2874254016|emb|OY970341.1| | 34034 | g149211 | i0 | 90.406 | 469.229090909091 | 271 | 22 | 98 | 4 | 7 | 275 | 594043 | 594311 | MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1 | blastn | 129038 | 353 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26424426 | 26424426 | PRJEB14175_P_NODE_162239_length_262_cov_12.034826_g159972_i0 | PRJEB14175 | 162239 | 262 | 12.034826 | 31.53124412 | Bacteria | 2 | Bacteria | Bacteria | 429 | 9.449999999999999e-116 | NTclustered | gi|2795024240|gb|PQ251928.1| | 34034 | g159972 | i0 | 98.765 | 92.7328244274809 | 243 | 0 | 92 | 1 | 23 | 262 | 166 | 408 | Uncultured delta proteobacterium clone OTU18248 16S ribosomal RNA gene, partial sequence | blastn | 24296 | 429 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26561318 | 26561318 | PRJEB14175_P_NODE_210360_length_220_cov_3.471698_g208093_i0 | PRJEB14175 | 210360 | 220 | 3.471698 | 7.6377356 | Myxococcota | 2818505 | Bacteria | Bacteria | 174 | 3.99e-39 | NTclustered | gi|15027337|emb|AJ318168.1| | 34034 | g208093 | i0 | 98.969 | 43.9363636363636 | 97 | 1 | 44 | 0 | 23 | 119 | 1292 | 1388 | Uncultured delta proteobacterium 16S rRNA gene, clone BIrii41 | blastn | 9666 | 174 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;