contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153484 | 153484 | PRJNA1005695_P_NODE_22361_length_317_cov_3.885246_g21509_i0 | PRJNA1005695 | 22361 | 317 | 3.885246 | 12.31622982 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 462 | 1.16e-125 | NTclustered | gi|308156989|gb|GQ890454.1| | 10195 | g21509 | i0 | 93.987 | 22.0315457413249 | 316 | 2 | 99 | 7 | 2 | 317 | 428 | 130 | Brachionus plicatilis isolate DNA16 large subunit ribosomal RNA gene, partial sequence | blastn | 6984 | 462 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 7806041 | 7806041 | PRJNA1005695_P_NODE_24227_length_305_cov_1.681034_g23375_i0 | PRJNA1005695 | 24227 | 305 | 1.681034 | 5.1271537 | Proales similis | 360698 | Rotifera | other_Eukaryota | 67.6 | 1.02e-6 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g23375 | i0 | 71.854 | 3.74098360655738 | 302 | 63 | 96 | 18 | 11 | 303 | 8374 | 8086 | Proales similis mitochondrion, complete genome | blastn | 1141 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 7806217 | 7806217 | PRJNA1005695_P_NODE_4507_length_753_cov_4.322059_g3774_i0 | PRJNA1005695 | 4507 | 753 | 4.322059 | 32.54510427 | Brachionus koreanus | 1199090 | Rotifera | other_Eukaryota | 172 | 5.55e-38 | NTclustered | gi|477541870|gb|KC603851.1| | 1199090 | g3774 | i0 | 76.807 | 4.9203187250996 | 332 | 62 | 43 | 14 | 293 | 618 | 6067 | 5745 | Brachionus sp. 'koreanus' chromosome I mitochondrion, complete sequence | blastn | 3705 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus koreanus | |
| 11631986 | 11631986 | PRJNA1005695_P_NODE_14550_length_399_cov_26.733129_g13698_i0 | PRJNA1005695 | 14550 | 399 | 26.733129 | 106.66518471 | Lecane bulla | 96446 | Rotifera | other_Eukaryota | 505 | 2.44e-138 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g13698 | i0 | 89.474 | 31.1503759398496 | 399 | 42 | 100 | 0 | 1 | 399 | 444 | 46 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 12429 | 505 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 12480023 | 12480023 | PRJNA1005695_P_NODE_5550_length_672_cov_18.712855_g4734_i0 | PRJNA1005695 | 5550 | 672 | 18.712855 | 125.7503856 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 1112 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g4734 | i0 | 96.588 | 41.4389880952381 | 674 | 17 | 99 | 5 | 1 | 671 | 1513 | 2183 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 27847 | 1118 | 0.994633273703041 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;