contig_metadata
10 rows where bioproject = "PRJNA177642", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5468766 | 5468766 | PRJNA177642_P_NODE_14205_length_218_cov_2.724868_g12980_i0 | PRJNA177642 | 14205 | 218 | 2.724868 | 5.94021224 | Charadrius vociferus | 50402 | Chordata | Chordata | 375 | 1.0099999999999998e-99 | NTclustered | gi|699667904|ref|XM_009885697.1| | 50402 | g12980 | i0 | 97.706 | 35.848623853211 | 218 | 5 | 100 | 0 | 1 | 218 | 262 | 45 | PREDICTED: Charadrius vociferus uncharacterized LOC104287046 (LOC104287046), partial mRNA | blastn | 7815 | 375 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Charadriidae | Charadrius | Charadrius vociferus | |
| 9293555 | 9293555 | PRJNA177642_P_NODE_16668_length_170_cov_2.886525_g15443_i0 | PRJNA177642 | 16668 | 170 | 2.886525 | 4.9070925 | Gallus gallus | 9031 | Chordata | Chordata | 305 | 9.88e-79 | NTclustered | gi|2201664513|ref|XM_040653867.2| | 9031 | g15443 | i0 | 99.405 | 12.5294117647059 | 168 | 1 | 99 | 0 | 2 | 169 | 275 | 108 | PREDICTED: Gallus gallus zinc finger protein 501-like (LOC121107770), mRNA | blastn | 2130 | 305 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 11844045 | 11844045 | PRJNA177642_P_NODE_16930_length_169_cov_1.128571_g15705_i0 | PRJNA177642 | 16930 | 169 | 1.128571 | 1.90728499 | Sus scrofa | 9823 | Chordata | Chordata | 219 | 1.3099999999999999e-52 | NTclustered | gi|165931778|emb|AM932505.1| | 9823 | g15705 | i0 | 90 | 21.112426035503 | 170 | 15 | 100 | 2 | 1 | 169 | 62 | 230 | Sus scrofa centromeric satellite repeat, clone Pg3 | blastn | 3568 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 11844058 | 11844058 | PRJNA177642_P_NODE_17530_length_166_cov_1.810219_g16305_i0 | PRJNA177642 | 17530 | 166 | 1.810219 | 3.00496354 | Charadrius vociferus | 50402 | Chordata | Chordata | 265 | 1.64e-66 | NTclustered | gi|699695430|ref|XM_009891680.1| | 50402 | g16305 | i0 | 95.758 | 6.8855421686747 | 165 | 6 | 99 | 1 | 1 | 164 | 998 | 1162 | PREDICTED: Charadrius vociferus uncharacterized LOC104292323 (LOC104292323), partial mRNA | blastn | 1143 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Charadriidae | Charadrius | Charadrius vociferus | |
| 13119196 | 13119196 | PRJNA177642_P_NODE_13011_length_283_cov_1.122047_g11786_i0 | PRJNA177642 | 13011 | 283 | 1.122047 | 3.17539301 | Charadrius vociferus | 50402 | Chordata | Chordata | 444 | 3.69e-120 | NTclustered | gi|699656164|ref|XM_009883139.1| | 50402 | g11786 | i0 | 95.053 | 25.8268551236749 | 283 | 13 | 99 | 1 | 2 | 283 | 1806 | 2088 | PREDICTED: Charadrius vociferus uncharacterized LOC104284769 (LOC104284769), mRNA | blastn | 7309 | 444 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Charadriidae | Charadrius | Charadrius vociferus | |
| 16357532 | 16357532 | PRJNA177642_P_NODE_16973_length_169_cov_1.028571_g15748_i0 | PRJNA177642 | 16973 | 169 | 1.028571 | 1.73828499 | Bubalus | 9918 | Chordata | Chordata | 313 | 5.859999999999999e-81 | NTclustered | gi|1904695191|gb|MT942706.1| | 89462 | g15748 | i0 | 100 | 100 | 169 | 0 | 100 | 0 | 1 | 169 | 13420 | 13588 | Bubalus bubalis isolate H18 mitochondrion, complete genome | blastn | 16900 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bubalus | Bubalus bubalis | |
| 26775415 | 26775415 | PRJNA177642_P_NODE_17901_length_165_cov_1.058824_g16676_i0 | PRJNA177642 | 17901 | 165 | 1.058824 | 1.7470596 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0094 | NR | CAB3266990.1 | 59560 | g16676 | i0 | 41.5 | 4.74545454545455 | 53 | 29 | 92.7 | 1 | 6 | 158 | 395 | 447 | CAB3266990.1 reverse transcriptase [Phallusia mammillata] | diamond | 783 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 30186409 | 30186409 | PRJNA177642_P_NODE_11312_length_328_cov_1.307692_g10087_i0 | PRJNA177642 | 11312 | 328 | 1.307692 | 4.28922976 | Xenopus | 8353 | Chordata | Chordata | 47 | 0.00328 | NR | XP_018102548.1 | 8355 | g10087 | i0 | 55.9 | 1.55487804878049 | 34 | 15 | 31.1 | 0 | 2 | 103 | 386 | 419 | XP_018102548.1 neuronal PAS domain-containing protein 2 isoform X1 [Xenopus laevis] | diamond | 510 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 31717428 | 31717428 | PRJNA177642_P_NODE_14657_length_205_cov_1.227273_g13432_i0 | PRJNA177642 | 14657 | 205 | 1.227273 | 2.51590965 | Bombina bombina | 8345 | Chordata | Chordata | 74.7 | 1.25e-13 | NR | XP_053571558.1 | 8345 | g13432 | i0 | 62.9 | 1.81463414634146 | 62 | 23 | 90.7 | 0 | 193 | 8 | 802 | 863 | XP_053571558.1 uncharacterized protein LOC128661312 [Bombina bombina] | diamond | 372 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 31717431 | 31717431 | PRJNA177642_P_NODE_16617_length_171_cov_1.014085_g15392_i0 | PRJNA177642 | 16617 | 171 | 1.014085 | 1.73408535 | Callorhinchus milii | 7868 | Chordata | Chordata | 62.8 | 1.18e-9 | NR | XP_042201711.1 | 7868 | g15392 | i0 | 56.9 | 5.07017543859649 | 58 | 20 | 94.7 | 2 | 3 | 164 | 564 | 620 | XP_042201711.1 LOW QUALITY PROTEIN: uncharacterized protein LOC121851711, partial [Callorhinchus milii] | diamond | 867 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii |
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);;