contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1095825" and tax_kingdom = "Thermotogati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 200718 | 200718 | PRJNA1095825_P_NODE_253101_length_248_cov_0.988571_g250038_i0 | PRJNA1095825 | 253101 | 248 | 0.988571 | 2.45165608 | Deinococcus radiomollis | 468916 | Bacteria | Bacteria | 416 | 6.9e-112 | NTclustered | gi|2865409981|gb|CP129906.1| | 468916 | g250038 | i0 | 96.813 | 228.487903225806 | 251 | 5 | 100 | 3 | 1 | 248 | 1000946 | 1001196 | Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome | blastn | 56665 | 416 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiomollis | ||
| 2294961 | 2294961 | PRJNA1095825_P_NODE_253362_length_248_cov_0.880000_g250299_i0 | PRJNA1095825 | 253362 | 248 | 0.88 | 2.1824 | Deinococcus | 1298 | Bacteria | Bacteria | 407 | 4.16e-109 | NTclustered | gi|2264081587|gb|CP094462.1| | 1299 | g250299 | i0 | 96.721 | 21.3508064516129 | 244 | 8 | 98 | 0 | 1 | 244 | 2295300 | 2295543 | Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence | blastn | 5295 | 407 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiodurans | ||
| 8672649 | 8672649 | PRJNA1095825_P_NODE_204047_length_274_cov_0.950249_g200984_i0 | PRJNA1095825 | 204047 | 274 | 0.950249 | 2.60368226 | Deinococcus | 1298 | Bacteria | Bacteria | 484 | 2.0899999999999994e-132 | NTclustered | gi|2264081587|gb|CP094462.1| | 1299 | g200984 | i0 | 98.54 | 293.806569343066 | 274 | 4 | 100 | 0 | 1 | 274 | 879584 | 879857 | Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence | blastn | 80503 | 484 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiodurans | ||
| 11223036 | 11223036 | PRJNA1095825_P_NODE_285629_length_243_cov_0.905882_g282566_i0 | PRJNA1095825 | 285629 | 243 | 0.905882 | 2.20129326 | Thermus | 270 | Bacteria | Bacteria | 444 | 3.09e-120 | NTclustered | gi|2090198728|gb|CP082325.1| | 274 | g282566 | i0 | 99.588 | 10 | 243 | 1 | 100 | 0 | 1 | 243 | 51789 | 51547 | Thermus thermophilus strain N-1 plasmid unnamed2, complete sequence | blastn | 2430 | 444 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus thermophilus | ||
| 15047130 | 15047130 | PRJNA1095825_P_NODE_206932_length_271_cov_2.535354_g203869_i0 | PRJNA1095825 | 206932 | 271 | 2.535354 | 6.87080934 | Truepera | 332248 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2573973991|gb|CP133611.1| | 332249 | g203869 | i0 | 100 | 0.214022140221402 | 29 | 0 | 11 | 0 | 230 | 258 | 3108346 | 3108318 | Truepera radiovictrix strain CIP 108686 chromosome, complete genome | blastn | 58 | 54.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 15047200 | 15047200 | PRJNA1095825_P_NODE_241812_length_250_cov_0.870056_g238749_i0 | PRJNA1095825 | 241812 | 250 | 0.870056 | 2.17514 | Thermus | 270 | Bacteria | Bacteria | 451 | 1.91e-122 | NTclustered | gi|2049910225|gb|CP076325.1| | 88190 | g238749 | i0 | 99.2 | 48.684 | 250 | 2 | 100 | 0 | 1 | 250 | 487378 | 487129 | MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome | blastn | 12171 | 451 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus antranikianii | ||
| 16778772 | 16778772 | PRJNA1095825_P_NODE_71434_length_448_cov_1.402667_g68371_i0 | PRJNA1095825 | 71434 | 448 | 1.402667 | 6.28394816 | Deinococcus sp. QL22 | 2939437 | Bacteria | Bacteria | 726 | 0 | NTclustered | gi|2238957582|gb|CP097149.1| | 2939437 | g68371 | i0 | 95.982 | 212.247767857143 | 448 | 16 | 99 | 2 | 1 | 447 | 1507971 | 1508417 | Deinococcus sp. QL22 chromosome, complete genome | blastn | 95087 | 726 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. QL22 | ||
| 20602856 | 20602856 | PRJNA1095825_P_NODE_80517_length_422_cov_1.338109_g77454_i0 | PRJNA1095825 | 80517 | 422 | 1.338109 | 5.64681998 | Deinococcus puniceus | 1182568 | Bacteria | Bacteria | 623 | 6.869999999999999e-174 | NTclustered | gi|1028459476|gb|CP011387.1| | 1182568 | g77454 | i0 | 93.396 | 252.144549763033 | 424 | 23 | 100 | 5 | 1 | 422 | 70898 | 71318 | Deinococcus puniceus strain DY1, complete genome | blastn | 106405 | 623 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus puniceus |
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);;