contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA724011" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7089249 | 7089249 | PRJNA724011_P_NODE_19446_length_668_cov_3.368067_g18440_i0 | PRJNA724011 | 19446 | 668 | 3.368067 | 22.49868756 | Phototrophicus methaneseepsis | 2710758 | Bacteria | Bacteria | 625 | 3.129999999999999e-174 | NTclustered | gi|1932369605|gb|CP062983.1| | 2710758 | g18440 | i0 | 84.603 | 147.62425149700599 | 643 | 84 | 95 | 12 | 1 | 637 | 4993331 | 4992698 | Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome | blastn | 98613 | 625 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicus | Phototrophicus methaneseepsis | ||
| 7089553 | 7089553 | PRJNA724011_P_NODE_65066_length_314_cov_1.497925_g64043_i0 | PRJNA724011 | 65066 | 314 | 1.497925 | 4.7034845 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 54.7 | 0.008 | NTclustered | gi|2893358394|emb|OZ220685.1| | 2026734 | g64043 | i0 | 100 | 0.0923566878980892 | 29 | 0 | 9 | 0 | 152 | 180 | 281169 | 281141 | MAG: Dehalococcoidia bacterium isolate 2a27cef4-6af2-4f96-82a3-29fad4755a7e genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 10914504 | 10914504 | PRJNA724011_P_NODE_21089_length_633_cov_2.571429_g20077_i0 | PRJNA724011 | 21089 | 633 | 2.571429 | 16.27714557 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 56.5 | 0.005 | NTclustered | gi|2513924934|gb|CP126532.1| | 2306968 | g20077 | i0 | 96.97 | 0.0521327014218009 | 33 | 1 | 5 | 0 | 194 | 226 | 1763406 | 1763374 | MAG: Ktedonobacterales bacterium isolate bin_006 chromosome, complete genome | blastn | 33 | 56.5 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 10914881 | 10914881 | PRJNA724011_P_NODE_72389_length_294_cov_2.117647_g71366_i0 | PRJNA724011 | 72389 | 294 | 2.117647 | 6.22588218 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g71366 | i0 | 100 | 0.0952380952380952 | 28 | 0 | 10 | 0 | 9 | 36 | 283342 | 283369 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 13464530 | 13464530 | PRJNA724011_P_NODE_63351_length_319_cov_1.304878_g62328_i0 | PRJNA724011 | 63351 | 319 | 1.304878 | 4.16256082 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 54.7 | 0.008 | NTclustered | gi|2874253698|emb|OY969424.1| | 1672391 | g62328 | i0 | 96.875 | 0.100313479623824 | 32 | 1 | 10 | 0 | 164 | 195 | 1394371 | 1394340 | MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 18562498 | 18562498 | PRJNA724011_P_NODE_57755_length_336_cov_3.939163_g56732_i0 | PRJNA724011 | 57755 | 336 | 3.939163 | 13.23558768 | Phototrophicus methaneseepsis | 2710758 | Bacteria | Bacteria | 248 | 3.7699999999999995e-61 | NTclustered | gi|1932369605|gb|CP062983.1| | 2710758 | g56732 | i0 | 80.793 | 171.723214285714 | 328 | 53 | 97 | 10 | 3 | 327 | 4992349 | 4992669 | Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome | blastn | 57699 | 248 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicus | Phototrophicus methaneseepsis | ||
| 18562539 | 18562539 | PRJNA724011_P_NODE_64175_length_316_cov_10.761317_g63152_i0 | PRJNA724011 | 64175 | 316 | 10.761317 | 34.00576172 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 324 | 5.68e-84 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g63152 | i0 | 89.272 | 27.4145569620253 | 261 | 24 | 82 | 4 | 58 | 316 | 276015 | 275757 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 8663 | 324 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium |
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);;