contig_metadata
7 rows where bioproject = "PRJNA306153", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2927031 | 2927031 | PRJNA306153_S_NODE_2283_length_165_cov_3.522059_g2270_i0 | PRJNA306153 | 2283 | 165 | 3.522059 | 5.81139735 | Metazoa | 33208 | Chordata | Chordata | 82 | 2.1e-18 | NR | XP_039271593.1 | 7725 | g2270 | i0 | 69.8 | 5.65454545454545 | 53 | 16 | 96.4 | 0 | 161 | 3 | 13 | 65 | XP_039271593.1 40S ribosomal protein S20-like [Styela clava] | diamond | 933 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 4203532 | 4203532 | PRJNA306153_S_NODE_1784_length_185_cov_4.365385_g1771_i0 | PRJNA306153 | 1784 | 185 | 4.365385 | 8.07596225 | Sus scrofa | 9823 | Chordata | Chordata | 207 | 3.19e-49 | NTclustered | gi|2103|emb|X16513.1| | 9823 | g1771 | i0 | 94.776 | 4.83783783783784 | 134 | 6 | 72 | 1 | 53 | 185 | 236 | 103 | Pig gender-neutral repetitive DNA | blastn | 895 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 8029613 | 8029613 | PRJNA306153_S_NODE_407_length_351_cov_6.068323_g394_i0 | PRJNA306153 | 407 | 351 | 6.068323 | 21.29981373 | Sus scrofa | 9823 | Chordata | Chordata | 440 | 6.059999999999999e-119 | NTclustered | gi|509046|emb|X70941.1| | 9823 | g394 | i0 | 92.013 | 54.2364672364672 | 313 | 25 | 100 | 0 | 36 | 348 | 1 | 313 | S.scrofa DNA for centromere specific motif | blastn | 19037 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 15679124 | 15679124 | PRJNA306153_S_NODE_2773_length_151_cov_2.319672_g2760_i0 | PRJNA306153 | 2773 | 151 | 2.319672 | 3.50270472 | Phacochoerus africanus | 41426 | Chordata | Chordata | 182 | 1.51e-41 | NTclustered | gi|2224989275|ref|XM_047766103.1| | 41426 | g2760 | i0 | 92.188 | 1.58278145695364 | 128 | 10 | 85 | 0 | 24 | 151 | 474 | 347 | PREDICTED: Phacochoerus africanus spidroin-1-like (LOC125119259), mRNA | blastn | 239 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Phacochoerus | Phacochoerus africanus | |
| 22052889 | 22052889 | PRJNA306153_S_NODE_2698_length_153_cov_3.145161_g2685_i0 | PRJNA306153 | 2698 | 153 | 3.145161 | 4.81209633 | Sus scrofa | 9823 | Chordata | Chordata | 278 | 1.9e-70 | NTclustered | gi|255697262|emb|FP104550.9| | 9823 | g2685 | i0 | 99.346 | 549.176470588235 | 153 | 1 | 100 | 0 | 1 | 153 | 144792 | 144944 | Pig DNA sequence from clone CH242-320P11 on chromosome X, complete sequence | blastn | 84024 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 22739050 | 22739050 | PRJNA306153_S_NODE_2358_length_162_cov_4.601504_g2345_i0 | PRJNA306153 | 2358 | 162 | 4.601504 | 7.45443648 | root | 1 | Root_unresolved | Root_unresolved | 300 | 4.36e-77 | NTclustered | gi|2904934840|gb|PQ737764.1| | 10090 | g2345 | i0 | 100 | 349.098765432099 | 162 | 0 | 100 | 0 | 1 | 162 | 308 | 469 | Mus musculus lncRNA174 lncRNA, complete sequence | blastn | 56554 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27439765 | 27439765 | PRJNA306153_S_NODE_2663_length_154_cov_3.208000_g2650_i0 | PRJNA306153 | 2663 | 154 | 3.208 | 4.94032 | Opisthokonta | 33154 | Chordata | Chordata | 45.1 | 0.00149 | NR | XP_069463138.1 | 8296 | g2650 | i0 | 87 | 4.03246753246753 | 23 | 3 | 44.8 | 0 | 3 | 71 | 217 | 239 | XP_069463138.1 large ribosomal subunit protein eL18 [Ambystoma mexicanum] | diamond | 621 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum |
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);;