contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145211 | 145211 | PRJNA1000943_P_NODE_5941_length_330_cov_2.789883_g5803_i0 | PRJNA1000943 | 5941 | 330 | 2.789883 | 9.2066139 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 241 | 6.18e-59 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g5803 | i0 | 80.531 | 11.9636363636364 | 339 | 44 | 100 | 20 | 1 | 330 | 273207 | 273532 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 3948 | 241 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 5247917 | 5247917 | PRJNA1000943_P_NODE_16065_length_223_cov_4.413333_g15927_i0 | PRJNA1000943 | 16065 | 223 | 4.413333 | 9.84173259 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 278 | 2.9999999999999995e-70 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g15927 | i0 | 89.238 | 17.8654708520179 | 223 | 22 | 99 | 2 | 2 | 223 | 276008 | 275787 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 3984 | 278 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 5247954 | 5247954 | PRJNA1000943_P_NODE_4385_length_377_cov_0.934211_g4248_i0 | PRJNA1000943 | 4385 | 377 | 0.934211 | 3.52197547 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 396 | 1.44e-105 | NTclustered | gi|2874253835|emb|OY969885.1| | 1672391 | g4248 | i0 | 86.253 | 225.724137931034 | 371 | 43 | 98 | 8 | 10 | 377 | 2092868 | 2092503 | MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1 | blastn | 85098 | 396 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 6523538 | 6523538 | PRJNA1000943_P_NODE_7806_length_295_cov_1.405405_g7668_i0 | PRJNA1000943 | 7806 | 295 | 1.405405 | 4.14594475 | Phototrophicus methaneseepsis | 2710758 | Bacteria | Bacteria | 278 | 4.15e-70 | NTclustered | gi|1932369605|gb|CP062983.1| | 2710758 | g7668 | i0 | 84.429 | 633.471186440678 | 289 | 38 | 97 | 6 | 1 | 286 | 2827989 | 2828273 | Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome | blastn | 186874 | 278 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicus | Phototrophicus methaneseepsis | ||
| 9072664 | 9072664 | PRJNA1000943_P_NODE_8368_length_286_cov_1.098592_g8230_i0 | PRJNA1000943 | 8368 | 286 | 1.098592 | 3.14197312 | Candidatus Promineifilum breve | 1806508 | Bacteria | Bacteria | 222 | 1.9e-53 | NTclustered | gi|1041165931|emb|LN890655.2| | 1806508 | g8230 | i0 | 81.164 | 136.944055944056 | 292 | 42 | 98 | 9 | 6 | 286 | 598462 | 598173 | Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I | blastn | 39166 | 222 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilum | Candidatus Promineifilum breve | ||
| 24371090 | 24371090 | PRJNA1000943_P_NODE_8120_length_290_cov_1.082949_g7982_i0 | PRJNA1000943 | 8120 | 290 | 1.082949 | 3.1405521 | Roseiflexus sp. RS-1 | 357808 | Bacteria | Bacteria | 250 | 8.87e-62 | NTclustered | gi|470481958|ref|NR_076505.1| | 357808 | g7982 | i0 | 82.594 | 7.37241379310345 | 293 | 42 | 100 | 9 | 1 | 290 | 1514 | 1228 | Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence | blastn | 2138 | 250 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 |
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);;