contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA914897" and tax_phylum = "Nematoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2170413 | 2170413 | PRJNA914897_P_NODE_41562_length_243_cov_0.905882_g41138_i0 | PRJNA914897 | 41562 | 243 | 0.905882 | 2.20129326 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 449 | 6.65e-122 | NTclustered | gi|1972264789|ref|NM_066171.10| | 6239 | g41138 | i0 | 100 | 56.4197530864198 | 243 | 0 | 100 | 0 | 1 | 243 | 426 | 184 | Caenorhabditis elegans Small ribosomal subunit protein uS11 (rps-14), mRNA | blastn | 13710 | 449 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 11098454 | 11098454 | PRJNA914897_P_NODE_34629_length_261_cov_1.638298_g34205_i0 | PRJNA914897 | 34629 | 261 | 1.638298 | 4.27595778 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 139 | 1.78e-28 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g34205 | i0 | 81.111 | 1.58620689655172 | 180 | 28 | 68 | 6 | 23 | 199 | 213 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 414 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 16197648 | 16197648 | PRJNA914897_P_NODE_11753_length_538_cov_1.815054_g11333_i0 | PRJNA914897 | 11753 | 538 | 1.815054 | 9.76499052 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 169 | 5.0299999999999995e-37 | NTclustered | gi|1376143741|ref|XM_024652282.1| | 34506 | g11333 | i0 | 76.803 | 4.59293680297398 | 319 | 62 | 58 | 11 | 1 | 313 | 887 | 575 | Strongyloides ratti Serine/threonine-protein phosphatase PP1-beta catalytic subunit (SRAE_2000134100), partial mRNA | blastn | 2471 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 20021479 | 20021479 | PRJNA914897_P_NODE_1916_length_1357_cov_2.165109_g1734_i0 | PRJNA914897 | 1916 | 1357 | 2.165109 | 29.38052913 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 67.6 | 4.96e-6 | NTclustered | gi|1376154429|ref|XM_024648508.1| | 34506 | g1734 | i0 | 72.157 | 0.187914517317612 | 255 | 59 | 18 | 12 | 65 | 313 | 1256 | 1008 | Strongyloides ratti Dihydropyrimidinase-related protein 2 (SRAE_X000139900), partial mRNA | blastn | 255 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 25120863 | 25120863 | PRJNA914897_P_NODE_1160_length_1592_cov_2.990125_g1032_i0 | PRJNA914897 | 1160 | 1592 | 2.990125 | 47.60279 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 71.3 | 4.52e-7 | NTclustered | gi|1376134321|ref|XM_024647115.1| | 34506 | g1032 | i0 | 84.507 | 0.215452261306533 | 71 | 11 | 4 | 0 | 799 | 869 | 325 | 395 | Strongyloides ratti Serine/threonine-protein phosphatase PP1-beta catalytic subunit (SRAE_1000030000), partial mRNA | blastn | 343 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 25120951 | 25120951 | PRJNA914897_P_NODE_26720_length_312_cov_1.794979_g26296_i0 | PRJNA914897 | 26720 | 312 | 1.794979 | 5.60033448 | Diplogastrellus gracilis | 669117 | Nematoda | Nematoda | 211 | 4.55e-50 | NTclustered | gi|256709130|gb|GQ422217.1| | 669117 | g26296 | i0 | 79.801 | 80.1121794871795 | 302 | 51 | 95 | 8 | 8 | 304 | 427 | 723 | Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 24995 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Diplogastrellus | Diplogastrellus gracilis | |
| 25121023 | 25121023 | PRJNA914897_P_NODE_36280_length_252_cov_1.290503_g35856_i0 | PRJNA914897 | 36280 | 252 | 1.290503 | 3.25206756 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|2445372991|ref|XM_003107690.2| | 31234 | g35856 | i0 | 100 | 0.115079365079365 | 29 | 0 | 12 | 0 | 65 | 93 | 166 | 194 | Caenorhabditis remanei uncharacterized protein (GCK72_013861), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 25121133 | 25121133 | PRJNA914897_P_NODE_6240_length_792_cov_2.952712_g5870_i0 | PRJNA914897 | 6240 | 792 | 2.952712 | 23.38547904 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 78.7 | 1.31e-9 | NTclustered | gi|1376149593|ref|XM_024643132.1| | 34506 | g5870 | i0 | 82.105 | 0.482323232323232 | 95 | 14 | 12 | 3 | 306 | 398 | 598 | 505 | Strongyloides ratti Vacuolar protein sorting-associated protein 26B (SRAE_2000428100), partial mRNA | blastn | 382 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti |
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);;