contig_metadata
15 rows where bioproject = "PRJNA760976", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 742297 | 742297 | PRJNA760976_P_NODE_1041_length_1213_cov_1.301754_g866_i0 | PRJNA760976 | 1041 | 1213 | 1.301754 | 15.79027602 | Metazoa | 33208 | Porifera | other_Eukaryota | 446 | 3.359999999999999e-152 | NR | XP_064384573.1 | 6063 | g866 | i0 | 62.6 | 17.401483924155 | 369 | 136 | 91.3 | 2 | 1109 | 3 | 3 | 369 | XP_064384573.1 3-ketoacyl-CoA thiolase, mitochondrial-like [Halichondria panicea] | diamond | 21108 | 447 | 0.997762863534676 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 6309048 | 6309048 | PRJNA760976_P_NODE_185_length_2396_cov_39.044339_g141_i0 | PRJNA760976 | 185 | 2396 | 39.044339 | 935.50236244 | Mycale | 86015 | Porifera | other_Eukaryota | 176 | 1.41e-38 | NTclustered | gi|514227091|gb|KC961671.1| | 458504 | g141 | i0 | 83.333 | 8.98038397328881 | 198 | 25 | 8 | 6 | 734 | 928 | 289 | 97 | Mycale laxissima voucher UERJ4 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 21517 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Poecilosclerida | Mycalidae | Mycale | Mycale laxissima | |
| 8858136 | 8858136 | PRJNA760976_P_NODE_41147_length_268_cov_1.564103_g40826_i0 | PRJNA760976 | 41147 | 268 | 1.564103 | 4.19179604 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 147 | 1.6499999999999996e-41 | NR | Q4KTI3.1 | 55567 | g40826 | i0 | 78.7 | 103.611940298507 | 89 | 19 | 99.6 | 0 | 1 | 267 | 6 | 94 | Q4KTI3.1 RecName: Full=Large ribosomal subunit protein uL18; AltName: Full=60S ribosomal protein L5 [Suberites domuncula] | diamond | 27768 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 10946512 | 10946512 | PRJNA760976_P_NODE_52649_length_244_cov_1.350877_g52328_i0 | PRJNA760976 | 52649 | 244 | 1.350877 | 3.29613988 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 105 | 8.26e-25 | NR | XP_003383564.1 | 400682 | g52328 | i0 | 66.3 | 1.9672131147541 | 80 | 27 | 98.4 | 0 | 4 | 243 | 144 | 223 | XP_003383564.1 PREDICTED: 60S ribosomal protein L4-A-like [Amphimedon queenslandica] | diamond | 480 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 13496143 | 13496143 | PRJNA760976_P_NODE_38111_length_277_cov_1.102941_g37790_i0 | PRJNA760976 | 38111 | 277 | 1.102941 | 3.05514657 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 143 | 1.03e-39 | NR | XP_003388041.1 | 400682 | g37790 | i0 | 71.4 | 6.89891696750903 | 91 | 26 | 98.6 | 0 | 3 | 275 | 91 | 181 | XP_003388041.1 PREDICTED: inorganic pyrophosphatase-like [Amphimedon queenslandica] | diamond | 1911 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 14771210 | 14771210 | PRJNA760976_P_NODE_10832_length_436_cov_1.451791_g10513_i0 | PRJNA760976 | 10832 | 436 | 1.451791 | 6.32980876 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 206 | 1.94e-63 | NR | XP_064395651.1 | 6063 | g10513 | i0 | 70.3 | 9.95642201834862 | 145 | 39 | 99.8 | 1 | 436 | 2 | 26 | 166 | XP_064395651.1 large ribosomal subunit protein uL18 [Halichondria panicea] | diamond | 4341 | 207 | 0.995169082125604 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 22419732 | 22419732 | PRJNA760976_P_NODE_57598_length_231_cov_2.360759_g57277_i0 | PRJNA760976 | 57598 | 231 | 2.360759 | 5.45335329 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 89.4 | 1.37e-20 | NR | KAI6648847.1 | 111878 | g57277 | i0 | 56.8 | 5.77922077922078 | 74 | 32 | 96.1 | 0 | 10 | 231 | 59 | 132 | KAI6648847.1 hypothetical protein LOD99_7108 [Oopsacas minuta] | diamond | 1335 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 26873264 | 26873264 | PRJNA760976_P_NODE_27221_length_313_cov_1.562500_g26900_i0 | PRJNA760976 | 27221 | 313 | 1.5625 | 4.890625 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 60.8 | 3.31e-8 | NR | XP_062517397.1 | 121492 | g26900 | i0 | 32.9 | 1.61980830670927 | 85 | 56 | 81.5 | 1 | 255 | 1 | 122 | 205 | XP_062517397.1 arrestin domain-containing protein A-like [Corticium candelabrum] | diamond | 507 | 61.2 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27210963 | 27210963 | PRJNA760976_P_NODE_24322_length_326_cov_0.889328_g24001_i0 | PRJNA760976 | 24322 | 326 | 0.889328 | 2.89920928 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 50.8 | 1.45e-4 | NR | XP_062519574.1 | 121492 | g24001 | i0 | 35.4 | 1.38957055214724 | 79 | 49 | 71.8 | 2 | 318 | 85 | 831 | 908 | XP_062519574.1 uncharacterized protein LOC134194649 [Corticium candelabrum] | diamond | 453 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27337720 | 27337720 | PRJNA760976_P_NODE_3523_length_695_cov_1.980707_g3220_i0 | PRJNA760976 | 3523 | 695 | 1.980707 | 13.76591365 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 119 | 1.2299999999999998e-29 | NR | CAI8030757.1 | 519541 | g3220 | i0 | 50.4 | 0.60863309352518 | 141 | 55 | 57.8 | 6 | 409 | 8 | 18 | 150 | CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] | diamond | 423 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 27779806 | 27779806 | PRJNA760976_P_NODE_13244_length_403_cov_1.409091_g12924_i0 | PRJNA760976 | 13244 | 403 | 1.409091 | 5.67863673 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 71.2 | 2.43e-11 | NR | XP_065176714.1 | 27933 | g12924 | i0 | 31.1 | 0.982630272952854 | 132 | 88 | 96 | 2 | 1 | 387 | 566 | 697 | XP_065176714.1 uncharacterized protein LOC135806452 [Sycon ciliatum] | diamond | 396 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27779809 | 27779809 | PRJNA760976_P_NODE_42404_length_265_cov_1.390625_g42083_i0 | PRJNA760976 | 42404 | 265 | 1.390625 | 3.68515625 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 95.5 | 1.35e-20 | NR | XP_065193612.1 | 27933 | g42083 | i0 | 49.4 | 1.94716981132075 | 85 | 43 | 96.2 | 0 | 257 | 3 | 958 | 1042 | XP_065193612.1 uncharacterized protein LOC135824819 [Sycon ciliatum] | diamond | 516 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31728151 | 31728151 | PRJNA760976_P_NODE_28797_length_307_cov_1.264957_g28476_i0 | PRJNA760976 | 28797 | 307 | 1.264957 | 3.88341799 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 159 | 7.139999999999998e-48 | NR | XP_064390314.1 | 6063 | g28476 | i0 | 80.4 | 1.99348534201954 | 102 | 18 | 99.7 | 1 | 1 | 306 | 7 | 106 | XP_064390314.1 small ribosomal subunit protein eS17-like [Halichondria panicea] | diamond | 612 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 31728152 | 31728152 | PRJNA760976_P_NODE_30837_length_299_cov_1.898230_g30516_i0 | PRJNA760976 | 30837 | 299 | 1.89823 | 5.6757077 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 60.8 | 3.1e-8 | NR | CAI8057942.1 | 519541 | g30516 | i0 | 36.1 | 0.832775919732441 | 83 | 51 | 82.3 | 2 | 255 | 10 | 454 | 535 | CAI8057942.1 Filamin-B [Geodia barretti] | diamond | 249 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 32865764 | 32865764 | PRJNA760976_P_NODE_56960_length_241_cov_0.857143_g56639_i0 | PRJNA760976 | 56960 | 241 | 0.857143 | 2.06571463 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 63.9 | 1.19e-9 | NR | XP_065832396.1 | 121494 | g56639 | i0 | 45.7 | 0.871369294605809 | 70 | 31 | 87.1 | 2 | 216 | 7 | 90 | 152 | XP_065832396.1 carboxypeptidase A1-like [Oscarella lobularis] | diamond | 210 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis |
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);;