contig_metadata
9 rows where bioproject = "PRJEB25583" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6401149 | 6401149 | PRJEB25583_P_NODE_8306_length_151_cov_1.026316_g8129_i0 | PRJEB25583 | 8306 | 151 | 1.026316 | 1.54973716 | Panthera onca | 9690 | Chordata | Chordata | 154 | 3.28e-33 | NTclustered | gi|2614064246|ref|XM_060611915.1| | 9690 | g8129 | i0 | 97.753 | 164.94701986755 | 89 | 2 | 59 | 0 | 63 | 151 | 9626 | 9714 | PREDICTED: Panthera onca BTB domain containing 3 (BTBD3), transcript variant X1, mRNA | blastn | 24907 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Panthera | Panthera onca | |
| 12776574 | 12776574 | PRJEB25583_P_NODE_5351_length_178_cov_1.680851_g5174_i0 | PRJEB25583 | 5351 | 178 | 1.680851 | 2.99191478 | Mus musculus | 10090 | Chordata | Chordata | 279 | 6.35e-71 | NTclustered | gi|2904935163|gb|PQ738086.1| | 10090 | g5174 | i0 | 94.972 | 70.7078651685393 | 179 | 8 | 100 | 1 | 1 | 178 | 633 | 811 | Mus musculus lncRNA, complete sequence | blastn | 12586 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 16289147 | 16289147 | PRJEB25583_P_NODE_5753_length_173_cov_1.139706_g5576_i0 | PRJEB25583 | 5753 | 173 | 1.139706 | 1.97169138 | Phasianidae | 9005 | Chordata | Chordata | 285 | 1.32e-72 | NTclustered | gi|2919603018|emb|OZ238772.1| | 9079 | g5576 | i0 | 97.059 | 1.98265895953757 | 170 | 4 | 98 | 1 | 4 | 173 | 13270521 | 13270353 | Alectoris rufa genome assembly, chromosome: 7 | blastn | 343 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 17874575 | 17874575 | PRJEB25583_P_NODE_1995_length_297_cov_1.565385_g1818_i0 | PRJEB25583 | 1995 | 297 | 1.565385 | 4.64919345 | Sus scrofa | 9823 | Chordata | Chordata | 279 | 1.16e-70 | NTclustered | gi|225543075|emb|CU468696.15| | 9823 | g1818 | i0 | 88.066 | 143.946127946128 | 243 | 19 | 79 | 5 | 64 | 297 | 8855 | 9096 | Pig DNA sequence from clone CH242-204N7 on chromosome X, complete sequence | blastn | 42752 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 17874606 | 17874606 | PRJEB25583_P_NODE_6115_length_168_cov_2.801527_g5938_i0 | PRJEB25583 | 6115 | 168 | 2.801527 | 4.70656536 | Mus musculus | 10090 | Chordata | Chordata | 89.8 | 1.08e-13 | NTclustered | gi|2904935057|gb|PQ737980.1| | 10090 | g5938 | i0 | 87.342 | 17.6071428571429 | 79 | 9 | 47 | 1 | 90 | 168 | 384 | 307 | Mus musculus lncRNA390 lncRNA, complete sequence | blastn | 2958 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 22663419 | 22663419 | PRJEB25583_P_NODE_7298_length_158_cov_0.925620_g7121_i0 | PRJEB25583 | 7298 | 158 | 0.92562 | 1.4624796 | Opisthokonta | 33154 | Chordata | Chordata | 292 | 7.07e-75 | NTclustered | gi|74203961|dbj|AK149617.1| | 10090 | g7121 | i0 | 100 | 2 | 158 | 0 | 100 | 0 | 1 | 158 | 1408 | 1565 | Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:G530002K15 product:unclassifiable, full insert sequence | blastn | 316 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 22974980 | 22974980 | PRJEB25583_P_NODE_7219_length_158_cov_1.760331_g7042_i0 | PRJEB25583 | 7219 | 158 | 1.760331 | 2.78132298 | Sus scrofa | 9823 | Chordata | Chordata | 87.9 | 3.58e-13 | NTclustered | gi|299507935|emb|CU928840.6| | 9823 | g7042 | i0 | 85.542 | 1.36708860759494 | 83 | 12 | 53 | 0 | 59 | 141 | 10831 | 10749 | Pig DNA sequence from clone CH242-486G13 on chromosome X, complete sequence | blastn | 216 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 24248821 | 24248821 | PRJEB25583_P_NODE_4760_length_188_cov_1.390728_g4583_i0 | PRJEB25583 | 4760 | 188 | 1.390728 | 2.61456864 | Sus scrofa | 9823 | Chordata | Chordata | 126 | 9.36e-25 | NTclustered | gi|294988734|gb|GU983681.1| | 9823 | g4583 | i0 | 80.814 | 1.82978723404255 | 172 | 23 | 90 | 3 | 1 | 169 | 1646 | 1810 | Sus scrofa mucin 4 transcript variant 4 (MUC4) gene, complete cds, alternatively spliced | blastn | 344 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 25212553 | 25212553 | PRJEB25583_P_NODE_5740_length_173_cov_1.411765_g5563_i0 | PRJEB25583 | 5740 | 173 | 1.411765 | 2.44235345 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.001 | NTclustered | gi|2911451938|emb|OZ223580.1| | 8472 | g5563 | i0 | 100 | 129.277456647399 | 30 | 0 | 17 | 0 | 101 | 130 | 23254435 | 23254464 | Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 22 | blastn | 22365 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Lepidochelys | Lepidochelys kempii |
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);;