contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1129273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1031656 | 1031656 | PRJNA1129273_P_NODE_4961_length_320_cov_1.789474_g4681_i0 | PRJNA1129273 | 4961 | 320 | 1.789474 | 5.7263168 | Cricetidae | 337677 | Chordata | Chordata | 52.8 | 0.03 | NTclustered | gi|2246065583|ref|XM_048442227.1| | 447135 | g4681 | i0 | 96.875 | 0.6 | 32 | 0 | 10 | 1 | 54 | 85 | 731 | 701 | PREDICTED: Myodes glareolus bile acid receptor-like (LOC125405635), transcript variant X2, mRNA | blastn | 192 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Myodes | Myodes glareolus | |
| 11761901 | 11761901 | PRJNA1129273_P_NODE_9230_length_248_cov_1.320000_g8950_i0 | PRJNA1129273 | 9230 | 248 | 1.32 | 3.2736 | Sciurus carolinensis | 30640 | Chordata | Chordata | 52.8 | 0.022 | NTclustered | gi|2219436147|ref|XM_047533143.1| | 30640 | g8950 | i0 | 100 | 0.338709677419355 | 28 | 0 | 11 | 0 | 219 | 246 | 2914 | 2941 | PREDICTED: Sciurus carolinensis sorting nexin 8 (Snx8), transcript variant X3, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Sciurus | Sciurus carolinensis | |
| 17609353 | 17609353 | PRJNA1129273_P_NODE_8674_length_251_cov_0.876404_g8394_i0 | PRJNA1129273 | 8674 | 251 | 0.876404 | 2.19977404 | Bovidae | 9895 | Chordata | Chordata | 213 | 9.86e-51 | NTclustered | gi|1068294018|gb|KX592814.1| | 9913 | g8394 | i0 | 89.881 | 91.6135458167331 | 168 | 13 | 68 | 4 | 86 | 251 | 10869026 | 10869191 | Bos taurus isolate Dominette_000065F genomic sequence | blastn | 22995 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 21433562 | 21433562 | PRJNA1129273_P_NODE_11097_length_228_cov_3.554839_g10817_i0 | PRJNA1129273 | 11097 | 228 | 3.554839 | 8.10503292 | Artiodactyla | 91561 | Chordata | Chordata | 292 | 1.1e-74 | NTclustered | gi|2871639840|ref|XM_070463572.1| | 9874 | g10817 | i0 | 89.956 | 602.219298245614 | 229 | 19 | 99 | 2 | 3 | 227 | 2839 | 3067 | PREDICTED: Odocoileus virginianus Holliday junction recognition protein (HJURP), transcript variant X1, mRNA | blastn | 137306 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Odocoileus | Odocoileus virginianus | |
| 21960023 | 21960023 | PRJNA1129273_P_NODE_2738_length_459_cov_2.984456_g2460_i0 | PRJNA1129273 | 2738 | 459 | 2.984456 | 13.69865304 | Lampetra fluviatilis | 7748 | Chordata | Chordata | 52.8 | 0.045 | NTclustered | gi|2805736765|emb|OZ078441.1| | 7748 | g2460 | i0 | 100 | 0.0610021786492375 | 28 | 0 | 6 | 0 | 254 | 281 | 3545844 | 3545871 | Lampetra fluviatilis genome assembly, chromosome: 38 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 21960076 | 21960076 | PRJNA1129273_P_NODE_8918_length_250_cov_0.870056_g8638_i0 | PRJNA1129273 | 8918 | 250 | 0.870056 | 2.17514 | Mus musculus | 10090 | Chordata | Chordata | 460 | 3.17e-125 | NTclustered | gi|354786133|gb|JN950634.1| | 10090 | g8638 | i0 | 100 | 2.988 | 249 | 0 | 99 | 0 | 2 | 250 | 26788 | 26540 | Mus musculus targeted KO-first, conditional ready, lacZ-tagged mutant allele Casd1:tm1a(EUCOMM)Hmgu; transgenic | blastn | 747 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 23235584 | 23235584 | PRJNA1129273_P_NODE_4639_length_332_cov_1.347490_g4359_i0 | PRJNA1129273 | 4639 | 332 | 1.34749 | 4.4736668 | Tupaia chinensis | 246437 | Chordata | Chordata | 165 | 3.85e-36 | NTclustered | gi|1561705453|ref|XM_014584312.2| | 246437 | g4359 | i0 | 80.645 | 50.7981927710843 | 217 | 38 | 64 | 4 | 115 | 328 | 380 | 165 | PREDICTED: Tupaia chinensis 40S ribosomal protein S20 (LOC106733939), mRNA | blastn | 16865 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Scandentia | Tupaiidae | Tupaia | Tupaia chinensis | |
| 24509259 | 24509259 | PRJNA1129273_P_NODE_9180_length_248_cov_2.628571_g8900_i0 | PRJNA1129273 | 9180 | 248 | 2.628571 | 6.51885608 | Canis lupus | 9612 | Chordata | Chordata | 329 | 9.249999999999998e-86 | NTclustered | gi|2272530954|ref|XR_007409564.1| | 286419 | g8900 | i0 | 90.763 | 11.0645161290323 | 249 | 20 | 99 | 3 | 2 | 248 | 1568 | 1815 | PREDICTED: Canis lupus dingo uncharacterized LOC125754758 (LOC125754758), transcript variant X1, ncRNA | blastn | 2744 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus |
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);;