contig_metadata
8 rows where bioproject = "PRJNA1120203" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9203140 | 9203140 | PRJNA1120203_P_NODE_67968_length_272_cov_35.773869_g66952_i0 | PRJNA1120203 | 67968 | 272 | 35.773869 | 97.30492368 | Liriope tetraphylla | 37524 | Cnidaria | other_Eukaryota | 407 | 4.619999999999999e-109 | NTclustered | gi|952952540|gb|KT809327.1| | 37524 | g66952 | i0 | 94.981 | 95.2316176470588 | 259 | 13 | 95 | 0 | 13 | 271 | 2581 | 2839 | Liriope tetraphylla mitochondrion, partial genome | blastn | 25903 | 407 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Limnomedusae | Geryoniidae | Liriope | Liriope tetraphylla | |
| 9956006 | 9956006 | PRJNA1120203_P_NODE_60088_length_290_cov_1.294931_g59072_i0 | PRJNA1120203 | 60088 | 290 | 1.294931 | 3.7552999 | Cyanea | 27803 | Cnidaria | other_Eukaryota | 490 | 4.799999999999999e-134 | NTclustered | gi|2020261272|gb|MW832751.1| | 135523 | g59072 | i0 | 98.556 | 94.0172413793103 | 277 | 4 | 96 | 0 | 1 | 277 | 223 | 499 | Cyanea nozakii isolate 16S rRNA Hap31 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 27265 | 490 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Semaeostomeae | Cyaneidae | Cyanea | Cyanea nozakii | |
| 15055213 | 15055213 | PRJNA1120203_P_NODE_106352_length_237_cov_10.219512_g105336_i0 | PRJNA1120203 | 106352 | 237 | 10.219512 | 24.22024344 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 399 | 6.589999999999999e-107 | NTclustered | gi|2889125804|gb|PQ875201.1| | 51068 | g105336 | i0 | 98.667 | 94.6708860759494 | 225 | 3 | 95 | 0 | 1 | 225 | 1406 | 1630 | Sandalolitha robusta isolate 3209F mitochondrion, complete genome | blastn | 22437 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Fungiidae | Sandalolitha | Sandalolitha robusta | |
| 19401177 | 19401177 | PRJNA1120203_P_NODE_73956_length_259_cov_2.827957_g72940_i0 | PRJNA1120203 | 73956 | 259 | 2.827957 | 7.32440863 | Hydractinia carica | 2752231 | Cnidaria | other_Eukaryota | 172 | 1.7399999999999999e-38 | NTclustered | gi|150368568|emb|AM411418.1| | 2752231 | g72940 | i0 | 79.518 | 19.1737451737452 | 249 | 46 | 95 | 5 | 14 | 259 | 468 | 222 | Hydractinia minuta 16S rRNA gene, haplotype Hydractinia minuta mitochondrial partial 16S rRNA variant New Zealand | blastn | 4966 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia carica | |
| 20153971 | 20153971 | PRJNA1120203_P_NODE_106516_length_234_cov_4.515528_g105500_i0 | PRJNA1120203 | 106516 | 234 | 4.515528 | 10.56633552 | Merulinidae | 46736 | Cnidaria | other_Eukaryota | 394 | 3.02e-105 | NTclustered | gi|2571076060|gb|OR492066.1| | 498486 | g105500 | i0 | 98.649 | 94.8076923076923 | 222 | 3 | 95 | 0 | 1 | 222 | 207 | 428 | Favites pentagona isolate M24 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 22185 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Favites | Favites pentagona | |
| 26742437 | 26742437 | PRJNA1120203_P_NODE_100241_length_243_cov_0.905882_g99225_i0 | PRJNA1120203 | 100241 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 129 | 3.64e-33 | NR | PFX11132.1 | 50429 | g99225 | i0 | 85.2 | 12 | 81 | 12 | 100 | 0 | 1 | 243 | 22 | 102 | PFX11132.1 Protein TolQ, partial [Stylophora pistillata] | diamond | 2916 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30480916 | 30480916 | PRJNA1120203_P_NODE_93953_length_245_cov_0.895349_g92937_i0 | PRJNA1120203 | 93953 | 245 | 0.895349 | 2.19360505 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 75.1 | 1.53e-13 | NR | CAH3123430.1 | 104759 | g92937 | i0 | 38.8 | 1.95918367346939 | 80 | 48 | 98 | 1 | 243 | 4 | 55 | 133 | CAH3123430.1 unnamed protein product [Porites lobata] | diamond | 480 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 32188210 | 32188210 | PRJNA1120203_P_NODE_85358_length_249_cov_0.875000_g84342_i0 | PRJNA1120203 | 85358 | 249 | 0.875 | 2.17875 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 76.3 | 6.29e-14 | NR | XP_028405678.1 | 151771 | g84342 | i0 | 45.7 | 6.8433734939759 | 81 | 38 | 91.6 | 2 | 230 | 3 | 379 | 458 | XP_028405678.1 uncharacterized protein LOC114528250 [Dendronephthya gigantea] | diamond | 1704 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea |
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);;