contig_metadata
21 rows where bioproject = "PRJNA235310", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1642195 | 1642195 | PRJNA235310_P_NODE_6082_length_163_cov_1.078947_g6056_i0 | PRJNA235310 | 6082 | 163 | 1.078947 | 1.75868361 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82 | 1.64e-17 | NR | XP_064382283.1 | 6063 | g6056 | i0 | 66 | 3.90184049079755 | 53 | 17 | 97.5 | 1 | 3 | 161 | 24 | 75 | XP_064382283.1 coiled-coil domain-containing protein 25-like [Halichondria panicea] | diamond | 636 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 2331904 | 2331904 | PRJNA235310_P_NODE_1962_length_282_cov_1.223176_g1936_i0 | PRJNA235310 | 1962 | 282 | 1.223176 | 3.44935632 | Demospongiae | 6042 | Porifera | other_Eukaryota | 104 | 4.13e-25 | NR | P57747.1 | 55567 | g1936 | i0 | 53.8 | 8.80851063829787 | 93 | 43 | 98.9 | 0 | 280 | 2 | 16 | 108 | P57747.1 RecName: Full=V-type proton ATPase subunit D; Short=V-ATPase subunit D; AltName: Full=Vacuolar proton pump subunit D [Suberites domuncula] | diamond | 2484 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 14396383 | 14396383 | PRJNA235310_P_NODE_1952_length_283_cov_1.273504_g1926_i0 | PRJNA235310 | 1952 | 283 | 1.273504 | 3.60401632 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 272 | 1.8399999999999999e-68 | NTclustered | gi|2732923973|ref|XM_065328925.1| | 27933 | g1926 | i0 | 89.401 | 78.6466431095406 | 217 | 21 | 76 | 2 | 68 | 283 | 465 | 250 | PREDICTED: Sycon ciliatum histone H3 (LOC135815608), mRNA | blastn | 22257 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 19493294 | 19493294 | PRJNA235310_P_NODE_176_length_758_cov_7.320169_g158_i0 | PRJNA235310 | 176 | 758 | 7.320169 | 55.48688102 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 271 | 7.179999999999998e-88 | NR | XP_062521049.1 | 121492 | g158 | i0 | 57.9 | 12.0554089709763 | 235 | 99 | 93 | 0 | 25 | 729 | 27 | 261 | XP_062521049.1 large ribosomal subunit protein uL30-like [Corticium candelabrum] | diamond | 9138 | 272 | 0.996323529411765 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27421867 | 27421867 | PRJNA235310_P_NODE_2543_length_242_cov_0.948187_g2517_i0 | PRJNA235310 | 2543 | 242 | 0.948187 | 2.29461254 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 94 | 3.45e-20 | NR | XP_065898859.1 | 196820 | g2517 | i0 | 56.6 | 4.00413223140496 | 83 | 33 | 99.2 | 1 | 2 | 241 | 360 | 442 | XP_065898859.1 circularly permutated Ras protein 1-like [Dysidea avara] | diamond | 969 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28242396 | 28242396 | PRJNA235310_P_NODE_2146_length_267_cov_1.426606_g2120_i0 | PRJNA235310 | 2146 | 267 | 1.426606 | 3.80903802 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 75.1 | 2.06e-13 | NR | KAI6652654.1 | 111878 | g2120 | i0 | 56.4 | 2.49438202247191 | 55 | 24 | 61.8 | 0 | 4 | 168 | 474 | 528 | KAI6652654.1 Non-specific lipid-transfer protein-like [Oopsacas minuta] | diamond | 666 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 28274010 | 28274010 | PRJNA235310_P_NODE_3366_length_207_cov_0.886076_g3340_i0 | PRJNA235310 | 3366 | 207 | 0.886076 | 1.83417732 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 95.1 | 8.25e-21 | NR | XP_064388772.1 | 6063 | g3340 | i0 | 73.5 | 2.95652173913043 | 68 | 18 | 98.6 | 0 | 2 | 205 | 663 | 730 | XP_064388772.1 aldehyde dehydrogenase family 16 member A1-like [Halichondria panicea] | diamond | 612 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28576009 | 28576009 | PRJNA235310_P_NODE_2627_length_236_cov_2.021390_g2601_i0 | PRJNA235310 | 2627 | 236 | 2.02139 | 4.7704804 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89.7 | 4.18e-20 | NR | XP_065175506.1 | 27933 | g2601 | i0 | 60.7 | 1.4364406779661 | 56 | 22 | 71.2 | 0 | 169 | 2 | 133 | 188 | XP_065175506.1 cysteine and glycine-rich protein 1-like [Sycon ciliatum] | diamond | 339 | 90.5 | 0.991160220994475 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 28873982 | 28873982 | PRJNA235310_P_NODE_1828_length_294_cov_0.987755_g1802_i0 | PRJNA235310 | 1828 | 294 | 0.987755 | 2.9039997 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 122 | 1e-29 | NR | KAI6649214.1 | 111878 | g1802 | i0 | 59.8 | 2.86734693877551 | 97 | 39 | 99 | 0 | 291 | 1 | 917 | 1013 | KAI6649214.1 Sarco/endoplasmic reticulum calcium ATPase isoform C [Oopsacas minuta] | diamond | 843 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 28873988 | 28873988 | PRJNA235310_P_NODE_5028_length_168_cov_1.310924_g5002_i0 | PRJNA235310 | 5028 | 168 | 1.310924 | 2.20235232 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 44.3 | 0.00182 | NR | XP_065844892.1 | 121494 | g5002 | i0 | 74.2 | 0.553571428571429 | 31 | 8 | 55.4 | 0 | 168 | 76 | 108 | 138 | XP_065844892.1 large ribosomal subunit protein eL32-like [Oscarella lobularis] | diamond | 93 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 29126907 | 29126907 | PRJNA235310_P_NODE_4989_length_168_cov_2.184874_g4963_i0 | PRJNA235310 | 4989 | 168 | 2.184874 | 3.67058832 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 50.8 | 1.84e-5 | NR | XP_065179152.1 | 27933 | g4963 | i0 | 52.6 | 3.42857142857143 | 38 | 18 | 67.9 | 0 | 167 | 54 | 533 | 570 | XP_065179152.1 cytochrome b-245 heavy chain-like [Sycon ciliatum] | diamond | 576 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29586123 | 29586123 | PRJNA235310_P_NODE_1630_length_315_cov_1.007519_g1604_i0 | PRJNA235310 | 1630 | 315 | 1.007519 | 3.17368485 | Porifera | 6040 | Porifera | other_Eukaryota | 110 | 9.4e-26 | NR | XP_065187505.1 | 27933 | g1604 | i0 | 47.1 | 3.8952380952381 | 104 | 54 | 98.1 | 1 | 5 | 313 | 30 | 133 | XP_065187505.1 neutral ceramidase-like [Sycon ciliatum] | diamond | 1227 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 29807328 | 29807328 | PRJNA235310_P_NODE_3111_length_215_cov_1.253012_g3085_i0 | PRJNA235310 | 3111 | 215 | 1.253012 | 2.6939758 | root | 1 | Root_unresolved | Root_unresolved | 113 | 1.29e-29 | NR | CAI8043642.1 | 519541 | g3085 | i0 | 71.8 | 10.8558139534884 | 71 | 20 | 99.1 | 0 | 213 | 1 | 36 | 106 | CAI8043642.1 NAD(P)H dehydrogenase (quinone) [Geodia barretti] | diamond | 2334 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29947677 | 29947677 | PRJNA235310_P_NODE_4091_length_186_cov_1.291971_g4065_i0 | PRJNA235310 | 4091 | 186 | 1.291971 | 2.40306606 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 79.3 | 2.04e-15 | NR | XP_065846557.1 | 121494 | g4065 | i0 | 54.8 | 1.96774193548387 | 62 | 27 | 98.4 | 1 | 185 | 3 | 197 | 258 | XP_065846557.1 neutral ceramidase A-like [Oscarella lobularis] | diamond | 366 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30010969 | 30010969 | PRJNA235310_P_NODE_3931_length_190_cov_2.156028_g3905_i0 | PRJNA235310 | 3931 | 190 | 2.156028 | 4.0964532 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 79.3 | 2e-15 | NR | XP_065184261.1 | 27933 | g3905 | i0 | 54 | 0.994736842105263 | 63 | 29 | 99.5 | 0 | 189 | 1 | 285 | 347 | XP_065184261.1 probable serine/threonine-protein kinase PkwA [Sycon ciliatum] | diamond | 189 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30579272 | 30579272 | PRJNA235310_P_NODE_1673_length_310_cov_1.417625_g1647_i0 | PRJNA235310 | 1673 | 310 | 1.417625 | 4.3946375 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 92 | 4.15e-19 | NR | XP_065194561.1 | 27933 | g1647 | i0 | 45.5 | 0.97741935483871 | 101 | 50 | 94.8 | 3 | 7 | 300 | 316 | 414 | XP_065194561.1 multiple C2 and transmembrane domain-containing protein 2-like isoform X4 [Sycon ciliatum] | diamond | 303 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30610997 | 30610997 | PRJNA235310_P_NODE_773_length_449_cov_8.265000_g747_i0 | PRJNA235310 | 773 | 449 | 8.265 | 37.10985 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 196 | 1.16e-61 | NR | XP_065826293.1 | 121494 | g747 | i0 | 73.8 | 8.7260579064588 | 130 | 34 | 86.9 | 0 | 19 | 408 | 1 | 130 | XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] | diamond | 3918 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31545652 | 31545652 | PRJNA235310_P_NODE_5656_length_165_cov_1.603448_g5630_i0 | PRJNA235310 | 5656 | 165 | 1.603448 | 2.6456892 | Porifera | 6040 | Porifera | other_Eukaryota | 83.6 | 4.14e-17 | NR | XP_065175244.1 | 27933 | g5630 | i0 | 79.6 | 5.89090909090909 | 54 | 11 | 98.2 | 0 | 164 | 3 | 322 | 375 | XP_065175244.1 actin-related protein 3-like [Sycon ciliatum] | diamond | 972 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31875490 | 31875490 | PRJNA235310_P_NODE_1837_length_293_cov_1.065574_g1811_i0 | PRJNA235310 | 1837 | 293 | 1.065574 | 3.12213182 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 141 | 3.4e-37 | NR | XP_062499291.1 | 121492 | g1811 | i0 | 68.4 | 5.91808873720136 | 98 | 28 | 97.3 | 1 | 9 | 293 | 212 | 309 | XP_062499291.1 cystathionine beta-synthase-like [Corticium candelabrum] | diamond | 1734 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32729201 | 32729201 | PRJNA235310_P_NODE_4500_length_176_cov_0.866142_g4474_i0 | PRJNA235310 | 4500 | 176 | 0.866142 | 1.52440992 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 54.3 | 4.97e-7 | NR | XP_062500374.1 | 121492 | g4474 | i0 | 50 | 0.647727272727273 | 38 | 19 | 64.8 | 0 | 1 | 114 | 100 | 137 | XP_062500374.1 uncharacterized protein LOC134177614 [Corticium candelabrum] | diamond | 114 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32823647 | 32823647 | PRJNA235310_P_NODE_520_length_525_cov_2.201681_g496_i0 | PRJNA235310 | 520 | 525 | 2.2016810000000002 | 11.55882525 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 112 | 5.65e-28 | NR | XP_064400518.1 | 6063 | g496 | i0 | 41.5 | 0.908571428571429 | 159 | 82 | 86.3 | 3 | 487 | 35 | 15 | 170 | XP_064400518.1 uncharacterized protein LOC135346725 [Halichondria panicea] | diamond | 477 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea |
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);;