contig_metadata
10 rows where bioproject = "PRJNA330616", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3620160 | 3620160 | PRJNA330616_P_NODE_5683_length_352_cov_1.937294_g5274_i0 | PRJNA330616 | 5683 | 352 | 1.937294 | 6.81927488 | Ironus | 211205 | Nematoda | Nematoda | 207 | 6.71e-49 | NTclustered | gi|68271495|gb|DQ086676.1| | 554024 | g5274 | i0 | 83.482 | 57.46875 | 224 | 35 | 63 | 2 | 106 | 327 | 175 | 398 | Uncultured nematode isolate NEMATD17 large subunit ribosomal RNA gene, partial sequence | blastn | 20229 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Nematoda environmental sample | |||||
| 11868242 | 11868242 | PRJNA330616_P_NODE_17610_length_200_cov_1.350993_g17201_i0 | PRJNA330616 | 17610 | 200 | 1.350993 | 2.701986 | Ancylostoma duodenale | 51022 | Nematoda | Nematoda | 161 | 2.77e-35 | NTclustered | gi|66734013|gb|DQ055415.1| | 51022 | g17201 | i0 | 81.538 | 53.43 | 195 | 36 | 98 | 0 | 6 | 200 | 1239 | 1045 | Ancylostoma duodenale beta-tubulin mRNA, complete cds | blastn | 10686 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma duodenale | |
| 13143346 | 13143346 | PRJNA330616_P_NODE_31531_length_162_cov_0.902655_g31122_i0 | PRJNA330616 | 31531 | 162 | 0.902655 | 1.4623011 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 102 | 1.32e-17 | NTclustered | gi|1972257304|ref|NM_064671.9| | 6239 | g31122 | i0 | 82.609 | 4.24074074074074 | 115 | 20 | 71 | 0 | 9 | 123 | 190 | 76 | Caenorhabditis elegans Ribosomal protein L37 (rpl-37.1), partial mRNA | blastn | 687 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 18920932 | 18920932 | PRJNA330616_P_NODE_5155_length_372_cov_1.879257_g4746_i0 | PRJNA330616 | 5155 | 372 | 1.879257 | 6.99083604 | Opisthokonta | 33154 | Nematoda | Nematoda | 274 | 6.94e-69 | NTclustered | gi|1376156759|ref|XM_024645793.1| | 34506 | g4746 | i0 | 82.099 | 87.1182795698925 | 324 | 54 | 86 | 4 | 1 | 321 | 355 | 33 | Strongyloides ratti Ras-like protein 3 (SRAE_X000250800), partial mRNA | blastn | 32408 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 20791377 | 20791377 | PRJNA330616_P_NODE_8697_length_281_cov_1.775862_g8288_i0 | PRJNA330616 | 8697 | 281 | 1.775862 | 4.99017222 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 211 | 4.04e-50 | NTclustered | gi|268559799|ref|XM_002646027.1| | 6238 | g8288 | i0 | 92.053 | 55.864768683274 | 151 | 10 | 53 | 2 | 131 | 280 | 1307 | 1158 | Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA | blastn | 15698 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 28702637 | 28702637 | PRJNA330616_P_NODE_27927_length_165_cov_0.879310_g27518_i0 | PRJNA330616 | 27927 | 165 | 0.87931 | 1.4508615 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 68.9 | 3.58e-13 | NR | VDO78519.1 | 241478 | g27518 | i0 | 53.6 | 12.2545454545455 | 56 | 24 | 98.2 | 1 | 165 | 4 | 63 | 118 | VDO78519.1 unnamed protein product [Soboliphyme baturini] | diamond | 2022 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 29491822 | 29491822 | PRJNA330616_P_NODE_13950_length_223_cov_1.172414_g13541_i0 | PRJNA330616 | 13950 | 223 | 1.172414 | 2.61448322 | Metazoa | 33208 | Nematoda | Nematoda | 49.7 | 1.07e-4 | NR | KAI3420146.1 | 36090 | g13541 | i0 | 42.6 | 5.34080717488789 | 54 | 31 | 72.6 | 0 | 5 | 166 | 705 | 758 | KAI3420146.1 hypothetical protein GPALN_003468 [Globodera pallida] | diamond | 1191 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Globodera | Globodera pallida | |
| 31292541 | 31292541 | PRJNA330616_P_NODE_33155_length_151_cov_3.500000_g32746_i0 | PRJNA330616 | 33155 | 151 | 3.5 | 5.285 | Metazoa | 33208 | Nematoda | Nematoda | 87.4 | 2.21e-19 | NR | CAD5209926.1 | 6326 | g32746 | i0 | 70.8 | 5.74172185430464 | 48 | 14 | 95.4 | 0 | 3 | 146 | 2 | 49 | CAD5209926.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 867 | 88.2 | 0.99092970521542 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 32129589 | 32129589 | PRJNA330616_P_NODE_20438_length_187_cov_0.775362_g20029_i0 | PRJNA330616 | 20438 | 187 | 0.775362 | 1.44992694 | Oigolaimella sp. VS-2 | 1538701 | Nematoda | Nematoda | 98.6 | 4.8199999999999996e-24 | NR | AIL48349.1 | 1538701 | g20029 | i0 | 73 | 6.03208556149733 | 63 | 16 | 99.5 | 1 | 2 | 187 | 52 | 114 | AIL48349.1 large subunit ribosomal protein 9, partial [Oigolaimella sp. VS-2014] | diamond | 1128 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Oigolaimella | Oigolaimella sp. VS-2014 | |
| 32620991 | 32620991 | PRJNA330616_P_NODE_25960_length_167_cov_0.864407_g25551_i0 | PRJNA330616 | 25960 | 167 | 0.864407 | 1.44355969 | Opisthokonta | 33154 | Nematoda | Nematoda | 43.9 | 0.00402 | NR | NP_490749.1 | 6239 | g25551 | i0 | 65.5 | 9.32335329341317 | 29 | 10 | 52.1 | 0 | 162 | 76 | 102 | 130 | NP_490749.1 Nascent polypeptide-associated complex subunit alpha [Caenorhabditis elegans] | diamond | 1557 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans |
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);;