contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1072736" and tax_clade = "Opisthokonta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26710399 | 26710399 | PRJNA1072736_S_NODE_4761_length_178_cov_4.703704_g4756_i0 | PRJNA1072736 | 4761 | 178 | 4.703704 | 8.37259312 | root | 1 | Root_unresolved | Root_unresolved | 119 | 8.560000000000001e-33 | NR | AAR11853.1 | 10090 | g4756 | i0 | 98.3 | 15.8932584269663 | 59 | 1 | 99.4 | 0 | 2 | 178 | 77 | 135 | AAR11853.1 reverse transcriptase, partial [Mus musculus] | diamond | 2829 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27320335 | 27320335 | PRJNA1072736_S_NODE_6223_length_162_cov_1.579832_g6218_i0 | PRJNA1072736 | 6223 | 162 | 1.579832 | 2.55932784 | Ovis ammon polii x Ovis aries | 2918886 | Chordata | Chordata | 69.7 | 8.77e-13 | NR | KAI4586444.1 | 2918886 | g6218 | i0 | 84.6 | 0.722222222222222 | 39 | 6 | 72.2 | 0 | 128 | 12 | 139 | 177 | KAI4586444.1 hypothetical protein MJG53_004231 [Ovis ammon polii x Ovis aries] | diamond | 117 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon polii x Ovis aries | |
| 28077987 | 28077987 | PRJNA1072736_S_NODE_2365_length_228_cov_15.772973_g2360_i0 | PRJNA1072736 | 2365 | 228 | 15.772973 | 35.96237844 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.5 | 0.0159 | NR | XP_067660915.1 | 109174 | g2360 | i0 | 36.5 | 2.48684210526316 | 63 | 34 | 81.6 | 2 | 193 | 8 | 144 | 201 | XP_067660915.1 uncharacterized protein [Haliotis asinina] | diamond | 567 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 28164405 | 28164405 | PRJNA1072736_S_NODE_3765_length_194_cov_1.556291_g3760_i0 | PRJNA1072736 | 3765 | 194 | 1.556291 | 3.01920454 | root | 1 | Root_unresolved | Root_unresolved | 129 | 7.98e-33 | NR | AAA39757.1 | 10090 | g3760 | i0 | 98.4 | 29.6907216494845 | 64 | 1 | 99 | 0 | 193 | 2 | 5 | 68 | AAA39757.1 pol protein, partial [Mus musculus] | diamond | 5760 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 28741131 | 28741131 | PRJNA1072736_S_NODE_5867_length_166_cov_1.317073_g5862_i0 | PRJNA1072736 | 5867 | 166 | 1.317073 | 2.18634118 | Phyllostomus discolor | 89673 | Chordata | Chordata | 41.6 | 0.0302 | NR | KAF6084349.1 | 89673 | g5862 | i0 | 64 | 0.451807228915663 | 25 | 9 | 45.2 | 0 | 120 | 46 | 17 | 41 | KAF6084349.1 hypothetical protein HJG60_008620 [Phyllostomus discolor] | diamond | 75 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 28890427 | 28890427 | PRJNA1072736_S_NODE_3488_length_199_cov_1.717949_g3483_i0 | PRJNA1072736 | 3488 | 199 | 1.717949 | 3.41871851 | Metazoa | 33208 | Mollusca | Mollusca | 60.1 | 1.53e-8 | NR | XP_046346306.1 | 6454 | g3483 | i0 | 100 | 32.713567839196 | 31 | 0 | 46.7 | 0 | 3 | 95 | 491 | 521 | XP_046346306.1 T-complex protein 1 subunit beta-like [Haliotis rufescens] | diamond | 6510 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 29206494 | 29206494 | PRJNA1072736_S_NODE_4289_length_185_cov_3.612676_g4284_i0 | PRJNA1072736 | 4289 | 185 | 3.612676 | 6.6834506 | Cladistia | 1338366 | Chordata | Chordata | 44.7 | 0.00368 | NR | XP_043941443.1 | 7888 | g4284 | i0 | 95 | 31.7837837837838 | 20 | 1 | 32.4 | 0 | 124 | 183 | 1756 | 1775 | XP_043941443.1 ubiquitin carboxyl-terminal hydrolase 24 [Protopterus annectens] | diamond | 5880 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 29206495 | 29206495 | PRJNA1072736_S_NODE_6029_length_164_cov_1.677686_g6024_i0 | PRJNA1072736 | 6029 | 164 | 1.677686 | 2.75140504 | root | 1 | Root_unresolved | Root_unresolved | 55.5 | 4.02e-7 | NR | KAI5938739.1 | 9974 | g6024 | i0 | 64.1 | 17.1585365853659 | 39 | 14 | 71.3 | 0 | 135 | 19 | 221 | 259 | KAI5938739.1 LINE-1 retrotransposable element ORF2 protein [Manis javanica] | diamond | 2814 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis javanica | |
| 29964205 | 29964205 | PRJNA1072736_S_NODE_7591_length_151_cov_0.870370_g7586_i0 | PRJNA1072736 | 7591 | 151 | 0.87037 | 1.3142587 | Chordata | 7711 | Chordata | Chordata | 48.9 | 5.99e-5 | NR | KAI8522083.1 | 7741 | g7586 | i0 | 53.7 | 21.9735099337748 | 41 | 18 | 79.5 | 1 | 32 | 151 | 28 | 68 | KAI8522083.1 hypothetical protein Bbelb_018370 [Branchiostoma belcheri] | diamond | 3318 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 30130226 | 30130226 | PRJNA1072736_S_NODE_6052_length_164_cov_1.165289_g6047_i0 | PRJNA1072736 | 6052 | 164 | 1.165289 | 1.91107396 | Muntiacus reevesi | 9886 | Chordata | Chordata | 55.5 | 2.69e-7 | NR | KAB0387345.1 | 9886 | g6047 | i0 | 51.2 | 0.75 | 41 | 20 | 75 | 0 | 164 | 42 | 192 | 232 | KAB0387345.1 hypothetical protein FD755_002301, partial [Muntiacus reevesi] | diamond | 123 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 32153859 | 32153859 | PRJNA1072736_S_NODE_2178_length_236_cov_1.564767_g2173_i0 | PRJNA1072736 | 2178 | 236 | 1.564767 | 3.69285012 | Extremus antarcticus | 702011 | Fungi | Fungi | 162 | 3.77e-49 | NR | KAK3052181.1 | 702011 | g2173 | i0 | 92.3 | 1.98305084745763 | 78 | 6 | 99.2 | 0 | 234 | 1 | 70 | 147 | KAK3052181.1 Mitochondrial matrix iron chaperone [Extremus antarcticus] | diamond | 468 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Extremus | Extremus antarcticus | |
| 32785419 | 32785419 | PRJNA1072736_S_NODE_7580_length_151_cov_0.870370_g7575_i0 | PRJNA1072736 | 7580 | 151 | 0.87037 | 1.3142587 | Mirounga angustirostris | 9716 | Chordata | Chordata | 77.4 | 5.84e-15 | NR | XP_064441285.1 | 9716 | g7575 | i0 | 68.9 | 0.894039735099338 | 45 | 14 | 89.4 | 0 | 14 | 148 | 85 | 129 | XP_064441285.1 F-box-like/WD repeat-containing protein TBL1XR1 isoform X2 [Mirounga angustirostris] | diamond | 135 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Mirounga | Mirounga angustirostris |
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);;