contig_metadata
8 rows where bioproject = "PRJNA400391", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 414033 | 414033 | PRJNA400391_S_NODE_3981_length_202_cov_3.017964_g3920_i0 | PRJNA400391 | 3981 | 202 | 3.017964 | 6.09628728 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 311 | 2.63e-80 | NTclustered | gi|2556906889|gb|CP129483.1| | 2073117 | g3920 | i0 | 94.527 | 180.460396039604 | 201 | 11 | 99 | 0 | 1 | 201 | 2028363 | 2028163 | MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome | blastn | 36453 | 311 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 1688949 | 1688949 | PRJNA400391_S_NODE_5702_length_165_cov_1.430769_g5641_i0 | PRJNA400391 | 5702 | 165 | 1.430769 | 2.36076885 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 239 | 9.87e-59 | NTclustered | gi|2556899361|gb|CP129481.1| | 2073117 | g5641 | i0 | 92.727 | 17.6363636363636 | 165 | 12 | 100 | 0 | 1 | 165 | 1234073 | 1233909 | MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome | blastn | 2910 | 239 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 6791823 | 6791823 | PRJNA400391_S_NODE_4506_length_188_cov_21.862745_g4445_i0 | PRJNA400391 | 4506 | 188 | 21.862745 | 41.1019606 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 342 | 8.539999999999999e-90 | NTclustered | gi|2556895010|gb|CP129480.1| | 2073117 | g4445 | i0 | 99.468 | 117.5 | 188 | 1 | 100 | 0 | 1 | 188 | 1577359 | 1577172 | MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome | blastn | 22090 | 342 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 8067365 | 8067365 | PRJNA400391_S_NODE_2087_length_275_cov_10.991667_g2026_i0 | PRJNA400391 | 2087 | 275 | 10.991667 | 30.22708425 | uncultured Anaerolineaceae bacterium | 310067 | Bacteria | Bacteria | 370 | 6.14e-98 | NTclustered | gi|310323905|gb|HQ044406.1| | 310067 | g2026 | i0 | 90.942 | 100.04 | 276 | 23 | 100 | 2 | 1 | 275 | 392 | 118 | Uncultured Anaerolinaceae bacterium clone GE7GXPU01B8DOW 16S ribosomal RNA gene, partial sequence | blastn | 27511 | 370 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | uncultured Anaerolineaceae bacterium | |||
| 8067450 | 8067450 | PRJNA400391_S_NODE_6447_length_153_cov_3.245763_g6386_i0 | PRJNA400391 | 6447 | 153 | 3.245763 | 4.96601739 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 195 | 1.97e-45 | NTclustered | gi|2874253788|emb|OY969772.1| | 1672391 | g6386 | i0 | 89.542 | 151.549019607843 | 153 | 16 | 100 | 0 | 1 | 153 | 671647 | 671495 | MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1 | blastn | 23187 | 195 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 18265775 | 18265775 | PRJNA400391_S_NODE_955_length_362_cov_4.623853_g894_i0 | PRJNA400391 | 955 | 362 | 4.623853 | 16.73834786 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 464 | 3.719999999999999e-126 | NTclustered | gi|2874253882|emb|OY969938.1| | 1672391 | g894 | i0 | 90.278 | 608.450276243094 | 360 | 27 | 98 | 7 | 1 | 356 | 2064106 | 2063751 | MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1 | blastn | 220259 | 464 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 19539875 | 19539875 | PRJNA400391_S_NODE_4916_length_179_cov_5.298611_g4855_i0 | PRJNA400391 | 4916 | 179 | 5.298611 | 9.48451369 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 291 | 2.95e-74 | NTclustered | gi|2874253788|emb|OY969772.1| | 1672391 | g4855 | i0 | 96.067 | 112.664804469274 | 178 | 7 | 99 | 0 | 1 | 178 | 670246 | 670069 | MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1 | blastn | 20167 | 291 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 24640497 | 24640497 | PRJNA400391_S_NODE_540_length_441_cov_35.736453_g480_i0 | PRJNA400391 | 540 | 441 | 35.736453 | 157.59775773 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 501 | 3.52e-137 | NTclustered | gi|2556899361|gb|CP129481.1| | 2073117 | g480 | i0 | 87.5 | 282.977324263039 | 448 | 38 | 98 | 8 | 1 | 434 | 1234388 | 1233945 | MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome | blastn | 124793 | 501 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales 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);;