contig_metadata
10 rows where bioproject = "PRJNA615175", tax_clade = "Opisthokonta" and tax_phylum = "Porifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 594760 | 594760 | PRJNA615175_P_NODE_12961_length_396_cov_2.331269_g12793_i0 | PRJNA615175 | 12961 | 396 | 2.331269 | 9.23182524 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|2664277667|ref|XR_009969595.1| | 121492 | g12793 | i0 | 96.97 | 0.0833333333333333 | 33 | 0 | 8 | 1 | 242 | 273 | 254 | 222 | PREDICTED: Corticium candelabrum uncharacterized LOC134178186 (LOC134178186), ncRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 1871232 | 1871232 | PRJNA615175_P_NODE_8542_length_510_cov_2.967963_g8374_i0 | PRJNA615175 | 8542 | 510 | 2.967963 | 15.1366113 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 156 | 3.0299999999999997e-45 | NR | XP_003388638.1 | 400682 | g8374 | i0 | 53.8 | 2.71176470588235 | 158 | 59 | 88.2 | 4 | 61 | 510 | 1 | 152 | XP_003388638.1 PREDICTED: 40S ribosomal protein S10-like [Amphimedon queenslandica] | diamond | 1383 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 12074460 | 12074460 | PRJNA615175_P_NODE_3670_length_811_cov_7.299458_g3520_i0 | PRJNA615175 | 3670 | 811 | 7.299458 | 59.19860438 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 268 | 2.78e-86 | NR | CAI8022810.1 | 519541 | g3520 | i0 | 55.8 | 3.59556103575832 | 242 | 106 | 89.1 | 1 | 62 | 784 | 26 | 267 | CAI8022810.1 60S ribosomal protein L7a [Geodia barretti] | diamond | 2916 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 20997181 | 20997181 | PRJNA615175_P_NODE_2217_length_1030_cov_1.801463_g2100_i0 | PRJNA615175 | 2217 | 1030 | 1.801463 | 18.5550689 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 208 | 6.1e-63 | NR | XP_065889818.1 | 196820 | g2100 | i0 | 52.9 | 5.97378640776699 | 204 | 71 | 59.4 | 4 | 694 | 83 | 4 | 182 | XP_065889818.1 phosphopantothenoylcysteine decarboxylase-like [Dysidea avara] | diamond | 6153 | 210 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 22271894 | 22271894 | PRJNA615175_P_NODE_11398_length_429_cov_1.514045_g11230_i0 | PRJNA615175 | 11398 | 429 | 1.514045 | 6.49525305 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 68.9 | 1.86e-10 | NR | XP_065898024.1 | 196820 | g11230 | i0 | 56.5 | 0.321678321678322 | 46 | 20 | 32.2 | 0 | 288 | 425 | 109 | 154 | XP_065898024.1 CXXC-type zinc finger protein 1-like [Dysidea avara] | diamond | 138 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 26795527 | 26795527 | PRJNA615175_P_NODE_31241_length_246_cov_2.225434_g31073_i0 | PRJNA615175 | 31241 | 246 | 2.225434 | 5.47456764 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 52 | 6.79e-6 | NR | XP_065916846.1 | 196820 | g31073 | i0 | 40.9 | 1.60975609756098 | 66 | 36 | 76.8 | 1 | 201 | 13 | 85 | 150 | XP_065916846.1 selenoprotein F-like [Dysidea avara] | diamond | 396 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 27080301 | 27080301 | PRJNA615175_P_NODE_1982_length_1082_cov_5.415263_g1868_i0 | PRJNA615175 | 1982 | 1082 | 5.415263 | 58.59314566 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 140 | 5.66e-34 | NR | XP_062502077.1 | 121492 | g1868 | i0 | 33 | 1.64972273567468 | 285 | 165 | 77.1 | 8 | 882 | 49 | 125 | 390 | XP_062502077.1 mitochondrial inner membrane protein OXA1L-like [Corticium candelabrum] | diamond | 1785 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 29543315 | 29543315 | PRJNA615175_P_NODE_1510_length_1212_cov_4.906936_g1414_i0 | PRJNA615175 | 1510 | 1212 | 4.906936 | 59.47206432 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 247 | 4.99e-71 | NR | XP_065831101.1 | 121494 | g1414 | i0 | 36.4 | 4.08415841584158 | 420 | 244 | 99.5 | 12 | 1207 | 2 | 256 | 670 | XP_065831101.1 uncharacterized protein [Oscarella lobularis] | diamond | 4950 | 247 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32369803 | 32369803 | PRJNA615175_P_NODE_3359_length_848_cov_5.263226_g3214_i0 | PRJNA615175 | 3359 | 848 | 5.263226 | 44.63215648 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 196 | 6.489999999999999e-54 | NR | CAI8029155.1 | 519541 | g3214 | i0 | 33.9 | 19.3160377358491 | 292 | 169 | 97.3 | 3 | 7 | 831 | 350 | 634 | CAI8029155.1 Tuftelin-interacting protein 11 [Geodia barretti] | diamond | 16380 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 32653645 | 32653645 | PRJNA615175_P_NODE_16280_length_349_cov_1.065217_g16112_i0 | PRJNA615175 | 16280 | 349 | 1.065217 | 3.71760733 | Metazoa | 33208 | Porifera | other_Eukaryota | 141 | 3.95e-38 | NR | XP_065897645.1 | 196820 | g16112 | i0 | 56 | 5.89684813753582 | 109 | 48 | 93.7 | 0 | 7 | 333 | 253 | 361 | XP_065897645.1 phytanoyl-CoA dioxygenase domain-containing protein 1 homolog [Dysidea avara] | diamond | 2058 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara |
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);;