contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax_phylum = "Nemertea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2797931 | 2797931 | PRJNA1120060_P_NODE_2123943_length_268_cov_1.287179_g2105899_i0 | PRJNA1120060 | 2123943 | 268 | 1.287179 | 3.44963972 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2724534978|ref|XM_064774463.1| | 88925 | g2105899 | i0 | 100 | 0.671641791044776 | 30 | 0 | 11 | 0 | 8 | 37 | 4057 | 4028 | PREDICTED: Lineus longissimus pro-neuregulin-1, membrane-bound isoform-like (LOC135489190), transcript variant X6, mRNA | blastn | 180 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 4062434 | 4062434 | PRJNA1120060_P_NODE_1279364_length_308_cov_2.659574_g1261419_i0 | PRJNA1120060 | 1279364 | 308 | 2.659574 | 8.19148792 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2724591921|ref|XR_010447182.1| | 88925 | g1261419 | i0 | 100 | 0.181818181818182 | 28 | 0 | 9 | 0 | 82 | 109 | 4386 | 4359 | PREDICTED: Lineus longissimus uncharacterized LOC135489634 (LOC135489634), transcript variant X2, misc_RNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 9178055 | 9178055 | PRJNA1120060_P_NODE_2343328_length_259_cov_3.768817_g2325267_i0 | PRJNA1120060 | 2343328 | 259 | 3.768817 | 9.76123603 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|2724580863|ref|XM_064769150.1| | 88925 | g2325267 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 40 | 67 | 74 | 47 | PREDICTED: Lineus longissimus nucleoporin NDC1-like (LOC135486387), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 10435108 | 10435108 | PRJNA1120060_P_NODE_1025209_length_312_cov_2.020921_g1007280_i0 | PRJNA1120060 | 1025209 | 312 | 2.020921 | 6.30527352 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2724554674|ref|XR_010449335.1| | 88925 | g1007280 | i0 | 100 | 0.0897435897435897 | 28 | 0 | 9 | 0 | 174 | 201 | 1994 | 1967 | PREDICTED: Lineus longissimus uncharacterized LOC135499745 (LOC135499745), transcript variant X2, ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 10471243 | 10471243 | PRJNA1120060_P_NODE_539609_length_359_cov_2.241259_g521951_i0 | PRJNA1120060 | 539609 | 359 | 2.241259 | 8.04611981 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 52.8 | 0.034 | NTclustered | gi|2724566686|ref|XM_064797118.1| | 88925 | g521951 | i0 | 100 | 0.545961002785515 | 28 | 0 | 8 | 0 | 233 | 260 | 7950 | 7977 | PREDICTED: Lineus longissimus diacylglycerol kinase theta-like (LOC135503497), transcript variant X3, mRNA | blastn | 196 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 11738045 | 11738045 | PRJNA1120060_P_NODE_3115870_length_235_cov_3.320988_g3097768_i0 | PRJNA1120060 | 3115870 | 235 | 3.320988 | 7.8043218 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2724543753|ref|XM_064785078.1| | 88925 | g3097768 | i0 | 100 | 0.246808510638298 | 29 | 0 | 12 | 0 | 205 | 233 | 3460 | 3432 | PREDICTED: Lineus longissimus palmitoyltransferase ZDHHC1-like (LOC135496001), transcript variant X1, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 19364888 | 19364888 | PRJNA1120060_P_NODE_1511616_length_293_cov_1.627273_g1493628_i0 | PRJNA1120060 | 1511616 | 293 | 1.627273 | 4.76790989 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2724554674|ref|XR_010449335.1| | 88925 | g1493628 | i0 | 100 | 0.0955631399317406 | 28 | 0 | 10 | 0 | 189 | 216 | 1967 | 1994 | PREDICTED: Lineus longissimus uncharacterized LOC135499745 (LOC135499745), transcript variant X2, ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 20656033 | 20656033 | PRJNA1120060_P_NODE_271237_length_431_cov_2.324022_g254295_i0 | PRJNA1120060 | 271237 | 431 | 2.324022 | 10.01653482 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 52.8 | 0.042 | NTclustered | gi|2724596259|ref|XM_064777211.1| | 88925 | g254295 | i0 | 100 | 0.71461716937355 | 28 | 0 | 6 | 0 | 282 | 309 | 8798 | 8825 | PREDICTED: Lineus longissimus dedicator of cytokinesis protein 4-like (LOC135491381), transcript variant X8, mRNA | blastn | 308 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 21934186 | 21934186 | PRJNA1120060_P_NODE_2935898_length_243_cov_0.911765_g2917805_i0 | PRJNA1120060 | 2935898 | 243 | 0.911765 | 2.21558895 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2724570948|ref|XM_064763792.1| | 88925 | g2917805 | i0 | 90.476 | 0.691358024691358 | 42 | 2 | 16 | 2 | 46 | 85 | 10066 | 10025 | PREDICTED: Lineus longissimus fibrillin-2-like (LOC135483169), transcript variant X2, mRNA | blastn | 168 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus |
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);;