contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_phylum = "Tardigrada"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5775609 | 5775609 | PRJNA690592_S_NODE_88685_length_344_cov_1.243542_g87671_i0 | PRJNA690592 | 88685 | 344 | 1.243542 | 4.27778448 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2493449007|ref|XM_055483839.1| | 2943436 | g87671 | i0 | 96.97 | 0.767441860465116 | 33 | 1 | 10 | 0 | 298 | 330 | 3111 | 3079 | PREDICTED: Paramacrobiotus metropolitanus G protein-coupled receptor kinase 1-like (LOC129589233), transcript variant X1, mRNA | blastn | 264 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 12150256 | 12150256 | PRJNA690592_S_NODE_139650_length_285_cov_5.353774_g138636_i0 | PRJNA690592 | 139650 | 285 | 5.353774 | 15.2582559 | Calohypsibius ornatus | 947157 | Tardigrada | other_Eukaryota | 97.1 | 1.2e-15 | NTclustered | gi|1519192601|gb|MH079505.1| | 947157 | g138636 | i0 | 87.059 | 16.1649122807018 | 85 | 11 | 30 | 0 | 201 | 285 | 201 | 285 | Calohypsibius ornatus isolate Tar801 28S ribosomal RNA gene, partial sequence | blastn | 4607 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Calohypsibiidae | Calohypsibius | Calohypsibius ornatus | |
| 13424693 | 13424693 | PRJNA690592_S_NODE_130371_length_294_cov_1.393665_g129357_i0 | PRJNA690592 | 130371 | 294 | 1.393665 | 4.0973751 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 318 | 2.439999999999999e-82 | NTclustered | gi|2493458319|ref|XM_055486313.1| | 2943436 | g129357 | i0 | 86.348 | 32.6904761904762 | 293 | 38 | 99 | 2 | 1 | 292 | 797 | 506 | PREDICTED: Paramacrobiotus metropolitanus actin-related protein 2 (LOC129590881), mRNA | blastn | 9611 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 22348595 | 22348595 | PRJNA690592_S_NODE_185498_length_251_cov_1.325843_g184484_i0 | PRJNA690592 | 185498 | 251 | 1.325843 | 3.32786593 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 248 | 2.7e-61 | NTclustered | gi|2493392886|ref|XM_055487985.1| | 2943436 | g184484 | i0 | 86.607 | 41.4820717131474 | 224 | 30 | 89 | 0 | 13 | 236 | 321 | 544 | PREDICTED: Paramacrobiotus metropolitanus ATP synthase subunit alpha, mitochondrial-like (LOC129592040), mRNA | blastn | 10412 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus | |
| 23624182 | 23624182 | PRJNA690592_S_NODE_201159_length_246_cov_0.890173_g200145_i0 | PRJNA690592 | 201159 | 246 | 0.890173 | 2.18982558 | Paramacrobiotus metropolitanus | 2943436 | Tardigrada | other_Eukaryota | 178 | 3.5099999999999993e-40 | NTclustered | gi|2493463315|ref|XM_055487665.1| | 2943436 | g200145 | i0 | 81.364 | 9.90650406504065 | 220 | 39 | 89 | 2 | 23 | 241 | 6386 | 6168 | PREDICTED: Paramacrobiotus metropolitanus pre-mRNA-processing-splicing factor 8 (LOC129591837), mRNA | blastn | 2437 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Tardigrada | Eutardigrada | Parachela | Macrobiotidae | Paramacrobiotus | Paramacrobiotus metropolitanus |
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);;