contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 616743 | 616743 | PRJNA641707_P_NODE_56121_length_285_cov_11.605932_g53460_i0 | PRJNA641707 | 56121 | 285 | 11.605932 | 33.0769062 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 187 | 6.919999999999998e-43 | NTclustered | gi|2746766284|ref|XM_065987079.1| | 121494 | g53460 | i0 | 81.696 | 2.19649122807018 | 224 | 41 | 79 | 0 | 11 | 234 | 122 | 345 | PREDICTED: Oscarella lobularis cilia- and flagella-associated protein 20 (LOC136197342), mRNA | blastn | 626 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 1887439 | 1887439 | PRJNA641707_P_NODE_120442_length_245_cov_7.403061_g117779_i0 | PRJNA641707 | 120442 | 245 | 7.403061 | 18.13749945 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 93.5 | 1.3e-14 | NTclustered | gi|2664246044|ref|XM_062663140.1| | 121492 | g117779 | i0 | 85.556 | 3.26530612244898 | 90 | 12 | 36 | 1 | 148 | 236 | 4571 | 4482 | PREDICTED: Corticium candelabrum dynein axonemal heavy chain 7-like (LOC134194214), mRNA | blastn | 800 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 6990235 | 6990235 | PRJNA641707_P_NODE_144306_length_240_cov_8.586387_g141643_i0 | PRJNA641707 | 144306 | 240 | 8.586387 | 20.6073288 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 75 | 4.61e-9 | NTclustered | gi|2746780638|ref|XM_065974291.1| | 121494 | g141643 | i0 | 80.808 | 0.4125 | 99 | 15 | 40 | 3 | 2 | 98 | 358 | 262 | PREDICTED: Oscarella lobularis programmed cell death protein 6-like (LOC136186820), mRNA | blastn | 99 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 7535525 | 7535525 | PRJNA641707_P_NODE_318186_length_158_cov_7.917431_g315523_i0 | PRJNA641707 | 318186 | 158 | 7.917431 | 12.50954098 | Demospongiae | 6042 | Porifera | other_Eukaryota | 65.8 | 1.68e-6 | NTclustered | gi|512765385|gb|KC869623.1| | 375146 | g315523 | i0 | 91.489 | 33.7151898734177 | 47 | 4 | 30 | 0 | 2 | 48 | 2327 | 2281 | Ianthella basta voucher NCI067 28S ribosomal RNA gene, partial sequence | blastn | 5327 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Verongiida | Ianthellidae | Ianthella | Ianthella basta | |
| 10815325 | 10815325 | PRJNA641707_P_NODE_113129_length_246_cov_2.426396_g110466_i0 | PRJNA641707 | 113129 | 246 | 2.426396 | 5.96893416 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 95.3 | 3.64e-15 | NTclustered | gi|2746774461|ref|XM_065971077.1| | 121494 | g110466 | i0 | 84.694 | 1.08943089430894 | 98 | 11 | 39 | 4 | 6 | 101 | 5143 | 5238 | PREDICTED: Oscarella lobularis dynein axonemal heavy chain 5-like (LOC136184219), mRNA | blastn | 268 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 10821310 | 10821310 | PRJNA641707_P_NODE_70629_length_249_cov_5.495000_g67966_i0 | PRJNA641707 | 70629 | 249 | 5.495 | 13.68255 | Pseudocorticium jarrei | 61082 | Porifera | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|308912677|gb|HQ269357.1| | 61082 | g67966 | i0 | 100 | 0.566265060240964 | 29 | 0 | 12 | 0 | 23 | 51 | 572 | 600 | Pseudocorticium jarrei isolate DL028 mitochondrion, complete genome | blastn | 141 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Pseudocorticium | Pseudocorticium jarrei | |
| 14644547 | 14644547 | PRJNA641707_P_NODE_30952_length_389_cov_6.529412_g28340_i0 | PRJNA641707 | 30952 | 389 | 6.529412 | 25.39941268 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 71.3 | 1.03e-7 | NTclustered | gi|2664271035|ref|XM_062643815.1| | 121492 | g28340 | i0 | 95.455 | 0.113110539845758 | 44 | 2 | 11 | 0 | 307 | 350 | 890 | 847 | PREDICTED: Corticium candelabrum dual specificity mitogen-activated protein kinase kinase 7-like (LOC134177097), mRNA | blastn | 44 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 14645411 | 14645411 | PRJNA641707_P_NODE_44352_length_326_cov_4.104693_g41703_i0 | PRJNA641707 | 44352 | 326 | 4.104693 | 13.38129918 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 141 | 6.36e-29 | NTclustered | gi|2746756347|ref|XM_065982156.1| | 121494 | g41703 | i0 | 80.978 | 10.5950920245399 | 184 | 29 | 56 | 5 | 141 | 321 | 1090 | 910 | PREDICTED: Oscarella lobularis radixin-like (LOC136193293), transcript variant X2, mRNA | blastn | 3454 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 19007886 | 19007886 | PRJNA641707_P_NODE_154275_length_229_cov_2.088889_g151612_i0 | PRJNA641707 | 154275 | 229 | 2.088889 | 4.78355581 | root | 1 | Root_unresolved | Root_unresolved | 75 | 4.36e-9 | NTclustered | gi|147931667|gb|AY626303.2| | 297672 | g151612 | i0 | 100 | 26.8078602620087 | 40 | 0 | 17 | 0 | 23 | 62 | 588 | 549 | Timea sp. G313459 28S large subunit ribosomal RNA gene, complete sequence | blastn | 6139 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tethyida | Timeidae | Timea | Timea sp. G313459 | |
| 19741478 | 19741478 | PRJNA641707_P_NODE_269416_length_174_cov_7.096000_g266753_i0 | PRJNA641707 | 269416 | 174 | 7.096 | 12.34704 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 163 | 6.480000000000001e-36 | NTclustered | gi|2749515378|ref|XM_066026873.1| | 196820 | g266753 | i0 | 84.337 | 1.4367816091954 | 166 | 26 | 95 | 0 | 1 | 166 | 721 | 556 | PREDICTED: Dysidea avara casein kinase I (LOC136236648), mRNA | blastn | 250 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 19741915 | 19741915 | PRJNA641707_P_NODE_288696_length_167_cov_6.398305_g286033_i0 | PRJNA641707 | 288696 | 167 | 6.398305 | 10.68516935 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 110 | 8.2e-20 | NTclustered | gi|2732933038|ref|XR_010554093.1| | 27933 | g286033 | i0 | 87.379 | 37.437125748503 | 103 | 4 | 59 | 7 | 65 | 162 | 104 | 6 | PREDICTED: Sycon ciliatum U2 spliceosomal RNA (LOC135820365), ncRNA | blastn | 6252 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 21018386 | 21018386 | PRJNA641707_P_NODE_326877_length_155_cov_5.443396_g324214_i0 | PRJNA641707 | 326877 | 155 | 5.443396 | 8.4372638 | Penares turmericolor | 3121256 | Porifera | other_Eukaryota | 69.4 | 1.27e-7 | NTclustered | gi|2913438676|emb|OZ224072.1| | 3121256 | g324214 | i0 | 93.478 | 6.26451612903226 | 46 | 3 | 30 | 0 | 104 | 149 | 1624 | 1579 | Penares turmericolor genome assembly, organelle: mitochondrion | blastn | 971 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Penares | Penares turmericolor | |
| 24839647 | 24839647 | PRJNA641707_P_NODE_210000_length_195_cov_9.910959_g207337_i0 | PRJNA641707 | 210000 | 195 | 9.910959 | 19.32637005 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 69.4 | 1.67e-7 | NTclustered | gi|2732899947|ref|XR_010551580.1| | 27933 | g207337 | i0 | 100 | 3.8051282051282 | 37 | 0 | 19 | 0 | 153 | 189 | 3415 | 3379 | PREDICTED: Sycon ciliatum large subunit ribosomal RNA (LOC135807293), rRNA | blastn | 742 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 25382987 | 25382987 | PRJNA641707_P_NODE_187860_length_199_cov_5.666667_g185197_i0 | PRJNA641707 | 187860 | 199 | 5.666667 | 11.27666733 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2732917861|ref|XM_065325756.1| | 27933 | g185197 | i0 | 96.875 | 1.30150753768844 | 32 | 1 | 16 | 0 | 3 | 34 | 655 | 624 | PREDICTED: Sycon ciliatum potassium/sodium hyperpolarization-activated cyclic nucleotide-gated channel 1-like (LOC135812381), mRNA | blastn | 259 | 54.7 | 1 | 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);;