contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJEB43370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5162509 | 5162509 | PRJEB43370_P_NODE_2865_length_256_cov_1.946860_g2822_i0 | PRJEB43370 | 2865 | 256 | 1.94686 | 4.9839616 | Tylopharynx sp. WEM-2009 | 669147 | Nematoda | Nematoda | 135 | 2.25e-27 | NTclustered | gi|256709231|gb|GQ422268.1| | 669147 | g2822 | i0 | 80.769 | 2.91796875 | 182 | 28 | 69 | 5 | 47 | 223 | 10 | 189 | Tylopharynx sp. WEM-2009 small subunit ribosomal protein 28 (rps-28) mRNA, partial cds | blastn | 747 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Tylopharyngidae | Tylopharynx | Tylopharynx sp. WEM-2009 | |
| 5162574 | 5162574 | PRJEB43370_P_NODE_9825_length_164_cov_0.904348_g9782_i0 | PRJEB43370 | 9825 | 164 | 0.904348 | 1.48313072 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 110 | 8.01e-20 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g9782 | i0 | 93.243 | 1.4390243902439 | 74 | 5 | 45 | 0 | 55 | 128 | 110 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 236 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 11193301 | 11193301 | PRJEB43370_P_NODE_2449_length_276_cov_1.731278_g2406_i0 | PRJEB43370 | 2449 | 276 | 1.731278 | 4.77832728 | Strongyloides | 6247 | Nematoda | Nematoda | 228 | 3.9299999999999985e-55 | NTclustered | gi|199600273|tpg|BK006066.1| | 6248 | g2406 | i0 | 81.522 | 82.213768115942 | 276 | 51 | 100 | 0 | 1 | 276 | 1077 | 802 | TPA_inf: Strongyloides stercoralis eukaryotic translation elongation factor 1A (eft-2) mRNA, complete cds | blastn | 22691 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides stercoralis | |
| 16636985 | 16636985 | PRJEB43370_P_NODE_2754_length_261_cov_0.981132_g2711_i0 | PRJEB43370 | 2754 | 261 | 0.981132 | 2.56075452 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 185 | 2.2499999999999994e-42 | NTclustered | gi|1376154049|ref|XM_024646386.1| | 34506 | g2711 | i0 | 80.408 | 13.0574712643678 | 245 | 46 | 93 | 2 | 16 | 259 | 316 | 559 | Strongyloides ratti V-type proton ATPase subunit B, kidney (SRAE_X000121000), partial mRNA | blastn | 3408 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 22666819 | 22666819 | PRJEB43370_P_NODE_1998_length_308_cov_1.378378_g1955_i0 | PRJEB43370 | 1998 | 308 | 1.378378 | 4.24540424 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 370 | 6.99e-98 | NTclustered | gi|268619129|gb|GU130148.1| | 6326 | g1955 | i0 | 88.312 | 101.850649350649 | 308 | 36 | 100 | 0 | 1 | 308 | 875 | 568 | Bursaphelenchus xylophilus actin-4 mRNA, complete cds | blastn | 31370 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 23012159 | 23012159 | PRJEB43370_P_NODE_3319_length_240_cov_1.361257_g3276_i0 | PRJEB43370 | 3319 | 240 | 1.361257 | 3.2670168 | Acrostichus rhynchophori | 1538711 | Nematoda | Nematoda | 139 | 1.61e-28 | NTclustered | gi|675118829|gb|KJ877294.1| | 1538711 | g3276 | i0 | 82.803 | 3.09583333333333 | 157 | 25 | 65 | 2 | 24 | 179 | 198 | 43 | Acrostichus rhynchophori strain RGD193 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 743 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Acrostichus | Acrostichus rhynchophori |
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);;