contig_metadata
19 rows where bioproject = "PRJNA397736", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4239195 | 4239195 | PRJNA397736_S_NODE_2684_length_162_cov_1.669173_g2648_i0 | PRJNA397736 | 2684 | 162 | 1.669173 | 2.70406026 | Sus scrofa | 9823 | Chordata | Chordata | 278 | 2.04e-70 | NTclustered | gi|165931778|emb|AM932505.1| | 9823 | g2648 | i0 | 98.113 | 67.7901234567901 | 159 | 3 | 100 | 0 | 1 | 159 | 279 | 437 | Sus scrofa centromeric satellite repeat, clone Pg3 | blastn | 10982 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 10616033 | 10616033 | PRJNA397736_S_NODE_29_length_1461_cov_21.652235_g24_i0 | PRJNA397736 | 29 | 1461 | 21.652235 | 316.33915335 | root | 1 | Root_unresolved | Root_unresolved | 659 | 2.229999999999999e-233 | NR | AAI35234.1 | 8364 | g24 | i0 | 67.6 | 343.047227926078 | 478 | 154 | 98.2 | 1 | 28 | 1461 | 8 | 484 | AAI35234.1 hsp70 protein, partial [Xenopus tropicalis] | diamond | 501192 | 665 | 0.990977443609023 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 11890937 | 11890937 | PRJNA397736_S_NODE_1330_length_243_cov_5.934579_g1294_i0 | PRJNA397736 | 1330 | 243 | 5.934579 | 14.42102697 | Latimeria chalumnae | 7897 | Chordata | Chordata | 54.7 | 0.006 | NTclustered | gi|2721749050|ref|XM_005986866.2| | 7897 | g1294 | i0 | 100 | 0.119341563786008 | 29 | 0 | 12 | 0 | 75 | 103 | 2346 | 2374 | PREDICTED: Latimeria chalumnae frizzled-9 (LOC102349865), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 14441046 | 14441046 | PRJNA397736_S_NODE_2052_length_189_cov_5.162500_g2016_i0 | PRJNA397736 | 2052 | 189 | 5.1625 | 9.757125 | Sus scrofa | 9823 | Chordata | Chordata | 263 | 6.879999999999999e-66 | NTclustered | gi|2103|emb|X16513.1| | 9823 | g2016 | i0 | 93.258 | 41.3333333333333 | 178 | 12 | 100 | 0 | 11 | 188 | 417 | 240 | Pig gender-neutral repetitive DNA | blastn | 7812 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 27092128 | 27092128 | PRJNA397736_S_NODE_1162_length_264_cov_5.451064_g1126_i0 | PRJNA397736 | 1162 | 264 | 5.451064 | 14.39080896 | root | 1 | Root_unresolved | Root_unresolved | 174 | 3.73e-53 | NR | XP_037755641.2 | 8469 | g1126 | i0 | 98.9 | 23.6136363636364 | 87 | 1 | 98.9 | 0 | 262 | 2 | 57 | 143 | XP_037755641.2 40S ribosomal protein S13 [Chelonia mydas] | diamond | 6234 | 175 | 0.994285714285714 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Chelonia | Chelonia mydas | ||
| 27440067 | 27440067 | PRJNA397736_S_NODE_1283_length_248_cov_3.876712_g1247_i0 | PRJNA397736 | 1283 | 248 | 3.876712 | 9.61424576 | Cervidae | 9850 | Chordata | Chordata | 155 | 8.62e-44 | NR | OWK11568.1 | 46360 | g1247 | i0 | 81.9 | 2.2741935483871 | 94 | 5 | 99.2 | 1 | 246 | 1 | 47 | 140 | OWK11568.1 hypothetical protein Celaphus_00003504 [Cervus elaphus hippelaphus] | diamond | 564 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus elaphus | |
| 27724308 | 27724308 | PRJNA397736_S_NODE_344_length_507_cov_37.933054_g311_i0 | PRJNA397736 | 344 | 507 | 37.933054 | 192.32058378 | Ichthyophis | 8452 | Chordata | Chordata | 238 | 1.22e-76 | NR | AJT34968.1 | 8453 | g311 | i0 | 93.9 | 524.07100591716 | 132 | 8 | 78.1 | 0 | 398 | 3 | 89 | 220 | AJT34968.1 cytochrome oxidase subunit 1, partial [Ichthyophis bannanicus] | diamond | 265704 | 240 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Ichthyophiidae | Ichthyophis | Ichthyophis bannanicus | |
| 28292112 | 28292112 | PRJNA397736_S_NODE_1666_length_214_cov_15.362162_g1630_i0 | PRJNA397736 | 1666 | 214 | 15.362162 | 32.87502668 | Aves | 8782 | Chordata | Chordata | 129 | 2.9899999999999998e-34 | NR | XP_047929473.2 | 8845 | g1630 | i0 | 95.3 | 17.214953271028 | 64 | 3 | 89.7 | 0 | 23 | 214 | 122 | 185 | XP_047929473.2 small ribosomal subunit protein eS6 [Anser cygnoides] | diamond | 3684 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Anser | Anser cygnoides | |
| 28955571 | 28955571 | PRJNA397736_S_NODE_2128_length_186_cov_1.961783_g2092_i0 | PRJNA397736 | 2128 | 186 | 1.961783 | 3.64891638 | Chordata | 7711 | Chordata | Chordata | 125 | 3.48e-33 | NR | XP_038659826.1 | 7830 | g2092 | i0 | 96.7 | 64.9354838709677 | 61 | 2 | 98.4 | 0 | 3 | 185 | 227 | 287 | XP_038659826.1 ribosome biogenesis protein NSA2 homolog [Scyliorhinus canicula] | diamond | 12078 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 29776114 | 29776114 | PRJNA397736_S_NODE_2751_length_160_cov_2.641221_g2715_i0 | PRJNA397736 | 2751 | 160 | 2.641221 | 4.2259536 | Chordata | 7711 | Chordata | Chordata | 107 | 1.85e-25 | NR | XP_032821688.1 | 7757 | g2715 | i0 | 96.2 | 118.95 | 52 | 2 | 97.5 | 0 | 3 | 158 | 87 | 138 | XP_032821688.1 nucleolar GTP-binding protein 1 [Petromyzon marinus] | diamond | 19032 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 30738807 | 30738807 | PRJNA397736_S_NODE_794_length_322_cov_67.020478_g758_i0 | PRJNA397736 | 794 | 322 | 67.020478 | 215.80593916 | Naja naja | 35670 | Chordata | Chordata | 168 | 1.92e-46 | NR | KAG8137473.1 | 35670 | g758 | i0 | 96.6 | 63.2142857142857 | 87 | 3 | 81.1 | 0 | 261 | 1 | 551 | 637 | KAG8137473.1 hypothetical protein E2320_004718 [Naja naja] | diamond | 20355 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Naja | Naja naja | |
| 30976920 | 30976920 | PRJNA397736_S_NODE_2414_length_173_cov_6.361111_g2378_i0 | PRJNA397736 | 2414 | 173 | 6.361111 | 11.00472203 | Chordata | 7711 | Chordata | Chordata | 108 | 1.9000000000000003e-28 | NR | XP_043913022.1 | 7888 | g2378 | i0 | 98.2 | 92.2543352601156 | 56 | 1 | 97.1 | 0 | 172 | 5 | 15 | 70 | XP_043913022.1 TSC22 domain family protein 3 isoform X2 [Protopterus annectens] | diamond | 15960 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 31466042 | 31466042 | PRJNA397736_S_NODE_916_length_298_cov_7.368030_g880_i0 | PRJNA397736 | 916 | 298 | 7.36803 | 21.9567294 | Hypanus sabinus | 79690 | Chordata | Chordata | 198 | 2.05e-63 | NR | AAU29554.1 | 79690 | g880 | i0 | 98 | 55.2181208053691 | 98 | 2 | 98.7 | 0 | 296 | 3 | 34 | 131 | AAU29554.1 ribosomal protein L8, partial [Hypanus sabinus] | diamond | 16455 | 199 | 0.994974874371859 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 31497649 | 31497649 | PRJNA397736_S_NODE_976_length_289_cov_8.350000_g940_i0 | PRJNA397736 | 976 | 289 | 8.35 | 24.1315 | Pleurodeles waltl | 8319 | Chordata | Chordata | 157 | 6.42e-46 | NR | KAJ1217629.1 | 8319 | g940 | i0 | 98.8 | 45.9550173010381 | 82 | 1 | 85.1 | 0 | 2 | 247 | 171 | 252 | KAJ1217629.1 hypothetical protein NDU88_005222 [Pleurodeles waltl] | diamond | 13281 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 31546035 | 31546035 | PRJNA397736_S_NODE_1896_length_198_cov_6.668639_g1860_i0 | PRJNA397736 | 1896 | 198 | 6.668639 | 13.20390522 | root | 1 | Root_unresolved | Root_unresolved | 135 | 4.1e-38 | NR | XP_067886592.1 | 7792 | g1860 | i0 | 100 | 115 | 66 | 0 | 100 | 0 | 1 | 198 | 120 | 185 | XP_067886592.1 60S ribosomal protein L17 isoform X1 [Heterodontus francisci] | diamond | 22770 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Heterodontiformes | Heterodontidae | Heterodontus | Heterodontus francisci | |
| 31640681 | 31640681 | PRJNA397736_S_NODE_1156_length_265_cov_3.648305_g1120_i0 | PRJNA397736 | 1156 | 265 | 3.648305 | 9.66800825 | Pipidae | 8352 | Chordata | Chordata | 48.9 | 2.68e-4 | NR | KAE8584502.1 | 8364 | g1120 | i0 | 95.5 | 10.7094339622642 | 22 | 1 | 24.9 | 0 | 3 | 68 | 240 | 261 | KAE8584502.1 hypothetical protein XENTR_v10020993 [Xenopus tropicalis] | diamond | 2838 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 32020409 | 32020409 | PRJNA397736_S_NODE_3058_length_150_cov_5.173554_g3022_i0 | PRJNA397736 | 3058 | 150 | 5.173554 | 7.760331 | Mammalia | 40674 | Chordata | Chordata | 101 | 2.3e-26 | NR | XP_006750317.2 | 9713 | g3022 | i0 | 95.9 | 69.58 | 49 | 2 | 98 | 0 | 148 | 2 | 7 | 55 | XP_006750317.2 40S ribosomal protein S21-like [Leptonychotes weddellii] | diamond | 10437 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Leptonychotes | Leptonychotes weddellii | |
| 32400204 | 32400204 | PRJNA397736_S_NODE_919_length_298_cov_3.349442_g883_i0 | PRJNA397736 | 919 | 298 | 3.349442 | 9.98133716 | Mammalia | 40674 | Chordata | Chordata | 80.1 | 4.4e-15 | NR | XP_030890132.1 | 9713 | g883 | i0 | 78.4 | 2.62751677852349 | 51 | 9 | 51.3 | 1 | 153 | 1 | 198 | 246 | XP_030890132.1 palmitoyltransferase ZDHHC20 [Leptonychotes weddellii] | diamond | 783 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Leptonychotes | Leptonychotes weddellii | |
| 32589978 | 32589978 | PRJNA397736_S_NODE_2659_length_162_cov_7.037594_g2623_i0 | PRJNA397736 | 2659 | 162 | 7.037594 | 11.40090228 | Squamata | 8509 | Chordata | Chordata | 111 | 8.600000000000001e-30 | NR | AAZ38997.1 | 8668 | g2623 | i0 | 96.2 | 44.1666666666667 | 53 | 2 | 98.1 | 0 | 161 | 3 | 36 | 88 | AAZ38997.1 adenine nucleotide translocator, partial [Oxyuranus scutellatus] | diamond | 7155 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Oxyuranus | Oxyuranus scutellatus |
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);;