contig_metadata
6 rows where bioproject = "PRJEB6584", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25523775 | 25523775 | PRJEB6584f_S_NODE_41_length_889_cov_24.277518_g39_i0 | PRJEB6584 | 41 | 889 | 24.277518 | 215.82713502 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 102 | 8.78e-17 | NTclustered | gi|2575820295|emb|OY730414.1| | 2910168 | g39 | i0 | 84.112 | 14.6062992125984 | 107 | 15 | 12 | 2 | 218 | 323 | 1273691 | 1273586 | MAG: Longimicrobiales bacterium isolate 35361606-ee58-41ba-9638-b7483a57a1ce genome assembly, chromosome: 1 | blastn | 12985 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 25795809 | 25795809 | PRJEB6584h_S_NODE_635_length_443_cov_393.029412_g575_i0 | PRJEB6584 | 635 | 443 | 393.029412 | 1741.12029516 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 102 | 4.2e-17 | NTclustered | gi|2575820295|emb|OY730414.1| | 2910168 | g575 | i0 | 84.112 | 29.3115124153499 | 107 | 15 | 24 | 2 | 204 | 309 | 1273691 | 1273586 | MAG: Longimicrobiales bacterium isolate 35361606-ee58-41ba-9638-b7483a57a1ce genome assembly, chromosome: 1 | blastn | 12985 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 25932108 | 25932108 | PRJEB6584i_S_NODE_348_length_377_cov_4.520468_g336_i0 | PRJEB6584 | 348 | 377 | 4.520468 | 17.04216436 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 102 | 3.52e-17 | NTclustered | gi|2575820295|emb|OY730414.1| | 2910168 | g336 | i0 | 84.112 | 34.4429708222812 | 107 | 15 | 28 | 2 | 141 | 246 | 1273586 | 1273691 | MAG: Longimicrobiales bacterium isolate 35361606-ee58-41ba-9638-b7483a57a1ce genome assembly, chromosome: 1 | blastn | 12985 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 26339646 | 26339646 | PRJEB6584a_S_NODE_1767_length_271_cov_472.792373_g1747_i0 | PRJEB6584 | 1767 | 271 | 472.792373 | 1281.26733083 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 132 | 3.1e-26 | NTclustered | gi|2874254163|emb|OY970395.1| | 412054 | g1747 | i0 | 78.319 | 310.756457564576 | 226 | 34 | 79 | 10 | 58 | 271 | 1607876 | 1607654 | MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1 | blastn | 84215 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26476364 | 26476364 | PRJEB6584e_S_NODE_40_length_682_cov_7.766615_g32_i0 | PRJEB6584 | 40 | 682 | 7.766615 | 52.9683143 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 102 | 6.66e-17 | NTclustered | gi|2575820295|emb|OY730414.1| | 2910168 | g32 | i0 | 84.112 | 19.0395894428152 | 107 | 15 | 16 | 2 | 313 | 418 | 1273586 | 1273691 | MAG: Longimicrobiales bacterium isolate 35361606-ee58-41ba-9638-b7483a57a1ce genome assembly, chromosome: 1 | blastn | 12985 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 26478188 | 26478188 | PRJEB6584p_S_NODE_3480_length_215_cov_2.605556_g3449_i0 | PRJEB6584 | 3480 | 215 | 2.605556 | 5.6019454 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 102 | 1.86e-17 | NTclustered | gi|2575820295|emb|OY730414.1| | 2910168 | g3449 | i0 | 84.112 | 60.3953488372093 | 107 | 15 | 49 | 2 | 73 | 178 | 1273586 | 1273691 | MAG: Longimicrobiales bacterium isolate 35361606-ee58-41ba-9638-b7483a57a1ce genome assembly, chromosome: 1 | blastn | 12985 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales 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);;