contig_metadata
13 rows where bioproject = "PRJNA971676", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11470192 | 11470192 | PRJNA971676_P_NODE_10789_length_279_cov_1.014563_g10700_i0 | PRJNA971676 | 10789 | 279 | 1.014563 | 2.83063077 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 163 | 7.36e-50 | NR | XP_065826293.1 | 121494 | g10700 | i0 | 82 | 7.65591397849462 | 89 | 16 | 95.7 | 0 | 2 | 268 | 42 | 130 | XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] | diamond | 2136 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 17522680 | 17522680 | PRJNA971676_P_NODE_18134_length_247_cov_0.885057_g18045_i0 | PRJNA971676 | 18134 | 247 | 0.885057 | 2.18609079 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2719019795|ref|XM_064543558.1| | 6063 | g18045 | i0 | 100 | 0.226720647773279 | 28 | 0 | 11 | 0 | 213 | 240 | 67 | 94 | PREDICTED: Halichondria panicea NACHT, LRR and PYD domains-containing protein 5-like (LOC135346072), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 26842557 | 26842557 | PRJNA971676_P_NODE_8601_length_304_cov_0.982684_g8512_i0 | PRJNA971676 | 8601 | 304 | 0.982684 | 2.98735936 | Porifera | 6040 | Porifera | other_Eukaryota | 111 | 1.23e-26 | NR | XP_003386149.1 | 400682 | g8512 | i0 | 65.8 | 4.3125 | 73 | 25 | 72 | 0 | 3 | 221 | 313 | 385 | XP_003386149.1 PREDICTED: S-adenosylmethionine synthase-like [Amphimedon queenslandica] | diamond | 1311 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 27632577 | 27632577 | PRJNA971676_P_NODE_784_length_807_cov_2.106267_g709_i0 | PRJNA971676 | 784 | 807 | 2.106267 | 16.99757469 | Metazoa | 33208 | Porifera | other_Eukaryota | 321 | 1.01e-101 | NR | XP_065177937.1 | 27933 | g709 | i0 | 61.1 | 49.5390334572491 | 270 | 91 | 99.6 | 3 | 806 | 3 | 372 | 629 | XP_065177937.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 1-like [Sycon ciliatum] | diamond | 39978 | 323 | 0.993808049535604 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27759141 | 27759141 | PRJNA971676_P_NODE_20604_length_244_cov_0.900585_g20515_i0 | PRJNA971676 | 20604 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 2.5000000000000002e-22 | NR | XP_064398470.1 | 6063 | g20515 | i0 | 60.8 | 7.77049180327869 | 79 | 31 | 97.1 | 0 | 243 | 7 | 315 | 393 | XP_064398470.1 isoleucine--tRNA ligase, cytoplasmic-like [Halichondria panicea] | diamond | 1896 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28605082 | 28605082 | PRJNA971676_P_NODE_9227_length_295_cov_1.387387_g9138_i0 | PRJNA971676 | 9227 | 295 | 1.387387 | 4.09279165 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 102 | 6.389999999999999e-23 | NR | XP_065192050.1 | 27933 | g9138 | i0 | 55.8 | 0.966101694915254 | 95 | 42 | 96.6 | 0 | 293 | 9 | 326 | 420 | XP_065192050.1 tripeptidyl-peptidase 1-like [Sycon ciliatum] | diamond | 285 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 28699937 | 28699937 | PRJNA971676_P_NODE_10487_length_282_cov_1.105263_g10398_i0 | PRJNA971676 | 10487 | 282 | 1.105263 | 3.11684166 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 47.8 | 0.00105 | NR | KAI6660993.1 | 111878 | g10398 | i0 | 65.6 | 0.340425531914894 | 32 | 11 | 34 | 0 | 20 | 115 | 1141 | 1172 | KAI6660993.1 Transient receptor potential cation channel [Oopsacas minuta] | diamond | 96 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 28857514 | 28857514 | PRJNA971676_P_NODE_1868_length_554_cov_2.241164_g1780_i0 | PRJNA971676 | 1868 | 554 | 2.241164 | 12.41604856 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 95.9 | 3.01e-19 | NR | XP_065890435.1 | 196820 | g1780 | i0 | 38.9 | 1.57039711191336 | 144 | 86 | 76.9 | 1 | 439 | 14 | 531 | 674 | XP_065890435.1 filamin-B-like [Dysidea avara] | diamond | 870 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29520653 | 29520653 | PRJNA971676_P_NODE_2350_length_499_cov_1.802817_g2261_i0 | PRJNA971676 | 2350 | 499 | 1.802817 | 8.99605683 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 75.9 | 1.72e-12 | NR | XP_065898084.1 | 196820 | g2261 | i0 | 36.6 | 0.739478957915832 | 123 | 72 | 72.7 | 4 | 135 | 497 | 2165 | 2283 | XP_065898084.1 uncharacterized protein [Dysidea avara] | diamond | 369 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30752718 | 30752718 | PRJNA971676_P_NODE_12234_length_265_cov_1.494792_g12145_i0 | PRJNA971676 | 12234 | 265 | 1.494792 | 3.9611988 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 96.7 | 4.319999999999999e-23 | NR | XP_065175085.1 | 27933 | g12145 | i0 | 62.5 | 2.56981132075472 | 80 | 29 | 90.6 | 1 | 240 | 1 | 17 | 95 | XP_065175085.1 small ribosomal subunit protein uS9-like [Sycon ciliatum] | diamond | 681 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31897114 | 31897114 | PRJNA971676_P_NODE_21557_length_243_cov_0.905882_g21468_i0 | PRJNA971676 | 21557 | 243 | 0.905882 | 2.20129326 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.8 | 0.00302 | NR | XP_064404833.1 | 6063 | g21468 | i0 | 56.4 | 2.46913580246914 | 39 | 17 | 48.1 | 0 | 112 | 228 | 373 | 411 | XP_064404833.1 alkylated DNA repair protein alkB homolog 8-like [Halichondria panicea] | diamond | 600 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32365713 | 32365713 | PRJNA971676_P_NODE_4199_length_394_cov_2.853583_g4110_i0 | PRJNA971676 | 4199 | 394 | 2.853583 | 11.24311702 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 188 | 6.35e-59 | NR | XP_065826293.1 | 121494 | g4110 | i0 | 74.4 | 9.6243654822335 | 125 | 32 | 95.2 | 0 | 376 | 2 | 1 | 125 | XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] | diamond | 3792 | 188 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 32403470 | 32403470 | PRJNA971676_P_NODE_5039_length_368_cov_2.203390_g4950_i0 | PRJNA971676 | 5039 | 368 | 2.20339 | 8.1084752 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 186 | 1.37e-52 | NR | XP_065177937.1 | 27933 | g4950 | i0 | 73.8 | 18.8967391304348 | 122 | 32 | 99.5 | 0 | 366 | 1 | 357 | 478 | XP_065177937.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 1-like [Sycon ciliatum] | diamond | 6954 | 187 | 0.994652406417112 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum |
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);;