contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax_phylum = "Nematomorpha"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 259660 | 259660 | PRJNA1120060_P_NODE_3124201_length_235_cov_2.308642_g3106099_i0 | PRJNA1120060 | 3124201 | 235 | 2.308642 | 5.4253087 | Gordionus sp. m RMFG-2023 | 3053472 | Nematomorpha | other_Eukaryota | 58.4 | 4.53e-4 | NTclustered | gi|2733949631|ref|XM_065459367.1| | 3053472 | g3106099 | i0 | 100 | 0.131914893617021 | 31 | 0 | 13 | 0 | 10 | 40 | 210 | 240 | PREDICTED: Gordionus sp. m RMFG-2023 uncharacterized LOC135924313 (LOC135924313), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematomorpha | Gordioida | Chordodea | Parachordodidae | Gordionus | Gordionus sp. m RMFG-2023 | |
| 262854 | 262854 | PRJNA1120060_P_NODE_3408601_length_215_cov_5.521127_g3390481_i0 | PRJNA1120060 | 3408601 | 215 | 5.521127 | 11.87042305 | Gordionus sp. m RMFG-2023 | 3053472 | Nematomorpha | other_Eukaryota | 52.8 | 0.019 | NTclustered | gi|2733947807|ref|XM_065458421.1| | 3053472 | g3390481 | i0 | 100 | 0.26046511627907 | 28 | 0 | 13 | 0 | 148 | 175 | 2894 | 2921 | PREDICTED: Gordionus sp. m RMFG-2023 SWI/SNF complex subunit SMARCC2-like (LOC135923587), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematomorpha | Gordioida | Chordodea | Parachordodidae | Gordionus | Gordionus sp. m RMFG-2023 | |
| 269531 | 269531 | PRJNA1120060_P_NODE_658721_length_339_cov_3.477444_g640937_i0 | PRJNA1120060 | 658721 | 339 | 3.477444 | 11.78853516 | Gordionus sp. m RMFG-2023 | 3053472 | Nematomorpha | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2733951422|ref|XR_010571512.1| | 3053472 | g640937 | i0 | 94.595 | 0.218289085545723 | 37 | 0 | 11 | 2 | 113 | 148 | 209 | 244 | PREDICTED: Gordionus sp. m RMFG-2023 uncharacterized LOC135925066 (LOC135925066), transcript variant X1, ncRNA | blastn | 74 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematomorpha | Gordioida | Chordodea | Parachordodidae | Gordionus | Gordionus sp. m RMFG-2023 | |
| 10449970 | 10449970 | PRJNA1120060_P_NODE_2057389_length_270_cov_3.142132_g2039352_i0 | PRJNA1120060 | 2057389 | 270 | 3.142132 | 8.4837564 | Gordionus sp. m RMFG-2023 | 3053472 | Nematomorpha | other_Eukaryota | 62.1 | 4.11e-5 | NTclustered | gi|2733956693|ref|XM_065462799.1| | 3053472 | g2039352 | i0 | 97.297 | 0.137037037037037 | 37 | 0 | 14 | 1 | 88 | 124 | 366 | 331 | PREDICTED: Gordionus sp. m RMFG-2023 uncharacterized LOC135926866 (LOC135926866), mRNA | blastn | 37 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematomorpha | Gordioida | Chordodea | Parachordodidae | Gordionus | Gordionus sp. m RMFG-2023 | |
| 14261539 | 14261539 | PRJNA1120060_P_NODE_1081292_length_311_cov_3.386555_g1063357_i0 | PRJNA1120060 | 1081292 | 311 | 3.386555 | 10.53218605 | Gordionus sp. m RMFG-2023 | 3053472 | Nematomorpha | other_Eukaryota | 62.1 | 4.83e-5 | NTclustered | gi|2733956693|ref|XM_065462799.1| | 3053472 | g1063357 | i0 | 97.297 | 0.118971061093248 | 37 | 0 | 12 | 1 | 178 | 214 | 331 | 366 | PREDICTED: Gordionus sp. m RMFG-2023 uncharacterized LOC135926866 (LOC135926866), mRNA | blastn | 37 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematomorpha | Gordioida | Chordodea | Parachordodidae | Gordionus | Gordionus sp. m RMFG-2023 | |
| 14267751 | 14267751 | PRJNA1120060_P_NODE_1491692_length_294_cov_1.031674_g1473705_i0 | PRJNA1120060 | 1491692 | 294 | 1.031674 | 3.03312156 | Gordionus sp. m RMFG-2023 | 3053472 | Nematomorpha | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2733955406|ref|XM_065462165.1| | 3053472 | g1473705 | i0 | 94.595 | 0.125850340136054 | 37 | 0 | 12 | 2 | 30 | 64 | 538 | 574 | PREDICTED: Gordionus sp. m RMFG-2023 uncharacterized LOC135926328 (LOC135926328), mRNA | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematomorpha | Gordioida | Chordodea | Parachordodidae | Gordionus | Gordionus sp. m RMFG-2023 | |
| 23191986 | 23191986 | PRJNA1120060_P_NODE_1566339_length_290_cov_3.350230_g1548347_i0 | PRJNA1120060 | 1566339 | 290 | 3.35023 | 9.715667 | Gordionus sp. m RMFG-2023 | 3053472 | Nematomorpha | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2733966066|ref|XM_065467402.1| | 3053472 | g1548347 | i0 | 96.97 | 0.113793103448276 | 33 | 0 | 11 | 1 | 179 | 210 | 2751 | 2719 | PREDICTED: Gordionus sp. m RMFG-2023 uncharacterized LOC135930571 (LOC135930571), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematomorpha | Gordioida | Chordodea | Parachordodidae | Gordionus | Gordionus sp. m RMFG-2023 |
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);;